CS6005 ADVANCED DATABASE SYSTEMS |syllabus (ELECTIVE-II)

CS6005      ADVANCED DATABASE SYSTEMS L T P C 3 0 0 3

                                                                                     

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)

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)

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)

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.

UNIT IV      COMPLEX QUERIES AND REASONING    (9)

Logic of Query Languages – Relational Calculi – Recursive rules – Syntax and semantics of Data log
– Fix point semantics – Implementation Rules and Recursion – Rule rewriting methods – Compilation
and Optimization – Recursive Queries in SQL – Open issues.

UNIT V      SPATIAL, TEXT AND MULTIMEDIA DATABASES    (9)

Traditional Indexing Methods (Secondary Keys, Spatial Access Methods) – Text Retrieval –
Multimedia Indexing – 1D Time Series – 2d Color images – Sub pattern Matching – Open Issues –
Uncertainties.

                                                                                                                       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:

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

REFERENCES:

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

Click here to download full syllabus                           AULibrary.com