Notes
Please click on that boxes
Database Access Notes
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
Please click on that boxes
| MTECH CALENDER | ||
| . | . | |
| MFCS NOTES | WEB TECHNOLOGIES | |
| . | . | |
| MTECH SYLLABUS | ||
| ADS LAB | ||
| JWT LAB | validation program | |
| Servlet program | ||
Database Access Notes
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
