Rajiv Gandhi Technological University, Bhopal (MP)
M.Tech. Sofware Engineering
Advanced DBMS Syllabus,
Enforced From Session 2009-10
SECOND SEMESTER (PROPOSED)
M.Tech. Sofware Engineering
Advanced DBMS Syllabus,
Enforced From Session 2009-10
SECOND SEMESTER (PROPOSED)
UNIT-1 : DBMS Concept Introduction, Data Model, Entity & Attributes, Relationship, E-R Model, Relational Data Model, Domain Tuples, Attributes, Key, Schema, Integrity Constraints, Relational Algebra & Relational Calculus, Normalization & Normal Form.
Unit-2: Query Processing and Optimization Introduction, Query Processing, Syntax Analyzer, Query Decomposition:- Query Analysis, Query Normalization, Semantic Analyzer, Query Simplifier, Query Restructuring. Query Optimization, Cost Estimation in Query Optimization, Structure of Query Evaluation Plans, Pipelining and Materialization.
Unit-3: Distributed Databases Introduction, Architecture of Distributed Databases , Distributed Database System Design, Distributed Query Processing, Concurrency Control in Distributed Databases, Recovery Control in Distributed Databases.
Unit-4: Object-Oriented Databases Introduction, Concept of Object Oriented Database,Object Oriented Data Model(OODM), Object-Oriented DBMS(OODBMS), Object Data Management Group and Object-Oriented Languages. Object-Relational DBMS, ORDBMS Design, ORDBMS Query Language.
Unit-5: Web Databases, Multimedia Databases, Spatial Databases, Clustering-based Disaster-proof Databases, Mobile Databases.
References:
1. S.K Singh, Database Systems Concepts, Design and Applications, Pearson Education.
2. Ceri & Pelagatti, Distributed Databases Principles & Systems,TMH
3. Patrick O’Neil & Elizabeth O’Neil, Database Principles, Programming and Performance, Morgan Kaufmann Hardcourt India.
Unit-2: Query Processing and Optimization Introduction, Query Processing, Syntax Analyzer, Query Decomposition:- Query Analysis, Query Normalization, Semantic Analyzer, Query Simplifier, Query Restructuring. Query Optimization, Cost Estimation in Query Optimization, Structure of Query Evaluation Plans, Pipelining and Materialization.
Unit-3: Distributed Databases Introduction, Architecture of Distributed Databases , Distributed Database System Design, Distributed Query Processing, Concurrency Control in Distributed Databases, Recovery Control in Distributed Databases.
Unit-4: Object-Oriented Databases Introduction, Concept of Object Oriented Database,Object Oriented Data Model(OODM), Object-Oriented DBMS(OODBMS), Object Data Management Group and Object-Oriented Languages. Object-Relational DBMS, ORDBMS Design, ORDBMS Query Language.
Unit-5: Web Databases, Multimedia Databases, Spatial Databases, Clustering-based Disaster-proof Databases, Mobile Databases.
References:
1. S.K Singh, Database Systems Concepts, Design and Applications, Pearson Education.
2. Ceri & Pelagatti, Distributed Databases Principles & Systems,TMH
3. Patrick O’Neil & Elizabeth O’Neil, Database Principles, Programming and Performance, Morgan Kaufmann Hardcourt India.
ConversionConversion EmoticonEmoticon