Table implementation method and device based on key value pair storage system, equipment and medium

A storage system and implementation method technology, applied in other database retrieval, structured data retrieval, database indexing and other directions, can solve the application layer storage requirements to provide effective support, unable to support table management methods, limited KV storage system data storage structural issues

Active Publication Date: 2019-05-24
BAIDU ONLINE NETWORK TECH (BEIJIBG) CO LTD
View PDF11 Cites 5 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, limited by the data storage structure of the KV storage system, it cannot provide effective support for the increasingly rich storage requirements of the application layer
Typically, people are more accustomed to using tables to manage data, but the KV storage system cannot support table management

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
  • Table implementation method and device based on key value pair storage system, equipment and medium
  • Table implementation method and device based on key value pair storage system, equipment and medium
  • Table implementation method and device based on key value pair storage system, equipment and medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0031] figure 1 It is a flowchart of a table implementation method based on a key-value pair storage system provided by Embodiment 1 of the present invention. This embodiment can be applied to how to convert table data into a key-value pair storage system, so that the application layer can It is especially applicable to the scenario of how to implement the management of tabular data on the basis of the underlying storage system of the blockchain, including the key-value pair storage system.

[0032] The following embodiments will be described by taking the conversion of table data in the blockchain system into key-value pairs as an example. Among them, the so-called table is a data structure with rows and columns, and a typical example is an excel table. A table may include at least one row of row data, and the row data includes the specific values ​​of each column according to each column set in the table.

[0033] The method can be implemented by a table implementation dev...

Embodiment 2

[0055] Figure 2A It is a flow chart of a method for implementing a table based on a key-value pair storage system provided by Embodiment 2 of the present invention. This embodiment introduces an index on the basis of the above embodiment for further optimization. see Figure 2A , the method specifically includes:

[0056] S210. Obtain a form data processing request transmitted by the application layer.

[0057] S220. Determine the key identifier of the row data to be processed according to the form data processing request, wherein the key identifier is the value of at least one column in the row data to be processed, and the column corresponding to the key identifier is used as the key identifier column of the row data.

[0058] S230, determine the corresponding row data key-value pair according to the key identifier, and process the value in the row data key-value pair according to the form data processing request, wherein, the key field of the row data key-value pair is u...

Embodiment 3

[0088] image 3 A flowchart of a table implementation method based on a key-value pair storage system provided by Embodiment 3 of the present invention. On the basis of the above-mentioned embodiments, this embodiment uses the method of Embodiment 2 to construct index key-value pairs in the underlying storage system. , and when an index block is introduced, when the table data processing request is a row data write request, the update of the index will be described in detail. see image 3 , the method specifically includes:

[0089] S310. Acquire a form data processing request transmitted by the application layer.

[0090] S320. Determine the key identifier of the row data to be processed according to the table data processing request, wherein the key identifier is the value of at least one column in the row data to be processed, and the column corresponding to the key identifier is used as the key identifier column of the row data.

[0091] S330. Determine the correspondin...

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 embodiment of the invention discloses a table implementation method and device based on a key value pair storage system, equipment and a medium. The method comprises the steps of obtaining a formdata processing request transmitted by an application layer; determining a key identifier of row data to be processed according to the table data processing request with the key identifier being a numerical value of at least one column in the row data to be processed, and a column corresponding to the key identifier being a key identifier column of the row data; and determining a corresponding rowdata key value pair according to the key identifier, and processing numerical values in the row data key value pair according to the table data processing request, the key domain of the row data keyvalue pair being used for storing the key identifier, and the value domain of the row data key value pair being used for storing the numerical values of row data. By adopting the technical scheme provided by the embodiment of the invention, the data management mode of the table can be realized on the basis of the key value pair storage system of the block chain.

Description

technical field [0001] The embodiments of the present invention relate to the technical field of data storage, and in particular, to a method, device, device and medium for implementing a table based on a key-value pair storage system. Background technique [0002] There are many underlying data storage technologies used in the current blockchain system, and one of the more widely used ones is the Key Value (KV) storage system. Under the control of the application layer of the blockchain system, the KV storage system supports access processing such as data reading and writing of the blockchain system. [0003] In the KV storage system, many key-value pairs are used to store various data that the blockchain system needs to store. However, limited by the data storage structure of the KV storage system, it cannot provide effective support for the increasingly rich storage requirements of the application layer. Typically, people are more accustomed to using tables to manage da...

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
IPC IPC(8): G06F16/901G06F16/22
Inventor 段兵谭待肖伟
Owner BAIDU ONLINE NETWORK TECH (BEIJIBG) CO LTD
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