Database data exporting method and device, computer equipment and storage medium

A data export and database technology, applied in relational databases, database models, database management systems, etc., can solve the problem of low export efficiency of structured query language statements, and achieve the effect of improving export efficiency

Pending Publication Date: 2021-01-01
CHINA CONSTRUCTION BANK
View PDF0 Cites 5 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] When using the tools that come with the Oracle database to export data, complex configurations and operations are required to convert Structured Query Language (SQL) statements, and the export efficiency of Structured Query Language statements is low

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
  • Database data exporting method and device, computer equipment and storage medium
  • Database data exporting method and device, computer equipment and storage medium
  • Database data exporting method and device, computer equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0030] figure 1 It is a flow chart of the database data export method provided by Embodiment 1 of the present invention. This embodiment is applicable to the situation where the data in the Oracle database is exported as an SQL statement, and the method can be executed by a computer device for data migration. Specifically include the following steps:

[0031] Step 110, connect to the target database.

[0032] The target database is a database storing target data, and the target database is an Oracle database. This application is used to export the target data in the target database.

[0033] In one implementation manner, step 110 may be implemented in the following manner: receiving the database address input by the user, the target data form identifier and the identity identifier; and connecting to the target database according to the database address.

[0034] When a data export requirement occurs, provide the user with an interface for inputting the database address, and...

Embodiment 2

[0080] figure 2 The structural diagram of the database data exporting device provided for the second embodiment of the present application, when the device exports the data in the Oracle database as SQL statements, the device can be applied to computer equipment for data migration, including: connection module 210, element A group writing module 220 , a query statement generating module 230 and a target file writing module 240 .

[0081] A connection module 210, configured to connect to the target database;

[0082] Tuple writes module 220, is used for writing the target data in target database into python tuple;

[0083] Query statement generation module 230, for generating structured query language statement according to python tuple;

[0084] The target file writing module 240 is configured to create a target file according to a preset file format, and write structured query language statements into the target file.

[0085] On the basis of the above embodiments, the co...

Embodiment 3

[0113] Figure 4 A schematic structural diagram of a computer device provided in Embodiment 3 of the present invention, such as Figure 4 As shown, the computer equipment includes a processor 30, a memory 31, an input device 32 and an output device 33; the number of processors 30 in the computer equipment can be one or more, Figure 4 Take a processor 30 as an example; the processor 30, memory 31, input device 32 and output device 33 in the computer equipment can be connected by bus or other methods, Figure 4 Take connection via bus as an example.

[0114] Memory 31, as a computer-readable storage medium, can be used to store software programs, computer-executable programs and modules, such as program instructions / modules corresponding to the database data export method in the embodiment of the present invention (for example, connection module 210, tuple writing module 220, query statement generating module 230 and target file writing module 240). The processor 30 executes...

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 database data exporting method and device, computer equipment and a storage medium. The method comprises the steps of connecting to a target database; writing the target datain the target database into the boa tuple; generating a structured query language statement according to the boa tuples; and creating a target file according to a preset file format, and writing thestructured query language statement into the target file. According to the database data exporting scheme provided by the embodiment of the invention, after the target database is connected, the python tuples are used for storing the target data in the target database, then the structured query language statements are generated according to the data stored in the python tuples, and the structuredquery language statements are written into the created target file, so that the data exporting efficiency is improved. In the exporting process of the structured query language statement, the boa tuples serve as an intermediate medium, the target data in the database is automatically exported as the structured query language statement, and the exporting efficiency of the structured query languagestatement is improved.

Description

technical field [0001] Embodiments of the present invention relate to database data processing technology, and in particular to a database data export method, device, computer equipment and storage medium. Background technique [0002] In the software development process in the financial field, in order to meet the needs of agile development and iterative deployment, it is necessary to publish the data of the tables in the Oracle database in one development and test environment to another development and test environment. [0003] When using the tools that come with the Oracle database to export data, complex configurations and operations are required to convert Structured Query Language (SQL) statements, and the export efficiency of Structured Query Language statements is low. Contents of the invention [0004] The invention provides a database data export method, device, computer equipment and storage medium, so as to improve the export efficiency of SQL statements of an...

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 Applications(China)
IPC IPC(8): G06F16/25G06F16/28G06F16/242
CPCG06F16/2445G06F16/258G06F16/284
Inventor 彭建恩
Owner CHINA CONSTRUCTION BANK
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