CSC545: Database System Concepts

This course emphasizes recent technological advances in database management systems. The course centers around data models. Special attention is paid to relational and object-oriented data models and systems which implement these. Relational data model topics include conceptual modeling, logical and algebraic query languages, and the theory of normalization. Object-oriented data models include motivation for object-oriented systems, basic object-oriented concepts, object-oriented data modeling, and commercial object-oriented database management systems. Other topics introduced include database security (including record retention), transaction management, information states, concurrency control, recovery, data warehousing, data mining, accountability, custodianship.