Method and system for importing database and medium
What is Al technical title?
Al technical title is built by PatSnap Al team. It summarizes the technical point description of the patent document.
A data import and database technology, applied in the field of database import, can solve the problems of affecting import speed and wasting time
Inactive Publication Date: 2021-05-07
SUZHOU LANGCHAO INTELLIGENT TECH CO LTD
View PDF0 Cites 0 Cited by
Summary
Abstract
Description
Claims
Application Information
AI Technical Summary
This helps you quickly interpret patents by identifying the three key elements:
Problems solved by technology
Method used
Benefits of technology
Problems solved by technology
[0003] The present invention mainly solves the time taken by separate index creation and statistical informat
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
Click on the blue label to locate the original text in one second.
Reading with bidirectional positioning of images and text.
Smart Image
Examples
Experimental program
Comparison scheme
Effect test
Embodiment 1
[0061] The embodiment of the present invention provides a database import method, please refer to figure 1 , including the following steps:
[0062] S100, at present, the logic import of ORACLE database cannot control the stop of writing REDO and UNDO. Normal logic import will write REDO and UNDO data. REDO and UNDO, and then receive the REDO and UNDO of the master node at the standby node for data reconstruction;
[0063] The function of writing REDO and UNDO is to facilitate database rollback and data redo after database downtime. Data migration through logical export and import is new data for the target database. If it can be guaranteed that the imported data does not need to be returned Roll and the database will not experience abnormal conditions such as downtime during the import process, so there is actually no need to write REDO and UNDO data;
[0064] When there is no database configured with the DataGuard scheme, there is no problem when not recording and writing ...
Embodiment 2
[0077] The embodiment of the present invention also provides a database import system, please refer to Figure 4 , including: parameter control module, logic import processing module, thread module and execution module;
[0078] The parameter control module is used to add parameters in the imported data and set the fields of the parameters;
[0079] The logical import processing module is used to perform import data operations according to the fields of the parameters;
[0080] The thread module is used to set the degree of parallelism, and start multi-threading according to the degree of parallelism;
[0081] The execution module is used to import table data and create indexes and collect statistics according to multithreading.
[0082] The logical import processing module includes a first import operation module and a second import operation module;
[0083] The first import operation module is used to execute the imdpd command to read the DMP file; the data after the DMP...
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 a method for importing a database. The method comprises the following steps of: adding parameters in to-be-imported data and setting fields of the parameters; and executing database import operation, wherein the database import operation comprises a logic import operation and a data import operation, the import logic operation is that if the field of the parameter is 'No', a first import logic operation is executed, and if the field of the parameter is 'YES', a second import logic operation is executed, and the data importing operation comprises the steps of setting a parallelism degree, creating multiple threads according to the parallelism degree, importing data of the table through the multiple threads, creating an index of the table and collecting statistical information of the table. By means of the mode, the data importing speed can be increased by controlling the importing process not to write REDO and UNDO data, a large amount of importing time is saved, the data migration efficiency can be improved by adding parallel and thread synchronous execution importing table data and creating indexes and statistical information during importing, and the shutdown duration of a service system is shortened.
Description
technical field [0001] The invention relates to the field of database import, in particular to a database import method, system and medium. Background technique [0002] The existing logic import is processed serially in the following order: import metadata, import table data, create indexes, import statistical information, and a large amount of REDO and UNDO data will be generated during the import process. Since the above sequence is executed serially, even if some data has been imported into the table, the index creation and statistical information collection on the table must be concentrated in the later stage of the entire import process. In addition, due to the large amount of REDO and UNDO data generated, the UNDO data will be Writing to the UNDO tablespace will occupy I / O (Input / Output) on the one hand, and on the other hand, if the UNDO tablespace is set relatively small, it will seriously affect the import speed, and the generated REDO data will be written into the...
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
Application Date:The date an application was filed.
Publication Date:The date a patent or application was officially published.
First Publication Date:The earliest publication date of a patent with the same application number.
Issue Date:Publication date of the patent grant document.
PCT Entry Date:The Entry date of PCT National Phase.
Estimated Expiry Date:The statutory expiry date of a patent right according to the Patent Law, and it is the longest term of protection that the patent right can achieve without the termination of the patent right due to other reasons(Term extension factor has been taken into account ).
Invalid Date:Actual expiry date is based on effective date or publication date of legal transaction data of invalid patent.