CP7202 ADVANCED DATABASES

CP7202      ADVANCED DATABASES

UNIT I   PARALLEL AND DISTRIBUTED DATABASES    

Database System Architectures: Centralized and Client-Server Architectures – Server System Architectures – Parallel Systems- Distributed Systems – Parallel Databases: I/O Parallelism – Inter and Intra Query Parallelism – Inter and Intra operation Parallelism – Design of Parallel Systems- Distributed Database Concepts - Distributed Data Storage – Distributed Transactions – Commit Protocols – Concurrency Control – Distributed Query Processing – Case Studies

  

UNIT II  OBJECT AND OBJECT RELATIONAL DATABASES

Concepts for Object Databases: Object Identity – Object structure – Type Constructors – Encapsulation of Operations – Methods – Persistence – Type and Class Hierarchies – Inheritance – Complex Objects – Object Database Standards, Languages and Design: ODMG Model – ODL – OQL – Object Relational and Extended – Relational Systems: Object Relational features in SQL/Oracle – Case Studies. 

UNIT III  INTELLIGENT DATABASES

 Active Databases: Syntax and Semantics (Starburst, Oracle, DB2)- Taxonomy- ApplicationsDesign Principles for Active Rules- Temporal Databases: Overview of Temporal Databases- TSQL2- Deductive Databases: Logic of Query Languages – Datalog- Recursive Rules-Syntax and Semantics of Datalog Languages- Implementation of Rules and Recursion- Recursive Queries in SQL- Spatial Databases- Spatial Data Types- Spatial Relationships- Spatial Data StructuresSpatial Access Methods- Spatial DB Implementation.  

UNIT IV  ADVANCED DATA MODELS 

 Mobile Databases: Location and Handoff Management - Effect of Mobility on Data Management - Location Dependent Data Distribution - Mobile Transaction Models -Concurrency Control - Transaction Commit Protocols- Multimedia Databases- Information Retrieval- Data Warehousing- Data Mining- Text Mining.   

UNIT V EMERGING TECHNOLOGIES

XML Databases: XML-Related Technologies-XML Schema- XML Query Languages- Storing XML in Databases-XML and SQL- Native XML Databases- Web Databases- Geographic Information Systems- Biological Data Management- Cloud Based Databases: Data Storage Systems on the Cloud- Cloud Storage Architectures-Cloud Data Models- Query Languages- Introduction to Big Data-Storage-Analysis. 

REFERENCES:  

1. R. Elmasri, S.B. Navathe, “Fundamentals of Database Systems”, Fifth Edition, Pearson              Education/Addison Wesley, 2007.  

2. Thomas Cannolly and Carolyn Begg, “Database Systems, A Practical Approach to Design,        Implementation and Management”, Third Edition, Pearson Education, 2007.  

3. Henry F Korth, Abraham Silberschatz, S. Sudharshan, “Database SystemConcepts”,  Fifth        Edition, McGraw Hill, 2006.  

4. C.J.Date, A.Kannan and S.Swamynathan, ”An Introduction to Database Systems”, Eighth        Edition, Pearson Education, 2006.  

5. Raghu Ramakrishnan, Johannes Gehrke, “Database Management Systems”, McGraw        Hill, Third Edition 2004.