Skip to main content
SpringerLink
Log in

Storage cost considerations in secondary index selection

  • Published:
International Journal of Computer & Information Sciences Aims and scope Submit manuscript

Abstract

This paper is concerned with the combined problem of selecting secondary indices for a large relational data base and placing data files and index files in multileveled storage. It is shown that if storage cost consideration is explicitly incorporated, then the optimization becomes nontrivial. An algorithm is presented for minimizing the expected query time under arbitrary storage cost constraints. The formulation includes the consideration that a physical storage block (rather than a single tuple) is the smallest unit of data transfer and that block size is level dependent.

This is a preview of subscription content, log in via an institution to check access.

Access this article

Log in via an institution

Price excludes VAT (USA)
Tax calculation will be finalised during checkout.

Instant access to the full article PDF.

Institutional subscriptions

Similar content being viewed by others

References

  1. D. Knuth,The Art of Computer Programming (Addison Wesley, Reading, Massachusetts, 1973), Vol. 3, Sec. 6.5.

    Google Scholar 

  2. V. Y. Lum and H. Ling, “An optimization problem on the selection of secondary keys,” inProc. ACM Nat. Conf., Vol.26 (1971), pp. 349–356.

    Google Scholar 

  3. T. C. Hu,Integer Programming and Network Flows (Addison Wesley, Reading, Massachusetts, 1969).

    Google Scholar 

  4. M. Stonebraker, “The choice of partial inversions and combined indices,”Int. J. Comp. Inf. Sci. 3(2): 167–188 (1974).

    Google Scholar 

  5. W. F. King, “On the selection of indices for a file,” IBM Research Report, RJ 1341 (1974).

  6. E. F. Codd, “A relational model of data for large shared data bases,”Commun. ACM 13(6):377–387 (1970).

    Google Scholar 

  7. J. B. Rothnie and T. Lozano, “Attribute based file organization in a paged memory environment,”Commun. ACM 17(2):63–69 (1974).

    Google Scholar 

  8. C. V. Ramamoorthy and K. M. Chandy, “Optimization of memory hierarchies in multiprogrammed systems,”J. ACM 17(3):426–445 (1970).

    Google Scholar 

  9. W. Chu, “Optimal file allocation in a multiple computer system,”IEEE Trans. on Computers C-18(10):885–889 (1969).

    Google Scholar 

  10. P. S. Chen, “Optimal file allocation in multilevel storage systems,” NCC 73, pp. 277–282.

Download references

Author information

Authors and Affiliations

  1. Computer Sciences Department, IBM Thomas J. Watson Research Center, Yorktown Heights, New York

    P. C. Yue & C. K. Wong

Authors
  1. P. C. Yue
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. C. K. Wong
    View author publications

    You can also search for this author in PubMed Google Scholar

Rights and permissions

Reprints and permissions

About this article

Cite this article

Yue, P.C., Wong, C.K. Storage cost considerations in secondary index selection. International Journal of Computer and Information Sciences 4, 307–327 (1975). https://doi.org/10.1007/BF00979372

Download citation

  • Received:

  • Revised:

  • Issue Date:

  • DOI: https://doi.org/10.1007/BF00979372

Key words

Search

Navigation