15PCS305 Advanced Databases: Course Objectives

Download as docx, pdf, or txt
Download as docx, pdf, or txt
You are on page 1of 2

15PCS305 ADVANCED DATABASES 3 1 0 4

COURSE OBJECTIVES

 To understand the system architecture of distributed and parallel databases


 To have a thorough knowledge about object and object relational databases
 To gain knowledge about the XML databases and multimedia databases
 To have an introductory knowledge about mobile databases and the emerging trends in the area of
Data mining and Data Warehousing.

UNIT I PARALLEL AND DISTRIBUTED DATABASES 14

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 – Distributed Database Concepts - Distributed Data Storage – Distributed
Transactions – Commit Protocols – Concurrency Control – Distributed Query Processing – Three Tier Client Server
Architecture-Case Studies.

UNIT II OBJECT AND OBJECT RELATIONAL DATABASES


12
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 XML DATABASES 10


XML Databases: XML Data Model – DTD - XML Schema - XML Querying – Web Databases – JDBC –
Information Retrieval – Data Warehousing – Data Mining –Database Tuning

UNIT IV MOBILE DATABASES 12


Mobile Databases: Location and Handoff Management - Effect of Mobility on Data Management -Location
Dependent Data Distribution - Mobile Transaction Models - Concurrency Control – Transaction Commit Protocols-
Mobile Database Recovery Schemes

UNIT V MULTIMEDIA DATABASES 12


Multidimensional Data Structures – Image Databases – Text/Document Databases- Video Databases – Audio
Databases – Multimedia Database Design.

STATE OF ART (NOT FOR EXAMINATION)


JSON - Complex Event Processing - Data Stream Management System -No SQL -In memory database

TOTAL: 60
2. COURSE OUTCOMES
At the end of the course the student should be able to

 Be familiar with basic concepts and applications of database systems


 Develop a XML database
 Understand the concepts of mobile databases and its recovery schemes
 Differentiate various types of multimedia databases

REFERENCES

1. R. Elmasri, S.B. Navathe, “Fundamentals of Database Systems”, Sixth Edition, Pearson


Education/Addison Wesley, 2011.
2. Thomas Cannolly and Carolyn Begg, “ Database Systems, A Practical Approach to
Design, Implementation and Management”, 5th Edition, Pearson Education, 2009.
3. Henry F Korth, Abraham Silberschatz, S. Sudharshan, “Database System Concepts”, McGraw Hill, 2010.
4. C.J.Date, A.Kannan and S.Swamynathan, “An Introduction to Database Systems”, Eighth Edition,Pearson
Education, 2006.
5. V.S.Subramanian, “Principles of Multimedia Database Systems”, Second Edition, Harcourt India Pvt Ltd., 2013.
6. Vijay Kumar, “Mobile Database Systems”, John Wiley & Sons, 2006.

You might also like