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

A data export and distributed technology, applied in the database field, can solve the problems of too many computer resources, unfavorable cost control, and reduced user experience.

Active Publication Date: 2019-02-01
HANGZHOU ANHENG INFORMATION TECH CO LTD
View PDF9 Cites 8 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

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 a

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • A data exporting method and device of a distributed large single table
  • A data exporting method and device of a distributed large single table
  • A data exporting method and device of a distributed large single table

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0042] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

[0043] The embodiment of the invention discloses a data export method, device, equipment and readable storage medium of a distributed large single table, so as to improve the data export efficiency of the large single table.

[0044] see figure 1 , a method for exporting data of a distributed large single table provided by an embodiment of the present invention, comprising:

[0045] S101. Receive a request for exporting data sent by the client;

[0046] S102...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

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...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
IPC IPC(8): G06F16/2458G06F16/25
Inventor 赖双波范渊
Owner HANGZHOU ANHENG INFORMATION TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap