RGPV / RGTU M.Tech. Sofware Engineering 2nd sem Advanced DBMS Syllabus

siteowner 2:16 AM
Tags: Advanced DBMS Syllabus, M.Tech Syllabus, Sofware Engineering M.Tech Syllabus, Advanced DBMS Syllabus, M.Tech 2nd sem Syllabus, Sofware Engineering M.Tech 2nd semester Syllabus, RGPV, RGTU,


Rajiv Gandhi Technological University, Bhopal (MP)
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.

Artikel Terkait

Previous
Next Post »