M.P. Johnson, DBMS, Stern/NYU, Sp2004
General problems to solve
In building our own system, many Qs arise:
how do we store the data? (file organization, etc.)
how do we query the data? (write programs…)
make sure that updates don’t mess things up?
leave the DB “consistent”
provide different views on the data?
e.g., ATM user’s view v. bank teller’s view
how do we deal with crashes?
Too hard! Go buy a DBMS!
Q: How does a DBMS solve these problems?
A: See third part of course