CSVTU BE VI Semester IT Advanced DATA Base Systems Syllabus

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.

Text books:

1. Database system concepts, 4

th

edition, Silberschatz-Korth-Sudarshan, MH

2. Fundamentals of database systems 3

 

 

rd

edition, Elmasri & Navathe, Pearson education

 

Reference Books:-

1. Database concepts & systems, 2nd edition, Ivan Bayross, SPD

2. Database Management System, Rajesh Narang, PHI.

3. An introduction to database systems, 7

th

edition, C.J. Date, Pearson education

 

Leave a Comment