CS 330 Databases
Overview


  1. Relational Model. Example: tables in the Access example database.
  2. Query languages: SQL, QBE.
  3. Integrity Constraints.
  4. Relational Database Design.
  5. Implementation issues: file structure; file organization; data-dictionary storage.
  6. Indexing and Hashing.
  7. Query Processing.
  8. Transactions.
  9. Concurrency Control.
  10. Recovery System
  11. Database System Architectures: centralized systems; client-server; parallel; distributed; network.
  12. Special Topics: security and integrity; time in databases; user interfaces.
  13. New Applications: data analysis; data mining; data warehousing; spatial and geographic databases; multimedia databases; mobility and personal databases; information retrieval systems; distributed information systems; the World Wide Web.


Reading

  1. Chapter 1 textbook


Last updated Sept 3, 1997.
Ileana Streinu