DATABASE TECHNOLOGIES
SYLLABUS-->
Objectives of the course:
• This course aims to provide continuum to where the first course of databases left off. Design aspects of
relational databases are covered.
• Complex data models like OO OR parallel and distributed are introduced.
• The course provides students a good overview of the ideas and the techniques, which are behind recent
developments in the fields of data warehousing and Online Analytical Processing (OLAP).
• This course aims to provide continuum to where the first course of databases left off. Design aspects of
relational databases are covered.
• Complex data models like OO OR parallel and distributed are introduced.
• The course provides students a good overview of the ideas and the techniques, which are behind recent
developments in the fields of data warehousing and Online Analytical Processing (OLAP).
1. Overview
Review of relational database systems, ER diagram, SQL.
2. Integrity and Security
Domain constraints; referential integrity, assertions; triggers; triggers and
Assertions in SQL. Security and Authorization; Authorization in SQL.
3. Relational database Design
First normal form; pitfalls in relational database design, functional
dependencies; decomposition. Desirable properties of decomposition. Boyce-
Code normal form; 3rd
and 4th
normal form. Mention of other formal forms.
4. The ER Model Revisited
Motivation for complex data types, User Defined Abstract Data Types And
Structured Types, Subclasses, Super classes, Inheritance, Specialization and
Generalization, Relationship Types of Degree Higher Than Two.
5. Object-Oriented & Object relational databases
Object Identity, Object Structure, and Type Constructors, Encapsulation of
Operations, Methods, and Persistence, Type Hierarchies and Inheritance,
Type extents and Queries, Database Design For An ORDBMS- Nested
Relations and Collections; Storage And Access methods, Overview of SQL 3
6. Parallel and Distributed Databases
Review of relational database systems, ER diagram, SQL.
2. Integrity and Security
Domain constraints; referential integrity, assertions; triggers; triggers and
Assertions in SQL. Security and Authorization; Authorization in SQL.
3. Relational database Design
First normal form; pitfalls in relational database design, functional
dependencies; decomposition. Desirable properties of decomposition. Boyce-
Code normal form; 3rd
and 4th
normal form. Mention of other formal forms.
4. The ER Model Revisited
Motivation for complex data types, User Defined Abstract Data Types And
Structured Types, Subclasses, Super classes, Inheritance, Specialization and
Generalization, Relationship Types of Degree Higher Than Two.
5. Object-Oriented & Object relational databases
Object Identity, Object Structure, and Type Constructors, Encapsulation of
Operations, Methods, and Persistence, Type Hierarchies and Inheritance,
Type extents and Queries, Database Design For An ORDBMS- Nested
Relations and Collections; Storage And Access methods, Overview of SQL 3
6. Parallel and Distributed Databases
Parallel y Evaluation; Parallelizing Individual Operations, Sorting, Joins;
Distributed Databases Concepts, Data Fragmentation, Replication, and
Allocation technique for Distributed Database Design; Query Processing in
Distributed Databases; Concurrency Control and Recovery in Distributed
Databases.
7. Enhanced Data Models for Advanced Applications.
(Overview and Design issues)
Temporal Databases; Spatial Databases & Geographic Information Systems,
Mobile Databases.
8. Data Warehousing and OLAP
a) Data Warehousing Basics : Data Warehousing (DW) Introduction &
Overview; Data Marts, DW components; Data warehouse
architecture; ETL – Data Transformation-Extracting , Conditioning,
cleansing, Scrubbing, Merging, etc.
b) OLAP: Multidimensional modeling- Fact table, dimensions,
measures, ROLAP, MOLAP, HOLAP; tools. OLAP Operations-
Rollup, Drill-down, Dice slice, pivot.
Text Books:
1. Elmasri and Navathe, “ Fundamentals of Database System”,
Pearson Education
2. Raghu Ramakrishna , Johannes Gerhke , “Database management
Systems” McGraw Hill
3. Kimball, Ralph; Reeves, Laura et al Data warehousing lifecycle
Toolkit: expert methods for designing, developing, and deploing
data warehouses _ Wiley publications.
References:
1. Korth, Silberchatz, Sudarshan, “Database System concepts” Mcgraw Hill
2. K. J. Data, Longman, “Introduction to Database Systems”, Pearson Education
3. Paulraj Ponnian, “Data Warehousing Fundamentals”, John Wiley.
Distributed Databases Concepts, Data Fragmentation, Replication, and
Allocation technique for Distributed Database Design; Query Processing in
Distributed Databases; Concurrency Control and Recovery in Distributed
Databases.
7. Enhanced Data Models for Advanced Applications.
(Overview and Design issues)
Temporal Databases; Spatial Databases & Geographic Information Systems,
Mobile Databases.
8. Data Warehousing and OLAP
a) Data Warehousing Basics : Data Warehousing (DW) Introduction &
Overview; Data Marts, DW components; Data warehouse
architecture; ETL – Data Transformation-Extracting , Conditioning,
cleansing, Scrubbing, Merging, etc.
b) OLAP: Multidimensional modeling- Fact table, dimensions,
measures, ROLAP, MOLAP, HOLAP; tools. OLAP Operations-
Rollup, Drill-down, Dice slice, pivot.
Text Books:
1. Elmasri and Navathe, “ Fundamentals of Database System”,
Pearson Education
2. Raghu Ramakrishna , Johannes Gerhke , “Database management
Systems” McGraw Hill
3. Kimball, Ralph; Reeves, Laura et al Data warehousing lifecycle
Toolkit: expert methods for designing, developing, and deploing
data warehouses _ Wiley publications.
References:
1. Korth, Silberchatz, Sudarshan, “Database System concepts” Mcgraw Hill
2. K. J. Data, Longman, “Introduction to Database Systems”, Pearson Education
3. Paulraj Ponnian, “Data Warehousing Fundamentals”, John Wiley.
You Might Also Like :
