Method for saving and loading internal memory data base tables
A database and memory table technology, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve problems such as insufficient disk capacity, and achieve the effect of saving disk space and speeding up
Inactive Publication Date: 2008-07-16
OPEN INVENTION NEWTORK LLC
View PDF0 Cites 6 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
[0004] The invention provides a method for realizing storage and loading of memory database table to solve the problem of insufficient disk capacity
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
[0037] The invention proposes a method for sub-table storage according to the actual data of the table: when saving, only the table with records is stored, and the storage process is performed according to the actual data. Compress the table data content during the save process. In order to solve the problem of high CPU usage when compressing and decompressing a large amount of data, it is determined that the data volume of the table is divided into blocks according to a certain size, and a delay is performed after each block of data is processed to reduce CPU usage. occupancy, and then write the compressed data to disk block by block. The effect of this processing is to save disk space, increase the speed of saving the table, and reduce the CPU usage.
[0038] The technical solution of the present invention will be described in detail below in conjunction with the accompanying drawings and specific embodiments.
[0039] The implementation of this solution includes data stor...
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 realizing saving to disk of memory database tables which comprises that: 1) when a memory database table is saved to disk, the memory table data with a record is loaded to a memory buffer area; 2) a table saving file is created and table registration information is written in; 3) the checksum of the data of the memory table is calculated; 4) the data of the memory table is made a blocking compression, and the compression result and the checksum are written into the corresponding table saving file. The invention also discloses a memory database table loading method for realizing the saving of the method, which comprises that: a) the data of a registration structure of the memory table is read; b) the compressed memory table data of an appointed table is read to the memory buffer area in a blocking mode, and is decompressed; c) after the entire blocking data is decompressed, the data in the memory buffer area is loaded into the memory table. The proposal of the invention can save according to the content of the actual table data of the memory table, makes a blocking compression processing during the saving, saves the space of the magnetic disk, and quickens the speed of the saving.
Description
technical field [0001] The invention relates to a database in the field of mobile communication, in particular to a method for realizing disk storage and loading of an internal memory database table. Background technique [0002] In mobile communication technology applications, multiple memory tables need to be created to store data configuration information required by business applications. In order to save the configuration data, the configuration data needs to be saved to disk. When needed by other boards or systems, it can be loaded from disk without reconfiguration. With the expansion of business application functions, the amount of data required by database applications has increased dramatically, which is reflected in two aspects: one is the number of tables is increasing, and the other is the expansion of table capacity, which consumes more and more memory and external storage space . [0003] The storage mechanism of the original database uses a non-compression ...
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): G06F17/30
Inventor 杨绍明葛聪马龙
Owner OPEN INVENTION NEWTORK LLC