Distributed DBMS (V-U)

• Introduction to Distributed Database Systems and History (V-U)
• Definition of Distributed Database Systems (V-U)
• Resembling Setups, Reasons for DDBS and Promises of DDBMS (V-U)
• Reliablity of DDBS (V-U)
• Background of RDBMS,Relational Data Model,Keys,Tables (V-U)
• Normalization (Cont.) (V-U)
• Relational Data Languages (V-U)
• Derived Relational Algebra, Relational Calculus, Computer Networks (V-U)
• Computer Networks Concepts, DDBMS Architecture (V-U)
• DDBS Architecture, Dimensions, Architectural Alternatives (V-U)
• Major DDBS Architectures (V-U)
• Global Schema Architecture, Global Data Dictionary (V-U)
• Correctness Rules for Fragmentation, Horizontal & Vertical Fragmentation (V-U)
• Minterm Predicates (V-U)
• PHF-Minimality of Pr, PHF-COM-MIN Algorithm, DHF Examples (V-U)
• DHF Details, Vertical Fragmentation (VF) (V-U)
• Vertical Fragmentation Information Requirements (V-U)
• VF, Global Affinity Measure (AM), Bond Energy Algorithm (BEA) (V-U)
• VF, Global Affinity Measure (AM), Bond Energy Algorithm (Cont.) (V-U)
• VF, Hybrid Fragmentation, Computed CA, Partitioning Algorithm (V-U)
• Setting Up Replication in SQL Server (V-U)
• Agents Creation (Snapshot Agent, Distributor Agent) (V-U)
• Fragmentation (Practical Work) (V-U)
• Reasons for Fragmentation, DHF, Transactional Replication, Merge Replication (V-U)
• Transaction Management, Properties of Transaction (V-U)