Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Method and system for importing database and medium

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

Problems solved by technology

[0003] The present invention mainly solves the time taken by separate index creation and statistical information collection in the existing logic import process, and the time-wasting problems affecting the import speed

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
  • Method and system for importing database and medium
  • Method and system for importing database and medium
  • Method and system for importing database and medium

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

No 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
no application Login to View More
IPC IPC(8): G06F16/25G06F11/30G06F9/52
CPCG06F9/52G06F11/3051G06F16/25
Inventor 马国良
Owner SUZHOU LANGCHAO INTELLIGENT TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

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