Anna University B.Tech CS (R13) 7th Sem Advanced Database Systems Detailed Syllabus

Advanced Database Systems Syllabus for B.Tech 7th sem is covered here. This gives the details about credits, number of hours and other details along with reference books for the course.

The detailed syllabus for Advanced Database Systems B.Tech (R13) seventhsem is as follows

OBJECTIVES: The student should be made to:

• Learn different types of databases.
• Be exposed to query languages.
• Be familiar with the indexing techniques.

UNIT I : PARALLEL AND DISTRIBUTED DATABASES             [9 hours]
Inter and Intra Query Parallelism – Architecture – Query evaluation Optimization – Distributed Architecture – Storage – Catalog Management – Query Processing – Transactions – Recovery – Large-scale Data Analytics in the Internet Context – Map Reduce Paradigm – run-time system for supporting scalable and fault-tolerant execution – paradigms: Pig Latin and Hive and parallel databases versus Map Reduce.

UNIT II :  ACTIVE DATABASES            [9 hours]
Syntax and Sematics (Starburst, Oracle, DB2) – Taxonomy – Applications – Integrity Management – Workflow Management – Business Rules – Design Principles – Properties – Rule Modularization – Rule Debugging – IDEA methodology – Open Problems.

UNIT III : TEMPORAL AND OBJECT DATABASES             [9 hours]
Overview – Data types – Associating Facts – Temporal Query Language – TSQL2 – Time Ontology – Language Constructs – Architecture – Temporal Support – Object Database and Change Management – Change of Schema – Implementing Database Updates in O2 – Benchmark Database Updates – Performance Evaluation.

Download iStudy Android App for complete Anna University syllabus, results, timetables and all other updates. There are no ads and no pdfs and will make your life way easier.

TOTAL: 45 PERIODS

OUTCOMES: Upon completion of the course, the student should be able to:

• Design different types of databases.
• Use query languages.
• Apply indexing techniques.

TEXT BOOK:

• Raghu Ramakrishnan “Database Management System”, Mc Graw Hill Publications, 2000.

REFERENCES:

• Carlo Zaniolo, Stefano Ceri “Advanced Database Systems”, Morgan Kauffmann Publishers.VLDB Journal, 1997
• Abraham Silberschatz, Henry F. Korth and S. Sudharshan, “Database System Concepts”, Sixth Edition, Tata McGraw Hill, 2011

For all other B.Tech CSE 7th sem syllabus go to Anna University B.Tech COMPUTER SCIENCE AND ENGINEERING (CSE) 7th Sem Course Structure for (R13) Batch.All details and yearly new syllabus will be updated here time to time. Subscribe, like us on facebook and follow us on google plus for all updates.

Do share with friends and in case of questions please feel free drop a comment.