Building the Data Warehouse

Скачать в pdf «Building the Data Warehouse»

These then are the important features that the data warehouse provides to the Web-based ebusiness environment. The data warehouse provides the important background infrastructure that the Web needs in order to be successful.


We have seen that the Web environment is supported by the data warehouse in a variety of ways. The interface for moving data from the Web to the data warehouse is fairly simple. Web data is trapped in logs. The logs feed their clickstream information to the Granularity Manager. The Granularity Manager edits, filters, summarizes, and reorganizes data. The data passes out of the Granularity Manager into the data warehouse.

The interface for moving data from the warehouse to the Web is a little more complex. Data passes from the data warehouse into an ODS. In the ODS a profile record is created. The ODS becomes the sole point of contact between the Web environment and the data warehouse for purposes of data flow from the data warehouse to the Web environment. The reason for this is simple: The ODS is able to ensure that online transactions are processed quickly and consistently, which is essential for efficient Web processing.

In addition, the data warehouse provides a place where massive amounts of data can be downloaded from the Web environment and stored.

The data warehouse also provides a central point where corporate data can be merged and integrated with data coming in from one or more Web sites into a common single source.

ERP and the Data Warehouse

One of the most important advances in technology in the past 10 years has been Enterprise Resource Planning (ERP), the applications and transaction processing built for a company. The applications and transactions—built and maintained centrally by the vendor—cover the following corporate functions:

Скачать в pdf «Building the Data Warehouse»