中文网站
  Advanced Search
Read the latest Blogs from IT professionals in the field. Read and write community created documents. Need IT help? Ask our staff. Connect with your peers. Check our Tech Shop for posters, books and software tools. Home

11.9.1 Database Systems: Grid File

1. A grid structure for queries on two search keys is a 2-dimensional grid, or array, indexed by values for the search keys. Figure 11.10 (textbook 11.31) shows part of a grid structure for the deposit file.

2. A particular entry in the array contains pointers to all records with the speci ed search key values.

  • No special computations need to be done
  • Only the right records are accessed
  • Can also be used for single search key queries (one column or row)
  • Easy to extend to queries on n search keys { construct an n-dimensional array.
  • Significant improvement in processing time for multiple-key queries.
  • Imposes space overhead.
  • Performance overhead on insertion and deletion.

Database System Structure: