BA5020 Syllabus - Advanced Database Management System - 2017 Regulation Anna University

BA5020 Syllabus - Advanced Database Management System - 2017 Regulation Anna University

BA5020

ADVANCED DATABASE MANAGEMENT SYSTEM

 L T P C

3 0 0 3

OBJECTIVES:
• To understand the various advanced databases used in the organization
• To be aware of recent trends in database management.

UNIT I

INTRODUCTION

9

DBMS Models - Multimedia Databases, Parallel Databases, embedded, web, spatial, temporal databases, Virtualization, Active Databases - Embedded databases - Web databases.

UNIT II

DATABASE IMPLEMENTATION

9

Query Processing basics and optimization – Heuristic Optimization – Transactions Models – Concurrency Control – Recovery – Security and Authorization – Storage – Indexing and Hashing – ISAM – B-Trees – Kd Trees – X Trees – Dynamic Hashing.

UNIT III

DISTRIBUTED DATABASES

9

Distributed Databases – Queries – Optimization Access Strategies – Distributed Transactions Management – Concurrency Control – Reliability

UNIT IV

OBJECT ORIENTED DATABASES

9

Object Oriented Concepts – Data Object Models –Object Oriented Databases – Issues in OODBMS - Object Oriented Relational Databases – Object Definition Languages – Object Query Languages

UNIT V

EMERGING TRENDS

9

Data Mining – Data warehousing – Star, Snowflake, Fact Constellation; open source database systems, Scripting Language, JDBC, ODBC

TOTAL: 45 PERIODS

OUTCOMES:
• Awareness of database models
• Knowledge of database technologies

REFERENCES:
1. Peter Rob, Carlos Coronel, Database System and Design, Implementation and Management,8 th edition, Cengage,
2. Ramez Elmasri and Shamkant B. Navethe,Fundamentals of Database Systems,7th edition , Pearson Education, 2015.
3. Jeffrey A Hoffer et al, Modern Database Management, 12th Edition, Pearson Education, 2016,
4. Abraham Silberchatz, Henry F. Korth and S.Sudarsan, Database System Concepts, 6th Edition, McGraw-Hill, 2015.
5. Thomas M. Connolly and Carolyn E. Begg, Database Systems – A Practical Approach to Design, Implementation and Management, 6 th edition, Pearson Education, 2015.
6. Jefrey D. Ullman and Jenifer Widom, A First Course in Database Systems, 3 rd edition, Pearson Education Asia, 2013.
7. Stefano Ceri and Giuseppe Pelagatti, Distributed Databases Principles and Systems, McGraw-Hill International Editions, 2008.
8. Rajesh Narang, Object Oriented Interfaces and Databases, 1st edition ,Prentice Hall of India, 2004.
9. Mark L.Gillenson & el, Introduction to database management, 2 nd edition, Wiley India Pvt. Ltd, 2012
10. Charkrabarti, Advanced Database Management Systems, Wiley India Pvt Ltd, 2011

Comments

Popular posts from this blog

CS3491 Syllabus - Artificial Intelligence And Machine Learning - 2021 Regulation Anna University

CS3401 Syllabus - Algorithms - 2021 Regulation Anna University

CS3492 Syllabus - Database Management Systems - 2021 Regulation Anna University