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
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
Method used
Image
Examples
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...
PUM
Abstract
Description
Claims
Application Information
- R&D Engineer
- R&D Manager
- IP Professional
- Industry Leading Data Capabilities
- Powerful AI technology
- Patent DNA Extraction
Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.
© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com