CP7202 ADVANCED DATABASES EBOOKS

CP7202 ADVANCED DATABASES

OBJECTIVES:
 To learn the modeling and design of databases.
 To acquire knowledge on parallel and distributed databases and its applications.
 To study the usage and applications of Object Oriented database
 To understand the principles of intelligent databases.
 To understand the usage of advanced data models.
 To learn emerging databases such as XML, Cloud and Big Data.
 To acquire inquisitive attitude towards research topics in databases.

UNIT I PARALLEL AND DISTRIBUTED DATABASES 9
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 9
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 9
Active Databases: Syntax and Semantics (Starburst, Oracle, DB2)- Taxonomy- Applications-
Design 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 Structures-
Spatial Access Methods- Spatial DB Implementation.

UNIT IV ADVANCED DATA MODELS 9
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.

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.
                                                                                    TOTAL: 45 PERIODS
OUTCOMES:
Upon completion of the course, the students will be able to
 Select the appropriate high performance database like parallel and distributed database
 Model and represent the real world data using object oriented database
 Design a semantic based database to meaningful data access
 Embed the rule set in the database to implement intelligent databases
 Represent the data using XML database for better interoperability
 Handle Big data and store in a transparent manner in the cloud
 To solve the issues related to the data storage and retrieval

EBOOKS

 

DOWNLOAD