CA5105-Database Management Systems |
FUNDAMENTALS |
Database Systems vs. File Systems – View of Data – Data Models – Database
Languages – Transaction Management – Database Systems Structure – History of
Database Systems – Database Systems Applications – Entity Relationship Model |
RELATIONAL DATABASES |
The Relation - Keys - Constraints - Relational Algebra and Calculus – Queries -SQL –
Basic Structure – Set Operations – Complex Queries – Joined Queries – DDL –
Embedded SQL – Dynamic SQL –Other SQL Functions – Query by Example –
Integrity and Security of searching – Relational Database Design. |
DATA STORAGE AND INDEXING |
Storage & File Structure – Disks – RAID – File Organization – Indexing & Hashing –
B+ TREE – B Tree – Static Hashing – Dynamic Hashing – Multiple Key Access
|
QUERY EVALUATION & OPTIMIZATION |
Query Processing – Selection Operation – Sorting – Join Operation – Evaluation of
Expressions – Query Optimization
|
TRANSACTION MANAGEMENT |
Transaction Concept – Static Implementation – Concurrency Control – Protocols –
Deadlock Handling – Recovery Systems – Recovery with Concurrent Transactions –
Shadow Paging – Buffer Management – Case Studies – Oracle – Microsoft SQL Server |
Text Books |
1. Abraham Silberschatz, Henry F. Korth and S. Sudharsan, “Database System
Concepts”, Fifth Edition, Tata McGraw Hill, 2006.
2. C.J Date, A. Kannan and S. Swamynathan, “An Introduction to Database
Systems”, Eighth Edition, Pearson Education, 2006. |
Reference Books |
1. Raghu Ramakrishnan and Johannesgerhrke, “DataBase Management Systems”,
Third Edition, McGraw Hill, 2003.
2. R. Elmasri, S.B. Navathe, “Fundamentals of Database Systems”, Pearson
Education, 2004 |