This led to the development of data stores for decision
support apart from those for OLTP.
When Bill Inmon (whose books are noted in Appendix B) and others popularized the
term ???data warehouse??? in the early 1990s, a formalized common infrastructure for
building a solution came into being. The topology of business intelligence solutions
continued to evolve, as the next section illustrates. Today??™s business intelligence
solutions often include infrastructure that exposes data from data warehouses and
also OLTP systems in reports. Underlying hardware has evolved such that I/O is now
a more important design consideration for data warehousing hardware platforms
(see Chapter 12).
A Topology for Business Intelligence
The classic data warehouse topology, serving as an enterprise-wide source of information,
is represented by the multitier topology shown in Figure 10-1.
This topology developed over many years for a variety of reasons. Initial efforts at
creating a single enterprise warehouse often resulted in ???analysis paralysis.
Pages:
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495