Performance of industrial sensor data persistence in data vault

Research output: Chapter in Book/Report/Conference proceedingsConference contributionpeer-review

Abstract

Today manufacturing companies are facing important challenges from the market in terms of flexibility, ever growing product mixes, small lot sizes, high competition, etc. To meet these market conditions, digitalization and the use of data are offering a viable toolset considering the advances in the field throughout the last couple of years. The increasing use of sensor technology and the need for interconnecting data from different departments in smart production leads to a surge of recorded data. Persistence and integration of heterogeneous data, generated in a variety of software systems, is a key factor to gain value from data and its analysis. High flexibility in regards to the model is required to accommodate the data. Hence, application of the data vault modelling approach is a fitting candidate to design a data warehouse model. In this paper we present a data vault model for factory sensor data. We analyze the performance of the data warehouse in regards to bulk load of data and common analytic queries.

Original languageEnglish
Title of host publication30th European Modeling and Simulation Symposium, EMSS 2018
EditorsYuri Merkuryev, Miquel Angel Piera, Francesco Longo, Agostino G. Bruzzone, Michael Affenzeller, Emilio Jimenez
PublisherDIME UNIVERSITY OF GENOA
Pages226-233
Number of pages8
ISBN (Electronic)9788885741065
ISBN (Print)978-88-85741-03-4
Publication statusPublished - 2018
Event30th European Modeling and Simulation Symposium, EMSS 2018 - Budapest, Hungary
Duration: 17 Sep 201819 Sep 2018

Publication series

Name30th European Modeling and Simulation Symposium, EMSS 2018

Conference

Conference30th European Modeling and Simulation Symposium, EMSS 2018
CountryHungary
CityBudapest
Period17.09.201819.09.2018

Keywords

  • Data vault
  • Industrial data warehouse
  • Performance analysis
  • Sensor data persistence

Fingerprint Dive into the research topics of 'Performance of industrial sensor data persistence in data vault'. Together they form a unique fingerprint.

Cite this