Database Internals Detailed Syllabus for Web Technology M.Tech first year first sem is covered here. This gives the details about credits, number of hours and other details along with reference books for the course.
The detailed syllabus for Database Internals M.Tech 2017-2018 (R17) first year first sem is as follows.
M.Tech. I Year I Sem.
Course Objectives: By the end of the course, student will know:
- History and Structure of databases
- How to design a database
- How to convert the design into the appropriate tables
- Handling Keys appropriately
- Enforcing Integrity Constraints to keep the database consistent
- Normalizing the tables to eliminate redundancies
- Querying relational data
- and processing the queries
- Storage Optimizing Strategies for easy retrieval of data through index
- Triggers, Procedures and Cursors ,Transaction Management
- Distributed databases management system concepts and Implementation
UNIT – I : Database System Applications, Purpose of Database Systems, View of Data – Data Abstraction, Instances and Schemas, Data Models – the ER Model, Relational Model, Other Models – Database Languages – DDL, DML, Database Access from Applications Programs, Transaction Management, Data Storage and Querying, Database Architecture, Database Users and Administrators, ER diagrams,. Relational Model: Introduction to the Relational Model – Integrity Constraints Over Relations, Enforcing Integrity constraints, Querying relational data, Logical data base Design, Introduction to Views –Altering Tables and Views, Relational Algebra, Basic SQL Queries, Nested Queries, Complex Integrity Constraints in SQL, Triggers
UNIT – II : Introduction to Schema Refinement – Problems Caused by redundancy, Decompositions – Problem related to decomposition, Functional Dependencies – Reasoning about FDS, Normal Forms – FIRST, SECOND, THIRD Normal forms – BCNF –Properties of Decompositions- Loss less- join Decomposition, Dependency preserving Decomposition, Schema Refinement in Data base Design – Multi valued Dependencies – FOURTH Normal Form, Join Dependencies, FIFTH Normal form.
UNIT – III : Transaction Management: The ACID Properties, Transactions and Schedules, Concurrent Execution of Transactions – Lock Based Concurrency Control, Deadlocks – Performance of Locking – Transaction Support in SQL. Concurrency Control: Serializability, and recoverability – Introduction to Lock Management – Lock
Conversions, Dealing with Deadlocks, Specialized Locking Techniques – Concurrency Control without Locking. Crash recovery: Introduction to Crash recovery, Introduction to ARIES, the Log, and Other Recovery related Structures, the Write-Ahead Log Protocol, Check pointing, recovering from a System Crash, Media recovery
UNIT – IV : Overview of Storage and Indexing: Data on External Storage, File Organization, and Indexing – Clustered Indexes, Primary and Secondary Indexes, Index data Structures – Hash Based Indexing, Tree based Indexing, Storing data: Disks and Files: -The Memory Hierarchy – Redundant Arrays of Independent Disks. Tree Structured Indexing: Intuitions for tree Indexes, Indexed Sequential Access Methods (ISAM), B+ Trees: A Dynamic Index Structure, Search, Insert, Delete. Hash Based Indexing: Static Hashing, Extendable hashing, Linear Hashing, Extendable Vs Linear Hashing.
UNIT – V : Distributed databases: Introduction to distributed databases, Distributed DBMS architectures, Storing data in a distributed DBMS, Distributed catalog management, Distributed query processing Updating distributed data, Distributed transactions, Distributed concurrency control, Distributed recovery
TEXT BOOKS:
- Data base Management Systems, Raghu Ramakrishnan, Johannes Gehrke, TMH, 3rd Edition, 2003.
- Data base System Concepts, A. Silberschatz, H.F. Korth, S. Sudarshan, McGraw hill, VI edition, 2006.
- Fundamentals of Database Systems 5th edition, Ramez Elmasri, Shamkant B. Navathe, Pearson Education, 2008.
REFERENCE BOOKS:
- Introduction to Database Systems, C.J. Date, Pearson Education.
- Database Management System Oracle SQL and PL/SQL, P.K. Das Gupta, PHI.
- Database System Concepts, Peter Rob, & Carlos Coronel, Cengage Learning, 2008.
- Database Systems, A Practical approach to Design Implementation and Management Fourth edition, Thomas Connolly, Carolyn Begg, Pearson education.
- Database-Principles, Programming and Performance, P. O’Neil & E. O’Neil, 2nd ed, ELSEVIER
- Fundamentals of Relational Database Management Systems, S. Sumathi, S. Esakkirajan, Springer.
- Introduction to Database Management, M.L. Gillenson and others, Wiley Student Edition.
- Database Development and Management, Lee Chao, Auerbach publications, Taylor & Francis Group.
- Distributed Databases Principles & Systems, Stefano Ceri, Giuseppe Pelagatti, TMH.
- Principles of Distributed Database Systems, M. Tamer Ozsu, Patrick Valduriez , Pearson Education, 2nd Edition.
- Distributed Database Systems, Chhanda Ray, Pearson
For all other M.Tech 1st Year 1st Sem syllabus go to JNTUH M.Tech Web Technology 1st Year 1st Sem Course Structure for (R17) Batch.
All details and yearly new syllabus will be updated here time to time. Subscribe, like us on facebook and follow us on google plus for all updates.
Do share with friends and in case of questions please feel free drop a comment.