Course Info
|
Course Category
|
Computer Science/Information Technology
|
Course Level
|
Graduate
|
Credit Hours
|
3
|
Pre-requisites
|
N/A
|
Instructor
|
Dr. Nayyer Masood Dar
Ph.D Computer Science
University of Bradford, UK
|
|
Course Contents
|
|
Introduction to Distributed Database Systems,
Definition of Distributed Database Systems, Compulsory Parts, Characteristics, Objectives,
Resembling Setups, Reasons for DDBS and Promises of DDBMS,
The concept and role of the transaction in distributed computing,
Background of RDBMS, Relational Data Model, Keys, Tables, Normalization,
Relational Data Languages,
Derived Relational Algebra, Relational Calculus, Computer Networks,
Computer Networks Concepts, DDBMS Architecture,
DDBS Architecture, Dimensions, Architectural Alternatives,
Major DDBS Architectures,
Global Schema Architecture, Global Data Dictionary, DDB Design, Distribution Design Issues,
Correctness Rules For Fragmentation, Horizontal & Vertical Fragmentation,
Minterm Predicates,
PHF-Minimality of Pr, PHF-COM-MIN Algorithm, DHF Examples,
DHF Details, Vertical Fragmentation (VF),
Vertical Fragmentation Information Requirements, Clustering Algorithm, AM,
VF, Global Affinity Measure (AM), Bond Energy Algorithm,
VF, Computed CA, Partitioning Algorithm,
Fragmentation, Types, Replication, Replication Architecture in SQL Server, Models,
Setting Up Replication,
Agents Creation (Snapshot Agent, Distributor Agent),
Fragmentation (Practical Work),
Reasons for Fragmentation, DHF, Transactional Replication, Merge Replication,
Transaction Management, Properties of Transaction,
ACID Properties, Types of Transaction, Transaction in DDBS,
Serializability Theory in DDBS,
Locking based CC, Time Stamp ordering based CC,
Basic Concept of Query Optimization, QP in centralized and Distributed DBS,
Query Decomposition and its phases,
Final Phase of QD, Data Localization,
Data Localization for Hybrid Fragmentation, Query Optimization,
Query Optimization, Centralized QO, QO in Distributed Environment,
Query Optimization, Semijoin based algorithms, Distributed Query Process Algorithms,
Parallel Database Systems,
Parallel Processing Basics,
Parallel Systems Architecture,
Parallel Data Processing, Parallel Query Optimization,
Analysis of Parallel Data Processing Approaches, Parallel Query Optimization,
Different Situation in Modeling, Object Distribution Design, Architectural Issues,
Database Interoperability
|
|
|