skip to main content
article
Free Access

Approximating block accesses in database organizations

Published:01 April 1977Publication History
Skip Abstract Section

Abstract

When data records are grouped into blocks in secondary storage, it is frequently necessary to estimate the number of blocks XD accessed for a given query. In a recent paper [1], Cardenas gave the expression XD = m(1 - (1 - 1/m)k), (1) assuming that there are n records divided into m blocks and that the k records satisfying the query are distributed uniformly among the m blocks. The derivation of the expression was left to the reader as an exercise.

References

  1. 1 Cardenas, A.F. Analysis and performance of inverted data base structures. Comm. ACM 18, 5 (May 1975), 253-263. Google ScholarGoogle ScholarDigital LibraryDigital Library
  2. 2 Rothnie, J.B., and Lozano, T. Attribute based file organization in a paged memory environment. Comm. ACM 17, 2 (Feb. 1974), 63-69. Google ScholarGoogle ScholarDigital LibraryDigital Library
  3. 3 Severance, D.G. Some generalized modeling structures for use in design of file organizations. Ph.D. Diss., U. of Michigan, Ann Arbor, Mich. 1972. Google ScholarGoogle ScholarDigital LibraryDigital Library
  4. 4 Siler, K.F. A stochastic evaluation model for data base organizations in data retrieval systems. Comm. ACM 19, 2 (Feb. 1976), 84-95. Google ScholarGoogle ScholarDigital LibraryDigital Library
  5. 5 Yao, S.B. Tree structures construction using key densities. Proc. ACM 1975 Nat. Conf., pp. 337-340. Google ScholarGoogle ScholarDigital LibraryDigital Library
  6. 6 Yao, S.B. Evaluation and optimization of file organizations through analytic modeling. Ph.D~ Diss., U. of Michigan, Ann Arbor, Mich. 1974. Google ScholarGoogle ScholarDigital LibraryDigital Library
  7. 7 Yao, S.B. An attribute based model for database access cost analysis. ACM Trans. Database Syst. 2, 1 (March 1977) 45-67. Google ScholarGoogle ScholarDigital LibraryDigital Library
  8. 8 Yue, P.C., and Wong, C.K. Storage Cost Considerations in Secondary Index Selection. Int. J. Cptr. Inform. Sci. 4, 4 (1975), 307-327.Google ScholarGoogle Scholar

Recommendations

Comments

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Sign in

Full Access

  • Published in

    cover image Communications of the ACM
    Communications of the ACM  Volume 20, Issue 4
    April 1977
    85 pages
    ISSN:0001-0782
    EISSN:1557-7317
    DOI:10.1145/359461
    Issue’s Table of Contents

    Copyright © 1977 ACM

    Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

    Publisher

    Association for Computing Machinery

    New York, NY, United States

    Publication History

    • Published: 1 April 1977

    Permissions

    Request permissions about this article.

    Request Permissions

    Check for updates

    Qualifiers

    • article

PDF Format

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader