ReX: Extrapolating Relational Data in a Representative Way

Teodora Sandra Buda (1) , Thomas Cerqueus (2) , John Murphy (1) , Morten Kristiansen (3)

1 PEL - Performance Engineering Laboratory
2 DRIM - Distribution, Recherche d'Information et Mobilité
3 IBM - IBM [DUBLIN]

Generating synthetic data is useful in multiple application areas (e.g., database testing, software testing). Nevertheless, existing synthetic data generators generally lack the necessary mechanism to produce realistic data, unless a complex set of inputs are given from the user, such as the characteristics of the desired data. An automated and efficient technique is needed for generating realistic data. In this paper, we propose ReX, a novel extrapolation system targeting relational databases that aims to produce a representative extrapolated database given an original one and a natural scaling rate. Furthermore, we evaluate our system in comparison with an existing realistic scaling method, UpSizeR, by measuring the representativeness of the extrapolated database to the original one, the accuracy for approximate query answering, the database size, and their performance. Results show that our solution significantly outperforms the compared method for all considered dimensions.

Domaines: Base de données [cs.DB]

Teodora Sandra Buda, Thomas Cerqueus, John Murphy, Morten Kristiansen. ReX: Extrapolating Relational Data in a Representative Way. 30th British International Conference on Databases, Jul 2015, Édimbourg, United Kingdom. ⟨hal-01207668⟩