{"id":27100,"date":"2024-10-19T08:53:30","date_gmt":"2024-10-19T08:53:30","guid":{"rendered":"https:\/\/care.ac.in\/engineering\/?p=27100"},"modified":"2024-10-19T08:53:30","modified_gmt":"2024-10-19T08:53:30","slug":"guest-lecture-on-data-warehousing-2","status":"publish","type":"post","link":"https:\/\/care.ac.in\/engineering\/2024\/10\/19\/guest-lecture-on-data-warehousing-2\/","title":{"rendered":"Guest Lecture on \u201cData Warehousing&#8221;"},"content":{"rendered":"<p><img fetchpriority=\"high\" decoding=\"async\" class=\"wp-image-27103 aligncenter\" src=\"https:\/\/care.ac.in\/engineering\/wp-content\/uploads\/sites\/7\/2024\/10\/Guest-Lecture-DW.jpg\" alt=\"\" width=\"418\" height=\"591\" \/><\/p>\n<p>Department of Computer Science and Engineering Organized guest lecture for III CSE Students for the course \u201cCCS341 Data Warehousing\u201d in the topic \u201c<strong>Dimensional Modeling and its Schema<\/strong>\u201d on 16.10.2024 between 09.30 A.M to 11.00 A.M in Engineering Seminar Hall. The expert member Dr. S.Nickolas, Professor, Department of MCA, National Institute of Technology (NIT), Trichy, Tamil Nadu delivered his lecture.<\/p>\n<p>The guest lecture covered the following key topics in <strong>Dimensional Modeling and Schema<\/strong>:<\/p>\n<ul>\n<li><strong>Introduction to Dimensional Modeling<\/strong>: The speaker began by explaining the concept of Data warehouse and followed by dimensional modeling, its importance in data warehousing, and how it helps in simplifying complex queries in a data warehouse environment.<\/li>\n<li><strong>Schemas in Data Warehousing<\/strong>: The session covered the three main types of schemas\u2014<strong>Star Schema<\/strong>, <strong>Snowflake Schema<\/strong>, and <strong>Galaxy Schema<\/strong>. The speaker illustrated how these schemas are used to organize and structure data for better accessibility and analysis.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><strong>GUEST LECTURE OBJECTIVES:<\/strong><\/p>\n<p>To introduce students to the concepts of dimensional modeling, schema design, and their role in query optimization and data retrieval.<\/p>\n<p><strong>GUEST LECTURE OUTCOMES:<\/strong><\/p>\n<ol>\n<li>Demonstrate the ability to design a dimensional model and understand various types of schema such as star schema, snowflake schema, and galaxy schema.<\/li>\n<li>Optimize query performance in data warehouses using indexing and materialized views.<\/li>\n<li>Analyze and interpret the results from a well-designed dimensional model for decision support and business intelligence.<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<p><strong>COVERAGE OF PO\u2019S AND PSO\u2019S:<\/strong><\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<p><strong>PO1<\/strong>: Engineering Knowledge \u2013 Apply the knowledge of mathematics, science, and engineering fundamentals to the solution of complex engineering problems.<\/p>\n<p><strong>PO2<\/strong>: Problem Analysis \u2013 Identify, formulate, and analyze complex problems to derive suitable data-driven solutions.<\/p>\n<p><strong>PO3<\/strong>: Design and Development \u2013 Design solutions for complex engineering problems and design systems that meet the specified needs with appropriate considerations.<\/p>\n<p><strong>PO5<\/strong>: Modern Tool Usage \u2013 Create, select, and apply appropriate techniques, resources, and modern engineering and IT tools for modeling and prediction activities.<\/p>\n<p><strong>PO6<\/strong>: Engineer and Society \u2013 Understand the impact of data-driven solutions in societal contexts and the need for sustainable development.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-27140\" src=\"https:\/\/care.ac.in\/engineering\/wp-content\/uploads\/sites\/7\/2024\/10\/20241016_95324AMByGPSMapCamera-scaled.jpg\" alt=\"\" width=\"2560\" height=\"1920\" \/> <img decoding=\"async\" class=\"alignnone size-full wp-image-27141\" src=\"https:\/\/care.ac.in\/engineering\/wp-content\/uploads\/sites\/7\/2024\/10\/20241016_95335AMByGPSMapCamera-scaled.jpg\" alt=\"\" width=\"2560\" height=\"1920\" \/> <img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-27148\" src=\"https:\/\/care.ac.in\/engineering\/wp-content\/uploads\/sites\/7\/2024\/10\/WhatsApp-Image-2024-10-19-at-10.18.21-AM-scaled.jpeg\" alt=\"\" width=\"2560\" height=\"1920\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Department of Computer Science and Engineering Organized guest lecture for III CSE Students for the course \u201cCCS341 Data Warehousing\u201d in the topic \u201cDimensional Modeling and its Schema\u201d on 16.10.2024 between 09.30 A.M to 11.00 A.M in Engineering Seminar Hall. The expert member Dr. S.Nickolas, Professor, Department of MCA, National Institute of Technology (NIT), Trichy, Tamil [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":27103,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,18],"tags":[],"post_folder":[],"class_list":["post-27100","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cse-events","category-engineering-events"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Guest Lecture on \u201cData Warehousing&quot; - CARE College of Engineering<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/care.ac.in\/engineering\/2024\/10\/19\/guest-lecture-on-data-warehousing-2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Guest Lecture on \u201cData Warehousing&quot; - CARE College of Engineering\" \/>\n<meta property=\"og:description\" content=\"Department of Computer Science and Engineering Organized guest lecture for III CSE Students for the course \u201cCCS341 Data Warehousing\u201d in the topic \u201cDimensional Modeling and its Schema\u201d on 16.10.2024 between 09.30 A.M to 11.00 A.M in Engineering Seminar Hall. The expert member Dr. S.Nickolas, Professor, Department of MCA, National Institute of Technology (NIT), Trichy, Tamil [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/care.ac.in\/engineering\/2024\/10\/19\/guest-lecture-on-data-warehousing-2\/\" \/>\n<meta property=\"og:site_name\" content=\"CARE College of Engineering\" \/>\n<meta property=\"article:published_time\" content=\"2024-10-19T08:53:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/care.ac.in\/engineering\/wp-content\/uploads\/sites\/7\/2024\/10\/Guest-Lecture-DW.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1414\" \/>\n\t<meta property=\"og:image:height\" content=\"2000\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"cseeditor\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"cseeditor\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/care.ac.in\/engineering\/2024\/10\/19\/guest-lecture-on-data-warehousing-2\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/care.ac.in\/engineering\/2024\/10\/19\/guest-lecture-on-data-warehousing-2\/\"},\"author\":{\"name\":\"cseeditor\",\"@id\":\"https:\/\/care.ac.in\/engineering\/#\/schema\/person\/1f4b1252c18535ecf6f51cebf19cd6b1\"},\"headline\":\"Guest Lecture on \u201cData Warehousing&#8221;\",\"datePublished\":\"2024-10-19T08:53:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/care.ac.in\/engineering\/2024\/10\/19\/guest-lecture-on-data-warehousing-2\/\"},\"wordCount\":332,\"publisher\":{\"@id\":\"https:\/\/care.ac.in\/engineering\/#organization\"},\"image\":{\"@id\":\"https:\/\/care.ac.in\/engineering\/2024\/10\/19\/guest-lecture-on-data-warehousing-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/care.ac.in\/engineering\/wp-content\/uploads\/sites\/7\/2024\/10\/Guest-Lecture-DW.jpg\",\"articleSection\":[\"CSE Events\",\"Engineering Events\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/care.ac.in\/engineering\/2024\/10\/19\/guest-lecture-on-data-warehousing-2\/\",\"url\":\"https:\/\/care.ac.in\/engineering\/2024\/10\/19\/guest-lecture-on-data-warehousing-2\/\",\"name\":\"Guest Lecture on \u201cData Warehousing\\\" - CARE College of Engineering\",\"isPartOf\":{\"@id\":\"https:\/\/care.ac.in\/engineering\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/care.ac.in\/engineering\/2024\/10\/19\/guest-lecture-on-data-warehousing-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/care.ac.in\/engineering\/2024\/10\/19\/guest-lecture-on-data-warehousing-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/care.ac.in\/engineering\/wp-content\/uploads\/sites\/7\/2024\/10\/Guest-Lecture-DW.jpg\",\"datePublished\":\"2024-10-19T08:53:30+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/care.ac.in\/engineering\/2024\/10\/19\/guest-lecture-on-data-warehousing-2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/care.ac.in\/engineering\/2024\/10\/19\/guest-lecture-on-data-warehousing-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/care.ac.in\/engineering\/2024\/10\/19\/guest-lecture-on-data-warehousing-2\/#primaryimage\",\"url\":\"https:\/\/care.ac.in\/engineering\/wp-content\/uploads\/sites\/7\/2024\/10\/Guest-Lecture-DW.jpg\",\"contentUrl\":\"https:\/\/care.ac.in\/engineering\/wp-content\/uploads\/sites\/7\/2024\/10\/Guest-Lecture-DW.jpg\",\"width\":1414,\"height\":2000},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/care.ac.in\/engineering\/2024\/10\/19\/guest-lecture-on-data-warehousing-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/care.ac.in\/engineering\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Guest Lecture on \u201cData Warehousing&#8221;\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/care.ac.in\/engineering\/#website\",\"url\":\"https:\/\/care.ac.in\/engineering\/\",\"name\":\"CARE College of Engineering\",\"description\":\"Approved by AICTE | Affiliated to Anna University\",\"publisher\":{\"@id\":\"https:\/\/care.ac.in\/engineering\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/care.ac.in\/engineering\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/care.ac.in\/engineering\/#organization\",\"name\":\"CARE College of Engineering\",\"url\":\"https:\/\/care.ac.in\/engineering\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/care.ac.in\/engineering\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/care.ac.in\/engineering\/wp-content\/uploads\/sites\/7\/2025\/02\/cropped-cropped-Engg-College-Full.png\",\"contentUrl\":\"https:\/\/care.ac.in\/engineering\/wp-content\/uploads\/sites\/7\/2025\/02\/cropped-cropped-Engg-College-Full.png\",\"width\":2007,\"height\":707,\"caption\":\"CARE College of Engineering\"},\"image\":{\"@id\":\"https:\/\/care.ac.in\/engineering\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/care.ac.in\/engineering\/#\/schema\/person\/1f4b1252c18535ecf6f51cebf19cd6b1\",\"name\":\"cseeditor\",\"url\":\"https:\/\/care.ac.in\/engineering\/author\/cseeditor\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Guest Lecture on \u201cData Warehousing\" - CARE College of Engineering","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/care.ac.in\/engineering\/2024\/10\/19\/guest-lecture-on-data-warehousing-2\/","og_locale":"en_US","og_type":"article","og_title":"Guest Lecture on \u201cData Warehousing\" - CARE College of Engineering","og_description":"Department of Computer Science and Engineering Organized guest lecture for III CSE Students for the course \u201cCCS341 Data Warehousing\u201d in the topic \u201cDimensional Modeling and its Schema\u201d on 16.10.2024 between 09.30 A.M to 11.00 A.M in Engineering Seminar Hall. The expert member Dr. S.Nickolas, Professor, Department of MCA, National Institute of Technology (NIT), Trichy, Tamil [&hellip;]","og_url":"https:\/\/care.ac.in\/engineering\/2024\/10\/19\/guest-lecture-on-data-warehousing-2\/","og_site_name":"CARE College of Engineering","article_published_time":"2024-10-19T08:53:30+00:00","og_image":[{"width":1414,"height":2000,"url":"https:\/\/care.ac.in\/engineering\/wp-content\/uploads\/sites\/7\/2024\/10\/Guest-Lecture-DW.jpg","type":"image\/jpeg"}],"author":"cseeditor","twitter_card":"summary_large_image","twitter_misc":{"Written by":"cseeditor","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/care.ac.in\/engineering\/2024\/10\/19\/guest-lecture-on-data-warehousing-2\/#article","isPartOf":{"@id":"https:\/\/care.ac.in\/engineering\/2024\/10\/19\/guest-lecture-on-data-warehousing-2\/"},"author":{"name":"cseeditor","@id":"https:\/\/care.ac.in\/engineering\/#\/schema\/person\/1f4b1252c18535ecf6f51cebf19cd6b1"},"headline":"Guest Lecture on \u201cData Warehousing&#8221;","datePublished":"2024-10-19T08:53:30+00:00","mainEntityOfPage":{"@id":"https:\/\/care.ac.in\/engineering\/2024\/10\/19\/guest-lecture-on-data-warehousing-2\/"},"wordCount":332,"publisher":{"@id":"https:\/\/care.ac.in\/engineering\/#organization"},"image":{"@id":"https:\/\/care.ac.in\/engineering\/2024\/10\/19\/guest-lecture-on-data-warehousing-2\/#primaryimage"},"thumbnailUrl":"https:\/\/care.ac.in\/engineering\/wp-content\/uploads\/sites\/7\/2024\/10\/Guest-Lecture-DW.jpg","articleSection":["CSE Events","Engineering Events"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/care.ac.in\/engineering\/2024\/10\/19\/guest-lecture-on-data-warehousing-2\/","url":"https:\/\/care.ac.in\/engineering\/2024\/10\/19\/guest-lecture-on-data-warehousing-2\/","name":"Guest Lecture on \u201cData Warehousing\" - CARE College of Engineering","isPartOf":{"@id":"https:\/\/care.ac.in\/engineering\/#website"},"primaryImageOfPage":{"@id":"https:\/\/care.ac.in\/engineering\/2024\/10\/19\/guest-lecture-on-data-warehousing-2\/#primaryimage"},"image":{"@id":"https:\/\/care.ac.in\/engineering\/2024\/10\/19\/guest-lecture-on-data-warehousing-2\/#primaryimage"},"thumbnailUrl":"https:\/\/care.ac.in\/engineering\/wp-content\/uploads\/sites\/7\/2024\/10\/Guest-Lecture-DW.jpg","datePublished":"2024-10-19T08:53:30+00:00","breadcrumb":{"@id":"https:\/\/care.ac.in\/engineering\/2024\/10\/19\/guest-lecture-on-data-warehousing-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/care.ac.in\/engineering\/2024\/10\/19\/guest-lecture-on-data-warehousing-2\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/care.ac.in\/engineering\/2024\/10\/19\/guest-lecture-on-data-warehousing-2\/#primaryimage","url":"https:\/\/care.ac.in\/engineering\/wp-content\/uploads\/sites\/7\/2024\/10\/Guest-Lecture-DW.jpg","contentUrl":"https:\/\/care.ac.in\/engineering\/wp-content\/uploads\/sites\/7\/2024\/10\/Guest-Lecture-DW.jpg","width":1414,"height":2000},{"@type":"BreadcrumbList","@id":"https:\/\/care.ac.in\/engineering\/2024\/10\/19\/guest-lecture-on-data-warehousing-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/care.ac.in\/engineering\/"},{"@type":"ListItem","position":2,"name":"Guest Lecture on \u201cData Warehousing&#8221;"}]},{"@type":"WebSite","@id":"https:\/\/care.ac.in\/engineering\/#website","url":"https:\/\/care.ac.in\/engineering\/","name":"CARE College of Engineering","description":"Approved by AICTE | Affiliated to Anna University","publisher":{"@id":"https:\/\/care.ac.in\/engineering\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/care.ac.in\/engineering\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/care.ac.in\/engineering\/#organization","name":"CARE College of Engineering","url":"https:\/\/care.ac.in\/engineering\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/care.ac.in\/engineering\/#\/schema\/logo\/image\/","url":"https:\/\/care.ac.in\/engineering\/wp-content\/uploads\/sites\/7\/2025\/02\/cropped-cropped-Engg-College-Full.png","contentUrl":"https:\/\/care.ac.in\/engineering\/wp-content\/uploads\/sites\/7\/2025\/02\/cropped-cropped-Engg-College-Full.png","width":2007,"height":707,"caption":"CARE College of Engineering"},"image":{"@id":"https:\/\/care.ac.in\/engineering\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/care.ac.in\/engineering\/#\/schema\/person\/1f4b1252c18535ecf6f51cebf19cd6b1","name":"cseeditor","url":"https:\/\/care.ac.in\/engineering\/author\/cseeditor\/"}]}},"_links":{"self":[{"href":"https:\/\/care.ac.in\/engineering\/wp-json\/wp\/v2\/posts\/27100","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/care.ac.in\/engineering\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/care.ac.in\/engineering\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/care.ac.in\/engineering\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/care.ac.in\/engineering\/wp-json\/wp\/v2\/comments?post=27100"}],"version-history":[{"count":0,"href":"https:\/\/care.ac.in\/engineering\/wp-json\/wp\/v2\/posts\/27100\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/care.ac.in\/engineering\/wp-json\/wp\/v2\/media\/27103"}],"wp:attachment":[{"href":"https:\/\/care.ac.in\/engineering\/wp-json\/wp\/v2\/media?parent=27100"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/care.ac.in\/engineering\/wp-json\/wp\/v2\/categories?post=27100"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/care.ac.in\/engineering\/wp-json\/wp\/v2\/tags?post=27100"},{"taxonomy":"post_folder","embeddable":true,"href":"https:\/\/care.ac.in\/engineering\/wp-json\/wp\/v2\/post_folder?post=27100"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}