05-01-2017, 07:27 PM
SYLLABUS:-
UNIT I
Architecture of distributed systems: network operating system, distributed operating systems, Distributed database systems. (a) Federated database systems, (b) multi database systems, and © Client/Server systems, Distributed DBMS architecture.
Distributed database design: Top down design- Designing issues, Fragmentation, Allocation, Data dictionary, Bottom up design- Schema Matching, Schema Integration, Schema Mapping, Data Cleaning
Data and Access Control: views in centralised and distributed DBMS, Data security, Semantic Integrity Control.
UNIT II
Query Processing: Characterization of query processors, Layers of query processing, Query Decomposition: Normalization, Analysis, Elimination of redundancy,
Data Localization: Reduction of primary horizontal fragmentation, Reduction of vertical fragmentation, reduction of derived fragmentation, hybrid fragmentation.
Optimization of Distributed Query: Join ordering, Semi join based algorithms, optimization
UNIT III
Transaction Management: Properties of transactions, Types of transactions- flat transactions, nested transactions, workflow.
Distributed Concurrency Control: Serializability theory, Locking based concurrency control Algorithm, Timstamp based algorithms,
Deadlock Management: Prevention, Avoidance, Detection and Resolution
UNIT IV
Distributed DBMS Reliability: Local Reliability protocol, Distributed Reliability protocol- two phase commit protocol, three phase commit protocol.
Parallel Database System: System architecture, Parallel query processing, Load Balancing, Database Clusters. Web Data Management: Web Search-crawling, indexing ranking, Web Querying, Distributed XML Processing.
UNIT I
Architecture of distributed systems: network operating system, distributed operating systems, Distributed database systems. (a) Federated database systems, (b) multi database systems, and © Client/Server systems, Distributed DBMS architecture.
Distributed database design: Top down design- Designing issues, Fragmentation, Allocation, Data dictionary, Bottom up design- Schema Matching, Schema Integration, Schema Mapping, Data Cleaning
Data and Access Control: views in centralised and distributed DBMS, Data security, Semantic Integrity Control.
UNIT II
Query Processing: Characterization of query processors, Layers of query processing, Query Decomposition: Normalization, Analysis, Elimination of redundancy,
Data Localization: Reduction of primary horizontal fragmentation, Reduction of vertical fragmentation, reduction of derived fragmentation, hybrid fragmentation.
Optimization of Distributed Query: Join ordering, Semi join based algorithms, optimization
UNIT III
Transaction Management: Properties of transactions, Types of transactions- flat transactions, nested transactions, workflow.
Distributed Concurrency Control: Serializability theory, Locking based concurrency control Algorithm, Timstamp based algorithms,
Deadlock Management: Prevention, Avoidance, Detection and Resolution
UNIT IV
Distributed DBMS Reliability: Local Reliability protocol, Distributed Reliability protocol- two phase commit protocol, three phase commit protocol.
Parallel Database System: System architecture, Parallel query processing, Load Balancing, Database Clusters. Web Data Management: Web Search-crawling, indexing ranking, Web Querying, Distributed XML Processing.