ITC503: Advanced Data Management Technology Syllabus for IT 5th Sem 2018 Pattern Mumbai University

Advanced Data Management Technology 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 advanced data management technology is as follows.

Advanced Data Management Technology Syllabus for Information Technology TE 5th Sem 2018 Pattern Mumbai University

Course 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.
.

Course Outcomes:

Students will be able to:

1. Explain and understand the concept of a transaction and how ACID properties are maintained when concurrent transaction occur in a database
2. Measure query costs and design alternate efficient paths for query execution.
3. Apply sophisticated access protocols to control access to the database.
4. Implement alternate models like Distributed databases and Design applications using advanced models like mobile, spatial databases.
5. Organize strategic data in an enterprise and build a data Warehouse.
6. Analyze data using OLAP operations so as to take strategic decisions.

Prerequisites:

Database Management System.

Module I

Query Processing and Optimization: Overview, Measures of Query Cost Selection Operation, Sorting, Join Operation, Other Operations Evaluation of Expressions. Query Optimization Overview, Transformation of Relational Expressions Estimating Statistics of Expression Results Choice of Evaluation Plans 06 CO1

Module II

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 III

Advanced Data Management techniques Advanced Database Access protocols: Discretionary Access Control Based on Granting and Revoking Privileges; Mandatory Access Control and RoleBased Access Control. Overview of Advanced Database models like Mobile databases, Temporal databases, Spatial databases. 09 CO3 CO4

Module IV

Distributed Databases Introduction : Distributed Data Processing, What is a Distributed Database System? Design Issues . Distributed DBMS Architecture. Distributed Database Design : Top-Down Design Process, Distribution Design Issues, Fragmentation , Allocation . Overview of Query Processing : Query Processing Problem, Objectives of Query Processing, Complexity of Relational Algebra Operations, Characterization of Query Processors, Layers of Query Processing, Query Optimization in Distributed Databases; 09 CO4 Overview of Transaction Management in DDB; Overview of Concurrency Control in DDB; Overview of Recovery in DDB

Module V

Data Warehousing, Dimensional Modeling and OLAP The Need for Data Warehousing; Data Warehouse Defined; Benefits of Data Warehousing ; Features of a Data Warehouse; Data Warehouse Architecture; Data Warehouse and Data Marts; Data Warehousing Design Strategies. Dimensional Model Vs ER Model; The Star Schema; How Does a Query Execute? The Snowflake Schema; Fact Tables and Dimension Tables; Factless Fact Table; Updates To Dimension Tables, Primary Keys, Surrogate Keys & Foreign Keys; Aggregate Tables; Fact Constellation Schema or Families of Star Need for Online Analytical Processing; OLTP vs OLAP; OLAP Operations in a cube: Roll-up, Drilldown, Slice, Dice, Pivot ; OLAP Models: MOLAP, ROLAP, HOLAP. 10 CO5

Module VI

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.
.

Text Books:

1. Korth, Slberchatz,Sudarshan, :Database System Concepts, 6th Edition, McGraw – Hill
2. Elmasri and Navathe, Fundamentals of Database Systems, 6th Edition, PEARSON Education.
3. Theraja Reema, Data Warehousing, Oxford University Press, 2009.
4. Raghu Ramakrishnan and Johannes Gehrke, Database Management Systems 3rd Edition -McGraw Hill

Reference Books:

1. Paulraj Ponniah, Data Warehousing: Fundamentals for IT Professionals, Wiley India.
2. Hector Garcia-Molina, Jeffrey D. Ullman, Jennifer Widom Database System Implementation, Pearson Ltd. 1/ e
3. Thomas M. Connolly Carolyn Begg, Database Systems : A Practical Approach to Design, Implementation and Management, 4/e, Pearson Ltd.
4. Ralph Kimball, Margy Ross, The Data Warehouse Toolkit: The Definitive Guide To Dimensional Modeling, 3rd Edition. Wiley India.
5. Han, Kamber, “Data Mining Concepts and Techniques”, Morgan Kaufmann 3nd Edition.

Assessment:

Internal Assessment for 20 marks: Consisting of Two Compulsory Class Tests Approximately 40% to 50% of syllabus content must be covered in First test and remaining 40% to 50% of syllabus contents must be covered in second test. End Semester Theory Examination: Some guidelines for setting the question papers are as: Weightage of each module in end semester examination is expected to be/will be proportional to number of respective lecture hours mentioned in the syllabus. Question paper will comprise of total six questions, each carrying 20 marks. Q.1 will be compulsory and should cover maximum contents of the syllabus. Remaining question will be mixed in nature (for example if Q.2 has part

1. from module 3 then part
2. will be from any other module. (Randomly selected from all the modules) Total four questions need to be solved.

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