%0 Conference Proceedings
%T Data Vault Mappings to Dimensional Model Using Schema Matching
%+ Solita Ltd [Tampere]
%+ University of Tampere [Finland]
%A Puonti, Mikko
%A Raitalaakso, Timo
%Z Part 2: Technical Architecture and Applications for EIS
%< avec comité de lecture
%( Lecture Notes in Business Information Processing
%B 13th International Conference on Research and Practical Issues of Enterprise Information Systems (CONFENIS)
%C Prague, Czech Republic
%Y Petr Doucek
%Y Josef Basl
%Y A Min Tjoa
%Y Maria Raffai
%Y Antonin Pavlicek
%Y Katrin Detter
%I Springer International Publishing
%3 Research and Practical Issues of Enterprise Information Systems
%V LNBIP-375
%P 55-64
%8 2019-12-16
%D 2019
%R 10.1007/978-3-030-37632-1_5
%K Schema matching
%K Data flow
%K Data warehouse
%K Data vault
%K Dimensional model
%Z Computer Science [cs]
%Z Humanities and Social Sciences/Library and information sciencesConference papers
%X In data warehousing, business driven development defines data requirements to fulfill reporting needs. A data warehouse stores current and historical data in one single place. Data warehouse architecture consists of several layers and each has its own purpose. A staging layer is a data storage area to assists data loadings, a data vault modelled layer is the persistent storage that integrates data and stores the history, whereas publish layer presents data using a vocabulary that is familiar to the information users. By following the process which is driven by business requirements and starts with publish layer structure, this creates a situation where manual work requires a specialist, who knows the data vault model. Our goal is to reduce the number of entities that can be selected in a transformation so that the individual developer does not need to know the whole solution, but can focus on a subset of entities (partial schema). In this paper, we present two different schema matchers, one based on attribute names, and another based on data flow mapping information. Schema matching based on data flow mappings is a novel addition to current schema matching literature. Through the example of Northwind, we show how these two different matchers affect the formation of a partial schema for transformation source entities. Based on our experiment with Northwind we conclude that combining schema matching algorithms produces correct entities in the partial schema.
%G English
%Z TC 8
%Z WG 8.9
%2 https://inria.hal.science/hal-03408389/document
%2 https://inria.hal.science/hal-03408389/file/493186_1_En_5_Chapter.pdf
%L hal-03408389
%U https://inria.hal.science/hal-03408389
%~ SHS
%~ IFIP
%~ IFIP-TC
%~ IFIP-LNBIP
%~ IFIP-WG
%~ IFIP-TC8
%~ IFIP-WG8-9
%~ IFIP-CONFENIS
%~ IFIP-LNBIP-375