REVIEW OF THE DATA MODELING STANDARDS AND DATA MODEL TRANSFORMATION TECHNIQUES

Journal Title: Applied Computer Science - Year 2018, Vol 14, Issue 4

Abstract

Manual data transformations that result in high error rates are a big problem in complex integration and data warehouse projects, resulting in poor quality of data and delays in deployment to production. Automation of data trans-formations can be easily verified by humans; the ability to learn from past decisions allows the creation of metadata that can be leveraged in future mappings. Significant improvement of the quality of data transformations can be achieved, when at least one of the models used in transformation is already analyzed and understood. Over recent decades, particular industries have defined data models that are widely adopted in commercial and open source solutions. Those models (often industry standards, accepted by ISO or other organizations) can be leveraged to increase reuse in integration projects resulting in a) lower project costs and b) faster delivery to production. The goal of this article is to provide a comprehensive review of the practical applications of standardization of data formats. Using use cases from the Financial Services Industry as examples, the author tries to identify the motivations and common elements of particular data formats, and how they can be leveraged in order to automate process of data transformations between the models.

Authors and Affiliations

Leszek JASKIERNY

Keywords

Related Articles

NUMERICAL AND EXPERIMENTAL ANALYSIS OF THE STRENGTH OF TANKS DEDICATED TO HOT UTILITY WATER

The focus of this paper are experimental and numerical strength tests of domestic hot water storage tanks. The tests involved the verification of the minimum wall thickness for the assumed operating parameters while meet...

REVIEW OF THE DATA MODELING STANDARDS AND DATA MODEL TRANSFORMATION TECHNIQUES

Manual data transformations that result in high error rates are a big problem in complex integration and data warehouse projects, resulting in poor quality of data and delays in deployment to production. Automation of da...

EFFICIENT NUMERICAL MODELLING OF FUNCTIONALLY GRADED SHELL MECHANICAL BEHAVIOR

Numerical analysis of the static bending and free vibration mechanical behavior of FGM are performed using the UMAT-USDFLD subroutines in ABAQUS software. Different combinations of geometries, mechanical loading and boun...

APPLICATION OF ACOUSTIC SIGNAL PROCESSING METHODS IN DETECTING DIFFERENCES BETWEEN OPEN AND CLOSED KINEMATIC CHAIN MOVEMENT FOR THE KNEE JOINT

The paper presents results of preliminary research of analysis of signals recorded for open and closed kinematic chain in one volunteer with chon-dromalacia in both knees. The preliminary research was conducted in order...

ASYNCHRONOUS INFORMATION DISTRIBUTION AND CLUSTER STATE SYNCHRONIZATION

This article describes issues related to information distribution and cluster state synchronization in decentralized environments with inconsistent net-work topology. The main objective of this study was to create a set...

Download PDF file
  • EP ID EP558476
  • DOI 10.23743/acs-2018-32
  • Views 63
  • Downloads 0

How To Cite

Leszek JASKIERNY (2018). REVIEW OF THE DATA MODELING STANDARDS AND DATA MODEL TRANSFORMATION TECHNIQUES. Applied Computer Science, 14(4), 93-108. https://europub.co.uk/articles/-A-558476