Grid File (and Family)
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.
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...
- 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
- 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
- 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
- 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
- 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