Skip to main content
SpringerLink
Log in

Grid File (and Family)

  • Reference work entry
  • First Online:
Encyclopedia of Database Systems

  • 18 Accesses

Definition

The Grid File is a multidimensional indexing scheme capable to efficiently index database records in a symmetrical manner, i.e., by avoiding the distinction between primary and secondary keys. The structure is dynamic and adapts gracefully to its contents under insertions and deletions. A single record retrieval costs two disk accesses at most (upper bound), whereas range queries and partial-match queries are also executed efficiently. The Grid File can be thought of as a generalization of dynamic hashing (e.g., extendible hashing) in multiple dimensions.

Historical Background

Until the 1980s, many file structures for the processing of single-attribute queries have been proposed, i.e., queries on the primary key or any secondary key for which a corresponding index has been built. Multi-attribute queries are the ones where the user seeks objects that satisfy constraints (such as equality or range) on several attributes. Such queries can be executed by accessing all the...

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

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 4,499.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Hardcover Book
USD 6,499.99
Price excludes VAT (USA)
  • Durable hardcover edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Recommended Reading

  1. Becker L, Hinrichs K, Finke U. A new algorithm for computing joins with grid files. In: Proceedings of the 9th International Conference on Data Engineering; 1993, p. 190–97.

    Google Scholar 

  2. Bentley JL. Multidimensional binary search trees used for associative searching. Commun ACM. 1975;18(9):509–17.

    Article  MATH  Google Scholar 

  3. Blanken HM, Ijbema A, Meek P, van den Akker B. The generalized grid file: description and performance aspects. In: Proceedings of the 14th International Conference on Data Engineering; 1990, p. 380–88.

    Google Scholar 

  4. Freeston M. The BANG file: a new kind of grid file. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 1987, p. 260–69.

    Google Scholar 

  5. Hutflesz A, Six H -W, and Widmayer P. Twin grid files: space optimizing access schemes. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 1988, p. 183–90.

    Article  Google Scholar 

  6. Kim J -D, Hong B -H. Parallel spatial join algorithms using grid files. In: Proceedings of the 6th International Conference on Database Systems for Advanced Applications; 1999, p. 226–34.

    Google Scholar 

  7. Li J, Rotem D, Srivastava J. Algorithms for loading parallel grid files. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 1993, p. 347–56.

    Article  Google Scholar 

  8. Lim Y, Kim M. A Bitmap Index for multidimensional data cubes. In: Proceedings of the 15th International Conference on Database and Expert System Applied; 2004, p. 349–58.

    Google Scholar 

  9. Luo C, Hou WC, Wang CF, Wang H, Yu X. Grid file for efficient data cube storage. Computers and their applications, conference paper CATA, 2006, p. 424–29.

    Google Scholar 

  10. Nievergelt J, Hinterberger H, Sevcik KK. The grid file: an adaptable, symmetric multikey file structure. ACM Trans Database Syst. 1984;9(1):38–71.

    Article  Google Scholar 

  11. Schikuta E, Erhart M. The BANG-clustering system: grid-based data analysis. In: Proceedings of the 2nd International Symposium on Advances in Intelligent Data Analysis; 1997, p. 513–24.

    Chapter  Google Scholar 

  12. Whang K -Y, Krishnamurthy R. The multilevel grid file – a dynamic hierarchical multidimensional file structure. In: Proceedings of the 2nd International Conference on Database Systems for Advanced Applications; 1991, p. 449–59.

    Google Scholar 

  13. Zhou Y, Shekhar S, Coyle M. Disk allocation methods for parallelizing grid files. In: Proceedings of 10th International Conference on Data Engineering; 1994, p. 243–52.

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Aristotle University of Thessaloniki, Thessaloniki, Greece

    Apostolos N. Papadopoulos & Yannis Manolopoulos

  2. University of Piraeus, Piraeus, Greece

    Yannis Theodoridis

  3. University of California-Riverside, Riverside, CA, USA

    Vassilis J. Tsotras

Authors
  1. Apostolos N. Papadopoulos
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Yannis Manolopoulos
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Yannis Theodoridis
    View author publications

    You can also search for this author in PubMed Google Scholar

  4. Vassilis J. Tsotras
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Apostolos N. Papadopoulos .

Editor information

Editors and Affiliations

  1. Georgia Institute of Technology College of Computing, Atlanta, GA, USA

    Ling Liu

  2. University of Waterloo School of Computer Science, Waterloo, ON, Canada

    M. Tamer Özsu

Section Editor information

  1. Dept. of Computer Science and Eng., Hong Kong Univ. of Science and Technology, Kowloon, Hong Kong, Hong Kong SAR

    Dimitris Papadias

Rights and permissions

Reprints and permissions

Copyright information

© 2018 Springer Science+Business Media, LLC, part of Springer Nature

About this entry

Check for updates. Verify currency and authenticity via CrossMark

Cite this entry

Papadopoulos, A.N., Manolopoulos, Y., Theodoridis, Y., Tsotras, V.J. (2018). Grid File (and Family). In: Liu, L., Özsu, M.T. (eds) Encyclopedia of Database Systems. Springer, New York, NY. https://doi.org/10.1007/978-1-4614-8265-9_187

Download citation

Publish with us

Policies and ethics

Search

Navigation