Database Reference
In-Depth Information
DB2 Tools
As mentioned in Chapter 17, DB2 provides four main products for managing
data warehouses:
InfoSphere Warehouse Departmental Edition
InfoSphere Warehouse Departmental Base Edition
InfoSphere Warehouse Enterprise Edition
InfoSphere Warehouse Enterprise Base Edition
Each of these products (the latter being an upgrade of the former) consists of
related components that allow for the creation, population (via ETL transactions), and
management of data warehouses, according to organizational requirements.
24.5.3 Daily Operations and Expansion of the
Data Warehouse
Successive ETL transactions to the data warehouse must be scheduled and processed
in a specific order. Depending on the success or failure of the operation or parts of it,
the result must be tracked and subsequent, alternative processes might be started. The
control of the progress and the definition of a business workflow of the operations are
typically addressed by special ETL tools provided by the DBMS suite.
As the data warehouse is an active information system, data sources and targets
are not beyond the prospect of change. These changes must be maintained and
tracked through the lifespan of the system without overwriting or deleting the old ETL
process flow information. To build and keep a level of trust about the information in
the warehouse, the process flow of each individual record in the warehouse can be
reconstructed at any point in time in the future. With time, the data warehouse could
therefore expand into something larger and different.
24.6 Summary and Concluding Remarks
Here is a summary of what we have discussed in this chapter:
A data warehouse is an integrated, subject-oriented, time-variant,
nonvolatile, consistent database, obtained from a variety of
sources and made available to support decision making in a
business context.
A data warehouse is a relational database that is designed for
query and analysis rather than transaction processing.
The data warehouse is updated via the ETL process.
A data warehouse provides the decision support benefits that
a traditional DSS provides, while providing more flexibility for
expansion beyond the confines of the company.
 
Search WWH ::




Custom Search