{"id":13814,"date":"2020-08-27T06:40:49","date_gmt":"2020-08-27T06:40:49","guid":{"rendered":"https:\/\/www.inspirenignite.com\/mh\/itl503-olap-lab-syllabus-for-it-5th-sem-2018-pattern-mumbai-university\/"},"modified":"2020-08-27T06:40:49","modified_gmt":"2020-08-27T06:40:49","slug":"itl503-olap-lab-syllabus-for-it-5th-sem-2018-pattern-mumbai-university","status":"publish","type":"post","link":"https:\/\/www.inspirenignite.com\/mh\/itl503-olap-lab-syllabus-for-it-5th-sem-2018-pattern-mumbai-university\/","title":{"rendered":"ITL503: Olap Lab Syllabus for IT 5th Sem 2018 Pattern Mumbai University"},"content":{"rendered":"

Olap Lab detailed syllabus scheme for Information Technology (IT), 2018 regulation has been taken from the University of Mumbai<\/a> 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. <\/p>\n

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

Olap Lab Syllabus for Information Technology TE 5th Sem 2018 Pattern Mumbai University<\/h2>\n

OLAP Lab<\/title><\/p>\n<h4>Lab Objectives:<\/h4>\n<p id=\"istudy\" style=\"text-align:center\">For the complete Syllabus, results, class timetable, and many other features kindly download the <a href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy\" target=\"_blank\" rel=\"noopener\">iStudy App<\/a><br \/><b> It is a lightweight, easy to use, no images, and no pdf platform to make students’s lives easier.<\/b><br \/><a href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy&pcampaignid=pcampaignidMKT-Other-global-all-co-prtnr-py-PartBadge-Mar2515-1\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" src=\"https:\/\/play.google.com\/intl\/en_us\/badges\/static\/images\/badges\/en_badge_web_generic.png\" alt=\"Get it on Google Play\" style=\"height:65px\"><\/a>. <\/p>\n<h4>Lab Outcomes:<\/h4>\n<p align=\"justify\">\nStudent should be able:<\/p>\n<ol>\n<li>Implement simple query optimizers and design alternate efficient paths for query execution.<\/li>\n<li>Simulate the working of concurrency protocols, recovery mechanisms in a database<\/li>\n<li>Design applications using advanced models like mobile, spatial databases.<\/li>\n<li>Implement a distributed database and understand its query processing and transaction processing mechanisms<\/li>\n<li>Build a data warehouse<\/li>\n<li>Analyze data using OLAP operations so as to take strategic decisions.<\/li>\n<\/ol>\n<h4>Hardware and Software requirements:<\/h4>\n<p align=\"justify\">\nPC With following Configuration<\/p>\n<ol>\n<li>Intel Core i3\/i5\/i7<\/li>\n<li>ETL tools<\/li>\n<li>Warehouse tools<\/li>\n<li>Java\/Python compiler<\/li>\n<\/ol>\n<p> Processor<\/p>\n<ol>\n<li>4 GB RAM<\/li>\n<li>500 GB Harddisk<\/li>\n<\/ol>\n<h4>Prerequisites:<\/h4>\n<p align=\"justify\">\nDBMS<\/p>\n<h4>Module I<\/h4>\n<p id=\"istudy\" style=\"text-align:center\">For the complete Syllabus, results, class timetable, and many other features kindly download the <a href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy\" target=\"_blank\" rel=\"noopener\">iStudy App<\/a><br \/><b> It is a lightweight, easy to use, no images, and no pdf platform to make students’s lives easier.<\/b><br \/><a href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy&pcampaignid=pcampaignidMKT-Other-global-all-co-prtnr-py-PartBadge-Mar2515-1\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" src=\"https:\/\/play.google.com\/intl\/en_us\/badges\/static\/images\/badges\/en_badge_web_generic.png\" alt=\"Get it on Google Play\" style=\"height:65px\"><\/a>. <\/p>\n<h4>Module II<\/h4>\n<p align=\"justify\">\n<ol type=\"i\">\n<li>Simulation of Concurrency Control Algorithm, Recovery Algorithm (Java\/Python. 4 LO1<\/li>\n<\/ol>\n<h4>Module III<\/h4>\n<p align=\"justify\">\n<ol type=\"i\">\n<li>Design of a distributed database for a real life application – Fragmentation, Query Processing<\/li>\n<li>Simulation of Recovery methods. 4 LO 4<\/li>\n<\/ol>\n<h4>Module IV<\/h4>\n<p align=\"justify\">\nAdvanced Database Models Case study based assignments for Temporal, Mobile or Spatial databases 4 LO 3<\/p>\n<h4>Module V<\/h4>\n<p id=\"istudy\" style=\"text-align:center\">For the complete Syllabus, results, class timetable, and many other features kindly download the <a href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy\" target=\"_blank\" rel=\"noopener\">iStudy App<\/a><br \/><b> It is a lightweight, easy to use, no images, and no pdf platform to make students’s lives easier.<\/b><br \/><a href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy&pcampaignid=pcampaignidMKT-Other-global-all-co-prtnr-py-PartBadge-Mar2515-1\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" src=\"https:\/\/play.google.com\/intl\/en_us\/badges\/static\/images\/badges\/en_badge_web_generic.png\" alt=\"Get it on Google Play\" style=\"height:65px\"><\/a>. <\/p>\n<h4>Module VI<\/h4>\n<p align=\"justify\">\nOLAP Exercise<\/p>\n<ol type=\"i\">\n<li>Construction of Cubes<\/li>\n<li>OLAP Operations, OLAP Queries 4 LO 6<\/li>\n<\/ol>\n<h4>Text Books:<\/h4>\n<p align=\"justify\">\n<ol>\n<li>Elmasri and Navathe, Fundamentals of Database Systems, 6th Edition, PEARSON Education.<\/li>\n<li>Theraja Reema, Data Warehousing, Oxford University Press, 2009.<\/li>\n<li>Data Warehousing, Data Mining, & OLAP by Alex Berson McGraw Hill.<\/li>\n<\/ol>\n<h4>Reference Books:<\/h4>\n<p align=\"justify\">\n<ol>\n<li>Hector Garcia-Molina, Jeffrey D. Ullman, Jennifer Widom Database System Implementation, Pearson Ltd. 1\/ e<\/li>\n<li>Thomas M. Connolly Carolyn Begg, Database Systems : A Practical Approach to Design, Implementation and Management, 4\/e Pearson Ltd<\/li>\n<li>Ralph Kimball, Margy Ross, The Data Warehouse Toolkit: The Definitive Guide To Dimensional Modeling, 3rd Edition. Wiley India.<\/li>\n<\/ol>\n<h4>Term Work:<\/h4>\n<p id=\"istudy\" style=\"text-align:center\">For the complete Syllabus, results, class timetable, and many other features kindly download the <a href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy\" target=\"_blank\" rel=\"noopener\">iStudy App<\/a><br \/><b> It is a lightweight, easy to use, no images, and no pdf platform to make students’s lives easier.<\/b><br \/><a href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy&pcampaignid=pcampaignidMKT-Other-global-all-co-prtnr-py-PartBadge-Mar2515-1\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" src=\"https:\/\/play.google.com\/intl\/en_us\/badges\/static\/images\/badges\/en_badge_web_generic.png\" alt=\"Get it on Google Play\" style=\"height:65px\"><\/a>.<\/p>\n<p align=\"justify\">For detail syllabus of all other subjects of Information Technology (IT) 5th Sem 2018 regulation, visit <a href=\"..\/category\/it+5th-sem\">IT 5th Sem Subjects<\/a> syllabus for 2018 regulation.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>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 […]<\/p>\n","protected":false},"author":2351,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[37,84],"tags":[],"class_list":["post-13814","post","type-post","status-publish","format-standard","hentry","category-5th-sem","category-it"],"_links":{"self":[{"href":"https:\/\/www.inspirenignite.com\/mh\/wp-json\/wp\/v2\/posts\/13814","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inspirenignite.com\/mh\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inspirenignite.com\/mh\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inspirenignite.com\/mh\/wp-json\/wp\/v2\/users\/2351"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inspirenignite.com\/mh\/wp-json\/wp\/v2\/comments?post=13814"}],"version-history":[{"count":0,"href":"https:\/\/www.inspirenignite.com\/mh\/wp-json\/wp\/v2\/posts\/13814\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inspirenignite.com\/mh\/wp-json\/wp\/v2\/media?parent=13814"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/mh\/wp-json\/wp\/v2\/categories?post=13814"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/mh\/wp-json\/wp\/v2\/tags?post=13814"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}