National University of Sciences and Technology
Nust Home
ALUMNI
Contact Us
Home
All Courses
Home
>
Courses Detail
Home
|
Back
ISE-830 Advance Database Concepts
Campus
SEECS
Programs
PG
Session
Fall Semester 2016
Course Title
Advance Database Concepts
Course Code
ISE-830
Credit Hours
3.0
Pre-Requisutes
Database Design and Implementation
Course Objectives
On successful completion of this course students will be able to:
Demonstrate queries in the relational algebra by using operations from set theory (union, intersection, difference, and Cartesian product) and the relational algebra operations developed specifically for relational databases (select/restrict, project, join, and division).
Identify appropriate indices for given relational schema and query set.
Estimate time to retrieve information, when indices are used compared to when they are not used.
Evaluate costs and benefits of various indexing schemes and join algorithms.
Explain the concepts involved in transaction processing, concurrency and recovery procedures.
Detail Content
Review of Relational Database Design
Transaction Processing Concepts and Theory
Concurrency Control Techniques
Database Recovery Techniques
Relational Algebra
Physical Storage, Indexing and Hashing
Query Processing and Optimization
Advance Topics
Text/Ref Books
Silberschatz, Korth and Sudarshan (2006): Database System Concepts 5/E, McGraw‐Hill
Elmasri and Navathe (2006): Fundamentals of Database Systems 5/E, Addison Wesley
Time Schedule
Fall Semester, 2011
Faculty/Resource Person
Dr. Khalid Latif (PhD),
Instructor’s Designation: Assistant Professor