Last Updated on by ICT Byte
Course Title: Advanced Database Concepts
Full Marks: 45 + 30
Course No: C.Sc. 563
Pass Marks: 22.5 + 15
Nature of the Course: Theory + Lab
Credit Hrs: 3
- Course Objectives:
- Unit 1: File Organizations and Indexes 8 Hrs
- Unit 2: Algorithms for Query Processing and Optimization 8 Hrs
- Unit 3: Database Security and Authorization 8 Hrs
- Unit 4: Object-Oriented Databases 8 Hrs
- Unit 5: Object Relational and Extended Relational Databases 8 Hrs
- Unit 6: Parallel and Distributed Databases and Client-Server Architecture 8 Hrs
- References:
Course Objectives:
To study the further advanced database techniques beyond the fundamental database techniques which were covered in the graduate level course, and thus, to acquaint the students with some relatively advanced issues. At the end of the course students should be able to gain an awareness of the basic issues in file organizations, indexes, query processing and optimization, database security and authorization, objected oriented, and object relational databases, and distributed, and client server architectures.
Unit 1: File Organizations and Indexes 8 Hrs
Introduction; Secondary Storage Devices; Buffering Blocks; Placing File Records on Disk; Operations on Files; Files of Unordered Records; Files of Ordered Records; Hashing Techniques; Other Primary File Organizations; Parallelizing Disk Access Using RAID Technology; Storage Area Networks; Indexing Structures for Files
Unit 2: Algorithms for Query Processing and Optimization 8 Hrs
Translating SQL Queries into Relational Algebra; Algorithms for External Sorting; Algorithms for SELECT and JOIN Operations; Algorithms for PROJECT and SET Operations Implementing Aggregate Operations and Outer Joins; Combining Operations Using Pipeline; Using Heuristics in Query Optimization; Using Selectivity and Cost Estimates in Query Optimization; Semantic Query Optimization
Unit 3: Database Security and Authorization 8 Hrs
Introduction to Database Security Issues; Discretionary Access Control Based on Granting and Revoking Privileges; Mandatory Access Control and Role-Based Access Control for Multilevel Security; Introduction to Statistical Database Security; Introduction to Flow Control; Encryption and Public Key Infrastructure
Unit 4: Object-Oriented Databases 8 Hrs
Overview of Object-Oriented concepts, Object identity, Object structure, and type constructors, Encapsulation of operations, Methods, and Persistence, Type hierarchies and Inheritance, Type extents and queries, Complex objects; Database schema design for OODBMS; OQL, Persistent programming languages; OODBMS architecture and storage issues; Transactions and Concurrency control, Example of ODBMS
Unit 5: Object Relational and Extended Relational Databases 8 Hrs
Database design for an ORDBMS – Nested relations and collections; Storage and access methods, Query processing and Optimization; an overview of SQL3, Implementation issues for extended type; Systems comparison of RDBMS, OODBMS, ORDBMS
Unit 6: Parallel and Distributed Databases and Client-Server Architecture 8 Hrs
Architectures for parallel databases, Parallel query evaluation; Parallelizing individual operations, Sorting, Joins; Distributed database concepts, Data fragmentation, Replication, and allocation techniques for distributed database design; Query processing in distributed databases; Concurrency control and Recovery in distributed databases. An overview of Client-Server architecture
References:
- Elmasri and Navathe, Fundamentals of Database Systems [4e], Pearson Education
- Raghu Ramakrishnan, Johannes Gehrke, Database Management Systems [3e], McGraw-Hill
- Korth, Silberchatz, Sudarshan , Database System Concepts, McGraw-Hill.
- Peter Rob and Coronel, Database Systems, Design, Implementation and Management, Thomson Learning.
- C.J.Date, Longman, Introduction to Database Systems, Pearson Education