As
a result, consolidation of marts into the enterprise warehouse is a common trend.
More recent versions of Oracle enable effective management of different user communities,
helping to make such consolidation possible.
Operational Data Store and Enterprise Warehouse
The operational data store (ODS) concept also grew in popularity in the 1990s. The
ODS may best be described as a distribution center for current data. Like the OLTP
servers, the schema is highly normalized and the data is recent. The ODS serves as a
consolidation point for reporting and can give the business one location for viewing
current data that crosses divisions or departments. The popularity of the ODS grew
Data Warehouse Design | 227
in part as a result of companies in the midst of acquisitions and mergers. These organizations
often face mixed-application environments. The ODS can act as a staging
location that can be used as the source for further transformations into a data warehouse
or into data marts.
The warehouse server, or enterprise data warehouse, is a multisubject historical information
store usually supporting multiple departments and often serving as the
corporate database of record.
Pages:
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499