Wednesday 19 October 2011
Tuesday 18 October 2011
Database Management System
UNIT 1: INTRODUCTION
File systems versus Database systems – Data Models – DBMS Architecture – Data Independence – Data Modeling using Entity – Relationship Model – Enhanced E-R Modeling.
File systems versus Database systems – Data Models – DBMS Architecture – Data Independence – Data Modeling using Entity – Relationship Model – Enhanced E-R Modeling.
UNIT 2: STORAGE STRUCTURES
Secondary storage Devices – RAID Technology – File operations – Hashing Techniques – Indexing – Single level and Multi-level Indexes – B+ tree – Indexes on Multiple Keys.
UNIT 3: RELATIONAL MODEL
Relational Model Concepts – Relational Algebra – SQL – Basic Queries – Complex SQL Queries – Views – Constraints – Relational Calculus – Tuple Relational Calculus – Domain Relational Calculus – overview of commercial RDBMSs – Database Design – Functional Dependencies – Normal Forms – 1NF – 2NF-3NFBCNF – 4NF-5NF – Database Tuning.
Secondary storage Devices – RAID Technology – File operations – Hashing Techniques – Indexing – Single level and Multi-level Indexes – B+ tree – Indexes on Multiple Keys.
UNIT 3: RELATIONAL MODEL
Relational Model Concepts – Relational Algebra – SQL – Basic Queries – Complex SQL Queries – Views – Constraints – Relational Calculus – Tuple Relational Calculus – Domain Relational Calculus – overview of commercial RDBMSs – Database Design – Functional Dependencies – Normal Forms – 1NF – 2NF-3NFBCNF – 4NF-5NF – Database Tuning.
UNIT 4: QUERY AND TRANSACTION PROCESSING
Algorithms for Executing Query Operations – using Hermistics in Query operations – Cost Estimation – Semantic Query Optimization – Transaction Processing – Properties of Transactions - Serializability – Transaction support in SQL.
Algorithms for Executing Query Operations – using Hermistics in Query operations – Cost Estimation – Semantic Query Optimization – Transaction Processing – Properties of Transactions - Serializability – Transaction support in SQL.
UNIT 5: CONCURRENCY, RECOVERY AND SECURITY
Locking Techniques – Time Stamp ordering – Validation Techniques – Granularity of Data Items – Recovery concepts – Shadow paging – Log Based Recovery – Database Security Issues – Access control – Statistical Database Security.
Text Book: Locking Techniques – Time Stamp ordering – Validation Techniques – Granularity of Data Items – Recovery concepts – Shadow paging – Log Based Recovery – Database Security Issues – Access control – Statistical Database Security.
1. “Database System Concepts”, Abraham Silberschatz, Henry F. Korth and S. Sudarshan, McGraw-Hill, - Fourth Edition, 2002.
Reference Books :
1. “Fundamental Database Systems”, Ramez Elmasri and Shamkant B. Navathe, Pearson Education, Third Edition, 2003.
2. “Database Management System”, Raghu Ramakrishnan, Tata McGraw- Hill Publishing Company, 2003.
3. “Database System Implementation”, Hector Garcia–Molina, Jeffrey D.Ullman and Jennifer Widom, Pearson Education, 2000.
4. “Database System, Design, Implementation and Management”, Peter Rob and Corlos Coronel, Thompson Learning Course Technology, Fifth edition, 2003
Subscribe to:
Posts (Atom)