A database query method and device

Abstract

The invention discloses a database searching method and device. The database searching method and device are used for solving the technical problems that according to an existing database searching method, after the number of relational database single table data is larger than tens of millions of records, due to the limit of the system IO throughput and the influence of the original association and sorting relationship between database lists, a large number of multifarious read and write operations can be generated commonly among hardware for processing a searching instruction, and the differences among hardware utilization rates are too large, so that a lower balance among hardware is low, and the overall database searching speed is greatly affected. The database searching method comprises the steps ofreceiving a parallel service search command which is sent from a first interface determined by a first server according to a search command; performing searching through corresponding subprocesses according to the parallel service search command and combining a corresponding preset partition view, returning search result through the subprocesses, and establishing the preset partition view through the data of the database with the combination ofa target index field.

Description

[0001] This application claims the priority of the Chinese patent application with the application number 201610961824.4 and the title of the invention "a database query method and device" submitted to the China Patent Office on November 04, 2016, the entire contents of which are incorporated by reference in this application . technical field [0002] The invention relates to the technical field of data processing, in particular to a database query method and device. Background technique [0003] Traditional relational databases are often implemented based on Structured Query Language (Structured Query Language, hereinafter referred to as: SQL) statements. For each query, the business system can transmit the SQL statement and query parameters to the database server, for example, the SQL statement and query parameters can be sent by invoking the database client deployed on the business system. The database server parses the SQL statement, uses the CPU to load data from the d...

AI Technical Summary

Problems solved by technology

[0005] A database query method and device provided by the embodiments of the present invention solves the problem that the existing database query method is limited by the IO throughput of the system and the existing problems between database tables after the data in a single table of a relational database exceeds tens of millions of records. Affected by association and sorting relationships, a large number of complicated read and write operations are usually generated between hardware processing query instructions, which makes the utilization rate of hardware very different, resulting in low balance between hardware and greatly affecting the overall query speed of the database.

Images