Different types of data warehouses
In addition to the relational database, an enterprise data warehouse environment often consists of an Extract Transform and Load (ETL) solution, an OLAP engine (hooray Essbase), client analysis tools, and other web or desktop applications that manage the gathering of data and delivering it to business users.
There are three types of data warehouses:
- Enterprise Data Warehouse: An enterprise data warehouse provides a central database for decision support throughout the enterprise. It is recommended that there is only one data warehouse across the enterprise.
- Operational Data Store: This has a broad enterprise wide scope, but unlike the real enterprise data warehouse, data is refreshed in near real time and used ...
Get Oracle Essbase 9 Implementation Guide 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.
