UNIT – I
Object-based Databases : Object-Oriented Databases: Object-oriented data model, Object, Oriented Languages, Persistent Programming Languages. Object-Relational Databases: Nested Relations, Complex Types, . Inheritance, Reference Types, Querying with Complex Types, Functions and Procedures Storage for Object Databases
UNIT – II
Distributed Databases : Distributed Data Storage, Distributed Transactions, Commit protocol,Concurrency Control in Distributed Databases, Availability, Distributed Query Processing
UNIT – III
Parallel Databases : I/O Parallelism, Interquery Parallelism, Intraquery Parallelism,
Intraoperation Parallelism, Interoperation Parallelism, Design of Parallel Systems
UNIT – IV
Deductive Databases : Introduction to Recursive Queries, Theoretical Foundations, Recursive Queries with Negation, From Datalog to SQL, Evaluating Recursive Queries
UNIT – V
Information Retrieval and XML Data : Introduction to Information Retrieval, Indexing for Text Search, Web Search Engines, Managing Text in a DBMS, A Data Model for XML, Xquery, Efficient Evaluation of XML Queries.
UNIT – VI
PL/SQL basics, blocks, architecture, variables an constants, attributes, character set, PL/SQL sentence structure, data types, precompiler, conditional and sequential control statements, control structures, conditional control, sequential control, cursors, exceptions, triggers, procedures and packages.
