The application relates to the index technology field of
database structure, and particularly discloses an integrated
index method for a geothermal
system three-dimensional numerical
simulation database, which comprises the following steps: reading geothermal
system three-dimensional numerical
simulation data and analyzing data fields, the data covering two data structures of scattered
point data and body element data, sequentially performing attribute coding, space coding and time coding, and generating a unique identification suffix, splicing the unique identification suffix into a
single row key in a fixed order, enabling the
single row key to bear the multidimensional constraints of attributes, space and time, and completing the construction and writing of unified indexing; receiving a query request, performing range scanning in the unified index table, obtaining an index row key set, and then performing table query to obtain complete
business data, and performing secondary precision screening to output results; the application considers the coding of category attributes, scalar attributes and vector attributes, converts multidimensional query into prefix matching and range scanning, and solves the problems of index dimension isolation, low query efficiency and memory overflow in the prior art.