Encyclopedia of Database Systems

2018 Edition
| Editors: Ling Liu, M. Tamer Özsu

Grid File (and Family)

  • Apostolos N. Papadopoulos
  • Yannis Manolopoulos
  • Yannis Theodoridis
  • Vassilis J. Tsotras
Reference work entry
DOI: https://doi.org/10.1007/978-1-4614-8265-9_187

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 to check access.

Recommended Reading

  1. 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. 2.
    Bentley JL. Multidimensional binary search trees used for associative searching. Commun ACM. 1975;18(9):509–17.zbMATHCrossRefGoogle Scholar
  3. 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. 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. 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.CrossRefGoogle Scholar
  6. 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. 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.CrossRefGoogle Scholar
  8. 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. 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. 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.CrossRefGoogle Scholar
  11. 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.CrossRefGoogle Scholar
  12. 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. 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

Copyright information

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

Authors and Affiliations

  • Apostolos N. Papadopoulos
    • 1
  • Yannis Manolopoulos
    • 1
  • Yannis Theodoridis
    • 2
  • Vassilis J. Tsotras
    • 3
  1. 1.Aristotle University of ThessalonikiThessalonikiGreece
  2. 2.University of PiraeusPiraeusGreece
  3. 3.University of California-RiversideRiversideUSA

Section editors and affiliations

  • Dimitris Papadias
    • 1
  1. 1.Dept. of Computer Science and Eng.Hong Kong Univ. of Science and TechnologyKowloonHong Kong SAR