Data Warehouse

50 %
50 %
Information about Data Warehouse

Published on January 26, 2009

Author: ravionly431


Data warehouse : Data warehouse By: RAVI RANJAN By: Ravi Ranjan Definition : Definition Data Warehouse A collection of corporate information, derived directly from operational systems and some external data sources. Its specific purpose is to support business decisions, not business operations. The Purpose of Data Warehousing : The Purpose of Data Warehousing Realize the value of data Data / information is an asset Methods to realize the value, (Reporting, Analysis, etc.) Make better decisions Turn data into information Create competitive advantage Methods to support the decision making process, (EIS, DSS, etc.) Slide 4: Data Warehouse Components Staging Area A preparatory repository where transaction data can be transformed for use in the data warehouse Data Mart Traditional dimensionally modeled set of dimension and fact tables Per Kimball, a data warehouse is the union of a set of data marts Operational Data Store (ODS) Modeled to support near real-time reporting needs. Data Warehouse Functionality : Data Warehouse Functionality Evolution architecture of data warehouse : Evolution architecture of data warehouse GO TO DIAGRAM GO TO DIAGRAM GO TO DIAGRAM GO TO DIAGRAM Very Large Data Bases : Very Large Data Bases Terabytes -- 10^12 bytes: Petabytes -- 10^15 bytes: Exabytes -- 10^18 bytes: Zettabytes -- 10^21 bytes: Zottabytes -- 10^24 bytes: Wal-Mart -- 24 Terabytes Geographic Information Systems National Medical Records Weather images Intelligence Agency Videos Warehouses are Very Large Databases Complexities of Creating a Data Warehouse : Complexities of Creating a Data Warehouse Incomplete errors Missing Fields Records or Fields That, by Design, are not Being Recorded Incorrect errors Wrong Calculations, Aggregations Duplicate Records Wrong Information Entered into Source System SUCCESS & FUTURE OF DATA WAREHOUSE : SUCCESS & FUTURE OF DATA WAREHOUSE The Data Warehouse has successfully supported the increased needs of the State over the past eight years. The need for growth continues however, as the desire for more integrated data increases. The Data Warehouse has software and tools in place to provide the functionality needed to support new enterprise Data Warehouse projects. The future capabilities of the Data Warehouse can be expanded to include other programs and agencies. Data Warehouse Pitfalls : Data Warehouse Pitfalls You are going to spend much time extracting, cleaning, and loading data You are going to find problems with systems feeding the data warehouse You will find the need to store/validate data not being captured/validated by any existing system Large scale data warehousing can become an exercise in data homogenizing Data Warehouse Pitfalls… : Data Warehouse Pitfalls… The time it takes to load the warehouse will expand to the amount of the time in the available window... and then some You are building a HIGH maintenance system You will fail if you concentrate on resource optimization to the neglect of project, data, and customer management issues and an understanding of what adds value to the customer Best Practices : Best Practices Complete requirements and design Prototyping is key to business understanding Utilizing proper aggregations and detailed data Training is an on-going process Build data integrity checks into your system. Slide 13: Thank You Slide 14: BACK TO ARCHITECTURE Slide 15: BACK TO ARCHITECTURE Slide 16: BACK TO ARCHITECTURE Slide 17: BACK TO ARCHITECTURE

Add a comment

Related presentations

Related pages

Data-Warehouse – Wikipedia

Ein Data Warehouse (DW oder DWH) ist eine für Analysezwecke optimierte zentrale Datenbank, die Daten aus mehreren, in der Regel heterogenen Quellen ...
Read more

Definition » Data Warehouse « | Gabler Wirtschaftslexikon

Data Warehouse: eine von den operativen Datenverarbeitungssystemen separierte Datenbank, auf die nur Lesezugriff besteht. In regelmäßigen Abständen ...
Read more

Data Warehouse – MittelstandsWiki

Ein Data Warehouse ist eine zentrale Sammelstelle für betriebliche Echtdaten – interne wie externe –, die dort erfasst sind und dann Stellen wie ...
Read more

Data-Warehouse GmbH — Data-Warehouse GmbH

Data-Warehouse GmbH Systemhaus und Hersteller von Informationmanagementsystemen, CyberSecurity Systemen, Softwareentwicklungsplattformen; IT ...
Read more

Data warehouse - Wikipedia, the free encyclopedia

Types of systems Data mart A data mart is a simple form of a data warehouse that is focused on a single subject (or functional area) hence, they draw data ...
Read more

Data Warehouse, Data Warehousing - Software und Anbieter

Aktuelle Marktübersicht - Data Warehouse, Data Warehousing Software. Lösungen vergleichen, downloaden und testen!
Read more

Data Warehouse › PCS Beratungscontor AG

Für die Realisierung von BI-Lösungen setzen wir auf praxiserprobte Modelle angelehnt an empfohlene Referenzarchitekturen. Für klassische Data Warehouse ...
Read more

Data Warehouse -

Data Warehouse- Professionelle Datenverwaltung an Ihre Anforderungen angepasst ... Vielen Dank für Ihr Interesse an Services, Produkten und Leistungen ...
Read more

Data Warehouse (DW, DWH) -

Data Warehouse. Beim Data Warehouse (DW oder DWH) handelt es sich um eine zentrale Sammlung von (Unternehmens)Daten, deren Inhalt sich aus verschiedenen ...
Read more

Data Warehouse — Enzyklopaedie der Wirtschaftsinformatik

Seit mehr als zehn Jahren wird die serverseitige Ausgestaltung von analyseorientierten bzw. entscheidungsunterstützenden Systemlösungen maßgeblich durch ...
Read more