Catalog description:

Fundamental concepts, system organization, and implementation of database systems. Relational, hierarchical, and network data models; file organizations and data structures; query languages; query optimization; database design; concurrency control; security; issues involving distributed database systems.

Prerequisites: CSE 326.

Textbook(s) and/or other required material:

Database Management Systems (Ramakrishnan and Gehrke)

A first course on database systems (Ullman, Widom and Garcia Molina)

Course objectives:

Provide a basic introduction to the concepts of database system design and implementation, including: data models, conceptual design, query languages, system components, data storage, query optimization and transaction processing.

Topics covered:

data models, conceptual design, query languages, system components, data storage, query optimization and transaction processing.

Class/laboratory schedule:

3 lectures a week