Main Components of a DataMart

The main components of a DataMart Architecture

Published date: 2nd Feb 2015
Categories: Blog DataMarts

Data Marts serve as the “system of record” for decision making and information retrieval purposes of an organisation; providing easy and powerful access to data. Its architecture is made up of five main components:

  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 data Mart.

4/5. OLAP DATAMART / 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 more information on DataMart Reporting, please email info@codecdss.ie or call +44 (0) 207 8732 198