SYLLABUS FOR THE DATABASE PORTION OF THE SYSTEMS QUAL
1997
SYSTEMS QUAL DATABASES: OPEN BOOK
Principal data models and query languages. Schemas and database
design. File structures, indexing, and hashing methods. Query
processing and optimization. Transactions, concurrency control and
recovery, security and authorization, database performance, as covered
in CS 145 and CS 245A.
READING LIST
1. J.D. Ullman and J. Widom,
A First Course in Database Systems,
Prentice-Hall, 1997, all chapters
2. H.F. Korth and A. Silberschatz,
Database System Concepts (third edition)
McGraw-Hill, 1997, chapters 10-15
or
H.F. Korth and A. Silberschatz,
Database System Concepts (second edition)
McGraw-Hill, 1991, chapters 7-12
PREVIOUS SYSTEMS QUALS
Database
portion of 1995 Systems qual
Database
portion of 1996 Systems qual