{"id":53376,"date":"2023-04-08T06:01:01","date_gmt":"2023-04-08T06:01:01","guid":{"rendered":"https:\/\/www.inspirenignite.com\/anna-university\/ccs341-data-warehousing-syllabus-for-cse-2021-regulation-professional-elective-iii\/"},"modified":"2023-04-08T06:01:01","modified_gmt":"2023-04-08T06:01:01","slug":"ccs341-data-warehousing-syllabus-for-cse-2021-regulation-professional-elective-iii","status":"publish","type":"post","link":"https:\/\/www.inspirenignite.com\/anna-university\/ccs341-data-warehousing-syllabus-for-cse-2021-regulation-professional-elective-iii\/","title":{"rendered":"CCS341: Data Warehousing syllabus for CSE 2021 regulation (Professional Elective-III)"},"content":{"rendered":"

Data Warehousing detailed syllabus for Computer Science & Engineering (CSE) for 2021 regulation curriculum has been taken from the Anna Universities<\/a> official website and presented for the CSE students. For course code, course name, number of credits for a course and other scheme related information, do visit full semester subjects post given below. <\/p>\n

For Computer Science & Engineering 6th Sem scheme and its subjects, do visit CSE 6th Sem 2021 regulation scheme<\/a>. For Professional Elective-III scheme and its subjects refer to CSE Professional Elective-III syllabus scheme<\/a>. The detailed syllabus of data warehousing is as follows. <\/p>\n

Data Warehousing<\/title><\/p>\n<h4>Course Objectives:<\/h4>\n<h4 id=\"istudy\" style=\"text-align:center\"><a class=\"rank-math-link\" href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy\" style=\"color: inherit\" target=\"_blank\" rel=\"noopener\">Download the iStudy App for all syllabus and other updates.<\/a><br \/><a class=\"rank-math-link\" 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;text-align:center\"><\/a><\/h4>\n<h4>Unit I<\/h4>\n<p> <strong>INTRODUCTION TO DATA WAREHOUSE 5<\/strong> Data warehouse Introduction – Data warehouse components- operational database Vs data warehouse – Data warehouse Architecture – Three-tier Data Warehouse Architecture – Autonomous Data Warehouse- Autonomous Data Warehouse Vs Snowflake – Modern Data Warehouse<\/p>\n<h4>Unit II<\/h4>\n<h4 id=\"istudy\" style=\"text-align:center\"><a class=\"rank-math-link\" href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy\" style=\"color: inherit\" target=\"_blank\" rel=\"noopener\">Download the iStudy App for all syllabus and other updates.<\/a><br \/><a class=\"rank-math-link\" 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;text-align:center\"><\/a><\/h4>\n<h4>Unit III<\/h4>\n<p> <strong>META DATA, DATA MART AND PARTITION STRATEGY 7<\/strong> Meta Data – Categories of Metadata – Role of Metadata – Metadata Repository – Challenges for Meta Management – Data Mart – Need of Data Mart- Cost Effective Data Mart- Designing Data Marts- Cost of Data Marts- Partitioning Strategy – Vertical partition – Normalization – Row Splitting – Horizontal Partition<\/p>\n<h4>Unit IV<\/h4>\n<h4 id=\"istudy\" style=\"text-align:center\"><a class=\"rank-math-link\" href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy\" style=\"color: inherit\" target=\"_blank\" rel=\"noopener\">Download the iStudy App for all syllabus and other updates.<\/a><br \/><a class=\"rank-math-link\" 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;text-align:center\"><\/a><\/h4>\n<h4>Unit V<\/h4>\n<p> <strong>SYSTEM & PROCESS MANAGERS 6<\/strong> Data Warehousing System Managers: System Configuration Manager- System Scheduling Manager – System Event Manager – System Database Manager – System Backup Recovery Manager – Data Warehousing Process Managers: Load Manager – Warehouse Manager- Query Manager – Tuning – Testing<\/p>\n<h4>Practical Exercises:<\/h4>\n<h4 id=\"istudy\" style=\"text-align:center\"><a class=\"rank-math-link\" href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy\" style=\"color: inherit\" target=\"_blank\" rel=\"noopener\">Download the iStudy App for all syllabus and other updates.<\/a><br \/><a class=\"rank-math-link\" 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;text-align:center\"><\/a><\/h4>\n<h4>Course Outcomes:<\/h4>\n<p> At the end of the course the students should be able to<\/p>\n<ol>\n<li>Design data warehouse architecture for various Problems<\/li>\n<li>Apply the OLAP Technology<\/li>\n<li>Analyse the partitioning strategy<\/li>\n<li>Critically analyze the differentiation of various schema for given problem<\/li>\n<li>Frame roles of process manager & system manager<\/li>\n<\/ol>\n<h4>Text Books:<\/h4>\n<ol>\n<li>Alex Berson and Stephen J. Smith Data Warehousing, Data Mining & OLAP, Tata McGraw – Hill Edition, Thirteenth Reprint 2008.<\/li>\n<li>Ralph Kimball, The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling, Third edition, 2013.<\/li>\n<\/ol>\n<h4>Reference Books:<\/h4>\n<h4 id=\"istudy\" style=\"text-align:center\"><a class=\"rank-math-link\" href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy\" style=\"color: inherit\" target=\"_blank\" rel=\"noopener\">Download the iStudy App for all syllabus and other updates.<\/a><br \/><a class=\"rank-math-link\" 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;text-align:center\"><\/a><\/h4>\n<p align=\"justify\">For detailed syllabus of all the other subjects of Computer Science & Engineering 6th Sem, visit <a class=\"rank-math-link\" href=\"..\/category\/cse+6th-sem\">CSE 6th Sem subject syllabuses for 2021 regulation<\/a>. <\/p>\n<p align=\"justify\">For all Computer Science & Engineering results, visit <a class=\"rank-math-link\" href=\"https:\/\/www.inspirenignite.com\/anna-university\/anna-university-results\/\">Anna University CSE all semester results<\/a> direct link. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Data Warehousing detailed syllabus for Computer Science & Engineering (CSE) for 2021 regulation curriculum has been taken from the Anna Universities official website and presented for the CSE students. For […]<\/p>\n","protected":false},"author":2297,"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":[69],"tags":[],"class_list":["post-53376","post","type-post","status-publish","format-standard","hentry","category-cse"],"_links":{"self":[{"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/posts\/53376","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/users\/2297"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/comments?post=53376"}],"version-history":[{"count":0,"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/posts\/53376\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/media?parent=53376"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/categories?post=53376"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/tags?post=53376"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}