Home » CSE Events, Engineering Events

Guest Lecture on “Data Warehousing”

by

Department of Computer Science and Engineering Organized guest lecture for III CSE Students for the course “CCS341 Data Warehousing” in the topic “Dimensional Modeling and its Schema” 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.

The guest lecture covered the following key topics in Dimensional Modeling and Schema:

  • Introduction to Dimensional Modeling: 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.
  • Schemas in Data Warehousing: The session covered the three main types of schemas—Star Schema, Snowflake Schema, and Galaxy Schema. The speaker illustrated how these schemas are used to organize and structure data for better accessibility and analysis.

 

GUEST LECTURE OBJECTIVES:

To introduce students to the concepts of dimensional modeling, schema design, and their role in query optimization and data retrieval.

GUEST LECTURE OUTCOMES:

  1. Demonstrate the ability to design a dimensional model and understand various types of schema such as star schema, snowflake schema, and galaxy schema.
  2. Optimize query performance in data warehouses using indexing and materialized views.
  3. Analyze and interpret the results from a well-designed dimensional model for decision support and business intelligence.

 

COVERAGE OF PO’S AND PSO’S:

 

PO1: Engineering Knowledge – Apply the knowledge of mathematics, science, and engineering fundamentals to the solution of complex engineering problems.

PO2: Problem Analysis – Identify, formulate, and analyze complex problems to derive suitable data-driven solutions.

PO3: Design and Development – Design solutions for complex engineering problems and design systems that meet the specified needs with appropriate considerations.

PO5: Modern Tool Usage – Create, select, and apply appropriate techniques, resources, and modern engineering and IT tools for modeling and prediction activities.

PO6: Engineer and Society – Understand the impact of data-driven solutions in societal contexts and the need for sustainable development.

Comments are closed.