Database management systems notes

From Files to a Database

The six problems that make file storage collapse, and what a DBMS does about each. Every section is a drawn page beside a clear written explanation, about 18 minutes in all.

  • Chapter 1 of 34
  • About 18 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.

The first drawn page of From Files to a Database: The file-processing system
The chapter's first page: The file-processing system

In this chapter

  • The file-processing system
  • Problem 1 and 2: redundancy and inconsistency
  • Problem 3: every new question needs a new program
  • Problem 4 and 5: integrity and atomicity
  • Problem 6: many users at once (and who may see what)
  • What a DBMS provides in return
  • When a database is the wrong answer
  • The people involved, and a short history

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.