MCSE- 203 Advanced Concept in Data Bases

UNIT-1

DBMS Concept Introduction, Data Model, Entity & Attributes, Relationship, E-R Model, Relational Data

Model, Domain Tuples, Attributes, Key, Schema, Integrity Constraints, Relational Algebra & Relational

Calculus, Normalization & Normal Form.

Unit-2

Query Processing and Optimization Introduction, Query Processing, Syntax Analyzer, Query

Decomposition: - Query Analysis, Query Normalization, Semantic Analyzer, Query Simplifier, Query

Restructuring. Query Optimization, Cost Estimation in Query Optimization, Structure of Query Evaluation

Plans, Pipelining and Materialization.

Unit-3

Distributed Databases Introduction, Architecture of Distributed Databases , Distributed Database System

Design, Distributed Query Processing, Concurrency Control in Distributed Databases, Recovery Control

in Distributed Databases. Web Databases, Multimedia Databases, Spatial Databases, Clustering-based

Disaster-proof Databases, Mobile Databases.

Unit-4

Object-Oriented Databases Introduction, Concept of Object Oriented Database, Object Oriented Data

Model(OODM), Object-Oriented DBMS(OODBMS), Object Data Management Group and Object-Oriented

Languages. Object-Relational DBMS, ORDBMS Design, ORDBMS Query Language.

Unit-5

Design of Data Warehouse, Dimension and Measures, Data Marts and Distributed Data Marts,

Conceptual Modeling of Data Warehouses:-Star Schema, Snowflake Schema, Fact Constellations.

Multidimensional Data Model & Aggregates.

Data Mining : Data, Information and Knowledge Discovery, Data Mining Functionalities, Data Mining

System categorization and its Issues. Data Processing, Data Reduction, Data Mining Statistics. Data

Mining Techniques.

References:

1. C. J. Date: An Introduction to Database Systems , Addison-Wesley

2. Avi Silberschatz, Henry F. Korth ,S. Sudarshan ,Data Base System Concepts, TMH

3. Patrick O’Neil & Elizabeth O’Neil, Database Principles, Programming and Performance,

4. Morgan Kaufmann Hardcourt India

5. Gillenson, Fundamental of Data Base Management Sytem, Willey India

6. Ceri & Pelagatti, Distributed Databases Principles & Systems,TMH

7. Paulraj Ponniah, Data Ware Housing Fundamental, Willey India.

8. Jiawei Han, Data Mining Concept & Techniques, Elsevier Pub.