COMS 538: DISTRIBUTED DATABASE SYSTEMS
Introduction : Distributed data processing, distributed database design, distributed query
processing, distributed directory management, distributed concurrency control,
distributed deadlock management, reliability of distributed DBMS, operating system
support, heterogeneous databases. Overview of Relational DBMS
Review of computer networks : Data communication concepts, types of networks,
protocol standards, broadband networks, wireless networks, Internet.
DBMS Architecture : DBMS standardization, architectural model for distributed DBMS,
Distributed DBMS Architecture : client/server systems, peer-to-peer distributed systems.
Distributed Database Design : Alternative design strategies : top-down design process,
bottom-up design process, distribution design issues : reasons for fragmentation,
fragmentation alternatives, degree of fragmentation, correctness rules of fragmentation,
allocation alternatives, information requirements, fragmentation : horizontal
fragmentation, vertical fragmentation, hybrid fragmentation.
Semantic data control : View management: views in centralised DBMS, updates through
views, views in distributed DBMS.
Data security : centralized authorization control, distributed authorization control.
Distributed Concurrency Control : Locking-based concurrency control algorithm,
timestamp-based concurrency control algorithms : basic TO algorithm, conservative TO
algorithm, optimistic concurrency control algorithms
Deadlock management : deadlock prevention, deadlock avoidance, deadlock detection
Distributed DBMS Reliability : System, state and failure, reliability and availability,
mean time between failures/mean time to report, failure and fault tolerance in distributed
systems : reasons for failures, basic fault tolerance approaches and techniques.
Distributed Object Database Management: Object, abstract data types, composition, class,
collection, subtyping and inheritance, Object distribution design : horizontal class
partitioning, vertical class partitioning , path partitioning, class partitioning algorithms,
1.M.Tamer Ozsu-Patric Valduriez, "Principles of Distributed Database System" II
Edition, Pearson Education.