STUDY - Advanced DBMS
STUDY - Design Theory for Relational Database:
Functional Dependencies, Decomposition of Relation schemes, Normal
Forms for Relations. Schemes, Multivalued and other kinds of Dependencies.
Query Optimization: Basic Optimization Strategies, Algebraic Manipulation, Optimization of Selections in
System, Exact Optimization for a Subset of Relational Queries, Optimization under Weak Equivalence.
Database Protection: Integrity, Constraints in Query-by-Example, Security, Security in query-by-Example,
Security in Statistical Databases.
STUDY - Concurrent Operations on the Database:
Basic Concepts, A simple Transaction Model, Model with Read- and
Write-Locks, Read-only, Write-only Model, Concurrency for Hierarchically Structured Items, Protection
against Crashes, Optimistic Concurrency Control.
Principles of Distributed Data Bases, Framework for distribution. Translation of global queries into fragment
queries. Query optimization and management of distributed transaction. Concurrency control and reliability in
Administration of Distributed Data Bases. Example Systems.