Partial-match retrieval for dynamic files using linear hashing with partial expansions

  • Kotagiri Ramamohanarao
  • John Shepherd
  • Ron Sacks-Davis
Basic Data Structures
Part of the Lecture Notes in Computer Science book series (LNCS, volume 367)


The average number of disk accesses required to perform primary-key retrieval in systems using linear hasing can be reduced by employing the technique of partial expansions. This scheme maintains a more uniform distribution of records amongst the pages of the database file, thus reducing the average length of overflow chains and hence the average query cost. In this paper, we analyse the cost benefits of using linear hashing with partial expansions for partial-match retrieval and show that this type of indexing is effective for use with partial-match retrieval on highly dynamic files.


Home Page Average Cost File Size Split Pointer Query Type 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    A. V. Aho and J. D. Ullman, “Optimal partial-match retrieval when fields are independently specified”, ACM Transactions on Database Systems 4, 2 (June 1979), 168–179.Google Scholar
  2. 2.
    P. Larson, “Linear hashing with partial expansions”, Proceedings of the 6th International Conference on Very large Databases, 1980, 212–233.Google Scholar
  3. 3.
    W. Litwin, “Linear hashing: a new tool for file and table addressing”, Proceedings of the Sixth International Conference on Very Large Data Bases, 1980, 212–223.Google Scholar
  4. 4.
    J. W. Lloyd, “Optimal partial-match retrieval”, Bit 20 (1980), 406–413.Google Scholar
  5. 5.
    J. W. Lloyd and K. Ramamohanarao, “Partial-match retrieval for dynamic files”, BIT 22 (1982), 150–168.Google Scholar
  6. 6.
    S. Moran, “On the complexity of designing optimal partial-match retrieval systems”, ACM Transactions on Database Systems 8, 4 (December 1983), 543–551.Google Scholar
  7. 7.
    K. Ramamohanarao and J. W. Lloyd, “Dynamic hashing schemes”, The Computer Journal, November 1982.Google Scholar
  8. 8.
    K. Ramamohanarao, J. W. Lloyd and J. A. Thom, “Partial-match retrieval using hashing and descriptors”, ACM Transactions on Database Systems 8, 4 (December 1983), 552–576.Google Scholar
  9. 9.
    K. Ramamohanarao and R. Sacks-Davis, “Recursive linear hashing”, ACM Transactions on Database Systems 9, 3 (September 1984), 369–391.Google Scholar
  10. 10.
    K. Ramamohanarao, J. Shepherd and R. Sacks-Davis, “Partial-match retrieval using multi-key hashing with multiple file copies”, Proceedings of the International Symposium on Database Systems for Advanced Applications, Seoul, Korea, April 1988.Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 1989

Authors and Affiliations

  • Kotagiri Ramamohanarao
    • 1
  • John Shepherd
    • 1
  • Ron Sacks-Davis
    • 2
  1. 1.Department of Computer ScienceThe University of MelbourneParkvilleAustralia
  2. 2.Department of Computer ScienceRoyal Melbourne Institute of TechnologyMelbourneAustralia

Personalised recommendations