Parallel and distributed database systems

Distributed transactions; atomic commit protocols; concurrency control in distributed transactions; distributed deadlocks; transactions with replicated data; object and transaction model integration

Database languages and applications; active databases; data warehouses; data mining and knowledge discovery; multi-media information services; database support for workflow management systems.

Syllabus

1. Concepts of Parallel and Distributed DBMS
   • information systems
   • overview of traditional DBMS structure
   • distributed and parellel data processing
   • concept of distributed DBMS
   • architectural models for DDBMS
   • types of parallelism id database systems
2. Client-Server Architecture
   • structure of client-server systems
   • client-server standards
   • database middleware
   • transaction monitors
   • API for TM
3. Heterogeneous Database Servers
   • Interface Standards for Relational Database
   • ODBC
   • ODBC architecture
   • functionality and usage of ODBC
4. Architecture of Distributed DBMS
   • transparences in DDBMS
   • architecture of DDBMS
   • types and role of fregmentation
   • types and role of replication
   • allocation problem
5. Optimization of Distributed Query
   • problem of query processing
   • distributed query
   • query decomposition
   • objectives of query optimization
   • distributed query optimization algorithms
   • optimization of join operation
   • load balancing
6. Parallel Query Processing
   • muliprocessor architectures
   • parallel relational operators
   • parallel query processing
   • parallelism in main-memory DBMS
   • parallel handling of integrity constraints
7. Parallel Query Optimization
   • objectives of parallel query optimization
   • parallel query optimization
   • load balancing
   • parallelism in join queries
   • testing the quality of query optimization
8. Transaction Model of the DDBMS
   • concept of transaction and history
   • concurrency control models
   • serializability
   • multilevel atomicity
   • locking methods
9. Concurrency Control Algorithms
   • multiversion locking methods
   • multiversion timestamp ordering methods
   • validation methods
   • optimistic methods
   • deadlock management
10. Problems of Distributed Transaction Management
    • DDBMS performance
    • granularity of data
    • catalog management
    • update propagation
    • recovery control
    • two-phase commit method
11. Reliability Issues of DDBMS's
    • reliability concepts and measures
    • failures and failure tolerance
    • reliability protocols
    • architectural consideration
    • dealing with site failures
12. Security Aspects in DDBMS
    • security problems
    • security policies
    • DAC methods
    • MAC methods
    • security models for DDBMS
13. Design of Distributed Databases
    • design methodologies
    • design strategies
    • distribution design issues
    • fregmentation issues
14. WEB -based interface for DDBMS
    • structure of WEB based user interface
    • cgi interface
    • database web servers
    • Oracle WEB Server
15. DDBMS and Object Oriented Systems
    • OO concepts in DDBMS
    • implementaition level of OO concepts
    • management of OO data elements
    • COBRA architecture

1. Concepts of Distributed and Parallel Database Systems
   Part 1. 22 pages PDF (55k)
   Part 2. 10 pages PDF (35k)
2. Client Server Architecture
   31 pages PDF (61k)
3. The ODBC Interface
   20 pages PDF (37k)
4. Distributed DBMS Architecture
   33 pages PDF (61k)
5. Parallel Query Processing
   39 pages PDF (178k)
6. DDBMS Query Optimization
   48 pages PDF (107k)
7. Parallel Query Optimization
   34 pages PDF (81k)
8. Transaction Models of DDBMS
   34 pages PDF (66k)
9. DDBMS Concurrency Control
   27 pages PDF (68k)
10. The TUXEDO System
    26 pages PDF (56k)
11. Reliability and Security in PDDBMS
    29 pages PDF (53k)
12. Design of Distributed Databases
    24 pages PDF (62k)
13. WEB Database Publishing
    37 pages PDF (58k)

• Lionel Brunie
• Norbert Podhorszki
• László Kovács
• Zsolt Németh
• Péter Kacsuk