Title :
Behavior of keys in random databases
Author :
Seleznjev, Oleg ; Thalheim, Bernhard
Author_Institution :
Fac. of Math. & Mech., Moscow State Univ., Russia
Abstract :
The wide class of stochastic models for databases was considered. The properties of key systems and functional dependencies in stochastic databases were investigated in the average case setting. Comparing with the worst case setting the exponential size of minimal key system is rather unusual in average. For several stochastic models the Poisson approximations of characteristics of the most probable minimal key candidates have been derived in terms of the Renyi entropies. The proposed general method of analysis is based on probabilistic and information theory results. As the first and necessary step for a statistical analysis, several probabilistic models for random tables and relations have been investigated. The outline of possible further practical applications may be as the follows (i) fitting the corresponding stochastic model; (ii) estimation of the model parameters for a given data; (iii) approximation and analysis of key system characteristics. Besides the considered discrete distributions, the Markovian model for stochastic dependencies and the corresponding multivariate normal approximations for discrete distributions can be considered. For the normal distribution, the well-known technique can be applied for the estimation of the model parameters
Keywords :
database theory; entropy; probability; random processes; statistical analysis; stochastic systems; Markovian model; Poisson approximations; Renyi entropies; average case setting; discrete distributions; functional dependencies; information theory; key behavior; minimal key system; model parameter estimation; multivariate normal approximations; normal distribution; probabilistic models; random databases; random relations; random tables; statistical analysis; stochastic databases; stochastic dependencies; stochastic models; Application software; Computer science; Databases; Design optimization; Digital circuits; Entropy; Geology; Mathematics; Pattern recognition; Testing;
Conference_Titel :
Computer Science, 1998. SCCC '98. XVIII International Conference of the Chilean Society of
Conference_Location :
Antofogasta
Print_ISBN :
0-8186-8616-2
DOI :
10.1109/SCCC.1998.730797