• Author / Uploaded
• ahmed_sft

Citation preview

Riadh Ben Messaoud



Provide principles and concepts related to the implementation of data warehouses



Learn fundamental techniques for developing On-line Analysis Processing (OLAP) tools



Treat issues related to practical use of ad hoc software

Data Warehouses & OLAP

2



The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling - 2nd Edition, Ralph Kimball, Margy Ross, Wiley and Sons, Inc., 2002.



Building the Data Warehouse - 1st Edition, Bill Inmon, Wiley and Sons, Inc., 1992.



DW 2.0 - Architecture for the Next Generation of Data Warehousing, Bill Inmon, Derek Strauss, Genia Neushloss, Elsevier Press, 2008.



Data Warehousing, OLAP and Data Mining, S. Nagabhushana, New Age International Publishers, 2006.



Building and Maintaining a Data Warehouse, Fon Silvers, CRC Press, 2008.



Data Warehouses and OLAP: Concepts, Architectures and Solutions, Robert Wrembel & Christian Koncilia, IRM Press, 2007.



Oracle Warehouse Builder 11gR2: Getting Started 2011, Bob Griesemer, Packt Publishing, 2011. Data Warehouses & OLAP

3

1.

2. 3. 4.

5. 6. 7.

8. 9. 10.

The Big Picture Data Warehouse Philosophy Data Warehouse Concepts Warehousing Applications Warehouse Schema Design Business Intelligence Reporting On-Line Analytical Processing OLAP Applications Data Warehouse Implementation Warehousing Software Data Warehouses & OLAP

4

1.

2. 3. 4.

5. 6. 7.

8. 9. 10.

The Big Picture Data Warehouse Philosophy Data Warehouse Concepts Warehousing Applications Warehouse Schema Design Business Intelligence Reporting On-Line Analytical Processing OLAP Applications Data Warehouse Implementation Warehousing Software Data Warehouses & OLAP

5

Data Warehouses & OLAP

6



1977 – Jimmy Carter was President of the United States Data Warehouses & OLAP

7



1977 – Star Wars hit the big screen Data Warehouses & OLAP

8



1977 – Apple Computer, Inc. introduced to the world the first personal computer Data Warehouses & OLAP

9



1981 – Prince Charles and Lady Diana married Data Warehouses & OLAP

10



1981 – IBM began selling its IBM PC Data Warehouses & OLAP

11



1985 – Mikhail Gorbachev was the leader of the Soviet Union Data Warehouses & OLAP

12

All along these years:  Data was finding its own home inside computers  Data was going everywhere 

Supervisors, managers, and executives alike were no longer able to look at a single clipboard to find out how the business was performing



Such was the origin of Decision Support Systems

Data Warehouses & OLAP

13

What is a DW?  

  

  

It is a DB designed for analytical tasks It uses data from multiple applications It supports a small number of users with long interactions Its usage is read-intensive Its content is periodically updated (mostly additions) It contains current and historical data It provides a historical perspectives of information It contains a few large tables Data Warehouses & OLAP

14

What is a DW?

“ A data warehouse is a subject-oriented, integrated, timevariant and non-volatile collection of data in support of management's decision making process. ” Bill Inmon (Building the Data Warehouse)

“ A data warehouse is a copy of transaction data specifically structured for query and analysis. ” Ralph Kimball (The Data Warehouse Toolkit)

Data Warehouses & OLAP

15

Data Warehouses & OLAP

16