Data storage method and device
A data storage and data technology, applied in the direction of database update, structured data retrieval, database distribution/replication, etc., can solve the problems of large number of database accesses and high pressure of database access, so as to reduce the number of accesses, be easy to implement, and reduce the number of accesses. effect of stress
Inactive Publication Date: 2020-08-07
POTEVIO INFORMATION TECH CO LTD
View PDF6 Cites 0 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
[0004] In the above method of adding data records, because the ID acquisition operation must be performed every time a new data record is added, in the scenario of high data concurrency, the number of accesses to the database is too large, resulting in heavy pressure on database access
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
[0031] In order to make the purpose, technical solution and advantages of the present invention clearer, the present invention will be further described in detail below in conjunction with the accompanying drawings and specific embodiments.
[0032] figure 1 It is a schematic flow diagram of the method of the embodiment of the present invention, such as figure 1 As shown, the data storage method realized in this embodiment mainly includes:
[0033] Step 101. When the data providing device needs to add a data record to a preset database table for the first time, obtain the currently available record identifier of the data providing device from the database table, and use the record identifier to add the data record to In the database table, the number of the record identifier is extended by using the preset number of identifier extensions, and the range of the identifier number obtained by the number extension is stored in the memory of the data providing device, and the data ...
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 data storage method and device. The method comprises the following steps: when data providing equipment needs to add the data record to the preset database table for the first time, obtaining a currently available record identifier of the equipment from a database table, adding the data record into a database table by utilizing the record identifier, carrying out number extension on the record identifier by utilizing a preset identifier extension number, storing the obtained identifier number range in a memory, and updating the available record identifier of the equipment in the database table to be the maximum value of the identifier number range plus 1; when data records need to be added to a database table after the equipment is used for the first time, controlling threads needing to add data records at present to access the memory one by one to obtain record identifiers, storing the data records into the database table by utilizing the record identifiers,and triggering to update the identifier number range in the memory when the record identifiers in the identifier number range are all used. By adopting the method and the device, the database access pressure can be reduced.
Description
technical field [0001] The invention relates to computer application technology, in particular to a data storage method and device. Background technique [0002] In a system using a distributed architecture, data requires an identifier that can uniquely distinguish data records when storing and reading data. This identifier is usually called a serial number or ID. Ensuring the uniqueness of the ID is a problem that needs to be solved during system design, especially when the database uses sub-databases and sub-tables. [0003] At present, in a system using a distributed architecture, each time a data providing device adds a new data record to the database, it needs to first obtain an available data record identifier from the database, and then associate the data record identifier with the new The added data records are associated together and added to the database. [0004] In the above method of adding data records, because the ID acquisition operation is performed every ...
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/23G06F16/27
Inventor 叶树军
Owner POTEVIO INFORMATION TECH CO LTD