Methods and devices for importing/exporting database data
A technology of data import and data export, applied in electrical digital data processing, special data processing applications, instruments, etc., can solve the problems of large development workload for R&D personnel, difficulty in adapting to changes in user needs, etc., to achieve mutual data import/export , The effect of improving development efficiency and reducing workload
Inactive Publication Date: 2012-05-16
PEKING UNIV +2
View PDF1 Cites 14 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
[0004] The present invention is proposed in view of the problem that the development method of database data import / export in the related art has a large development workload for R&D personnel and it is difficult to adapt to changes in user needs. Therefore, the main purpose of the present invention is to provide a database data import / export method. Method and device to solve the above problems
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 moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment Construction
[0032] It should be noted that, in the case of no conflict, the embodiments in the present application and the features in the embodiments can be combined with each other. The present invention will be described in detail below with reference to the accompanying drawings and examples.
[0033] According to an embodiment of the present invention, a device for importing database data is provided.
[0034] figure 1 It is a schematic diagram of a device for importing database data according to an embodiment of the present invention. Such as figure 1 As shown, the device for importing data into the database includes: an acquisition module 11 configured to obtain a list of query configuration items in a query configuration file, the list of query configuration items includes one or more query configuration items; a processing module 13 configured to perform query configuration The query statement in the item, and generate an import statement matching the query statement; the data...
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
Login to View More Abstract
The invention discloses methods and devices for importing / exporting database data, wherein the method for importing the database data comprises the following steps of: obtaining an inquiry configuration item list in an inquiry configuration file, wherein the inquiry configuration item list comprises one or more inquiry configuration items; and each inquiry configuration item comprises the title of a data file for storing the imported data and an inquiry sentence; executing the inquiry sentence in each inquiry configuration item and generating an importing sentence matched with the inquiry sentence; and importing the data file into a database according to the importing sentence; and the method for exporting the database data comprises the following steps of: obtaining the inquiry configuration item list in the inquiry configuration file, and executing the inquiry sentences in the inquiry configuration items in the inquiry configuration item list, thereby obtaining the exported data file. With the methods and the devices provided in the invention, the work load of the research personnel can be reduced and the importing / exporting requirements of the database data can be quickly realized; therefore, the integrated development efficiency of software is improved; and mutual importing and exporting of data between heterogeneous databases is realized.
Description
technical field [0001] The invention relates to a database data import / export method and device. Background technique [0002] Database technology is the foundation and core of modern computer information systems and computer application systems, and is an important part of information systems. When developing a database application system, it is usually necessary to export database data for system backup or data sharing and exchange with other systems. Commonly used database management systems provide backup and recovery tools, such as Oracle provides import (Imp) and export (Exp) utilities, but these tools have a coarse control granularity for exporting data, which is difficult to meet the individual needs of users; the database management system itself The tools provided are difficult to import and export between heterogeneous database systems. For example, the data exported by the tools provided by Oracle is difficult to import into the DB2 database; in addition, these ...
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
Login to View More IPC IPC(8): G06F17/30
Inventor 乐以长葛庆生封素石张百春熊国强
Owner PEKING UNIV