A data query method

Abstract

The invention discloses a data inquiring method. The method includes the steps that a client sends a data inquiring command to a database application server; the database application server optimizes the data inquiring command, and when the data inquiring command includes preset complex operation keywords, the query field range of the optimized data inquiring command includes fields, corresponding to the complex operation keywords, in the data inquiring command; the database application server sends the optimized data inquiring command to a distributed data server storing corresponding data, and the distributed data server sends the data corresponding to the query field range in the optimized data inquiring command and stored in the distributed data server to the database application server; the database application server inquires and processes the data from the distributed data server according to the data inquiring command before optimization, and feeds back an inquiring and processing result to the client. By means of the method, complex database inquiring can be achieved.

Description

technical field [0001] The invention relates to database technology, in particular to a data query method. Background technique [0002] At present, with the wide application of database technology, the scale of data and the amount of visits are increasing day by day, and the traditional centralized database can no longer meet the application needs of such large-scale data. To solve this problem, a distributed database system is currently introduced. By sharding the data, each data fragment is distributed to multiple data servers for storage and management, so as to realize the distributed storage of large-scale data. [0003] At present, in distributed database systems, the method of horizontal sharding is often used for data sharding. In this way, certain business fields will be selected as the split key, and all tuples of the global relationship will be divided into several different groups according to the split key. Intersecting subsets, each of which is a fragment of ...

AI Technical Summary

Problems solved by technology

[0004] The data query scheme in the above distributed system does not support complex SQL query commands, for example, query commands including data grouping (GROUP), sorting (ORDER) and other operations

Because the data sent by each relevant data server in the above query scheme is only the field corresponding to the select command, which is often inconsistent with the business field on which operations such as GROUP and ORDER are based. In this way, the data obtained by the client is only selected The command corresponds to the data in the field, so the received data cannot be grouped (GROUP), sorted (ORDER), etc.

[0005] It can be seen that the data query method of the existing distributed system cannot meet the complex query operation requirements of the client

Images