RDBMS-II

BTCS 602 RDBMS–II Class Notes and PPTs.

BTCS 602 RDBMS–II (According to PTU Syllabus).

Objectives: This course offers a good understanding of advanced database concepts and technologies. It prepares the student to be in a position to use and design databases for a variety of applications.

Introduction to Database Systems: Database System Concepts and Architecture, Data Models, Data
Independence, SQL: DDL, DML, DCL, Normalization: 1NF, 2NF, 3NF, BCNF, 4NF, 5NF.

Query Processing and Optimization:
Query Processing, Syntax Analyzer, Query Decomposition, Query Optimization, Heuristic Query
Optimization, Cost Estimation, Cost Functions for Select, Join, Query Evaluation Plans.

Transaction Processing and Concurrency Control:
Transaction Processing Concepts, Concurrency Control Techniques: Two-phase Locking, Timestamp
Ordering, Multiversion, Validation, Multiple Granularity Locking.

Object Oriented and Object Relational Databases:
Object Oriented Concepts, Object Oriented Data Model, Object Definition Language, Object Query
Language, Object Relational Systems, SQL3, ORDBMS Design.

Distributed Databases:
Distributed Database Concepts, Advantages and Disadvantages, Types of Distributed Database Systems, Data Fragmentation, Replication and Allocation Techniques for Distributed Database Design, Five Level Schema
Architecture, Query Processing, Concurrency Control and Recovery in Distributed Databases.

Backup and Recovery:
Types of Database Failures, Types of Database Recovery, Recovery Techniques: Deferred Update, Immediate
Update, Shadow Paging, Checkpoints, Buffer Management.

Introduction to Data Warehousing and Data Mining:
Introduction to OLAP, OLTP, Data Warehouse, Data Marts, Data Mining, Data Mining Process, Big Data.

Enterprise Database Products:
Enterprise Database Products, Familiarity with IBM DB2 Universal Database, Oracle, Microsoft SQL Server,
MySQL, their features.

Share this: