Data Vault Modeling

14,000,000 Leading Edge Experts on the ideXlab platform

Scan Science and Technology

Contact Leading Edge Experts & Companies

Scan Science and Technology

Contact Leading Edge Experts & Companies

The Experts below are selected from a list of 9 Experts worldwide ranked by ideXlab platform

Nataraj Geethanjali - One of the best experts on this subject based on the ideXlab platform.

  • Integration of heterogeneous Data in the Data Vault model
    2019
    Co-Authors: Nataraj Geethanjali
    Abstract:

    Data increases tremendously with respect to volume, velocity, and variety. Nowadays, most of these Data are unstructured like text documents, images, videos, Internet of Things (IoT) Data, etc. Especially in enterprises, the analysis of semi-structured and unstructured Data together with traditional structured Data can add value. For example, semi-structured email Data can be combined with structured customer Data to keep a complete record of all customer information. Likewise, unstructured IoT Data can be combined with structured machine Data to enable predictive maintenance. Thereby, heterogeneous Data need to be efficiently stored, integrated, and analyzed to derive useful business insights. The traditional Modeling techniques like Kimball’s approach and Inmon’s approach are primarily focused on Modeling structured Data. Due to vast amounts of Data being collected and agile project execution, scalability and flexibility become more essential characteristics in Data Modeling. However, especially regarding flexibility, the traditional Data Modeling approaches used in Data warehousing face some limitations. Therefore, Data Vault Modeling was developed to overcome these limitations. However, the Data Vault model was designed for structured Data. To combine these structured Data with semi-structured and unstructured Data, the Data Vault model therefore needs to be adapted. However, there exists no comprehensive approach to do so for both semi-structured and unstructured Data. This thesis, therefore, focuses on developing various Modeling approaches to integrate semi-structured and unstructured Data along with structured Data into the Data Vault model. To this end, multiple use cases from different areas like Customer Relationship Management (CRM), Manufacturing, and Autonomous Car Testing that produce and use heterogeneous Data are taken into consideration. Using examples from these areas, the different approaches are implemented and their advantages and disadvantages are discussed. In addition, the developed concepts are evaluated to check whether they fulfill the Data Vault characteristics

Pete Kolárovec - One of the best experts on this subject based on the ideXlab platform.

  • Data Vault Modeling methodology application for ETL processes
    Czech Technical University in Prague. Computing and Information Centre., 2019
    Co-Authors: Pete Kolárovec
    Abstract:

    V práci sa zaoberám metodikou modelovania Data Vault v spojení s budovaním dátového skladu a prenosmi dát - ETL procesmi. Analyzujem možnosti rozvoja interného ETL nástroja firmy Neit Consulting s. r. o. Ako jej zamestnanec predstavujem nové, nezávislé riešenie pre dynamické generovanie spustiteľného SQL kódu na prenos dát. Generovanie prebieha na základe dát uložených v relačnej Databáze a znalostných modulov, ktoré obsahujú volania API funkcií pre dynamické dopĺňanie informácií. Toto rozšírenie je poskytnuté voľne a môže slúžiť komukoľvek ako základ pre jeho ETL nástroj.In this thesis, I deal with the Data Vault Modeling technique in conjunction with building a Data warehouse and transferring the Data - ETL processes. I analyze the development opportunities of intern ETL tool made by Neit Consulting Ltd. As its employee, I present a new, independent solution for dynamically generated runnable SQL code transferring the Data. The generating is based on metaData stored in a relational Database and knowledge modules, which contain API calls for dynamical insert of the Data. This extension is free to use, and it may serve to whomever as a base for their ETL too

Williams Connard - One of the best experts on this subject based on the ideXlab platform.

Collins Geoff - One of the best experts on this subject based on the ideXlab platform.

Ma Hoga - One of the best experts on this subject based on the ideXlab platform.

Data Vault Modeling - 15 days free trial to Access Experts & Abstracts