UNIT 1:
Purpose of Database system
Views of data – Data Models
Database System Architecture
Introduction to relational databases
UNIT 2:
Entity-Relationship model
Non-loss Decomposition, Normalization
UNIT 3:
Properties of transactions
Concurrency Control & Need
Isolation Levels – SQL Facilities for Concurrency and Recovery
Isolation Levels – SQL Facilities for Concurrency and Recovery
UNIT 4:
– File Organization – Organization of Records in Files – Indexing and Hashing
Ordered Indices – B+ tree Index Files
B tree Index Files – Static Hashing – Dynamic Hashing
Query Processing Overview
Algorithms for SELECT and JOIN operations
Algorithms for SELECT and JOIN operations
Heuristics and Cost Estimation
UNIT 5:
ODL, OQL - XML Databases: XML Hierarchical Model
Information Retrieval: IR Concepts
Retrieval Models, Queries in IR systems
Data Storage, Transaction Processing
Object-Relational features