Table of Contents
CS614 Handouts pdf
Course Category: Computer Science/Information Technology CS614 Handouts pdf
CS614: Data Warehousing Handouts (PDF)
A Data warehouse is the secure electronic storage of information by a business or other organization. The goal of data storage is to create a database that can be retrieved and analyzed in order to provide useful insights into organizational performance. CS614 Handouts pdf
Course Outline
Introduction to Data Ware Housing, Normalization, De-Normalization, De-Normalization Techniques, Issues of De-Normalization, Online Analytical Processing (OLAP, Multidimensional OLAP (MOLAP, Relational OLAP (ROLAP, Dimensional Modeling (DM, Process of Dimensional Modeling, Issues of Dimensional Modeling, Extract Transform Load (ETL), Issues of ETL, ETL Detail: Data Extraction & Transformation, ETL Detail: Data Cleansing, Data Duplication Elimination & BSN Method, Introduction to Data Quality Management (DQM), DQM: Quantifying Data Quality, Total DQM Need for Speed: Parallelism, Need for Speed: Hardware Techniques, Conventional Indexing Techniques, Need for Speed: Special Indexing Techniques, Join Techniques, A Brief Introduction to Data mining (DM,
What Can Data Mining Do Supervised Vs. Unsupervised Learning, DWH Lifecycle: Methodologies, DWH Implementation: Goal-Driven Approach I, DWH Implementation: Goal-Driven Approach II, DWH Life Cycle: Pitfalls, Mistakes, Tips., Course Project, Case Study: Agri-Data Warehouse Part-I, Case Study: Agri-Data Warehouse Part-II, Web Warehousing: An introduction, Web Warehousing: Issues, Lab Lecture-1: Data Transfer Service (DTS, Lab Lecture-2: Lab Data Set, Lab Lecture-3: Extracting Data Using Wizard, Lab Lecture-4: Data Profiling, Lab Lecture-5: Data Transformation & Standardization.CS614 Handouts pdf
Join VU assignment solution groups and also share with friends. In these WhatsApp groups, we send solution files, VU handouts, VU past papers, and links to you. To join WhatsApp groups click the below links.
ALSO, SEE:
FINAL TERM PAST PAPERS MEGA FILES
MUST JOIN VU STUDY GROUPS
CS614 HANDOUTS
CS614: Data Warehousing
What is Data Warehousing?
The data warehouse (DWH) is a place where an organization stores data by extracting it from applications and making it available for ad-hoc queries and scheduled reporting. In contrast, the process of building a data warehouse involves designing a data model that can generate data quickly. The data stored on DWH is different from the data available in the workspace. It is organized so that relevant data can be grouped together to facilitate daily operations, analysis, and reporting. This helps to determine trends over time and allows users to create programs based on that information. Therefore, to emphasize the importance of using the data warehouse for businesses.
Why Data Warehousing?
The global economy has transformed the industrial age into a knowledge-driven economy. The information age is characterized by computer technology, modern communication technology, and internet technology; they are all very popular in the world today. Governments around the world have recognized the power of knowledge, as “many things” in developing their economies, which not only create public wealth but also affect the future of the country. Thus, many countries around the world have incorporated modern information technology into their strategic plans. They see it as a vital strategic source for the development of their society, and they strive to achieve and remain at the top of the modern knowledge economy.
The Need for a Data Warehouse
“Drowning in data and starving for information”
“Knowledge is power, Intelligence is absolute power!”
Data are defined as numbers or other facts represented or recorded in a form suitable for computer processing. Data is usually a record or result of a task or activity that involves changing content on a website or adding lines to tables. Information in its simplest form is logically processed data. By processing, summarizing, or analyzing data, organizations create information. For example, current balance, items sold, cash made, etc.
This information should be designed to enhance individual knowledge, and therefore, ultimately be tailored to the needs of the recipient. The information is processed data to help and provide answers to questions such as “who”, “what”, “where”, and “when”. Information, on the other hand, is the use of information and data and provides insight by answering “how-to” questions.
