论文信息 - Join Sizes, urn Models and Normal Limiting Distributions

Join Sizes, urn Models and Normal Limiting Distributions

Abstract We study some parameters of relational databases (sizes of relations obtained by a join) that can be described by generating functions on three variables, of the kind ϕ( x, y, z ) d . We modelize these parameters by suitable urn models and give conditions under which they asymptotically follow a gaussian distribution.

Danièle Gardy

[1] Danièle Gardy,et al. On the effect of join operations on relation sizes , 1989, TODS.

[2] Matthias Jarke,et al. Query Optimization in Database Systems , 1984, CSUR.

[3] Arnon Rosenthal. Note on the expected size of a join , 1981, SGMD.

[4] Michael V. Mannino,et al. Statistical profile estimation in database systems , 1988, CSUR.

[5] Danièle Gardy,et al. On the sizes of projections: a generating function approach , 1984, Inf. Syst..

[6] William Feller,et al. An Introduction to Probability Theory and Its Applications , 1967 .

[7] J. D. Uiiman,et al. Principles of Database Systems , 2004, PODS 2004.

[8] Danièle Gardy. Normal Limiting Distributions for Projection and Semijoin Sizes , 1992, SIAM J. Discret. Math..

[9] Norman L. Johnson,et al. Urn models and their application , 1977 .

[10] Danièle Gardy. Bases de données, allocations aléatoires : quelques analyses de performances , 1989 .

[11] David Maier,et al. The Theory of Relational Databases , 1983 .