A data export method and device

A data export and database technology, applied in database update, digital data processing, structured data retrieval, etc., can solve the problems of slow export speed, waste of human resources, complicated operation and maintenance work, etc., and achieve the effect of fast export speed

Active Publication Date: 2018-12-18
BEIJING JINGDONG SHANGKE INFORMATION TECH CO LTD +1
View PDF7 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Therefore, for different export data requirements, the export data script must be rewritten each time, which is less flexible, and the operation and maintenance work will become very complicated and consume a lot of human resources
And when the amount of data is large, it takes a long time to export the data through the scrolling display method of the spool log file screen, the export speed is slow, and the time cost is uncontrollable

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 export method and device
  • A data export method and device
  • A data export method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0037] figure 1 It is a flow chart of a data export method provided by Embodiment 1 of the present invention. This embodiment is applicable to export tasks in different data formats. For export tasks in different data formats, there is no need to rewrite the program, only need to load the corresponding configuration information The data export can be done automatically. The embodiment of the present invention can be executed by a data exporting device, which can be realized by means of hardware and / or software, and can generally be integrated into a database server. Such as figure 1 As shown, the method includes the following steps:

[0038] Step 110, receiving the user's export data request task, and setting configuration information according to the export data request task;

[0039] In the process of using the database, it is inevitable that there will be a need to export the data in the data table, especially some companies need to frequently extract some business data ...

Embodiment 2

[0049] figure 2 It is a flow chart of a data export method provided by Embodiment 2 of the present invention. This embodiment is an optimization based on the above embodiments. Specifically, the method includes the following steps:

[0050] Step 210: Receive a data export request task from a user, and set configuration information according to the data export request task.

[0051] Step 220, according to the configuration information, determine whether the exported data format is an insert statement format.

[0052] When the exported data format is the insert statement format, execute steps 230, 250, and 260 in sequence; otherwise, execute steps 240, 250, and 260 in sequence.

[0053] Step 230, generating database executable insert statement information.

[0054] Step 240, generating database executable comma-separated value statement information.

[0055] Comma-Separated Values ​​(CSV), which stores tabular data in plain text, is widely used to transfer tabular data between...

Embodiment 3

[0060] image 3 It is a flow chart of a data export method provided by Embodiment 3 of the present invention. This embodiment is an optimization based on the above embodiments. Specifically, the method includes the following steps:

[0061] Step 310: Receive a data export request task from the user, and set configuration information according to the data export request task.

[0062] Step 320: Obtain the physical space occupied by the exported data table according to the configuration information, and determine whether to enable the parallel export mode according to the physical space occupied by the exported data table.

[0063] This step may read the physical space occupied by the exported data table from the data dictionary of the database according to the configuration information, and judge whether to enable the parallel export mode according to the physical space occupied by the exported data table. Specifically, a threshold can be set, and when the physical space occup...

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 and a data exporting device. The data exporting method comprises the following steps of receiving a data exporting request task of a user, and setting configuration information according to the data exporting request task; determining an exported data format according to the configuration information, and generating database executable statement information according to the exported data format; reading data to be exported according to the database executable statement information, and converting the data to be exported into exported data in a corresponding format; writing the exported data into a text file. According to the method and the device, exported data in different formats is automatically exported, the exporting speed is increased, and the operation and maintenance cost is reduced.

Description

technical field [0001] The embodiments of the present invention relate to the technical field of data export, and in particular, to a data export method and device. Background technique [0002] In the daily operation and maintenance of the database, it is often encountered to export data to a text file. The more commonly used data format is CSV (Comma-Separated Values, comma-separated value) format. Sometimes it is necessary to export and insert the INSERT statement format. Although the format is different, the processing method is basic. The same, at present, the spool log file is basically used to export the results. Usually, the operation and maintenance DBA (Database administrator, database administrator) writes the corresponding export data script according to the user's export data request, and then runs the export data script to generate the log file. The screen scrolls, and after scrolling and displaying all the exported data, it is packaged and sent to the user. T...

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
Patent Type & Authority Patents(China)
IPC IPC(8): G06F17/30
CPCG06F16/23
Inventor 李亮光
Owner BEIJING JINGDONG SHANGKE 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