Distributed Databases Notes-All 8 units

1.Introduction: syllabus, administration and organisation of the course, general introduction in distributed DBMS

2. DDBMS Architecture: definition of DDBMS architecture, ANSI/SPARC standard, global, local, external, and internal schemas, DDBMS architectures, components of DDBMS

3.Distributed Database Design: conceptual design (what can be distributed, design patterns), top-down, bottom-up patterns, technical design (fragmentation, allocation and replication of fragments, optimality, heuristics)

4.Semantic Integrity Control: view management, security control, integrity control

5.Distributed Query Processing: overview of query processing and query optimization, query decomposition and data localization

6.Query decomposition and data localization: normalization, analysis, elimination of redundancy, rewriting, reduction for HF, reduction for VF

7.Optimization of Distributed Queries: basic concepts, distributed cost model, database statistics

8.Optimization of Distributed Queries: ordering of joins and semijoins, query optimization algorithms, INGRES, System R, hill climbing

9.Transactions: introduction to transactions, definition and examples, properties, classification, processing issues, execution

10.Concurrency Control: definition, execution schedules, examples, locking based algorithms, timestamp ordering algorithms, deadlock management

11.Reliability: definitions, basic concepts, local recovery management, distributed reliability protocols

12.Reliability: distributed reliability protocols, 2PC protocol

Check the below links for all the above topics

Code:

http://www.mediafire.com/?ojznnhk45bm

some more material

Code:

http://redbook.cs.berkeley.edu/redbook3/lecs.html
http://www.csse.monash.edu.au/courseware/cse5200/index2005.html