Method and device for quickly loading data in database, equipment and medium
A data loading and database technology, applied in the database field, can solve the problems of increasing the data loading and warehousing time, the impact of large-scale data loading efficiency is very large, and the efficiency impact is very large, and the effect of avoiding inefficient search
Active Publication Date: 2020-06-12
INSPUR SUZHOU INTELLIGENT TECH CO LTD
View PDF3 Cites 2 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
It has a great impact on the efficiency of large batch data loading
At the same time, when data is inserted, it is necessary to insert corresponding data into the redo log at the same time, and the index also needs to be maintained, which also increases the time for data loading and storage, which has a great impact on the efficiency of large-scale data loading.
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
[0020] In order to make the object, technical solution and advantages of the present invention clearer, the embodiments of the present invention will be further described in detail below in conjunction with specific embodiments and with reference to the accompanying drawings.
[0021] It should be noted that all expressions using "first" and "second" in the embodiments of the present invention are used to distinguish two entities with the same name but different parameters or different parameters. It can be seen that "first" and "second" " is only for the convenience of expression, and should not be understood as a limitation to the embodiments of the present invention, and will not be described one by one in the subsequent embodiments.
[0022] Based on the above purpose, the first aspect of the embodiments of the present invention proposes an embodiment of a method for quickly loading data into a database. figure 1 Shown is a schematic diagram of an embodiment of the method ...
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 quickly loading data in a database. The method comprises the following steps: dividing a data block into an idle data block, a partially written data block and a fully written data block according to the use condition of the data block; writing the free data blocks and the initial addresses of the free spaces partially written into the data blocks into a staterecording table respectively; in response to the condition that the idle data block exists in the state record table after data loading is started, reading an initial address of the idle data block and writing the data into an idle space corresponding to the initial address; and in response to the situation that no idle data block exists in the state record table but a part of write-in data blocksexist after data loading is started, reading an initial address of the part of write-in data blocks, writing the data into an idle space corresponding to the initial address, and correspondingly changing the use condition of the data blocks in the state record table after data loading is completed. The invention further discloses a device, equipment and a medium. According to the invention, rapidloading and storage of the database are realized, and the data storage time is reduced.
Description
technical field [0001] The present invention relates to the technical field of databases, more specifically, to a method, device, device and medium for fast loading data in a database. Background technique [0002] At this stage, when the database loads data, it needs to scan sequentially from the initial position where the data is stored in the data table, and then start inserting data when the scan reaches the free position of the data block. The same is true for the insertion of the second piece of data. It is necessary to repeatedly scan the free positions in the data table, so looking for free positions takes up a lot of time for data loading and storage. It has a great impact on the efficiency of large batch data loading. At the same time, when data is inserted, the corresponding data needs to be inserted into the redo log at the same time, and the index also needs to be maintained, which also increases the time for data loading and storage, which has a great impact o...
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 Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/25
CPCG06F16/25
Inventor 魏本帅杜彦魁
Owner INSPUR SUZHOU INTELLIGENT TECH CO LTD