Data storage and retrieval methods and devices, computer readable storage medium and electronic equipment

A data retrieval and data storage technology, applied in the field of computer data, can solve the problems of insufficient compression ratio and query performance, and achieve the effect of good query performance, small storage space occupation, and small I/O bandwidth occupation

Active Publication Date: 2022-02-22
北京四维纵横数据技术有限公司
View PDF25 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0002] Storing non-relational key-value data in a relational database can greatly improve the flexibility of using a relational database, but existing key-value storage technologies always have various deficiencies in compression ratio and query performance

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
  • Data storage and retrieval methods and devices, computer readable storage medium and electronic equipment
  • Data storage and retrieval methods and devices, computer readable storage medium and electronic equipment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0065] In view of this, the present invention provides a data storage and retrieval method, device, computer-readable storage medium and electronic equipment. The data method is used to store key-value data, which can make it have high compression performance and high Loading performance and high query performance, so it is more suitable for practical use.

[0066] Interpretation of the data:

[0067] Taking PostgreSQL as an example, there are various built-in or third-party key-value storage formats:

[0068] json: describe key-value data in json format, such as {"product": "postgres", "version":12.3}, when loading data, it will directly save the above json text, and perform a complete syntax analysis every time it is read, And output part or all of the content according to the query needs.

[0069] jsonb: The key-value data is also described in json format. When the data is loaded, it will perform syntax analysis, convert it into a binary format and save it to disk. The bi...

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 invention discloses data storage and retrieval methods and devices, a computer readable storage medium and electronic equipment, and belongs to the technical field of computer data. The data storage method comprises the following steps: acquiring a json text, the json text being in a json object format; processing the json text and outputting an mxkv record; and writing the mxkv record into a memory after data compression. The data retrieval method comprises the following steps: acquiring a specified target key value; and in the mxkv record of the data storage method, finding a value corresponding to the specified target key value according to the specified target key value. The computer readable storage medium can be used for implementing the steps of the data storage method and/or the data retrieval method. When the data method is applied to store key-value data, the key-value data can have high compression performance, high loading performance and high query performance at the same time.

Description

technical field [0001] The present invention relates to the technical field of computer data, in particular to a data storage and retrieval method, device, computer-readable storage medium and electronic equipment. Background technique [0002] Storing non-relational key-value data in a relational database can greatly improve the flexibility of relational database use, but existing key-value storage technologies always have various deficiencies in compression ratio and query performance. Therefore, it is necessary to improve the storage and retrieval methods of key-value data. Contents of the invention [0003] In view of this, the present invention provides a data storage and retrieval method, device, computer-readable storage medium and electronic equipment. The data method is used to store key-value data, which can make it have high compression performance and high load capacity at the same time. Performance and high query performance, so it is more suitable for practi...

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 Applications(China)
IPC IPC(8): G06F16/22G06F16/2455G06F16/25
CPCG06F16/22G06F16/258G06F16/2455
Inventor 于宁
Owner 北京四维纵横数据技术有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap