When an ODS is established, the warehouse server
often extracts data from the ODS. When an ODS isn??™t present, data for the warehouse
is directly extracted and transformed from operational sources. External data
may also feed the warehouse server.
As noted previously, platform consolidation is popular within these tiers today. The
enterprise data warehouse can be the point of consolidation for the ODS and multiple
data marts. Although different logical models remain, they are consolidated to a
single platform and database.
OLTP Systems and Business Intelligence
True real-time data resides in the OLTP systems. Organizations can provide reporting
out of such transaction processing systems side-by-side in portals or dashboards
with information from data warehouse systems. A key to providing meaningful dashboards
is to provide high-quality data with consistent meaning. The quality of data
in OLTP systems is directly related to controlling data input to eliminate duplicate or
error-prone entries.
Consistent meaning can be resolved using master data management (MDM) solutions.
Pages:
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500