Starry Vault: Automating Multidimensional Modeling from Data Vaults
M. Golfarelli, S. Graziani, and S. Rizzi. Advances in Databases and Information Systems, page 137--151. Cham, Springer International Publishing, (2016)
Abstract
The data vault model natively supports data and schema evolution, so it is often adopted to create operational data stores. However, it can hardly be directly used for OLAP querying. In this paper we propose an approach called Starry Vault for finding a multidimensional structure in data vaults. Starry Vault builds on the specific features of the data vault model to automate multidimensional modeling, and uses approximate functional dependencies to discover out of data the information necessary to infer the structure of multidimensional hierarchies. The manual intervention by the user is limited to some editing of the resulting multidimensional schemata, which makes the overall process simple and quick enough to be compatible with the situational analysis needs of a data scientist.
Description
Starry Vault: Automating Multidimensional Modeling from Data Vaults | SpringerLink
%0 Conference Paper
%1 golfarelli2016
%A Golfarelli, Matteo
%A Graziani, Simone
%A Rizzi, Stefano
%B Advances in Databases and Information Systems
%C Cham
%D 2016
%E Pokorný, Jaroslav
%E Ivanović, Mirjana
%E Thalheim, Bernhard
%E Saloun, Petr
%I Springer International Publishing
%K dwa
%P 137--151
%T Starry Vault: Automating Multidimensional Modeling from Data Vaults
%X The data vault model natively supports data and schema evolution, so it is often adopted to create operational data stores. However, it can hardly be directly used for OLAP querying. In this paper we propose an approach called Starry Vault for finding a multidimensional structure in data vaults. Starry Vault builds on the specific features of the data vault model to automate multidimensional modeling, and uses approximate functional dependencies to discover out of data the information necessary to infer the structure of multidimensional hierarchies. The manual intervention by the user is limited to some editing of the resulting multidimensional schemata, which makes the overall process simple and quick enough to be compatible with the situational analysis needs of a data scientist.
%@ 978-3-319-44039-2
@inproceedings{golfarelli2016,
abstract = {The data vault model natively supports data and schema evolution, so it is often adopted to create operational data stores. However, it can hardly be directly used for OLAP querying. In this paper we propose an approach called Starry Vault for finding a multidimensional structure in data vaults. Starry Vault builds on the specific features of the data vault model to automate multidimensional modeling, and uses approximate functional dependencies to discover out of data the information necessary to infer the structure of multidimensional hierarchies. The manual intervention by the user is limited to some editing of the resulting multidimensional schemata, which makes the overall process simple and quick enough to be compatible with the situational analysis needs of a data scientist.},
added-at = {2019-11-05T20:18:29.000+0100},
address = {Cham},
author = {Golfarelli, Matteo and Graziani, Simone and Rizzi, Stefano},
biburl = {https://www.bibsonomy.org/bibtex/2f7518c40c1537ca5949a60171453b0f8/mialhoma},
booktitle = {Advances in Databases and Information Systems},
description = {Starry Vault: Automating Multidimensional Modeling from Data Vaults | SpringerLink},
editor = {Pokorn{\'y}, Jaroslav and Ivanovi{\'{c}}, Mirjana and Thalheim, Bernhard and {\v{S}}aloun, Petr},
interhash = {46d177eaa124502e930df3cd832bacd2},
intrahash = {f7518c40c1537ca5949a60171453b0f8},
isbn = {978-3-319-44039-2},
keywords = {dwa},
pages = {137--151},
publisher = {Springer International Publishing},
timestamp = {2019-11-05T20:18:29.000+0100},
title = {Starry Vault: Automating Multidimensional Modeling from Data Vaults},
year = 2016
}