TY - GEN
T1 - Performance of industrial sensor data persistence in data vault
AU - Bachinger, Florian
AU - Zenisek, Jan
AU - Kammerer, Lukas
AU - Stimpfl, Martin
AU - Kronberger, Gabriel
N1 - Publisher Copyright:
© Institute of Information Science. All rights reserved.
Copyright:
Copyright 2019 Elsevier B.V., All rights reserved.
PY - 2018
Y1 - 2018
N2 - 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.
AB - 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.
KW - Data vault
KW - Industrial data warehouse
KW - Performance analysis
KW - Sensor data persistence
UR - http://www.scopus.com/inward/record.url?scp=85056741623&partnerID=8YFLogxK
M3 - Conference contribution
SN - 978-88-85741-03-4
T3 - 30th European Modeling and Simulation Symposium, EMSS 2018
SP - 226
EP - 233
BT - 30th European Modeling and Simulation Symposium, EMSS 2018
A2 - Merkuryev, Yuri
A2 - Piera, Miquel Angel
A2 - Longo, Francesco
A2 - Bruzzone, Agostino G.
A2 - Affenzeller, Michael
A2 - Jimenez, Emilio
PB - DIME UNIVERSITY OF GENOA
T2 - 30th European Modeling and Simulation Symposium, EMSS 2018
Y2 - 17 September 2018 through 19 September 2018
ER -