Sunday , September 20 2020

Query Optimization on Random Databases

Silviu Laurenţiu VASILE1,2
1 University of Bucharest, Faculty of Mathematics and Computer Science, Academiei 14, RO-010014, Bucharest, Romania
2 Institute of Mathematical Statistics and Applied Mathematics,
Calea 13 Septembrie 13, RO-050711, Bucharest, Romania

Abstract: We analyze the cardinality of the ?-join operation into a random database for tables having column values following some representative types of probability distributions (uniform distribution, exponential distribution and normal distribution). The goal of our research is to use our analysis to make some query optimization on random databases. Some numerical results are studied and the conclusions we have drawn as a result of the practical experiments are presented.

Keywords: Random database, Join, Cardinality, Query optimization.

>>Full Text
Silviu Laurențiu VASILE, Query Optimization on Random Databases, Studies in Informatics and Control, ISSN 1220-1766, vol. 23 (3), pp. 257-264, 2014.