Advanced Database Systems

CS6005
CSE

Unit 1

PARALLEL AND DISTRIBUTED DATABASES

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. I

Part A (2m) Part B (16m)

Unit 2

ACTIVE DATABASES

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. 88 I

Part A (2m) Part B (16m)

Unit 3

TEMPORAL AND OBJECT DATABASES

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.

Part A (2m) Part B (16m)

Unit 4

COMPLEX QUERIES AND REASONING

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.

Part A (2m) Part B (16m)

Unit 5

SPATIAL, TEXT AND MULTIMEDIA DATABASES

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

Part A (2m) Part B (16m)
Related Notes