PGCA 1953
ADBMS Theory
Part A
Need of DBMS over traditional Data storage mechanisms, Basic DBMS terminologies; Architecture of a DBMS: Data Independence, DBMS Component Structure, DBMS USERS, various DBMS Data Models, [CO1]
Conceptual Model: Entity Relationship Model, Importance of ERD, Symbols (Entity:Types of Entities, week Entity, Composite Entity, Strong Entity, Attribute: Types of Attribute, Relationship: Type of relationship, Connectivity, Cardinality). [CO1]
Normalization and its various forms, Functional Dependencies, Multi-valued Dependencies, Join Dependencies Database Integrity: Domain, Entity, Referential Integrity Constraints.[CO2]
Relational Languages: Relational Algebra, Relational Calculus, Query Execution, optimization and evaluation Plans. [CO1]
Transaction Management and Concurrency Control techniques, Database Recovery Management Concepts and methods. [CO3]
Introduction and Need of Database Administration and activities of Database administration. [CO4]
Part B
Parallel Databases : Database System Architectures: Centralized and Client-Server Architectures – Server System Architectures – Parallel Systems-Parallel Databases: I/O Parallelism – Inter and Intra Query Parallelism – Inter and Intra operation Parallelism. [CO4]
Distributed Database Concepts : Distributed Data Storage – Distributed Transactions – Commit Protocols – Concurrency Control – Distributed Query Processing. [CO4]
Multidimensional Databases and their uses in data analytics.
Temporal Databases : Introduction to Temporality, Temporal relationships, temporal hierarchies. [CO4]
Spatial Databases: Spatial data types, spatial relationships, Topological Relationships, Spatial Data Structures and methods of storage. [CO4]
Big Data : introduction: introduction to NOSQL Databases (Open Source only). [CO5]
Need and usage of XML Databases: XML Data Model – DTD – XML Schema. [CO5]