+- studentsuvidha (https://studentsuvidha.com/forum)
+-- Forum: Student Stuffs (https://studentsuvidha.com/forum/Forum-Student-Stuffs)
+--- Forum: Indraprastha University IPU notes and papers (https://studentsuvidha.com/forum/Forum-Indraprastha-University-IPU-notes-and-papers)
+---- Forum: IPU B.tech/ B.E. papers and Notes -free downloads (https://studentsuvidha.com/forum/Forum-IPU-B-tech-B-E-papers-and-Notes-free-downloads)
+----- Forum: IPU B.tech/ B.E. IT papers and Notes -free downloads (https://studentsuvidha.com/forum/Forum-IPU-B-tech-B-E-IT-papers-and-Notes-free-downloads)
+------ Forum: 7th semester IPU B.tech IT papers and Notes -free download (https://studentsuvidha.com/forum/Forum-7th-semester-IPU-B-tech-IT-papers-and-Notes-free-download)
+------ Thread: Distributed Databases IPU IT notes and question paper free download (/Thread-Distributed-Databases-IPU-IT-notes-and-question-paper-free-download)
Distributed Databases IPU IT notes and question paper free download - Dipesh S - 05-01-2017
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.