{"id":55841,"date":"2023-08-28T16:08:48","date_gmt":"2023-08-28T16:08:48","guid":{"rendered":"https:\/\/www.inspirenignite.com\/anna-university\/ccs341-data-warehousing-syllabus-for-csbs-2021-regulation-professional-elective-ii\/"},"modified":"2023-08-28T16:08:48","modified_gmt":"2023-08-28T16:08:48","slug":"ccs341-data-warehousing-syllabus-for-csbs-2021-regulation-professional-elective-ii","status":"publish","type":"post","link":"https:\/\/www.inspirenignite.com\/anna-university\/ccs341-data-warehousing-syllabus-for-csbs-2021-regulation-professional-elective-ii\/","title":{"rendered":"CCS341: Data Warehousing syllabus for CS&BS 2021 regulation (Professional Elective-II)"},"content":{"rendered":"

Data Warehousing detailed syllabus for Computer Science & Business Systems (CS&BS) for 2021 regulation curriculum has been taken from the Anna Universities<\/a> official website and presented for the CS&BS 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 & Business Systems 5th Sem scheme and its subjects, do visit CS&BS 5th Sem 2021 regulation scheme<\/a>. For Professional Elective-II scheme and its subjects refer to CS&BS Professional Elective-II syllabus scheme<\/a>. The detailed syllabus of data warehousing is as follows. <\/p>\n

Course Objectives:<\/h4>\n

Download the iStudy App for all syllabus and other updates.<\/a>
\"Get<\/a><\/h4>\n

Unit I<\/h4>\n

INTRODUCTION TO DATA WAREHOUSE
\nData 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\n<\/p>\n

Unit II<\/h4>\n

ETL AND OLAP TECHNOLOGY
\nWhat is ETL – ETL Vs ELT – Types of Data warehouses – Data warehouse Design and Modeling -Delivery Process – Online Analytical Processing (OLAP) – Characteristics of OLAP – Online Transaction Processing (OLTP) Vs OLAP – OLAP operations- Types of OLAP- ROLAP Vs MOLAP Vs HOLAP.\n<\/p>\n

Unit III<\/h4>\n

Download the iStudy App for all syllabus and other updates.<\/a>
\"Get<\/a><\/h4>\n

Unit IV<\/h4>\n

DIMENSIONAL MODELING AND SCHEMA
\nDimensional Modeling- Multi-Dimensional Data Modeling – Data Cube- Star Schema- Snowflake schema- Star Vs Snowflake schema- Fact constellation Schema- Schema Definition – Process Architecture- Types of Data Base Parallelism – Datawarehouse Tools\n<\/p>\n

Unit V<\/h4>\n

SYSTEM & PROCESS MANAGERS
\nData 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 – T uning – T esting\n<\/p>\n

Practical Exercises<\/h4>\n
    \n
  1. Data exploration and integration with WEKA<\/li>\n
  2. Apply weka tool for data validation<\/li>\n
  3. Plan the architecture for real time application<\/li>\n
  4. Write the query for schema definition<\/li>\n
  5. Design data ware house for real time applications<\/li>\n
  6. Analyse the dimensional Modeling<\/li>\n
  7. Case study using OLAP<\/li>\n
  8. Case study using OTLP<\/li>\n
  9. Implementation of warehouse testing.<\/li>\n<\/ol>\n

    Course Outcomes:<\/h4>\n

    Download the iStudy App for all syllabus and other updates.<\/a>
    \"Get<\/a><\/h4>\n

    Text Books:<\/h4>\n
      \n
    1. Alex Berson and Stephen J. Smith \u201cData Warehousing, Data Mining & OLAP\u201d, Tata McGraw – Hill Edition, Thirteenth Reprint 2008.<\/li>\n
    2. Ralph Kimball, \u201cThe Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling\u201d, Third edition, 2013.<\/li>\n<\/ol>\n

      Reference Books:<\/h4>\n
        \n
      1. Paul Raj Ponniah, \u201cData warehousing fundamentals for IT Professionals\u201d, 2012.<\/li>\n
      2. K.P. Soman, ShyamDiwakar and V. Ajay \u201cInsight into Data mining Theory and Practice\u201d, Easter Economy Edition, Prentice Hall of India, 2006.<\/li>\n<\/li>\n<\/ol>\n

        For detailed syllabus of all the other subjects of Computer Science & Business Systems 5th Sem, visit CS&BS 5th Sem subject syllabuses for 2021 regulation<\/a>. <\/p>\n

        For all Computer Science & Business Systems results, visit Anna University CS&BS all semester results<\/a> direct link. <\/p>\n","protected":false},"excerpt":{"rendered":"

        Data Warehousing detailed syllabus for Computer Science & Business Systems (CS&BS) for 2021 regulation curriculum has been taken from the Anna Universities official website and presented for the CS&BS students. […]<\/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":[146],"tags":[],"class_list":["post-55841","post","type-post","status-publish","format-standard","hentry","category-csbs"],"_links":{"self":[{"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/posts\/55841","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=55841"}],"version-history":[{"count":0,"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/posts\/55841\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/media?parent=55841"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/categories?post=55841"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/tags?post=55841"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}