A method, device, device and medium for quickly loading data in a database
A data loading and database technology, applied in the database field, can solve the problems of increasing data loading and storage time, greatly affecting efficiency, and greatly affecting the efficiency of large-scale data loading, so as to avoid inefficient search
Active Publication Date: 2022-07-08
INSPUR SUZHOU INTELLIGENT TECH CO LTD
View PDF3 Cites 0 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 objectives, technical solutions and advantages of the present invention more clearly understood, the embodiments of the present invention will be further described in detail below with reference to the specific embodiments and the accompanying drawings.
[0021] It should be noted that all expressions using "first" and "second" in the embodiments of the present invention are for the purpose of distinguishing two entities with the same name but not the same or non-identical parameters. It can be seen that "first" and "second" " is only for the convenience of expression, and should not be construed as a limitation on the embodiments of the present invention, and subsequent embodiments will not describe them one by one.
[0022] Based on the above purpose, in a first aspect of the embodiments of the present invention, an embodiment of a method for quickly loading data from a database is provided. figure 1 Shown is a schematic diagram of an embodiment o...
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 rapidly loading data in a database, comprising: dividing data blocks into free data blocks, partially written data blocks and fully written data blocks according to the usage of the data blocks; The starting address of the free space in the data block is written into the state record table respectively; in response to the query that there is a free data block in the state record table after the data loading starts, the starting address of the free data block is read and the data is written to The free space corresponding to the starting address; in response to the query that there is no free data block in the status record table after the start of data loading, but there are some written data blocks, read the starting address of the partially written data block and write the data to The free space corresponding to the starting address, and the usage of the data blocks in the state record table will be changed accordingly after the data loading is completed. The invention also discloses a device, equipment and medium. The invention realizes the fast loading and storage of the database, and reduces the data storage time.
Description
technical field [0001] The present invention relates to the technical field of databases, and more particularly, to a method, apparatus, device and medium for rapidly 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 only start inserting data when the data block is free. It is necessary to repeatedly scan the free positions in the data table, so finding the free positions takes up a lot of time for data loading and storage. It has a great impact on the efficiency when loading large batches of data. At the same time, when data is inserted, corresponding data needs to be inserted into the redo log at the same time, and the index also needs to be maintained. SUMMARY OF THE INVENTION [0003] In view of this, the purpose of the embodiments of the present invention is to provide a method, apparatus, device, and medium for...
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 Patents(China)
IPC IPC(8): G06F16/25
CPCG06F16/25
Inventor 魏本帅杜彦魁
Owner INSPUR SUZHOU INTELLIGENT TECH CO LTD