Data Warehouse Development Traditional Systems Oracle Tips by Burleson Consulting

The Data Warehouse Development Life Cycle

Data Warehouse Analysis

There are many differences between traditional systems analysis and Oracle warehouse systems analysis. In a traditional systems analysis, the goal is to document all of the logical processes, describing data transformations, data stores, and external inputs and outputs from an existing system and a proposed system. Figure 3.1 displays a traditional systems development project.


Figure 3.1 A traditional systems development project.

In contrast, a data warehouse systems analysis focuses on determining the data requirements and data sources of a system, and documents how to extract and package data for end users. Figure 3.2 displays an Oracle data warehouse development project.


Figure 3.2 A data warehouse development project.

---

This is an excerpt from "High Performance Data Warehousing". To learn more about Oracle, try "Oracle Tuning: The Definitive Reference", by Donald K. Burleson.  You can buy it direct from the publisher at 30% off here:
http://www.rampant-books.com/book_1002_oracle_tuning_definitive_reference_2nd_ed.htm