Unlock instant, AI-driven research and patent intelligence for your innovation.

A data storage method, device and computer equipment

A data storage device and data storage technology, applied in computing, memory systems, electrical digital data processing, etc., can solve problems such as data reading errors, achieve the effect of enhancing flexibility and increasing the probability of querying data

Active Publication Date: 2021-01-29
北京思特奇信息技术股份有限公司
View PDF12 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

When reading customer information data in the second-level cache, since the customer data table is stored in cache1, the system does not access the data in the database, and directly reads data from the customer data table in cache1, while the customer data in cache2 has been modified and deleted. Clear, the customer data in cache1 read at this time is not the latest data, resulting in data read errors

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
  • A data storage method, device and computer equipment
  • A data storage method, device and computer equipment
  • A data storage method, device and computer equipment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0040] In the S1, multiple sqlIDs corresponding to each cache and multiple first tables corresponding to each sqlID are combined, and the contents of the same cache and the same sqlID in each table are merged to obtain a plurality of merged second tables. The process of the table is as figure 2 As shown, each mapper has a one-to-one correspondence with a cache, and there are multiple saqIDs under the same mapper, and one or more first tables under one sqlID.

[0041] figure 2 The query1, query2, and query3 respectively correspond to a sqlID, and the corresponding key1, key2, and key3 are the identifiers of each sqlID to cache data in a cache.

[0042] figure 2 t1, t2, and t3 under mappernamespace1 are the first tables, in which the first key value key1-vlaue involves two first tables of t1 and t2, the second key value key2-value involves a first table of t1, and the third The key value key3-value involves the first table of t3, and finally generates the data structure, s...

Embodiment 2

[0047] image 3 t2, t3, and t4 under mappernamespace3 are the first tables, in which the first key value key1-vlaue involves two first tables of t2 and t4, the second key value key2-value involves a first table of t4, and the third The key value key3-value involves the first table of t3, and finally generates the data structure, see image 3 In "Query cache cache key and cache table correspondence 3".

[0048] image 3 t4, t5, and t6 under mappernamespace4 are the first tables, in which the first key value key1-vlaue involves two first tables of t4 and t5, the second key value key2-value involves a first table of t4, and the third The key value key3-value involves the first table of t6, and finally generates the data structure, see image 3 In "Query the correspondence between the cache key and the cache table 4".

[0049] Merge the contents of the above "correspondence between query cache key and cache table 3" and "correspondence between query cache cache key and cache t...

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 present invention provides a data storage method, device and computer equipment. The method includes: a plurality of sqlIDs corresponding to each cache; one or more first tables corresponding to each sqlID; Multiple first tables with the same table name and content with different sqlIDs are merged to obtain one or more merged second tables, wherein each of the second tables contains multiple sqlIDs corresponding to multiple caches, each Each of the second tables corresponds to a plurality of first tables with the same table name, and there is no first table with the same name between any two of the second tables; parse the sqlID corresponding to the currently operating sql command and the cache corresponding to the command ; Determine whether the sqlID of the current operation and the merged second table where the cache is located are consistent, if they are consistent according to the sql operation of the current operation, delete or re-adjust the data of multiple caches involved in the second table from the database Fetch data and write to cache.

Description

technical field [0001] The present invention relates to the technical field of data storage, in particular to a data storage method, device and computer equipment. Background technique [0002] mybatis is a popular java persistence layer framework, which is mainly used to simplify the operation of the database in the traditional jdbc way. Establish the mapping relationship between POJO and SQL centered on data, and then map the parameters required by SQL and the returned result fields to the specified POJO through the mapping configuration file. iBATIS is an ORM implementation of "Sql Mapping". [0003] The second-level cache mybatis requires only a single table operation in the entire system, and all operations related to this table must be under one namespace. When performing a write operation, write the data containing customer information into the customer data table of cache1; if there is an update operation, update the data containing customer information in the cust...

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
Patent Type & Authority Patents(China)
IPC IPC(8): G06F12/0897
Inventor 吕志鹏
Owner 北京思特奇信息技术股份有限公司