Syllabus
UNIT-I
Object Based Databases: Overview, Complex Data Types, Structured Types and Inheritance in SQL, Table Inheritance, Array and Multi-set. Types in SQL, Object-Identity and Reference Types in SQL, Implementing O-R features, Persistent Programming Languages, Object-Relational Mapping, and Object-Oriented versus Object-Relational.
UNIT-II
XML: Motivation, Structure of XML data, XML Document Schema, Querying and Transformation, Application Program Interface to XML, Storage of XML data, XML applications.
UNIT-III
Query Processing: Overview, Measures of Query Cost, Selection Operation, Sorting, join Operation, Other Operations, Evaluation of Expressions.
Query Optimization: Overview, Transformation of Relational Expressions, Estimating Statistics of Expression Results, Choice of Evaluation Plans, Materialized Views.
UNIT-IV
Parallel Databases : Introduction, 1/0 Parallelism, Inter query Parallelism, Intra query Parallelism, Intra- operation Parallelism, Interoperation Parallelism, Query Optimization, Design of Parallel Systems.
Distributed Databases: Homogeneous and Heterogeneous Database, Distributed Data Storage, Distributed. Transactions, Commit Protocols, Concurrency Control in Distributed Databases, Availability and Distributed Query Processing, Heterogeneous Distributed Databases, Cloud-Based Databases and Directory Systems.
UNIT-V
Advanced Application Development: Performance Tuning, Performance Benchmarks Other Issues in Application Development, Standardization.
Spatial and Temporal Data and Mobility: Motivation, Time in Databases, Spatial and Geographic Data, Multimedia Databases, Mobility and Personal Databases.
Previous year question papers
