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

OPTIMIZATION OF FINGERPRINT SIZE FOR REGISTRATION

The propose algorithm finds the optimal reduced size of latent fingerprint. The algorithm accelerates the correlation methods of fingerprint registration. The Algorithm is based on decomposition and reduction of fingerpr...

A NOVEL APPROACH TO ENHANCE THE PERFORMANCE OF MOBILE AD HOC NETWORK (MANET) THROUGH A NEW BANDWIDTH OPTIMIZATION TECHNIQUE

Now is the age of information technology. World is advancing day by day. At present in this progressing world communication from one place to another has become so easy, less costly, and faster. This modern life is almos...

DETERMINATION OF RELATIVE LENGTHS OF BONE SEGMENTS OF THE DOMESTIC CAT'S LIMBS BASED ON THE DIGITAL IMAGE ANALYSIS

This paper is an introduction to the issues related to obtaining information on the metric dimensions of selected bone segments of a domestic cat based on the analysis of digital images. The main objective is to acquire...

AN EFFECTIVE METAHEURISTIC FOR TOURIST TRIP PLANNING IN PUBLIC TRANSPORT NETWORKS

The Time-Dependent Orienteering Problem with Time Windows (TDOPTW) is a combinatorial optimization problem defined on graphs. Its real life applications are particularly associated with tourist trip planning in trans-por...

STREET LIGHTS INTELLIGENT SYSTEM, BASED ON THE INTERNET OF THINGS CONCEPT

The paper presents a project of a street lights intelligent system, which allows for public savings, as a result of more efficient roads and pavements lights management. The system would operate based on the current loca...

Download PDF file
  • EP ID EP558476
  • DOI 10.23743/acs-2018-32
  • Views 84
  • 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