A data exporting method and device of a distributed large single table

Abstract

The invention discloses a data exporting method of a distributed large single table, which comprises the following steps: receiving a request for exporting data sent by a client; Searching the distributed database through sphinx, and obtaining the server identification and data partition ID satisfying the request; obtaining a target data strip corresponding to the request according to the server identification and the data partition ID; Write the target data bar to the target document and export to the client. The method firstly queries the server and the data partition satisfying the request,and then obtains the target data strip directly according to the server identification and the data partition ID, thereby improving the data query efficiency and the data export efficiency of the distributed large single table. At the same time, it can reduce the consumption of computer resources and improve the user experience. Accordingly, the data exporting device, the device and the readablestorage medium of the distributed large single table disclosed by the invention also have the technical effects mentioned above.

Description

technical field [0001] The present invention relates to the technical field of databases, and more specifically, to a data export method, device, equipment and readable storage medium of a distributed large single table. Background technique [0002] With the advent of the era of big data, high availability of databases has become increasingly important. Relational database technology has become a core technology in information systems. Due to the poor readability of the database, if you use database tools to query the database, security and authority issues may be involved, so the data in the database can be exported for easy query. [0003] At present, multi-threading is generally used to query a single table of the database, and then multi-threading is used to query the table again to obtain and export data in the database. However, this method is only applicable to the case where there is less data in a single table in the database. When there is a lot of data in a sin...

AI Technical Summary

Problems solved by technology

However, this method is only applicable to the case where there is less data in a single table in the database. When there is a lot of data in a single table in the database, that is, when a large single table needs to be exported, the efficiency of using database tools is relatively slow and consumes There are many computer resources, which is not conducive to cost control and also reduces the user experience; among them, a large single table refers to a single table with millions of data entries or more in a single table, and a distributed large single table refers to a distributed Large single table in database

Images