The invention discloses a
hybrid index structure with storage
perception, and belongs to the technical field of
database query. The
hybrid index structure is divided into a tree index structure from top to bottom, including three parts of a top layer in a primary storage, an interlayer in internal storage, and a bottom layer in an
external storage. The top layer, the interlayer, and the bottom layer are stored in the internal storage when the internal storage is sufficient. Partial or all interlayer is stored in the
external storage when the internal storage is insufficient. The invention also discloses a creation method, a reading method, a range query method, and a
reconstruction method of the
hybrid index structure. Through
memory map, when the internal storage is insufficient, part index data is stored in the
external storage, so as to effectively use the internal storage and the external storage and other storage resources. The internal and external storage occupation ratio of the hybrid index structure can be rationally decided according to
system conditions or user efficiency requirements, so as to improve query efficiency.