ADVANCED DATABASE TECHNOLOGY Syllabus

CS2029 ADVANCED DATABASE TECHNOLOGY L T P C
3 0 0 3
UNIT I RELATIONAL MODEL ISSUES 9
ER Model - Normalization – Query Processing – Query Optimization - Transaction
Processing - Concurrency Control – Recovery - Database Tuning.
UNIT II DISTRIBUTED DATABASES 9
Parallel Databases – Inter and Intra Query Parallelism – Distributed Database Features
– Distributed Database Architecture – Fragmentation – Distributed Query Processing –
Distributed Transactions Processing – Concurrency Control – Recovery – Commit
Protocols.
UNIT III OBJECT ORIENTED DATABASES 9
Introduction to Object Oriented Data Bases - Approaches - Modeling and Design -
Persistence – Query Languages - Transaction - Concurrency – Multi Version Locks –
Recovery – POSTGRES – JASMINE –GEMSTONE - ODMG Model.
UNIT IV EMERGING SYSTEMS 9
Enhanced Data Models - Client/Server Model - Data Warehousing and Data Mining -
Web Databases – Mobile Databases- XML and Web Databases.
UNIT V CURRENT ISSUES 9
Rules - Knowledge Bases - Active and Deductive Databases - Multimedia Databases–
Multimedia Data Structures – Multimedia Query languages - Spatial Databases.
TOTAL: 45 PERIODS
TEXT BOOKS:
1. Thomas Connolly and Carlolyn Begg, “Database Systems, A Practical
Approach to Design, Implementation and Management”, Third Edition, Pearson
Education 2003.
REFERENCES:
1. R. Elmasri, S.B. Navathe, “Fundamentals of Database Systems”, Fifth Edition,
Pearson Education, 2006.
2. Abraham Silberschatz, Henry F. Korth, S. Sudharshan, “Database System
Concepts”, Fifth Edition, Tata McGraw Hill, 2006.
3. C.J.Date, A.Kannan, S.Swamynathan, “An Introduction to Database Systems”,
Eighth Edition, Pearson Education, 2006.
IT2043 KNOWLEDGE MANAGEMENT L T P C
3 0 0 3
UNIT I