Database Systems Concepts and Design
Objective: The objective of this course is to give an advanced introduction to the concepts for modeling, designing, querying and managing large databases. The course covers a spectrum of topics involved with current approaches to modeling and design of databases and the design of DBMSs to manage databases. The relational model is emphasized and relational database management systems are addressed from the standpoint of query optimization, database security, transaction management, concurrency control, and recovery. Other topics introduced include object-oriented databases, object-relational database management, data warehousing and mining. This course is an overview course which is followed by specialized database courses: CS6411: O-O database models and systems, CS 6421: active and dynamic DBMSs, CS6430: parallel and distributed database systems and applications. A basic knowledge of programming languages, files, and the application development process is assumed. A first course in database management covering introduction to relational, hierarchical and network databases is useful but not a must. Those with sufficient undergraduate database coursework are advised to go straight to one of the advanced courses.
Semester: Fall, 1999
Days: Tuesdays and Thursdays
Time: 0435-0555pm
Location: CCB 102
Instructor: Sham Navathe
TA: Wai Gen Yee
Contents
Notes are in Microsoft Word format.
- Databases and Database Management (Book Chapters 1, 2)
- Data Modeling Using the Entity-Relationship (ER) Data Model (Book Chapter 3)
- File Organizations and Indexing (Book Chapters 5, 6)
- The Relational Data Model (Book Chapter 7)
- SQL - A Relational Database Language and Query By Example (QBE) (Book Chapters 8, 9)
- Theory of Relational Database Design (Book Chapter 14)
- Draft of Chapter 18: Query Processing and Optimization (Postscript)
- Draft of Chapter 19: Basic Transaction Concepts (Postscript)
- Draft of Chapter 20: Concurrency Control Techniques (Postscript)