RDBMS-2 (MCA 4th)

SECTION-A

Degree Of Data Abstraction, The Database Life Cycle (DBLC): Initial Study Of The Database,

Database Design, Implementation And Loading, Testing And Evaluation, Operation, Maintain

Ace And Evaluation.

SECTION-B

Centralized Verses Decentralized Design, What Is A Transaction? Concurrency Control

(Locking Methods, Time Stamping Method, Optimistic Method) DDBMS Distributed Database

Management Systems) Advantage And Disadvantages. Homogeneous And Heterogeneous

DBMS, Distributed Database Transparency Features. Level Of Data And Process Distribution:

SPSD (Single–Site Processing, Single-Site Data), MPSD (Multiple-Site Processing, Single Site

Data), MPMD (Multiple –Site Processing, Multiple-Site Data)

SECTION-C

Systems, Client / Server: Architecture And Implementation Issues.

Client / Server Systems, What Is Client / Server? The Forces That Drive Client /Server

SECTION-D

(DSS) Decision Support Systems: Operational Data Vs. Decision Support Data, The DSS

Database Requirements. The Data Warehouse: The Evaluation Of The Data Warehouse, Rules

For Data Warehouse. Online Analytical Processing (OLAP): OLAP Architecture Relational,

OLAP And Comparison, Data Mining.