Database management systems notes
Inside a DBMS
The three-schema architecture, data independence, and the components a query passes through. Every section is a drawn page beside a clear written explanation, about 19 minutes in all.
- Chapter 2 of 34
- About 19 minutes
- 8 sections
Sign in with Google or GitHub and you land straight on this page. DSA comes with the all labs plan and every ChaiCode batch.
In this chapter
- The three-schema architecture
- Why the layers exist: data independence
- Schema versus instance
- The two halves of SQL: DDL and DML
- The components a query passes through
- One query, end to end
- Where the database runs: client-server and its shapes
- A map to keep for the rest of the course
Next chapters
Read the whole chapter
Sign in and the chapter opens with every drawn page, and all 35 database management systems chapters beside it.
DSA comes with the all labs plan and every ChaiCode batch.