CHHATTISGARH SWAMI VIVEKANAND TECHNICAL UNIVERSITY BHILAI (C.G.)
Semester – VI Branch: Information Technology
Subject:- Advanced DATA Base Systems
Total Theory Periods: 40
Total Marks in End Semester Exam. : 80 Total Tutorial Periods: Nil
Minimum number of class test to be conducted: 02
UNIT- I DISTRIBUTED DATABASE DESIGN
Design strategies, Distribution design issues, Fragmentation, Allocation, and Oracle DDB
design, Distributed database system architecture, Date’s rule for DDBS.
UNIT- II DATA REPLICATION & QUERY PROCESSING IN DDBS
Classification of replica control strategies, Consistency & Request ordering, The Gossip
Architecture, Process groups & ISIS, Replication in Oracle, Query optimization in
Centralized system, Objective of query processing, Query decomposition, Distributed
query optimization algorithms, Query optimization in Oracle.
UNIT-III TRANASACTION PROCESSING & RECOVERY
Centralized & client serer architecture, server systems architectures, parallel & distributed
systems, distributed data storage, Transaction property, distributed transactions, commit
protocols, concurrency control in distributed database, availability, heterogeneous
distributed databases, Distributed deadlock management, recovery concepts, recovery
techniques based on deferred update & on immediate update shadow paging, The ARIES
Recovery Algo, Recovery in multidatabase systems, database backup and recovery from
catastrophic failures, Reliability concept & measure, Site failure & network portioning,
directory systems, Database recovery in Oracle.
UNIT- IV SECURITY MANAGEMENT & PL/SQL
Various aspect of database security, Basic model of database access control, TCSEC
Policy identification, Security models, Identification-Authentication- Authorization,
Statistical databases, Data encryption, Security in Oracle, JDBC, Purpose of PL/SQL,
PL/SQL block, structure & type, PL/SQL syntax & programming.
UNIT-V DIFERENT DATABASES
Parallel databases: Introduction, I/O parallelism. Interquery- intraquery- intraoperationinteroperation
parallelism design of parallel systems.
Client/Server DBS, Oracle DBMS, Distributed processing in Oracle, Oracle network
protocols, Network administration in Oracle. Theory of OO databases, Multimedia
databases, Real time databases.
1. Database system concepts, 4
edition, Silberschatz-Korth-Sudarshan, MH
2. Fundamentals of database systems 3
edition, Elmasri & Navathe, Pearson education
1. Database concepts & systems, 2nd edition, Ivan Bayross, SPD
2. Database Management System, Rajesh Narang, PHI.
3. An introduction to database systems, 7
edition, C.J. Date, Pearson education