DataMart Architecture

DataMart Architecture

There are five main components of DataMart Architecture:

1.            DATA SOURCES

a)      Internal Data Source / Operational Databases; Information that is procured, reported and consolidated within your organization, for example: purchase orders from sales, transactions from accounting, and leads from marketing or information from CRM software.

b)      External Data Sources: any information obtained from a source outside of your organization, for example: information collected through census or surveys.

 

  1.             METADATA DATABASE: The metadata database is the only permanent database within DataMart architecture. This database holds all of the configurations & metadata to build and connect everything together. (i.e. configuration information, connection strings, client specific KPIs and attributes etc.).
  2.            STAGING: Within a DataMart, the staging database has a short life cycle.  It is a relational database built to extracted raw data from the source applications; however is ripped down once this data is loaded and populated in the DataMart/OLAP Cube using an ETL Tool.

ETL = Extract – Transform – Load

  • Integration Layer: integrates the unrelated data sets by transforming the data from the staging layer and storing this transformed data in an operational data store (ODS) database.
  • The integrated data is then loaded into the DataMart relational database/OLAP Cube.
  • Each step within the extraction, transformation and load process will include error handling to ensure that errors do not make it down to the DataMart.

 

4/5.        OLAP DATA MART / REPORTING

The OLAP DataMart is made up of the relational database (Data Mart) and the OLAP Cube.

(OLAP) Online Analytical Processing is the analyses of business data for the release of business insight.

Similar to the staging database; the relational database is specifically created and loaded with the subset of data. The OLAP cube is built and processed and uses its in-built reporting tools to provide enhanced analytics and value add data to the organisation.

** Depending on your reporting requirements; you may receive just the OLAP cube or both components**

Using OLAP cubes, an organisation can:

  • Rotate and drill down
  • Create and examine calculated data
  • Determine comparative or relative differences.
  • Perform exception and trend analysis.
  • Perform advanced analytical functions

For in-depth information on OLAP Cubes; click here; or call +44 (0) 207 8732 198