CS8071- ADVANCED TOPICS ON DATABASES Syllabus 2017 Regulation
ADVANCED TOPICS ON DATABASES Syllabus 2017 Regulation,CS8071- ADVANCED TOPICS ON DATABASES Syllabus 2017 Regulation
CS8071 ADVANCED TOPICS ON DATABASES L T P C 3 0 0 3
- 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 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.
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
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.
- Ramez Elmasri, Shamkant B. Navathe, ―Fundamentals of Database Systems, Sixth Edition , Pearson, 2011.
- Thomas Cannolly and Carolyn Begg, ―Database Systems, A Practical Approach to Design, Implementation and Management, Fourth Edition, Pearson Education, 2008.
- Henry F Korth, Abraham Silberschatz, S. Sudharshan, ―Database System Concepts, Sixth Edition, McGraw Hill, 2011.
- C.J.Date, A.Kannan, S.Swamynathan, ―An Introduction to Database Systems, Eighth Edition, Pearson Education, 2006.
- Carlo Zaniolo, Stefano Ceri, Christos Faloutsos, Richard T.Snodgrass, V.S.Subrahmanian, Roberto Zicari, ―Advanced Database Systems, Morgan Kaufmann publishers,2006.