Data Warehouse: The Concept at Glance PDF
Document Details
Uploaded by EagerSunstone6461
Dr. Babasaheb Ambedkar Technological University
Tags
Summary
This document provides an overview of data warehousing concepts, including its definition, subject orientation, and time-variant nature. It explains how data is organized and managed in a data warehouse, emphasizing its role in business trend analysis.
Full Transcript
# Data Warehouse : The Concept at Glance Imagine a Supply Chain of Goods and visualize data as any other physical Product The Data is delivered via SFTP or direct source connection. The Data is then Extracted, Transported for Loading Protect Quality of Data: Return bad data # Data Warehouse : Defi...
# Data Warehouse : The Concept at Glance Imagine a Supply Chain of Goods and visualize data as any other physical Product The Data is delivered via SFTP or direct source connection. The Data is then Extracted, Transported for Loading Protect Quality of Data: Return bad data # Data Warehouse : Definition A Data Warehouse is a relational database that is designed for Data Storage and Analysis. A data warehouse environment includes an Extraction, Transformation, and Loading (ETL) solution, online analytical processing (OLAP), Data Mining capabilities, client analysis tools, and other applications that manage the process of gathering data and delivering it to business users. It is a series of processes, procedures and tools (h/w & s/w) that help the enterprise understand more about itself, its products, its customers and the market it services ### Golden Words _"Data Warehouse is a subject-oriented, integrated nonvolatile and time-variant collection of data in support of management's decisions."_ - William Inmon # Data Warehouse : Subject Oriented The data in data warehouse is organized around the major subject of the enterprise (i.e. the high level entities). The orientation around the major subject areas causes the data warehouse design to be data driven. The operational systems are designed around the application and functions. e.g. Loans, savings, credit cards in case of a Bank. Where Data Warehouse is designed around a subject like Customer, Product, Vendor etc. - Operational Systems - Data Warehouse - Customer - Supplier - Product Organized by processes Organized by subject # Data Warehouse: Time Variant - Data is stored as a series of snapshots or views which record how it is collected across time. - It helps in Business trend analysis - In contrast to OLTP environment, data warehouse's focus on change over time that is what we mean by time variant.
