The Data Warehouse Environment
Data warehouses comprise a multifaceted environment that spans the information systems spectrum from operational transaction systems to systems designed for executive and front-line decision makers. There are four main elements of a data warehouse environment:
Source systems
Extraction, transformation, and load (ETL) systems
Data warehouse repository
Reporting tools and portals
Each of these is described below.
Source Systems
As the name implies, source systems provide the raw material for the data warehouse and business intelligence systems. The design and implementation of these applications is outside the scope of the data warehouse, and source systems are typically treated as black boxes. Some of the considerations ...
Get Proven Portals: Best Practices for Planning, Designing, and Developing Enterprise Portals now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
