CN110096522B - Block chain data processing method, device and equipment supporting relational retrieval - Google Patents

Block chain data processing method, device and equipment supporting relational retrieval Download PDF

Info

Publication number
CN110096522B
CN110096522B CN201910402771.6A CN201910402771A CN110096522B CN 110096522 B CN110096522 B CN 110096522B CN 201910402771 A CN201910402771 A CN 201910402771A CN 110096522 B CN110096522 B CN 110096522B
Authority
CN
China
Prior art keywords
data
transaction
preset
block
state data
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
CN201910402771.6A
Other languages
Chinese (zh)
Other versions
CN110096522A (en
Inventor
彭延国
王玉超
李胜东
崔江涛
夏小芳
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Xidian University
Original Assignee
Xidian University
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Xidian University filed Critical Xidian University
Priority to CN201910402771.6A priority Critical patent/CN110096522B/en
Publication of CN110096522A publication Critical patent/CN110096522A/en
Application granted granted Critical
Publication of CN110096522B publication Critical patent/CN110096522B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/23Updating
    • G06F16/2365Ensuring data consistency and integrity
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • G06F16/2455Query execution
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/27Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/28Databases characterised by their database models, e.g. relational or object models
    • G06F16/284Relational databases
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02DCLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
    • Y02D10/00Energy efficient computing, e.g. low power processors, power management or thermal management

Abstract

The invention relates to a blockchain data processing method supporting relational retrieval, which comprises the following steps: acquiring transaction data and block header data in the block chain data; storing the transaction data into a preset transaction table of a first preset database, wherein the first preset database is a block chain bottom database, and the preset transaction table is provided with a block number field; storing the block header data into a preset block table of the first preset database, wherein the preset block table is provided with a block number field; and establishing a mapping relation between the transaction data and the block header data based on the block number field. By implementing the invention, the fine granularity of the transaction level supported by the blockchain data can be based on content retrieval, and meanwhile, the blockchain data can support SQL, so that complex query operation can be performed.

Description

Block chain data processing method, device and equipment supporting relational retrieval
Technical Field
The present invention relates to blockchain data management, and in particular, to a blockchain data processing method, apparatus and device supporting relational retrieval.
Background
The blockchain is a core front-edge technology for realizing smart cities, smart medical treatment, electronic government affairs and the like, has the characteristics of traceability and verifiability, but only the additional characteristic causes continuous expansion of data, so that an efficient data organization and management mechanism is needed to be proposed. The existing blockchain technology adopts a simple key-value model, data is unstructured, supported retrieval types are single, and therefore organization and utilization of blockchain data are difficult. Therefore, the bottom data of the blockchain is managed by adopting the relational database, so that SQL query is supported, efficient retrieval can be performed, complex query is supported, and the retrieval type of the blockchain data is enriched. The block chain bottom layer data is stored by adopting a block structure, and the data in the block is subjected to sequential coding compression in advance, so that the block chain bottom layer data only supports coarse granularity retrieval, and the transaction information in the block is difficult to inquire and utilize. Therefore, the block chain underlying data storage structure needs to be redefined, the transaction data is organized by using a relation model, so that the transaction information can support efficient content-based retrieval, and the block and the transaction in the block need to be associated by adopting an organization mode of the relation model, thereby guaranteeing the integrity of the block.
Some of the solutions currently existing mainly comprise two: forkBase, directly optimizing the bottom database to accelerate the query efficiency. But it only accelerates the existing query functions and does not support SQL queries. EtherQL, additionally maintaining a database outside the blockchain for querying. This approach creates snoop computation overhead and additional data storage overhead, and reduces the reliability of the query (query data breaks away from the blockchain).
Disclosure of Invention
Aiming at the problems in the prior art, the invention aims to provide a blockchain data processing method, a device and equipment for supporting relational retrieval, which redefine a blockchain bottom data storage structure, organize transaction data by using a relational model, so that the transaction information can support efficient content-based retrieval, and meanwhile, the block and the transaction in the block are associated by adopting the organization mode of the relational model, thereby guaranteeing the integrity of the block.
The first aspect of the present invention provides a blockchain data processing method supporting relational retrieval, the method comprising: acquiring transaction data and block header data in the block chain data; storing the transaction data into a preset transaction table of a first preset database, wherein the first preset database is a block chain bottom database, and the preset transaction table is provided with a block number field; storing the block header data into a preset block table of the first preset database, wherein the preset block table is provided with a block number field; and establishing a mapping relation between the transaction data and the block header data based on the block number field.
Further, the preset transaction table is provided with a transaction account field, and the method further comprises: determining historical state data based on the transaction data; storing the history state data into a preset history state data table of a second preset database, wherein the second preset database is a block chain bottom database, and the preset history state data table is provided with a transaction account field; and establishing a mapping relation between the historical state data and the transaction data based on the transaction account field.
Further, the method further comprises: acquiring transaction data in a preset time period in the transaction data; determining current state data based on the transaction data within the preset time period; storing the current state data into a preset current state data table of a third preset database, wherein the third preset database is a block chain bottom database, and the preset current state data table is provided with a transaction account field; and establishing a mapping relation between the current state data and the transaction data based on the transaction account field.
Further, the method further comprises: establishing a mapping relation between the current state data and the historical state data based on the transaction account field; and verifying consistency of the latest state data in the current state data and the historical state data based on the mapping relation of the current state data and the historical state data.
Further, the method further comprises: receiving a data query request; acquiring the data type of the data queried by the data query request; and returning the queried data based on the data type.
Further, the data type includes at least one of: transaction data type, chunk header data type, current status data type, and historical status data type.
Further, when the data type is a transaction data type, the returning the queried data based on the data type comprises: carrying out structural coding on the queried data to form a transaction entity set; packaging the transaction entity set; and returning the packaged transaction entity set.
Further, when the data type includes a transaction data type and a chunk header data type, the returning the queried data based on the data type includes: carrying out structural coding on transaction data in the queried data to form a transaction entity set; carrying out structural coding on the block header data in the queried data to form a block entity set by combining the transaction entity set; packaging the block entity set; and returning the packaged block entity set.
A second aspect of the present invention provides a blockchain data processing device supporting relational retrieval, the device comprising: the data acquisition module is used for acquiring transaction data and block header data in the block chain data; the first data storage module is used for storing the transaction data into a preset transaction table of a first preset database, wherein the first preset database is a block chain bottom database, and the preset transaction table is provided with a block number field; the second data storage module is used for storing the block header data into a preset block table of the first preset database, and the preset block table is provided with a block number field; and the mapping relation establishing module is used for establishing the mapping relation between the transaction data and the block header data based on the block number field.
A third aspect of the present invention provides a blockchain data processing device supporting relational retrieval, comprising: the system comprises a processor and a memory, wherein at least one instruction, at least one section of program, a code set or an instruction set is stored in the memory, and the at least one instruction, the at least one section of program, the code set or the instruction set is loaded and executed by the processor to realize any blockchain data processing method.
Due to the technical scheme, the invention has the following beneficial effects:
the invention redesigns the block chain bottom data storage structure based on the relation model, so that the fine granularity of the block chain data supporting transaction level is based on content retrieval;
and because the bottom data of the blockchain is managed by adopting the relational database, the blockchain data can support SQL, can carry out complex query operation, and the relational database provides powerful transaction processing function, has rich integrity, reduces data redundancy and simplifies data maintenance work.
Drawings
In order to more clearly illustrate the technical solution of the present invention, the following description will make a brief introduction to the drawings used in the description of the embodiments or the prior art. It is evident that the drawings in the following description are only some embodiments of the present invention and that other drawings may be obtained from these drawings without inventive effort for a person of ordinary skill in the art.
FIG. 1 is a schematic flow diagram of a method for processing blockchain data supporting relational retrieval according to an embodiment of the present invention;
FIG. 2 is a schematic flow chart of a blockchain data writing and SQL query in a blockchain data processing method supporting relational retrieval according to an embodiment of the present invention;
FIG. 3 is a schematic diagram of a preset transaction table in a blockchain data processing method supporting relational retrieval according to an embodiment of the present invention;
fig. 4 is a schematic structural diagram of a preset block table in a block chain data processing method supporting relational retrieval according to an embodiment of the present invention.
Detailed Description
In order that those skilled in the art will better understand the present invention, a technical solution in the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings in which it is apparent that the described embodiments are only some embodiments of the present invention, not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the present invention without making any inventive effort, shall fall within the scope of the present invention.
It should be noted that the terms "first," "second," and the like in the description and the claims and drawings of the present invention are used for distinguishing between similar objects and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used may be interchanged where appropriate such that the embodiments of the invention described herein may be implemented in sequences other than those illustrated or otherwise described herein. Furthermore, the terms "comprise" and "have," as well as any variations thereof, are intended to cover a non-exclusive inclusion.
In the following description of the blockchain data processing method of the present invention, fig. 1 is a schematic flow diagram of a blockchain data processing method supporting relational retrieval according to an embodiment of the present invention, and the present specification provides the method operation steps described in the examples or the flow diagrams, but may include more or fewer operation steps based on conventional or non-creative labor. The order of steps recited in the embodiments is merely one way of performing the order of steps and does not represent a unique order of execution. When an actual blockchain data processing apparatus product executes, it may execute in sequence or in parallel (e.g., in the context of a parallel processor or multi-threaded processing) as the methods illustrated in the embodiments or figures. As shown in fig. 1, the method may include:
step S101: acquiring transaction data and block header data in the block chain data;
in the embodiment of the invention, the transaction data can comprise data such as a block number, a transaction header, a signature, a transaction proposal and a proposal return, and the block header data can comprise data such as a block number, a current block Hash value, a previous block Hash value, a timestamp, a public key, a certificate, a signature and the like.
Step S103: storing the transaction data into a preset transaction table of a first preset database, wherein the first preset database is a block chain bottom database, and the preset transaction table is provided with a block number field;
in the embodiment of the present invention, in order to support fine-grained retrieval of transaction information levels, as shown in fig. 2, a first preset database needs to be established in advance, a preset transaction table is established in the first preset database, and after the transaction data is obtained from blockchain data, the transaction data is sequentially stored in the preset transaction table according to a corresponding relationship. As shown in fig. 3, the preset transaction table may include fields of a block number, a transaction header, a signature, a transaction proposal, a proposal return, and a data field, and the transaction proposal field may include a transaction account field (not shown).
Step S105: storing the block header data into a preset block table of the first preset database, wherein the preset block table is provided with a block number field;
in the embodiment of the present invention, in order to maintain the integrity of the block, as shown in fig. 2, a preset block table is further required to be established in the first preset database, and after the block header data is obtained from the blockchain data, the block header data is sequentially stored in the preset block table according to a corresponding relationship. As shown in fig. 4, the preset block table may include fields such as a block number, a current block Hash, a previous block Hash, a time stamp, a public key, a certificate, a signature, and a data field.
Step S107: and establishing a mapping relation between the transaction data and the block header data based on the block number field.
In the embodiment of the present invention, in order to maintain the integrity of the block, as shown in fig. 2, a mapping relationship between the transaction data and the block header data needs to be established. Since the preset transaction table and the preset block table each include a block number field, a mapping relationship between the transaction data and the block header data can be established based on the block number field.
In other embodiments, in order to speed up the query speed of the historical state verification and the trace back, the preset transaction table is provided with a transaction account field, and the method further includes:
determining historical state data based on the transaction data;
in an embodiment of the present invention, the preset historical state data determined based on the transaction data may include transaction account, resource, goods, and the like data.
Storing the history state data into a preset history state data table of a second preset database, wherein the second preset database is a block chain bottom database, and the preset history state data table is provided with a transaction account field;
in the embodiment of the present invention, in order to accelerate the query speed of the verification and the tracing of the historical state, as shown in fig. 2, a preset historical state data table is further required to be established in the second preset database, and after the historical state data is determined based on the transaction data, the historical state data is sequentially stored in the historical state data table according to the corresponding relationship. The preset historical state data table may include fields for transaction accounts, resources, goods, etc.
And establishing a mapping relation between the historical state data and the transaction data based on the transaction account field.
In the embodiment of the present invention, as shown in fig. 2, a mapping relationship between the historical state data and the transaction data needs to be established. Because the preset transaction table and the preset historical state data table both comprise transaction account fields, a mapping relationship between the historical state data and the transaction data can be established based on the transaction account fields.
In other embodiments, to speed up the query speed of current state verification and traceback, the method further includes:
acquiring transaction data in a preset time period in the transaction data;
in the embodiment of the invention, in order to determine the current state data, the earliest transaction data capable of calculating the current state data in the transaction data needs to be acquired, and the time difference between the earliest transaction data and the latest transaction data is the preset time period.
Determining current state data based on the transaction data within the preset time period;
in the embodiment of the present invention, the preset current state data determined based on the transaction data within the preset time period may include transaction account, resource, goods, and other data.
Storing the current state data into a preset current state data table of a third preset database, wherein the third preset database is a block chain bottom database, and the preset current state data table is provided with a transaction account field;
in the embodiment of the present invention, in order to accelerate the query speed of current state verification and tracing, as shown in fig. 2, a preset current state data table is further required to be established in the third preset database, and after current state data is determined based on transaction data in the preset time period, the current state data is sequentially stored in the current state data table according to a corresponding relationship. The preset current state data table may include fields for transaction accounts, resources, goods, etc.
And establishing a mapping relation between the current state data and the transaction data based on the transaction account field.
In the embodiment of the present invention, as shown in fig. 2, a mapping relationship between the current status data and the transaction data needs to be established. Because the preset transaction table and the preset current state data table both comprise transaction account fields, a mapping relationship between the current state data and the transaction data can be established based on the transaction account fields.
In other embodiments, to verify whether the current state data or the most recent state data in the historical state data has been tampered with, the method further comprises:
establishing a mapping relation between the current state data and the historical state data based on the transaction account field;
in the embodiment of the present invention, the historical state data includes latest state data, and when the current state data in the preset current state data table is not tampered, the current state data should be consistent with the latest state data in the historical state data.
And verifying consistency of the latest state data in the current state data and the historical state data based on the mapping relation of the current state data and the historical state data.
In practical application, the probability that the preset current state data table and the preset historical state data table are tampered is small, so that whether any data table is tampered can be verified through consistency of the current state data and the latest state data in the historical state data. If the data of the preset current state data table or the preset historical state data table is tampered, the verification result is inconsistent.
At this time, the data of the preset current state data table of the current node can be tampered by comparing the current state data of the current node with the current state data of other nodes, if the current state data of the current node is inconsistent with the current state data of most other nodes; and similarly, comparing the latest state data in the historical state data of the current node with the latest state data in the historical state data of other nodes, and if the historical state data of the current node is inconsistent with the historical state data of most other nodes, indicating that the data of the preset historical state data table of the current node is tampered.
In other embodiments, to support efficient querying, as shown in fig. 2, the method further comprises:
receiving a data query request;
in an embodiment of the present invention, the data query request includes an SQL statement and a data type of the queried data.
Acquiring the data type of the data queried by the data query request;
in an embodiment of the present invention, the data type may include at least one of: transaction data type, chunk header data type, current status data type, and historical status data type.
And returning the queried data based on the data type.
In a specific embodiment, when the data type is a transaction data type, the returning the queried data based on the data type includes:
carrying out structural coding on the queried data to form a transaction entity set;
in the embodiment of the present invention, the queried data is a plurality of records in the preset transaction table.
Packaging the transaction entity set;
and returning the packaged transaction entity set.
In a specific embodiment, when the data type includes a transaction data type and a chunk header data type, the returning the queried data based on the data type includes:
carrying out structural coding on transaction data in the queried data to form a transaction entity set;
in the embodiment of the present invention, the queried data is a plurality of records in the preset transaction table and the preset block table.
Carrying out structural coding on the block header data in the queried data to form a block entity set by combining the transaction entity set;
packaging the block entity set;
and returning the packaged block entity set.
In a specific embodiment, when the data type is a current state data type, the returning the queried data based on the data type includes:
and returning the queried data.
In the embodiment of the present invention, the queried data is a plurality of records in the preset current state data table.
In a specific embodiment, when the data type is a historical state data type, the returning the queried data based on the data type includes:
packaging the queried data;
in the embodiment of the present invention, the queried data is a plurality of records in the preset historical state data table.
And returning the packed queried data.
The invention also provides a blockchain data processing device supporting relational retrieval, which comprises:
the data acquisition module is used for acquiring transaction data and block header data in the block chain data;
the first data storage module is used for storing the transaction data into a preset transaction table of a first preset database, wherein the first preset database is a block chain bottom database, and the preset transaction table is provided with a block number field;
the second data storage module is used for storing the block header data into a preset block table of the first preset database, and the preset block table is provided with a block number field;
and the mapping relation establishing module is used for establishing the mapping relation between the transaction data and the block header data based on the block number field.
The device and method embodiments in the device embodiments described are based on the same inventive concept.
The embodiment of the invention also provides a block chain data processing device supporting relational retrieval, which comprises: the system comprises a processor and a memory, wherein at least one instruction, at least one section of program, a code set or an instruction set is stored in the memory, and the at least one instruction, the at least one section of program, the code set or the instruction set is loaded and executed by the processor to realize the blockchain data processing method.
As can be seen from the above embodiments of the blockchain data processing method, apparatus or device provided by the present invention, the embodiments of the present invention implement redesigning the blockchain underlying data storage structure based on the relational model, so that the blockchain data support transaction level fine granularity is based on content retrieval; and because the bottom data of the blockchain is managed by adopting the relational database, the blockchain data can support SQL, can carry out complex query operation, and the relational database provides powerful transaction processing function, has rich integrity, reduces data redundancy and simplifies data maintenance work.
It should be noted that: the sequence of the embodiments of the present invention is only for description, and does not represent the advantages and disadvantages of the embodiments. And the foregoing description has been directed to specific embodiments of this specification. Other embodiments are within the scope of the following claims. In some cases, the actions or steps recited in the claims can be performed in a different order than in the embodiments and still achieve desirable results. In addition, the processes depicted in the accompanying figures do not necessarily require the particular order shown, or sequential order, to achieve desirable results. In some embodiments, multitasking and parallel processing are also possible or may be advantageous.
In this specification, each embodiment is described in a progressive manner, and identical and similar parts of each embodiment are all referred to each other, and each embodiment mainly describes differences from other embodiments. In particular, for apparatus, terminal and system embodiments, the description is relatively simple, as it is substantially similar to method embodiments, with reference to the partial description of method embodiments being relevant.
It will be understood by those skilled in the art that all or part of the steps for implementing the above embodiments may be implemented by hardware, or may be implemented by a program for instructing relevant hardware, where the program may be stored in a computer readable storage medium, and the storage medium may be a read-only memory, a magnetic disk or an optical disk, etc.

Claims (9)

1. A blockchain data processing method supporting relational retrieval, applied to a blockchain, the method comprising:
acquiring transaction data and block header data in the block chain data; the transaction data and the block header data each include a block number;
storing the transaction data into a preset transaction table of a first preset database, wherein the first preset database is a block chain bottom database, and the preset transaction table is provided with a block number field, a transaction account field, a transaction header field, a signature field, a proposal return field and a data field;
storing the block header data into a preset block table of the first preset database, wherein the preset block table is provided with a block number field, a current block Hash field, a previous block Hash field, a timestamp field, a public key field, a certificate field, a signature field and a data field;
establishing a mapping relation between the transaction data and the block header data based on the block number field;
the method further comprises the steps of:
determining historical state data based on the transaction data;
storing the history state data into a preset history state data table of a second preset database, wherein the second preset database is a block chain bottom database, and the preset history state data table is provided with a transaction account field;
establishing a mapping relation between the historical state data and the transaction data based on the transaction account field;
comparing the latest state data in the historical state data of the current node with the latest state data in the historical state data of other nodes to generate a verification result; the verification result represents the consistency condition of the historical state data of the current node and the historical state data of other nodes and the condition that the data of a preset historical state data table of the current node is tampered; when the data of the preset historical state data table of the current node is tampered, the historical state data of the current node is inconsistent with the historical state data of most other nodes.
2. The blockchain data processing method supporting relational retrieval of claim 1, further comprising:
acquiring transaction data in a preset time period in the transaction data;
determining current state data based on the transaction data within the preset time period;
storing the current state data into a preset current state data table of a third preset database, wherein the third preset database is a block chain bottom database, and the preset current state data table is provided with a transaction account field;
and establishing a mapping relation between the current state data and the transaction data based on the transaction account field.
3. The blockchain data processing method supporting relational retrieval of claim 2, further comprising:
establishing a mapping relation between the current state data and the historical state data based on the transaction account field;
and verifying consistency of the latest state data in the current state data and the historical state data based on the mapping relation of the current state data and the historical state data.
4. A blockchain data processing method supporting relational retrieval as in claim 3, further comprising:
receiving a data query request;
acquiring the data type of the data queried by the data query request;
and returning the queried data based on the data type.
5. The method of claim 4, wherein the data type comprises at least one of:
transaction data type, chunk header data type, current status data type, and historical status data type.
6. The method of claim 4, wherein when the data type is a transaction data type, the returning the queried data based on the data type comprises:
carrying out structural coding on the queried data to form a transaction entity set;
packaging the transaction entity set;
and returning the packaged transaction entity set.
7. The method of claim 4, wherein when the data type includes a transaction data type and a chunk header data type, the returning the queried data based on the data type comprises:
carrying out structural coding on transaction data in the queried data to form a transaction entity set;
carrying out structural coding on the block header data in the queried data to form a block entity set by combining the transaction entity set;
packaging the block entity set;
and returning the packaged block entity set.
8. A blockchain data processing device supporting relational retrieval, characterized by being deployed in a blockchain; the device comprises:
the data acquisition module is used for acquiring transaction data and block header data in the block chain data; the transaction data and the block header data each include a block number;
the first data storage module is used for storing the transaction data into a preset transaction table of a first preset database, wherein the first preset database is a block chain bottom database, and the preset transaction table is provided with a block number field, a transaction account field, a transaction header field, a signature field, a proposal return field and a data field;
the second data storage module is used for storing the block header data into a preset block table of the first preset database, and the preset block table is provided with a block number field, a current block Hash field, a previous block Hash field, a timestamp field, a public key field, a certificate field, a signature field and a data field;
the mapping relation establishing module is used for establishing a mapping relation between the transaction data and the block header data based on the block number field; and determining historical state data based on the transaction data; storing the history state data into a preset history state data table of a second preset database, wherein the second preset database is a block chain bottom database, and the preset history state data table is provided with a transaction account field; establishing a mapping relation between the historical state data and the transaction data based on the transaction account field; comparing the latest state data in the historical state data of the current node with the latest state data in the historical state data of other nodes to generate a verification result; the verification result represents the consistency condition of the historical state data of the current node and the historical state data of other nodes and the condition that the data of a preset historical state data table of the current node is tampered; when the data of the preset historical state data table of the current node is tampered, the historical state data of the current node is inconsistent with the historical state data of most other nodes.
9. A blockchain data processing device supporting relational retrieval, comprising: a processor and a memory having stored therein at least one instruction, at least one program, code set or instruction set that is loaded and executed by the processor to implement the blockchain data processing method of any of claims 1-7.
CN201910402771.6A 2019-05-15 2019-05-15 Block chain data processing method, device and equipment supporting relational retrieval Active CN110096522B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201910402771.6A CN110096522B (en) 2019-05-15 2019-05-15 Block chain data processing method, device and equipment supporting relational retrieval

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201910402771.6A CN110096522B (en) 2019-05-15 2019-05-15 Block chain data processing method, device and equipment supporting relational retrieval

Publications (2)

Publication Number Publication Date
CN110096522A CN110096522A (en) 2019-08-06
CN110096522B true CN110096522B (en) 2023-07-28

Family

ID=67448253

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201910402771.6A Active CN110096522B (en) 2019-05-15 2019-05-15 Block chain data processing method, device and equipment supporting relational retrieval

Country Status (1)

Country Link
CN (1) CN110096522B (en)

Families Citing this family (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110471923B (en) * 2019-08-12 2024-01-16 深圳前海微众银行股份有限公司 Processing method and device for blockchain transaction records
CN110609839B (en) * 2019-09-17 2021-05-25 北京海益同展信息科技有限公司 Method, device and equipment for processing block chain data and readable storage medium
CN110602116B (en) * 2019-09-19 2021-05-11 腾讯科技(深圳)有限公司 Block chain based data verification method, device and computer readable storage medium
CN111506650B (en) * 2020-04-13 2023-06-23 西安电子科技大学 Relational blockchain data management method and storage medium
CN112131266B (en) * 2020-08-12 2023-06-13 迅鳐成都科技有限公司 Method, device, system and storage medium for supporting block chain complex query
CN112632080B (en) * 2020-12-29 2023-01-13 杭州趣链科技有限公司 Data storage method, device and equipment based on block chain

Citations (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN106506638A (en) * 2016-11-04 2017-03-15 江苏通付盾科技有限公司 Block storage method and device in block chain
CN107239954A (en) * 2017-06-07 2017-10-10 北京汇通金财信息科技有限公司 It is a kind of to improve the method and device that block produces speed
CN107562775A (en) * 2017-07-14 2018-01-09 阿里巴巴集团控股有限公司 A kind of data processing method and equipment based on block chain
CN109034849A (en) * 2018-08-08 2018-12-18 苏州酷外文化传媒有限公司 Agricultural product information based on block chain is traced to the source verification method and system
CN109086325A (en) * 2018-06-29 2018-12-25 阿里巴巴集团控股有限公司 Data processing method and device based on block chain
CN109165224A (en) * 2018-08-24 2019-01-08 东北大学 A kind of indexing means being directed to keyword key on block chain database
CN109726229A (en) * 2018-11-30 2019-05-07 深圳市元征科技股份有限公司 A kind of block chain date storage method and device

Family Cites Families (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US10565192B2 (en) * 2017-08-01 2020-02-18 International Business Machines Corporation Optimizing queries and other retrieve operations in a blockchain

Patent Citations (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN106506638A (en) * 2016-11-04 2017-03-15 江苏通付盾科技有限公司 Block storage method and device in block chain
CN107239954A (en) * 2017-06-07 2017-10-10 北京汇通金财信息科技有限公司 It is a kind of to improve the method and device that block produces speed
CN107562775A (en) * 2017-07-14 2018-01-09 阿里巴巴集团控股有限公司 A kind of data processing method and equipment based on block chain
CN109086325A (en) * 2018-06-29 2018-12-25 阿里巴巴集团控股有限公司 Data processing method and device based on block chain
CN109034849A (en) * 2018-08-08 2018-12-18 苏州酷外文化传媒有限公司 Agricultural product information based on block chain is traced to the source verification method and system
CN109165224A (en) * 2018-08-24 2019-01-08 东北大学 A kind of indexing means being directed to keyword key on block chain database
CN109726229A (en) * 2018-11-30 2019-05-07 深圳市元征科技股份有限公司 A kind of block chain date storage method and device

Also Published As

Publication number Publication date
CN110096522A (en) 2019-08-06

Similar Documents

Publication Publication Date Title
CN110096522B (en) Block chain data processing method, device and equipment supporting relational retrieval
EP3678346A1 (en) Blockchain smart contract verification method and apparatus, and storage medium
CN111444196B (en) Method, device and equipment for generating Hash of global state in block chain type account book
CN110795499B (en) Cluster data synchronization method, device, equipment and storage medium based on big data
CN109032631B (en) Application program patch package obtaining method and device, computer equipment and storage medium
CN101308471B (en) Method and device for data restoration
CN105279285B (en) A kind of synchronization system and method for relevant database and non-relational database
US20210081400A1 (en) Search method using data structure for supporting multiple search in blockchain-based iot environment, and device according to method
CN111444192B (en) Method, device and equipment for generating Hash of global state in block chain type account book
CN110647531A (en) Data synchronization method, device, equipment and computer readable storage medium
US10268776B1 (en) Graph store built on a distributed hash table
CN111752945B (en) Time sequence database data interaction method and system based on container and hierarchical model
Carver et al. Distributed reachability testing of concurrent programs
CN113421073A (en) Method and apparatus for concurrently executing transactions in a blockchain
CN112148794A (en) Version management method and device of intelligent contract and storage medium
CN111240772A (en) Data processing method and device based on block chain and storage medium
CN107391539B (en) Transaction processing method, server and storage medium
CN110706108B (en) Method and apparatus for concurrently executing transactions in a blockchain
CN112148713A (en) Data migration method and device between heterogeneous databases
CN112035466A (en) Block chain query external index development framework
CN115168384A (en) Data consistency processing method, device, server and storage medium
CN109710698A (en) A kind of data assemblage method, device, electronic equipment and medium
CN106294721B (en) Cluster data counting and exporting methods and devices
CN116010452A (en) Industrial data processing system and method based on stream type calculation engine and medium
CN116627775B (en) Writing optimization method and device for stateful server non-perception function

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant