236 | Chapter 10: Oracle Data Warehousing and Business Intelligence
Managing the Data Warehouse
Once you??™ve built a data warehouse topology, you could deploy multiple Oracle
databases to implement the data warehouse and its data marts. Enterprise-wide
warehouses are common on Unix servers, but are also appearing on clustered (RAC)
Linux platforms. Smaller data marts are common on Windows and Linux. Many
organizations are consolidating data marts and enterprise data warehouses on the
more scalable platforms.
Oracle Enterprise Manager provides a common GUI for managing these multiple
instances regardless of the underlying operating system. EM is browser-based with a
multiuser repository for tracking and managing the Oracle instances. (EM is discussed
in much more detail in Chapter 5.)
In warehousing, in addition to basic management, ongoing tuning for performance is
crucial. Enterprise Manager supports many of the automated diagnostics and tuning
features added in Oracle Database 10g and more recent releases.
Within the largest warehouses and data marts, you may want to manage or maintain
availability to some of the data even as other parts of the database are moved offline.
Pages:
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520