Unit-1
Introduction to Distributed Data system, Distributed Database Architecture, Distributed Data base Design, Transaction processing Concurrency Control techniques, Security.
Unit-2
Types of Data Fragmentations, Fragmentation and allocation of fragments, Distribution transparency, access primitives, integrity constraints.
Unit-3
Grouping and aggregate function, Query processing , Equivalence transformation of queries.
Unit-4
Evaluation, parametric queries, Query optimization, Join and general queries.
Unit-5
Management of Distributed transaction and concurrency control: Distributed Date base Administration, Catalouge Management Authorisation, Security and protection. Examples of distributed database systems. Cost Analysis
References:
1.Ceri & Palgathi, “Distributed Database System”, McGraw Hill.
2. Raghu Rama Krishnan and Johannes Gechrib, “Database Management Systems”, Mc Graw Hill.
3. Date C. J, “An Introduction to Database System, Vol1 & II”, Addition Wesley.
4. Korth, Silbertz, Sudarshan , “Database Concepts”, McGraw Hill.
5. Elmasari , Navathe, “Fundamentals of Data Base Systems”, Addition Wesley.
6. Data C. J , “An Introduction to Database System” , Addition Wesley
7. RamaKrishnan , Gehke, “Database Management System”, McGraw Hill