Engineering Tutorials

CSE-434 E Advanced Database Management Systems

Class Work: 50
Exam: 100

Unit-1: Data Models:

EER model and relationship to the OO model, Object Oriented data model and ODMG standard, Other data models – NIAM, GOOD, ORM.

Query Optimisation:

Query Execution Algorithms, Heuristics in Query Execution, Cost Estimation in Query Execution,

Semantic Query Optimisation.

Database Transactions and Recovery Procedures:

Transaction Processing Concepts, Transaction and System Concepts, Desirable Properties of a Transaction, Schedules and Recoverability, Serializability of Schedules, Transaction Support in SQL, Recovery Techniques, Database Backup,

Concurrency control,

Locking techniques for Concurrency Control, Concurrency Control Techniques, Granularity of Data Items.

Unit-2:

Client Server Computing:

Client Server Concepts, 2-Tier and 3-Tier Client Server Systems, Client/Server Architecture and the Internet, Client /Database Server Models, Technology Components of Client Server Systems, Application Development in Client Server Systems.

Distributed Databases:

Reliability and Commit protocols, Fragmentation and Distribution, View Integration, Distributed database design, Distributed algorithms for data management, Heterogeneous and Federated Database Systems.

Unit-3: Deductive Databases:

Recursive Queries, Prolog/Datalog Notation, Basic inference Mechanism for Logic Programs, Deductive Database Systems, Deductive Object Oriented Database Systems.

Commercial and Research Prototypes: Parallel database, Multimedia database, Mobile database,

Digital libraries, Temporal database.

Text Book:

• Fundamentals of Database Systems (3 edition), Elmasri R. and Navathe S.B., 2000, Addison Wesley, Low Priced Edition.

Reference Book:

• Database System Concepts by A. Silbershatz, H.F. Korth and S. Sudarshan, 3rd edition, 1997, McGraw-Hill, International Edition.

Note: Eight questions will be set in all by the examiners taking at least two questions from each unit. Students will be required to attempt five questions in all.

Related posts:

1. MDU Syllabus | F-Scheme | CSE-202 F Database Management Systems
2. CSE-202 E Database Management Systems
3. PTU Syllabus | CS– 305 DATABASE MANAGEMENT SYSTEMS
4. CSE- 212 E Database Management Systems Lab
5. MDU Syllabus | F-Scheme | CSE- 212 F Database Management Systems Lab