Databases Reference
In-Depth Information
•
Extract.
This provides data enhancement and copy management for
the data warehouse.
•
Distribution.
This provides seamless consistent data delivery to appli-
cations and end users.
•
Access.
This provides transparent user-initiated access, regardless of
platforms.
•
Control.
This provides and maintains the rules that govern enterprise
data.
•
Manager.
This individual provides the functions that monitor and di-
rect EDM processes.
•
EDM execution.
This step provides the tools and utilities that execute
EDM processes.
ENTERPRISE WAREHOUSE — THE DATA
In a logical sense, the enterprise warehouse component is a single mas-
ter repository of enterprise data and metadata that produces the physical
data structures required to store the subsequent informational data of the
corporation. Physical implementation may warrant multiple data elements
and fields; however, each replication is a clone of the logical master copy.
A single image of a data element is contained in a logical data store,
which is the conceptual enterprise warehouse. The corporation has only
one logical data element and its associated metadata for any given item.
Actual physical data elements of the data are unlikely to be stored in one
unique database. The physical layer of the enterprise warehouse are man-
aged within the enterprise data warehouse or downstream client data
warehouses (see Exhibit 2).
The enterprise data warehouse is the primary repository for the physi-
cal master data element. It is the first occurrence of physically depositing
the master copy of an element or field in an enterprise managed data store.
The client data warehouse contains the subsets of these data elements
stored in downstream physical locations to accommodate proximity and
platforms. The elements contained therein are identical to the master log-
ical image and are extracted from the enterprise data warehouse. In some
instances, individual departmental-specific data elements not needed by
other areas are stored in client data warehouses, and supersets are rolled
into the enterprise data warehouse as required by the enterprise.
The enterprise warehouse is a logical view of data from a corporate per-
spective. It is not oriented toward the needs of the individual application,
in the physical sense, but is modeled at a higher level to provide the con-
sistent foundation for the data and relationships that different user constit-
uents and applications have in common. It can eliminate the replication of
Search WWH ::
Custom Search