ITL503: Olap Lab Syllabus for IT 5th Sem 2018 Pattern Mumbai University

Olap Lab detailed syllabus scheme for Information Technology (IT), 2018 regulation has been taken from the University of Mumbai official website and presented for the Bachelor of Engineering students. For Course Code, Course Title, Test 1, Test 2, Avg, End Sem Exam, Team Work, Practical, Oral, Total, and other information, do visit full semester subjects post given below.

For all other Mumbai University Information Technology 5th Sem Syllabus 2018 Pattern, do visit IT 5th Sem 2018 Pattern Scheme. The detailed syllabus scheme for olap lab is as follows.

Olap Lab Syllabus for Information Technology TE 5th Sem 2018 Pattern Mumbai University

Lab Objectives:

For the complete Syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdf platform to make students’s lives easier.
.

Lab Outcomes:

Student should be able:

1. Implement simple query optimizers and design alternate efficient paths for query execution.
2. Simulate the working of concurrency protocols, recovery mechanisms in a database
3. Design applications using advanced models like mobile, spatial databases.
4. Implement a distributed database and understand its query processing and transaction processing mechanisms
5. Build a data warehouse
6. Analyze data using OLAP operations so as to take strategic decisions.

Hardware and Software requirements:

PC With following Configuration

1. Intel Core i3/i5/i7
2. ETL tools
3. Warehouse tools
4. Java/Python compiler

Processor

1. 4 GB RAM
2. 500 GB Harddisk

Prerequisites:

DBMS

Module I

For the complete Syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdf platform to make students’s lives easier.
.

Module II

1. Simulation of Concurrency Control Algorithm, Recovery Algorithm (Java/Python. 4 LO1

Module III

1. Design of a distributed database for a real life application – Fragmentation, Query Processing
2. Simulation of Recovery methods. 4 LO 4

Module IV

Advanced Database Models Case study based assignments for Temporal, Mobile or Spatial databases 4 LO 3

Module V

For the complete Syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdf platform to make students’s lives easier.
.

Module VI

OLAP Exercise

1. Construction of Cubes
2. OLAP Operations, OLAP Queries 4 LO 6

Text Books:

1. Elmasri and Navathe, Fundamentals of Database Systems, 6th Edition, PEARSON Education.
2. Theraja Reema, Data Warehousing, Oxford University Press, 2009.
3. Data Warehousing, Data Mining, & OLAP by Alex Berson McGraw Hill.

Reference Books:

1. Hector Garcia-Molina, Jeffrey D. Ullman, Jennifer Widom Database System Implementation, Pearson Ltd. 1/ e
2. Thomas M. Connolly Carolyn Begg, Database Systems : A Practical Approach to Design, Implementation and Management, 4/e Pearson Ltd
3. Ralph Kimball, Margy Ross, The Data Warehouse Toolkit: The Definitive Guide To Dimensional Modeling, 3rd Edition. Wiley India.

Term Work:

For the complete Syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdf platform to make students’s lives easier.
.

For detail syllabus of all other subjects of Information Technology (IT) 5th Sem 2018 regulation, visit IT 5th Sem Subjects syllabus for 2018 regulation.