Query optimization-oriented lateral expansion method of distributed geological borehole database

Abstract

Abstract In order to reduce the resource occupancy and retrieval efficiency of geological drilling databases, this study proposes a distributed horizontal expansion method for query optimization of geological drilling databases by constructing a comprehensive geological data subtree, analyzing the characteristics of distributed databases and elements in geological databases, and quickly retrieving data resources based on element attributes. In addition, this study has designed a method to horizontally extend the database designed for drilling holes using a multi-constraint model in order to achieve extension optimization of the distributed geological drilling database. Experiments are conducted to verify the performance and applicability of the proposed method. The experiment shows that when the geological data capacity is 80 GB, the capacity level of the geological database can be extended to 41 × 105TB using the method proposed in this study. The retrieval efficiency is higher than 89% and the resource occupancy rate is lower than 12% after the horizontal expansion of the database. By using this research method, the horizontal expansion of the geological drilling database is more effective, and can effectively reduce the resource occupancy rate and retrieval efficiency of the geological drilling databases. This has value significance for geological drilling with efficiency improvement and development.