An Automatic Schema-Instance Approach for Merging Multidimensional Data Warehouses

07/26/2021
by   Yuzhao Yang, et al.
0

Using data warehouses to analyse multidimensional data is a significant task in company decision-making.The data warehouse merging process is composed of two steps: matching multidimensional components and then merging them. Current approaches do not take all the particularities of multidimensional data warehouses into account, e.g., only merging schemata, but not instances; or not exploiting hierarchies nor fact tables. Thus, in this paper, we propose an automatic merging approach for star schema-modeled data warehouses that works at both the schema and instance levels. We also provide algorithms for merging hierarchies, dimensions and facts. Eventually, we implement our merging algorithms and validate them with the use of both synthetic and benchmark datasets.

READ FULL TEXT

page 1

page 2

page 3

page 4

research
07/13/2020

A class of ie-merging functions

We describe a general class of ie-merging functions and pose the problem...
research
08/26/2020

Automatic Integration Issues of Tabular Data for On-Line Analysis Processing

Companies and individuals produce numerous tabular data. The objective o...
research
01/31/2022

Eris: Measuring discord among multidimensional data sources

Data integration is a classical problem in databases, typically decompos...
research
09/07/2018

Hierarchical Characteristic Set Merging for Optimizing SPARQL Queries in Heterogeneous RDF

Characteristic sets (CS) organize RDF triples based on the set of proper...
research
03/24/2020

Efficient Algorithms for Multidimensional Segmented Regression

We study the fundamental problem of fixed design multidimensional segme...
research
11/14/2006

Cartes auto-organisées pour l'analyse exploratoire de données et la visualisation

This paper shows how to use the Kohonen algorithm to represent multidime...
research
01/31/2018

Technical Report: Adjudication of Coreference Annotations via Answer Set Optimization

We describe the first automatic approach for merging coreference annotat...

Please sign up or login with your details

Forgot password? Click here to reset