Regulation 2017 CS8071 Advanced Topics On Databases Syllabus
OBJECTIVES:
To learn the modeling and design of databases.
To acquire knowledge on parallel and distributed databases and their applications.
To study the usage and applications of Object Oriented and 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 SystemsDistributed 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- ApplicationsDesign Principles for Active Rules- Temporal Databases: Overview of Temporal DatabasesTSQL2- 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 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 WarehousingData Mining- Text Mining.
UNIT V EMERGING TECHNOLOGIES 9
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 develop in-depth understanding of relational databases and skills to optimize database
performance in practice.
To understand and critique on each type of databases.
To design faster algorithms in solving practical database problems.
To implement intelligent databases and various data models.
TEXT BOOKS:
1. Ramez Elmasri, Shamkant B. Navathe, ―Fundamentals of Database Systems‖, Sixth Edition ,Pearson, 2011.
2. Thomas Cannolly and Carolyn Begg, ―Database Systems, A Practical Approach to Design,Implementation and Management‖, Fourth Edition, Pearson Education, 2008.
REFERENCES:
1. Henry F Korth, Abraham Silberschatz, S. Sudharshan, ―Database System Concepts‖, Sixth Edition, McGraw Hill, 2011.
2. C.J.Date, A.Kannan, S.Swamynathan, ―An Introduction to Database Systems‖, Eighth Edition, Pearson Education, 2006.
3. Carlo Zaniolo, Stefano Ceri, Christos Faloutsos, Richard T.Snodgrass, V.S.Subrahmanian,Roberto Zicari, ―Advanced Database Systems‖, Morgan Kaufmann publishers,2006.