WO2021115002A1

WO2021115002A1 - Method and apparatus for processing blockchain transaction record

Info

Publication number: WO2021115002A1
Application number: PCT/CN2020/127877
Authority: WO
Inventors: 冀猛猛; 欧阳小安; 张开翔; 范瑞彬
Original assignee: 深圳前海微众银行股份有限公司
Priority date: 2019-12-12
Filing date: 2020-11-10
Publication date: 2021-06-17
Also published as: CN111161064A

Abstract

A method and apparatus for processing a blockchain transaction record. The method comprises: acquiring a transaction to be executed (101), wherein the transaction to be executed is used for changing the attribute value of a first attribute of a first account; determining a first attribute value of the first attribute after the transaction to be executed is executed (102); and updating the first attribute value and the current block height to a state table (103), wherein the state table records state data of a plurality of accounts, and the state data of each account refers to the latest attribute value of each attribute of a plurality of attributes of the account and a block height corresponding to the latest attribute value. The method is used for querying a block in which the attribute value of each attribute of an account was last changed.

Description

Method and device for processing block chain transaction records

Cross-references to related applications

This application claims the priority of a Chinese patent application filed with the Chinese Patent Office, the application number is 201911277152.5, and the application name is "a method and device for processing blockchain transaction records" on December 12, 2019, the entire content of which is by reference Incorporated in this application.

Technical field

The embodiment of the present invention relates to the field of financial technology (Fintech), and in particular to a method and device for processing blockchain (Blockchain) transaction records.

Background technique

With the development of computer technology, more and more technologies are applied in the financial field. The traditional financial industry is gradually transforming to Fintech. However, due to the security and real-time requirements of the financial industry, higher technology is also proposed. Requirements.

A state table is stored in the blockchain system. The state table is used to save the latest state data of each account and the block height corresponding to the latest state data. For example, the blockchain system receives a transaction and causes the state data of an account When a change occurs, the status data of the account after the change and the current block height will be updated to the status table. When subsequent queries are required, the status table can be directly queried from the status table to find the transaction that caused the status data to change. Block.

However, in the prior art, there are multiple attributes in the status data of an account, such as age, company, home address, account balance, etc. Every time a certain attribute value of the account is changed, the status data and block of the account will be updated. high. However, among the multiple attributes, some attributes corresponding to attribute values change frequently, such as age, while some attributes corresponding to attribute values change frequently, such as account balance, but when querying, such as records in the current status table The account balance of an account changes due to the latest transaction. If you want to query the block on which the account’s age attribute was last changed, you can’t query it directly from the status table, and you need to re-check it. Place a transaction to determine the block where the age attribute of the account was last changed.

Summary of the invention

The embodiment of the present invention provides a method and device for processing block chain transaction records, which are used to query the block where the attribute value of each attribute of the account was last changed.

An embodiment of the present invention provides a method for processing blockchain transaction records, including:

Acquiring a transaction to be executed; the transaction to be executed is used to change the attribute value of the first attribute of the first account;

Determining the first attribute value of the first attribute after the execution of the transaction to be executed;

The first attribute value and the current block height are updated to the status table; the status table records the status data of multiple accounts, and the status data of the account is the latest attribute value of each attribute of the multiple attributes of the account The block height corresponding to the latest attribute value.

In the above technical solution, the setting status table includes the status data of multiple accounts, and the status data of each account is the latest attribute value of each attribute of the multiple attributes of the account and the block height corresponding to the latest attribute value. In this way, The block height corresponding to the last modification of the attribute value of each attribute of the account can be determined.

Optionally, after updating the first attribute value and the current block height to the status table, the method further includes:

Acquire a first history table corresponding to the current block height; the first history table records modification records of multiple change accounts under the current block height, and the change account belongs to the attribute whose attribute value has changed Account, the modification record of the changed account includes the attribute value of the changed account under the current block height, the attribute value after the change, and the index corresponding to the attribute value after the change Block height, the index block height is the block height corresponding to the latest change of the attribute value after the change before this change;

The first attribute, the first attribute value, and the index block height corresponding to the first attribute value are added to the first history table as the first modification record of the first account.

In the above technical solution, the first history table is acquired, and the first attribute, the first attribute value, and the index block height corresponding to the first attribute value are added to the first history table as the first modification record of the first account, Among them, the first history table does not record the full amount of data, but only records the modification records of the changed account at the current block level, that is, only records the modification records of multiple changed accounts at the current block level, and one account Among the corresponding multiple attributes, if the attribute value of only one attribute changes, and the attribute value of other attributes does not change, only the modification record of the attribute whose attribute value has changed is recorded, and the attribute whose attribute value does not change is not recorded. Record, thereby further reducing the amount of recorded data in the history table.

Optionally, the method further includes:

Receiving a first query instruction; the first query instruction is used to obtain the attribute value of the second attribute of the second account at the specified block height;

If it is determined that the first block height corresponding to the latest attribute value of the second attribute in the status table is greater than the specified block height, start from the first block height, and determine the second account’s height in sequence from high to bottom. The corresponding block height when the attribute value of the second attribute is changed, until the first second block height that is less than the specified block height is determined;

The attribute value of the second attribute of the second account in the history table corresponding to the second block height is determined as the query result.

Optionally, the method further includes:

If it is determined that the first block height is not greater than the specified block height, the latest attribute value of the second attribute in the status table is determined as the query result.

Optionally, the method further includes:

Receiving a second query instruction; the second query instruction is used to obtain the latest N modification records of the second attribute of the second account;

Starting from the first block height corresponding to the latest attribute value of the second attribute in the status table, determine the block height and each block corresponding to the second attribute value of the second account when the attribute value of the second account is changed from high to bottom. The modification record of the second account corresponding to the high on the second attribute until N modification records are determined;

The N modification records are determined as the query result.

Optionally, the determining the block height corresponding to the change of the attribute value of the second attribute of the second account includes:

Acquiring a history table corresponding to the third block height according to the third block height corresponding to the second attribute value of the second account at the M-th change;

Determine the second modification record of the second account from the history table corresponding to the third block height; the second modification record includes the attribute value of the second attribute after the M-th change and The attribute value of the second attribute corresponds to the block height of the latest change before the Mth change.

In the above technical solution, the history table corresponding to each block height can be set, and each history table contains the attribute, attribute value, and index block height corresponding to the change account. The index block height is used to indicate the upper limit of the attribute value of the modification record. The block height when it was modified once, and then the history table corresponding to the block height when it was last modified is determined, and the modification record when the block height was last modified is determined from the history table corresponding to the block height when it was last modified. This cyclic process can quickly find the modification record of a certain attribute. Because the modification record of the change account in the history table only includes the information of the attribute whose attribute value has changed, the amount of record data in the history table is further reduced, and when querying It is also for the change of a certain attribute, this method can improve the query speed.

Optionally, there are multiple status tables; the service types corresponding to each status table are different;

The history table corresponding to each block height records the modification record of the change account in each state table of the block height; the history table includes the identifier of each state table.

In the above technical solution, the provided history table can correspond to the block height, so the history table corresponding to each block height will not be too large, and the history table corresponds to the modification record of the change account in multiple state tables, so that the entire block The number of history tables in the chain system will not be too much, which will further improve the query speed.

Correspondingly, an embodiment of the present invention also provides a processing device for blockchain transaction records, including:

An acquiring unit for acquiring a transaction to be executed; the transaction to be executed is used to change the attribute value of the first attribute of the first account;

The processing unit is configured to determine the first attribute value of the first attribute after the execution of the transaction to be executed; update the first attribute value and the current block height to a status table; how much is recorded in the status table The status data of each account is the latest attribute value of each attribute among the multiple attributes of the account and the block height corresponding to the latest attribute value.

Optionally, the obtaining unit is further configured to obtain a first history table corresponding to the current block height after the processing unit updates the first attribute value and the current block height to a status table; A history table records the modification records of multiple change accounts of the current block level, the change account is the account to which the attribute value has changed, and the modification record of the change account includes the change account in The attribute value of the attribute value changed under the current block height, the attribute value after the change, and the index block height corresponding to the attribute value after the change, and the index block height is the attribute after the change The value of the block height corresponding to the latest change before this change;

The processing unit is further configured to add the first attribute, the first attribute value, and the index block height corresponding to the first attribute value as the first modification record of the first account to the first History table.

Optionally, the processing unit is further configured to:

The N modification records are determined as the query result.

Optionally, the processing unit is specifically configured to:

Correspondingly, an embodiment of the present invention also provides a computing device, including:

Processor, memory, and communication interface; among them, the processor, memory and communication interface are connected by a bus;

The processor is configured to read the program in the memory and execute the above-mentioned method for processing blockchain transaction records;

The memory is used to store one or more executable programs, and can store data used by the processor when performing operations.

Correspondingly, the embodiment of the present invention also provides a non-transitory computer-readable storage medium, in which computer instructions are stored in the non-transitory computer-readable storage medium, and when it runs on a computer, the computer executes the above-mentioned blockchain transaction. The processing method of the record.

Correspondingly, an embodiment of the present invention also provides a computer program product containing instructions. The computer program product includes a calculation program stored on a non-transitory computer-readable storage medium. The computer program includes program instructions. When the program instructions are executed by a computer, the computer executes the above-mentioned blockchain transaction record processing method.

Description of the drawings

In order to explain the technical solutions in the embodiments of the present invention more clearly, the following will briefly introduce the drawings needed in the description of the embodiments. Obviously, the drawings in the following description are only some embodiments of the present invention. For those of ordinary skill in the art, without creative work, other drawings can be obtained based on these drawings.

FIG. 1 is a schematic diagram of a process for updating a status table according to an embodiment of the present invention;

FIG. 2 is a schematic flowchart of an update history table provided by an embodiment of the present invention;

FIG. 3 is a schematic diagram of a process for querying the attribute value of a specific block height according to an embodiment of the present invention;

4 is a schematic diagram of a flow chart for querying a modification record of a certain attribute according to an embodiment of the present invention;

FIG. 5 is a schematic structural diagram of a processing device for blockchain transaction records according to an embodiment of the present invention;

FIG. 6 is a schematic structural diagram of a computing device provided by this application.

Detailed ways

In order to make the objectives, technical solutions, and advantages of the present invention clearer, the present invention will be further described in detail below with reference to the accompanying drawings. Obviously, the described embodiments are only a part of the embodiments of the present invention, rather than all of them. Based on the embodiments of the present invention, all other embodiments obtained by those of ordinary skill in the art without creative work shall fall within the protection scope of the present invention.

The method for processing blockchain transaction records provided by the embodiment of the present invention is applicable to a blockchain system. The blockchain system is a P2P (Peer to Peer) network composed of multiple blockchain nodes. Can communicate directly with each other. The data generated by a blockchain node can be broadcast to multiple blockchain nodes at the same time, and it can also query and obtain data from any other node.

There is a state table in the blockchain system, and the state table is created by a smart contract of the same business type, that is, there can be multiple state tables in the blockchain system, and each state table corresponds to a different business type.

For a status table, the status data of multiple accounts are recorded in the status table, where the status data of any account is the latest attribute value of each attribute of the multiple attributes of the account and the block height corresponding to the latest attribute value . The index Key of the state table is SHA256 (table name + "_" + primary key) to ensure global uniqueness. Each attribute corresponds to a block height, which is used to record the block when the attribute value corresponding to the attribute was modified last time high.

For example, the name of the state table is "t_Balance", and the state table includes accounts Alice, Bob, and Henry. The attributes of each account are Balance (account balance) and Age (age). The state table can be as shown in Table 1. Take Alice as an example, the index Key of the state table is SHA256 ("t_Balance_Alice"), the latest value of Balance corresponding to Alice is 100, and the corresponding block height when last modified is 2; the latest value of Age corresponding to Alice is 37 , The corresponding block height is 2.

Table 1

Through the status table provided by the embodiment of the present invention, the block height corresponding to the latest attribute value of each attribute of the account can be determined when it was modified last time.

FIG. 1 exemplarily shows the flow of a method for processing blockchain transaction records provided by an embodiment of the present invention, and the flow may be executed by a processing device for blockchain transaction records.

As shown in Figure 1, the process specifically includes:

Step 101: Obtain a transaction to be executed;

Step 102: Determine the first attribute value of the first attribute after executing the transaction to be executed;

Step 103: Update the first attribute value and the current block height to the status table.

In the embodiment of the present invention, the transaction to be executed is used to change the attribute value of the first attribute of the first account, and the attribute value of the first attribute becomes the first attribute value after the transaction to be executed is executed. Take Table 1 as an example. When the current block height is 25, when a pending transaction of "Alice's Balance increases by 400 and Alice's Age increases by 1" is obtained, Alice is the first account, Balance and Age Both are the first attribute. After the transaction is executed, Alice's Balance will become 500, which is the first attribute value. Similarly, Alice's Age will become 38, and 38 is the first attribute value. When 500 and 38 and the current block height are updated to the status table respectively, the Balance_Blocknum corresponding to the Alice primary key in the original table 1 is changed to 25, and the Balance corresponding to the Alice primary key is changed to 500; the Age-Blocknum corresponding to the Alice primary key is changed. If it is 25, the Age corresponding to Alice's primary key becomes 38, and the updated Table 1 can be as shown in Table 2.

Table 2

In the embodiment of the present invention, in order to realize that the historical attribute value of each attribute of each account can be queried, such as querying the attribute value of a certain attribute of a certain account at a specific block height, a history table can also be set for recording The modification record of the account's attributes.

In an implementation manner, when a certain state table is created, it is determined whether to generate a history table corresponding to the state table. Specifically, when performing the creation of the state table, the incoming creation instruction includes whether to generate a history table. For those who do not care about historical data, the history table may not be generated to reduce storage overhead. In the blockchain database, a creation record of a status table can be recorded to indicate whether the history table corresponding to the status table has been created. The creation record can also be stored in the form of a table, as shown in Table 3, which can include The name of the state table and whether to generate a history table.

table 3

状态表的表名Table name of the state table	是否生成历史修改记录表Whether to generate historical modification record table
t_Balancet_Balance	TrueTrue
t_Membert_Member	TrueTrue
t_Ordert_Order	FalseFalse

In another implementation, when a state table is created, it is determined whether to write the modification record corresponding to the state table into the history table. That is to say, the history table here is pre-created, and multiple states The modification record corresponding to the table is written into the history table. Specifically, when the creation of the state table is executed, the incoming creation instruction includes whether to write the modification record into the history table. For those who do not care about historical data, the modification record may not be written into the history table to reduce storage overhead. . In the blockchain database, a creation record of a status table can be recorded to indicate whether the modification record of the status table is written into the history table. The creation record can also be stored in the form of a table, as shown in Table 4. It can include the table name of the status table and whether to write the modification record into the history table.

Table 4

状态表的表名Table name of the state table	是否将修改记录写入历史表Whether to write modification records into the history table
t_Balancet_Balance	TrueTrue
t_Membert_Member	TrueTrue
t_Ordert_Order	FalseFalse

In the embodiment of the present invention, each block height may be set to correspond to a history table, and the table name of the history table may be identified according to the block height, such as "t_history_block height". The history table corresponding to each block height does not record the full amount of data, but only records the modification record of the change account corresponding to the block height. As shown below, the structure of each history table is the same, thereby establishing a chained data relationship of multiple history tables.

In the embodiment of the present invention, since there can be multiple status tables, and each status table corresponds to a different business type, when the modification records of the change accounts of each status table are written into the same history table, it can be based on the status. The identification of the table is distinguished, and the history table includes the identification of each state table, such as the table name of each state table. The history table corresponding to each block height records the modification record of the change account in each state table of the block height.

The history table records the modification records of multiple change accounts corresponding to the block level. Among them, the change account is understood as the account to which the attribute value of the corresponding block level is changed. The modification record of the changed account includes the change account in The attribute value of the corresponding block height changed, the attribute value after the change, and the index block height corresponding to the attribute value after the change. The index block height is the latest value of the attribute value after the change before the change Change the corresponding block height.

The fields that can be included in the history table include the primary key, attribute, attribute value, and index block height of the attribute value of the state table. When multiple state tables correspond to a history table, the field of the history table also includes the identifier of the corresponding state table, such as the table name of the state table. Correspondingly, the index Key of the history table is SHA256 (the table of the state table). Name + "_" + primary key of the state table + "_" + attributes).

For example, the table name of the history table is "t_history_10", that is, the history table corresponding to the block height of 10, and the history table can be as shown in Table 5. The history table includes the accounts Bob and Henry. Take Bob as an example. The index Key of the history table is SHA256 ("t_Balance_Bob_Balance"). The value of Bob's Balance in the state table t_Balance at block height 10 is 200. The last change was Occurs when the block is 8 high.

table 5

Based on the foregoing description, in the embodiment of the present invention, after the first attribute value and the current block height are updated to the status table, the corresponding modification record may also be updated to the corresponding history table. In specific implementation, the flowchart shown in FIG. 2 can be used.

Step 201: Obtain a first history table corresponding to the current block height;

Step 202: Add the first attribute, the first attribute value, and the index block height corresponding to the first attribute value as the first modification record of the first account to the first history table.

Here, the first history table is the history table corresponding to the current block height. The first history table records the modification records of multiple change accounts of the current block height. The change account is the account to which the attribute whose attribute value is changed belongs. , The modification record of the changed account includes the attribute value of the changed account under the current block height, the attribute value after the change, and the index block height corresponding to the attribute value after the change. The index block height is after the change The block height corresponding to the last time the attribute value was changed.

Still taking the above example of a transaction that is "Alice's Balance increases by 400 and Alice's Age increases by 1", after the execution of the above transaction, not only the Balance–Blocknum corresponding to the primary key of Alice in the state table, and the primary key of Alice are corresponding The Age-Blocknum corresponding to the primary key of Alice and the Age update corresponding to the primary key of Alice will also add two modification records in the history table with a block height of 25, which are "Alice's Balance in the state table t_Balance is in the block height The value at 25 is 500, and the last modification was modified at block height 2." and "Alice’s Age in the state table t_Balance has a value of 38 at block height 25. The last modification was modified at block height 2. ", adding two new modification records to the history table t_history_25 can be as shown in Table 6.

Table 6

In the embodiment of the present invention, if the status data of an account is newly added, it is equivalent to adding a piece of data to the status table. For example, when the current block height is 70, the status data of Adam is added to the status table t_Balance, then The status table t_Balance of Table 2 is updated as shown in Table 7. At the same time, two new modification records will be added to the history table t_history_70. The two new modification records can be shown in Table 8. Among them, prevblocknum of -1 means that the status data of the account corresponding to the modification record is newly added. of.

Table 7

Table 8

In the above embodiment, the first history table is obtained, and the first attribute, the first attribute value, and the index block height corresponding to the first attribute value are added to the first history table as the first modification record of the first account. Among them, the first history table does not record the full amount of data, but only records the modification records of the change account of the current block level, that is, only records the modification records of multiple change accounts under the current block level, and if one Among the multiple attributes corresponding to the account, if the attribute value of only one attribute changes, and the attribute value of other attributes does not change, only the modification record of the attribute whose attribute value has changed is recorded, and the attribute whose attribute value does not change is not recorded. , Thereby further reducing the amount of data recorded in the history table.

In one implementation, it can support querying the attribute value of a certain attribute of the account at a specified block height.

As shown in Figure 3, an exemplary method for querying attribute values of a specific block height provided by an embodiment of the present invention is shown. The specific process includes:

Step 301: Receive a first query instruction;

Step 302: If it is determined that the first block height corresponding to the latest attribute value of the second attribute in the status table is greater than the specified block height, start from the first block height and determine the attribute value change of the second attribute of the second account in sequence from the high to the bottom. The block height corresponding to the time, until the second block height is determined;

Step 303: Determine the attribute value of the second attribute of the second account in the history table corresponding to the second block height as the query result.

In the embodiment of the present invention, the first query instruction is used to obtain the attribute value of the second attribute of the second account at the specified block height. After the first query instruction is received, the latest attribute of the second attribute is determined from the status table. The first block height corresponding to the value, here, the first block height is the block height corresponding to the latest attribute value of the second attribute, that is, the block height where the attribute value of the second attribute was last modified. If a block height is greater than the specified block height, start from the first block height, and determine the block height corresponding to the second attribute value of the second account at each change from high to low, until the first one is determined The block height is less than the specified block height, and the attribute value of the second attribute of the second account in the history table corresponding to the block height is determined as the query result.

In addition, after the first block height corresponding to the latest attribute value of the second attribute is determined from the status table, if it is determined that the first block height is not greater than the specified block height, the second account's first block height before the specified block height can be determined. The value after the latest change of the attribute value of the second attribute is the latest attribute value of the second attribute, and the latest attribute value of the second attribute can be used as the query result.

In the embodiment of the present invention, when determining the block height corresponding to the attribute value of the second attribute of the second account at each change, it may be based on the attribute value of the second attribute of the second account at the M-th change. Corresponding to the third block height, obtain the history table corresponding to the third block height; then determine the second modification record of the second account from the history table corresponding to the third block height; wherein, the second modification record is included in the Mth block The attribute value of the second attribute after the second change and the corresponding block height of the attribute value of the second attribute at the latest change before the Mth change (equivalent to the value of the attribute value of the second attribute after the Mth change) Index block height). That is to say, when determining the block height corresponding to the attribute value of the second attribute of the second account each time it is changed, it can be based on the block corresponding to the attribute value of the second attribute of the second account at the time of this change. High, obtain the history table of the block height corresponding to this change, and then determine the modification record of the block height corresponding to this change according to the history table of the corresponding block height at the time of this change, so as to modify The block height corresponding to the last change is determined in the record. In this way, the block height corresponding to each change of the attribute value of the second attribute of the second account is determined sequentially from high to low.

In order to better illustrate the embodiment of the present invention, only the account Alice is taken as an example. For example, the first query instruction received is "Query Alice's Age at block height 520", assuming that the current block height is 10000. Then the obtained state table t_Balance is shown in Table 9. After reading the state table t_Balance, it is determined that the block height of the latest attribute value corresponding to Age is 800. If it is greater than 520, the history table corresponding to the block height of 800 will be obtained. The table name is t_history_800. Assuming that the history table corresponding to the block height 800 is shown in Table 10, it can be determined that Alice's Age has been updated when the block height is 500, and the block height 500 is less than the block height 520, then the block height is determined to be 500 The updated Age value is the value to be queried, then the history table corresponding to the block height 500 is obtained. The table name of the history table is t_history_500. Assuming that the history table corresponding to the block height 500 is as shown in Table 11, you can It is determined that the value of Alice's Age at the block height of 500 is 39, that is, the value to be queried is 39.

Table 9

Table 10

Table 11

In the above example, assuming that the history table corresponding to the block height of 800 is as shown in Table 12, it can be determined that Alice's Age has been updated when the block height is 530, and the block height 530 is greater than the block height 520, then the corresponding block height 530 is obtained History table. The name of the history table is t_history_530. Assuming that the history table corresponding to the block height 530 is shown in Table 13, it can be determined that Alice's Age has been updated at the block height of 25, and the block height of 25 is not greater than the block. If the height is 520, it is determined that the updated Age value at the block height of 25 is the value to be queried, and then the history table corresponding to the block height of 25 is obtained. The table name of the history table is t_history_25, assuming the history table corresponding to the block height of 25 As shown in Table 14, it can be determined that the value of Alice's Age at the block height of 25 is 38, that is, the value to be queried is 38.

Table 12

Table 13

Table 14

In the above example, assuming that the obtained state table t_Balance is shown in Table 15, after reading the state table t_Balance, it is determined that the block height of the latest attribute value corresponding to Age is 500 and not greater than 520, then the Age corresponding to the block height of 500 can be determined The value of 40 is the data to be queried.

Table 15

In another implementation, it can also support querying the recent modification records of a certain attribute of the account. As shown in Fig. 4, a method for querying multiple modification records of a certain attribute provided by an embodiment of the present invention is exemplarily shown. The specific process includes:

Step 401: Receive a second query instruction;

Step 402: Starting from the first block height corresponding to the latest attribute value of the second attribute in the status table, sequentially determine the block height corresponding to the second attribute value change of the second account and the corresponding block height from the high to the bottom. The modification record for the second attribute of the second account until N modification records are determined;

Step 403: Determine N modification records as the query result.

In the embodiment of the present invention, the second query instruction is used to obtain the latest N modification records of the second attribute of the second account. After the second query instruction is received, the latest attribute value of the second attribute is determined from the status table. Corresponding to the first block height, here, the first block height is the block height corresponding to the latest attribute value of the second attribute, that is, the block height where the attribute value of the second attribute was last modified. Starting from the block height, determine from high to low the block height corresponding to the second attribute value of the second account each time it is changed, and each time it is determined that the second attribute value of the second account is changing When the block height corresponding to the time is high, the history table corresponding to the block height is obtained at the same time to obtain the modification record corresponding to this change until the N modification record is determined, and the N modification record is determined as the query result .

For example, the received second query instruction is "query the last three modification records of Alice's Age". Assuming that the obtained state table t_Balance is shown in Table 9, after reading the state table t_Balance, it is determined that the latest attribute value corresponding to Age is 40, and the block height corresponding to the latest attribute value 40 is 800, and the block height corresponding to 800 will be obtained. History table. The name of the history table is t_history_800. Assuming that the history table corresponding to the block height of 800 is shown in Table 10, the modification record of Alice's Age when the block height is 800 can be determined. The modification record is the most recent According to the index block height 500 in the modification record, the history table corresponding to the block height 500 is obtained. The table name of the history table is t_history_500. Assume that the history table corresponding to the block height 500 is shown in Table 11. Then you can determine the modification record of Alice's Age when the block height is 500. This modification record is the last-to-last modification record, and then obtain the block height 25 corresponding to the index block height 25 in the modification record. History table. The name of the history table is t_history_25. Assuming that the history table corresponding to a block height of 25 is shown in Table 14, you can determine the modification record of Alice's Age when the block height is 25. The modification record is the most recent The last three modification records of Alice’s Age can be obtained in the history table corresponding to block height 800, block height 500, and block height 25 respectively, and the last three times of Alice’s Age can be obtained. Change to 38→39→40.

In the above embodiment, the history table corresponding to each block height can be set, and each history table contains the attribute, attribute value, and index block height corresponding to the change account. The index block height is used to indicate the upper limit of the attribute value of the modification record. The block height when it was modified once, and then the history table corresponding to the block height when it was last modified is determined, and the modification record when the block height was last modified is determined from the history table corresponding to the block height when it was last modified. This cyclic process can quickly find the modification record of a certain attribute. Because the modification record of the change account in the history table only includes the information of the attribute whose attribute value has changed, the amount of record data in the history table is further reduced, and when querying It is also for the change of a certain attribute, this method can improve the query speed. The history table provided by the embodiment of the present invention may correspond to the block height, so the history table corresponding to each block height is not too large, which further improves the query speed.

Based on the same inventive concept, FIG. 5 exemplarily shows the structure of a block chain transaction record processing device provided by an embodiment of the present invention, and the device can execute the flow of the block chain transaction record processing method.

The device includes:

The obtaining unit 501 is configured to obtain a transaction to be executed; the transaction to be executed is used to change the attribute value of the first attribute of the first account;

The processing unit 502 is configured to determine the first attribute value of the first attribute after the execution of the transaction to be executed; update the first attribute value and the current block height to a status table; the status table records The status data of the multiple accounts. The status data of the account is the latest attribute value of each attribute in the multiple attributes of the account and the block height corresponding to the latest attribute value.

Optionally, the obtaining unit 501 is further configured to obtain the first history table corresponding to the current block height after the processing unit 502 updates the first attribute value and the current block height to the status table; The first history table records the modification records of multiple change accounts of the current block height, the change account is the account to which the attribute value has changed, and the modification record of the change account includes the change The attribute value of the account under the current block height is changed, the attribute value after the change, and the index block height corresponding to the attribute value after the change, and the index block height is the post-change attribute value The attribute value of is the block height corresponding to the latest change before this change;

The processing unit 502 is further configured to use the first attribute, the first attribute value, and the index block height corresponding to the first attribute value as the first modification record of the first account, and add it to the first account. A history table.

Optionally, the processing unit 502 is further configured to:

The N modification records are determined as the query result.

Optionally, the processing unit 502 is specifically configured to:

Based on the same inventive concept, this application also provides a computing device. As shown in FIG. 6, the computing device includes at least one processor 620 for implementing the blocks in the related embodiments of FIGS. 1 to 4 provided by the embodiments of this application. The processing method of chain transaction records.

The computing device 600 may also include at least one memory 630 for storing program instructions and/or data. The memory 630 and the processor 620 are coupled. The coupling in the embodiments of the present application is an indirect coupling or communication connection between devices, units or modules, and may be in electrical, mechanical or other forms, and is used for information exchange between devices, units or modules. The processor 620 may cooperate with the memory 630 to operate. The processor 620 may execute program instructions stored in the memory 630. At least one of the at least one memory may be included in the processor.

In the implementation process, each step of the above method can be completed by an integrated logic circuit of hardware in the processor or instructions in the form of software. The steps of the method disclosed in combination with the embodiments of the present application may be directly embodied as being executed and completed by a hardware processor, or executed and completed by a combination of hardware and software modules in the processor. The software module can be located in a mature storage medium in the field, such as random access memory, flash memory, read-only memory, programmable read-only memory, or electrically erasable programmable memory, registers. The storage medium is located in the memory, and the processor reads the information in the memory and completes the steps of the above method in combination with its hardware. To avoid repetition, it will not be described in detail here.

It should be noted that the processor in the embodiment of the present application may be an integrated circuit chip with signal processing capability. In the implementation process, the steps of the foregoing method embodiments may be completed by hardware integrated logic circuits in the processor or instructions in the form of software. The above-mentioned processor may be a general-purpose processor, a digital signal processing circuit (digital signal processor, DSP), a dedicated integrated circuit (application specific integrated circuit, ASIC), a field programmable gate array (field programmable gate array, FPGA) or other Programming logic devices, discrete gates or transistor logic devices, discrete hardware components. The methods, steps, and logical block diagrams disclosed in the embodiments of the present application can be implemented or executed. The general-purpose processor may be a microprocessor or the processor may also be any conventional processor or the like. The steps of the method disclosed in the embodiments of the present application may be directly embodied as being executed and completed by a hardware decoding processor, or executed and completed by a combination of hardware and software modules in the decoding processor. The software module can be located in a mature storage medium in the field, such as random access memory, flash memory, read-only memory, programmable read-only memory, or electrically erasable programmable memory, registers. The storage medium is located in the memory, and the processor reads the information in the memory and completes the steps of the above method in combination with its hardware.

It can be understood that the memory in the embodiments of the present application may be a volatile memory or a non-volatile memory, or may include both volatile and non-volatile memory. Among them, the non-volatile memory can be read-only memory (ROM), programmable read-only memory (programmable ROM, PROM), erasable programmable read-only memory (erasable PROM, EPROM), and electrically available Erase programmable read-only memory (electrically EPROM, EEPROM) or flash memory. The volatile memory may be random access memory (RAM), which is used as an external cache. By way of exemplary but not restrictive description, many forms of RAM are available, such as static random access memory (static RAM, SRAM), dynamic random access memory (dynamic RAM, DRAM), and synchronous dynamic random access memory (synchronous DRAM, SDRAM), double data rate synchronous dynamic random access memory (double data rate SDRAM, DDR SDRAM), enhanced synchronous dynamic random access memory (enhanced SDRAM, ESDRAM), synchronous connection dynamic random access memory (synchlink DRAM, SLDRAM) ) And direct memory bus random access memory (direct rambus RAM, DR RAM). It should be noted that the memories of the systems and methods described herein are intended to include, but are not limited to, these and any other suitable types of memories.

The computing device 600 may further include a communication interface 610 for communicating with other devices through a transmission medium, so that the device used in the computing device 600 can communicate with other devices. In the embodiment of the present application, the communication interface may be a transceiver, circuit, bus, module, or other type of communication interface. In the embodiment of the present application, when the communication interface is a transceiver, the transceiver may include an independent receiver and an independent transmitter; it may also be a transceiver with integrated transceiver functions, or an interface circuit.

The computing device 600 may also include a communication line 640. Among them, the communication interface 610, the processor 620, and the memory 630 may be connected to each other through a communication line 640; the communication line 640 may be a peripheral component interconnect (PCI) bus or an extended industry standard architecture (extended industry standard architecture). , Referred to as EISA) bus and so on. The communication line 640 can be divided into an address bus, a data bus, a control bus, and the like. For ease of representation, only one thick line is used in FIG. 6, but it does not mean that there is only one bus or one type of bus.

Based on the same inventive concept, embodiments of the present invention also provide a non-transitory computer-readable storage medium. The non-transitory computer-readable storage medium stores computer instructions. When it runs on a computer, the computer executes FIGS. 1 to 1 Fig. 4 is a processing method of blockchain transaction records in a related embodiment.

Based on the same inventive concept, embodiments of the present application provide a computer program product. The computer program product includes a calculation program stored on a non-transitory computer-readable storage medium. The computer program includes program instructions. When executed by a computer, the computer is caused to execute the blockchain transaction record processing method in the related embodiments of FIGS. 1 to 4.

The present invention is described with reference to flowcharts and/or block diagrams of methods, devices (systems), and computer program products according to embodiments of the present invention. It should be understood that each process and/or block in the flowchart and/or block diagram, and the combination of processes and/or blocks in the flowchart and/or block diagram can be realized by computer program instructions. These computer program instructions can be provided to the processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing equipment to generate a machine, so that the instructions executed by the processor of the computer or other programmable data processing equipment are generated It is a device that realizes the functions specified in one process or multiple processes in the flowchart and/or one block or multiple blocks in the block diagram.

These computer program instructions can also be stored in a computer-readable memory that can guide a computer or other programmable data processing equipment to work in a specific manner, so that the instructions stored in the computer-readable memory produce an article of manufacture including the instruction device. The device implements the functions specified in one process or multiple processes in the flowchart and/or one block or multiple blocks in the block diagram.

These computer program instructions can also be loaded on a computer or other programmable data processing equipment, so that a series of operation steps are executed on the computer or other programmable equipment to produce computer-implemented processing, so as to execute on the computer or other programmable equipment. The instructions provide steps for implementing the functions specified in one process or multiple processes in the flowchart and/or one block or multiple blocks in the block diagram.

Although the preferred embodiments of the present invention have been described, those skilled in the art can make additional changes and modifications to these embodiments once they learn the basic creative concept. Therefore, the appended claims are intended to be interpreted as including the preferred embodiments and all changes and modifications falling within the scope of the present invention.

Obviously, those skilled in the art can make various changes and modifications to the present invention without departing from the spirit and scope of the present invention. In this way, if these modifications and variations of the present invention fall within the scope of the claims of the present invention and their equivalent technologies, the present invention is also intended to include these modifications and variations.

Claims

A method for processing blockchain transaction records, which is characterized in that it includes:

Acquiring a transaction to be executed; the transaction to be executed is used to change the attribute value of the first attribute of the first account;

Determining the first attribute value of the first attribute after the execution of the transaction to be executed;

The first attribute value and the current block height are updated to the status table; the status table records the status data of multiple accounts, and the status data of the account is the latest attribute value of each attribute of the multiple attributes of the account The block height corresponding to the latest attribute value.
The method according to claim 1, wherein after said updating the first attribute value and the current block height to the status table, the method further comprises:

Acquire a first history table corresponding to the current block height; the first history table records modification records of multiple change accounts under the current block height, and the change account belongs to the attribute whose attribute value has changed Account, the modification record of the changed account includes the attribute value of the changed account under the current block height, the attribute value after the change, and the index corresponding to the attribute value after the change Block height, the index block height is the block height corresponding to the latest change of the attribute value after the change before this change;

The first attribute, the first attribute value, and the index block height corresponding to the first attribute value are added to the first history table as the first modification record of the first account.
The method according to claim 2, wherein the method further comprises:

Receiving a first query instruction; the first query instruction is used to obtain the attribute value of the second attribute of the second account at the specified block height;

If it is determined that the first block height corresponding to the latest attribute value of the second attribute in the status table is greater than the specified block height, start from the first block height, and determine the second account’s height in sequence from high to bottom. The corresponding block height when the attribute value of the second attribute is changed, until the first second block height that is less than the specified block height is determined;

The attribute value of the second attribute of the second account in the history table corresponding to the second block height is determined as the query result.
The method of claim 3, wherein the method further comprises:

If it is determined that the first block height is not greater than the specified block height, the latest attribute value of the second attribute in the status table is determined as the query result.
The method according to claim 2, wherein the method further comprises:

Receiving a second query instruction; the second query instruction is used to obtain the latest N modification records of the second attribute of the second account;

Starting from the first block height corresponding to the latest attribute value of the second attribute in the status table, determine the block height and each block corresponding to the second attribute value of the second account when the attribute value of the second account is changed from high to bottom. The modification record of the second account corresponding to the high on the second attribute until N modification records are determined;

The N modification records are determined as the query result.
The method according to any one of claims 3 to 5, wherein the determining the block height corresponding to the change of the attribute value of the second attribute of the second account comprises:

Acquiring a history table corresponding to the third block height according to the third block height corresponding to the second attribute value of the second account at the M-th change;

Determine the second modification record of the second account from the history table corresponding to the third block height; the second modification record includes the attribute value of the second attribute after the M-th change and The attribute value of the second attribute corresponds to the block height of the latest change before the Mth change.
The method according to claim 1, wherein there are multiple status tables; each of the status tables corresponds to a different service type;

The history table corresponding to each block height records the modification record of the change account in each state table of the block height; the history table includes the identifier of each state table.
A processing device for blockchain transaction records, which is characterized in that it comprises:

An acquiring unit for acquiring a transaction to be executed; the transaction to be executed is used to change the attribute value of the first attribute of the first account;

The processing unit is configured to determine the first attribute value of the first attribute after the execution of the transaction to be executed; update the first attribute value and the current block height to a status table; how much is recorded in the status table The status data of each account is the latest attribute value of each attribute among the multiple attributes of the account and the block height corresponding to the latest attribute value.
The apparatus according to claim 8, wherein the acquiring unit is further configured to acquire the current block height corresponding to the current block height after the processing unit updates the first attribute value and the current block height to a status table. The first history table; the first history table records the modification records of multiple change accounts of the current block height, the change account is the account of the attribute whose attribute value has changed, and the change account’s The modification record includes the attribute whose attribute value is changed under the current block height of the change account, the attribute value after the change, and the index block height corresponding to the attribute value after the change, the index block High is the block height corresponding to the latest change of the attribute value after the change before this change;

The processing unit is further configured to add the first attribute, the first attribute value, and the index block height corresponding to the first attribute value as the first modification record of the first account to the first History table.
The device according to claim 9, wherein the processing unit is further configured to:

Receiving a first query instruction; the first query instruction is used to obtain the attribute value of the second attribute of the second account at the specified block height;

If it is determined that the first block height corresponding to the latest attribute value of the second attribute in the status table is greater than the specified block height, start from the first block height, and determine the second account’s height in sequence from high to bottom. The corresponding block height when the attribute value of the second attribute is changed, until the first second block height that is less than the specified block height is determined;

The attribute value of the second attribute of the second account in the history table corresponding to the second block height is determined as the query result.
The device according to claim 10, wherein the processing unit is further configured to:

If it is determined that the first block height is not greater than the specified block height, the latest attribute value of the second attribute in the status table is determined as the query result.
The device according to claim 9, wherein the processing unit is further configured to:

Receiving a second query instruction; the second query instruction is used to obtain the latest N modification records of the second attribute of the second account;

Starting from the first block height corresponding to the latest attribute value of the second attribute in the status table, determine the block height and each block corresponding to the second attribute value of the second account when the attribute value of the second account is changed from high to bottom. The modification record of the second account corresponding to the high on the second attribute until N modification records are determined;

The N modification records are determined as the query result.
The device according to any one of claims 10 to 12, wherein the processing unit is specifically configured to:

Acquiring a history table corresponding to the third block height according to the third block height corresponding to the second attribute value of the second account at the M-th change;

Determine the second modification record of the second account from the history table corresponding to the third block height; the second modification record includes the attribute value of the second attribute after the M-th change and The attribute value of the second attribute corresponds to the block height of the latest change before the Mth change.
The device according to claim 8, wherein there are multiple status tables; each status table corresponds to a different service type;

The history table corresponding to each block height records the modification record of the change account in each state table of the block height; the history table includes the identifier of each state table.
A computing device, characterized by comprising a processor, a memory, and a communication interface, wherein the processor, the memory and the communication interface are connected by a bus;

The processor is configured to read the program in the memory and execute the method according to any one of claims 1 to 7;

The memory is used to store one or more executable programs and store data used by the processor when performing operations.
A non-transitory computer-readable storage medium, wherein the non-transitory computer-readable storage medium stores computer instructions, and the computer instructions are used to make the computer execute the method described in any one of claims 1 to 7 .
A computer program product, characterized in that the computer program product includes a calculation program stored on a non-transitory computer-readable storage medium, the computer program includes program instructions, and when the program instructions are executed by a computer, The computer executes the method described in any one of claims 1 to 7.