Relational databases

Data entities saved in a relational (staging) database

Package Hourglass ABB
Author Bert Dingemans
Alias --
Stereotypes DataObject

Diagrams

BI and DataWareHousing ETL process

--

Data Integration General view

The hourglass model is a specific model for the transformation of data sources to a standardized model in a target datastore. It is the simplified implementation of a layered Big Data architecture. The hourglass model can be used to medel specific implementations of transformation of data in a pattern called the datapipe.

In a number of other diagrams a detail view is given of these implementations in projects like Digital Transformation, TDP, MaxLimit and others.

File transformation overview

Overview of the transformation from file based data to a data target

Relation transformation overview

Overview of the transformation from a relational database to a data target

XML transformation overview

In this diagram a description of the datapipe from an (webservice) or XML file source to the target datamodel is described. This is based on the transformation of a XML model to an intermediate tabular or relational model and this is then processed in an ETL process to transform the source data model in a number of steps to the required target model.

Copyright © Interactory