2 docs tagged with "dbms"

Chapter 2: The Relationship Between a System and Its Database — The DBMS as Interpreter

This chapter explains, for junior engineers, where a database sits within the three-tier structure of a web system (user / application / data) and the role of the DBMS that connects the application to the database.

Chapter 6: DBMS and SQL — The Mechanism and Common Language for Operating Data

This chapter explains, for junior engineers, the role of a DBMS (SQL parsing, transaction management, permissions, optimization), the four categories of SQL (DDL/DML/DCL/TCL), and the characteristics and trade-offs of major RDBMS products (PostgreSQL / MySQL / SQLite / Oracle / SQL Server).