Anna University 2013 Regulation - CS6005 Advanced Database Systems - Syllabus - Download

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.

Anna University 2013 Regulation - CS6005 Advanced Database Systems - Syllabus - Download