CSVTU, B.E. VI Semester, Computer Science Engineering, Advanced Database Systems Syllabus

CHHATTISGARH SWAMI VIVEKANAND TECHNICAL UNIVERSITY, BHILAI

Semester:VI Branch: Computer Science & Engineering

Subject Name:Advanced Database Systems

UNIT- I DISTRIBUTED DATABASE DESIGN :-

Design strategies, Distribution design issues, Fragmentation, Allocation, 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 TRANSACTION PROCESSING & RECOVERY :-

Centralized & client server 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 Algorithm, Recovery in multi-database

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 DIFFERENT 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.

Text book:

1. Database system concepts , 4

th

edition, Silberschatz-Korth-Sudarshan, MH

2. Fundamentals of database systems 3

 

 

rd

edition, Elmasri & Navathe, Pearson education

 

References:-

1. Database concepts & systems ,2

nd

edition , Ivan Bayross, SPD

 

2.

Database Management System, Rajesh Narang, PHI.

3.

An Introduction to d

Leave a Comment