Introduction into Theory and Methodologies of Design, Implementation and Management of Distributed Databases

Course program:

1. Theory of the relational databases
   • The information system with the relational distributed databases
   • The data models (review)
   • The relational data models. Relational algebra. Relational operations
   • (Optionally) Review of the new relational data models
2. Theory of the design for the relational databases
   • Functional relationships. F- relationship. Т- relationship. MV- relationship. (Optionally). J- relationship
   • Normal forms
   • The method of the relationships decomposition
   • (Optionally). Method of relationships synthesis . Examples on the Prolog
   • Introduction into the semantic design. ( ER-method). The based 8 rules
3. SQL
   • (Optionally) SQL standard
   • Tutorial in SQL
   • Logic and SQL. Predicates and databases
   • SQL for client/server
4. Distributed Database Design Methodologies
   • Distributed Databases: Principles
   • Levels of distribution transparency
   • Fragmentation. Global and fragmentation queries
   • Query optimization
   • Distributed transactions. Concurrency control
5. CASE-environments for Distributed Databases Design
   • Business Process Reengenearing with BPwin
   • Developing logical data model with Erwin
   • Developing physical database model and Application Development with ERwin
6. Methods of the workbench for Distributed Databases
   • Introduction to the workbench Methods
   • Integration workbench tools
   • Server workbench tools