Abstract
The problem examined in this report is the calculation of the average wasted space at the end of the block when variable length records are inserted in the file. Previous efforts are based in approximations. Here, a detailed analysis based on Markov chains gives the exact solution. A framework is presented which shows the relations between the previous approaches. The proposed model includes the previous models as special limiting cases. Simulation results close to the analytic results are also presented.
Similar content being viewed by others
References
S. Christodoulakis,Estimating block selectivities, Information Systems, Vol. 9, No. 1, 1984.
S. Christodoulakis,Implications of certain assumptions in database performance evaluation, ACM Transactions on Database Systems, Vol. 9, No. 2, pp. 163–187, 1984.
S. Christodoulakis, Y. Manolopoulos and P. Å. Larson,Analysis of overflow handling for variable length records, Information Systems, Vol. 14, No. 1, pp. 151–162, 1989.
D. R. Cox,Renewal Theory, Methuen, London, 1967.
C. J. Date,Introduction to Database Systems, John Wiley, Vol. 1, 4th edition, 1988.
J. Hakola and A. Heiskanen,On the distribution of wasted space at the end of file blocks, BIT, Vol. 20, No. 2, pp. 145–156, 1980.
G. U. Hubbard,Computer-assisted Database Design, Van Nostrand Reinhold Company, 1981.
L. Kleinrock:Queueing Systems, Vol. I: Theory, John Wiley, NY, 1975.
Y. Manolopoulos and S. Christodoulakis,File organizations with shared overflow blocks for variable length objects, submitted.
Y. Manolopoulos and N. Fistas,Algorithms for a hash based file with variable length records, Information Sciences, to appear.
T. Sellis,Global query optimization, ACM Transactions on Database Systems, Vol. 13, No. 1, pp. 23–53, 1988.
T. J. Teorey and J. P. Fry,Design of Database Structures, Prentice Hall, NJ, 1982.
G. Wiederhold,File Organization for Database Design, McGraw-Hill, NY, 1987.
Author information
Authors and Affiliations
Additional information
This research was sponsored partially by the National Science Foundation under the grants DCR-86-16833, IRI-8719458 and IRI-8958546 and by the Air Force Office of Scientific Research under grant AFOSR-89-0303.
Rights and permissions
About this article
Cite this article
Manolopoulos, Y., Faloutsos, C. Analysis for the end of block wasted space. BIT 30, 620–630 (1990). https://doi.org/10.1007/BF01933210
Received:
Revised:
Issue Date:
DOI: https://doi.org/10.1007/BF01933210