Physical modeling

Physical model for the description of a technical implementatin model. This is platform specfic and is used for the creation of SQL DDL and ETL scripts and eventually for technical documentation.

Package Hourglass elements
Author 102401
Alias --
Stereotypes ApplicationFunction

Diagrams

Relation transformation overview

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

File transformation overview

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

Transformation generic ABB

Description of the generic aspectis of the transformation application function. This has the following elements

  • Data sources

  • Transformation functions

  • Data targets

  • Data or object modeling functions

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.

Linked elements

Hourglass elements

Copyright © Eaxpertise