Skip to content

DW Architecture: Operational Reports Data Repository

September 28, 2012

In the DW Architecture block diagram I presented the Operational Reports Data Repository (ORDR) as been part of the Data Warehouse Architecture.

The ORDR is use to reduce the source systems (OLTP) workload of complex and heavy queries needed to produce operational reports; it is part of Data Warehouse Architecture. The ORDR is built by replication data from the sources (OLTP) systems. The data in the ORDR is volatile, only contains the data required for the operational reports, does not contain any historical data. The ORDR is frequently purged, and as the EDR, contains data integrated from different source systems.

Some of the main difference between the ORDR and the EDW are:

Operational Reports Data Repository Enterprise Data Warehouse
Data is volatile. It is frequently purged. Contain all historic data of the enterprise.
Most of it content is raw data. Most of it content is transformed data.
It is feed from the OLTP systems used for the enterprise in the day to day operations. It is feed from all data sources of the enterprise, including unstructured data and big data sources.
Lack of bitemporal data. Contains bitemporal data.
Do not keep track of changes. Keep track of changes (changing dimensions).

This list is not complete and is only presented to clarify the differences between the ORDR and the EDW.

The ORDR is an optional component of the Data Warehouse Architecture; it implementation is the responsibility of the DW team. The existence of an EDW facilitates the development of the ORDR, because a lot of the integration work has already been done.


Read Further

The Data Warehouse Architecture


From → DW Architecture

Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: