IP Library Granted Patent US 11,204,933
Granted Patent B2
US 11,204,933 · App. 16/803,330 · Granted Dec 21, 2021

Data manipulation record storage method, system, apparatus, and device

Inventor: Xinying Yang (Hangzhou, CN)
Assignee: Advanced New Technologies Co., Ltd.
G06F16/252G06F16/2438G06F16/27
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 11,204,933
App. No.
16/803,330
Granted
Dec 21, 2021
Kind
B2
Abstract

Computer-implemented methods, computer-implemented systems, and non-transitory, computer-readable media for data manipulation record storage. One computer-implemented method includes: sending, by a server, one or more manipulation instructions to a database, wherein the one or more manipulation instructions are in a structured query language (SQL) format; receiving, by the server from the database, an execution result of the one or more manipulation instructions; generating, by the server, one or more data records comprising the one or more manipulation instructions and the execution result; and determining, by the server, that a predetermined condition of generating a data block is satisfied; and generating, by the server, the data block that includes at least a portion of the data records.

Claims (62)

1. A computer-implemented method for data manipulation record storage, comprising:

sending, by a server, one or more manipulation instructions to a database, wherein the one or more manipulation instructions are in a structured query language (SQL) format;

receiving, by the server from the database, an execution result of the one or more manipulation instructions;

generating, by the server, one or more data records comprising the one or more manipulation instructions and the execution result;

performing, by the server, classified storage based on one or more types of the one or more manipulation instructions in each data record, wherein performing classified storage comprises:

determining, by the server, that a predetermined condition of generating a data block is satisfied;

determining, by the server, a type of manipulation instructions that the data block stores;

determining, by the server, at least a portion of the data records that includes the type of manipulation instructions and corresponding execution results;

calculating, by the server, a first hash value based on the at least a portion of the data records and a second hash value of a newest data block of a blockchain-type ledger;

generating, by the server, the data block that includes the at least a portion of the data records and the second hash value, wherein, data records comprising the same type of manipulation instruction are written into the same data block;

appending the data block to the blockchain-type ledger;

receiving, by the server, a request to verify the at least a portion of the data records from a user terminal, wherein the request includes a third hash value calculated by the user terminal;

determining, by the server based on searching the blockchain-type ledger, that the first hash value matches the third hash value; and

sending, by the server to the user terminal, the at least a portion of the data records and an indication indicating that the at least a portion of the data records are correct.

2. The computer-implemented method of claim 1 , wherein the data block is a starting data block of the blockchain-type ledger, the data block has a predetermined block-height.

3. The computer-implemented method of claim 1 , wherein the data block is not a starting data block of a blockchain-type ledger, and a block height of the data block is greater than a block height of an immediately preceding data block of the newest data block.

4. The computer-implemented method of claim 1 , wherein the predetermined condition of generating a data block is one of a volume of the data records reaches a predetermined threshold and a last data block has been generated for a predetermined time.

5. The computer-implemented method of claim 1 , wherein the one or more manipulation instructions are in a subgroup of the SQL format selected from a data definition language (DDL), a data manipulation language (DML), and a data control language (DCL), the execution result further comprises output parameters corresponding to input parameters in the one or more manipulation instructions.

6. The computer-implemented method of claim 5 , further comprising:

determining, by the server, a subgroup code of the subgroup of the SQL format of the one or more manipulation instructions, wherein the one or more data records further comprises the subgroup code for identifying the subgroup associated with the one or more manipulation instructions.

7. A computer-implemented system for data manipulation record storage, comprising:

one or more computers; and

one or more computer memory devices interoperably coupled with the one or more computers and having tangible, non-transitory, machine-readable media storing one or more instructions that, when executed by the one or more computers, perform operations comprising:

sending, by a server, one or more manipulation instructions to a database, wherein the one or more manipulation instructions are in a structured query language (SQL) format;

receiving, by the server from the database, an execution result of the one or more manipulation instructions;

generating, by the server, one or more data records comprising the one or more manipulation instructions and the execution result;

performing, by the server, classified storage based on one or more types of the one or more manipulation instructions in each data record, wherein performing classified storage comprises:

determining, by the server, that a predetermined condition of generating a data block is satisfied;

determining, by the server, a type of manipulation instructions that the data block stores;

determining, by the server, at least a portion of the data records that includes the type of manipulation instructions and corresponding execution results;

calculating, by the server, a first hash value based on the at least a portion of the data records and a second hash value of a newest data block of a blockchain-type ledger;

generating, by the server, the data block that includes the at least a portion of the data records and the second hash value, wherein, data records comprising the same type of manipulation instruction are written into the same data block;

appending the data block to the blockchain-type ledger;

receiving, by the server, a request to verify the at least a portion of the data records from a user terminal, wherein the request includes a third hash value calculated by the user terminal;

determining, by the server based on searching the blockchain-type ledger, that the first hash value matches the third hash value; and

sending, by the server to the user terminal, the at least a portion of the data records and an indication indicating that the at least a portion of the data records are correct.

8. The computer-implemented system of claim 7 , wherein the data block is a starting data block of the blockchain-type ledger, the data block has a predetermined block-height.

9. The computer-implemented system of claim 7 , wherein the data block is not a starting data block of a blockchain-type ledger, and a block height of the data block is greater than a block height of an immediately preceding data block of the newest data block.

10. The computer-implemented system of claim 7 , wherein the predetermined condition of generating a data block is one of a volume of the data records reaches a predetermined threshold and a last data block has been generated for a predetermined time.

11. The computer-implemented system of claim 7 , wherein the one or more manipulation instructions are in a subgroup of the SQL format selected from a data definition language (DDL), a data manipulation language (DML), and a data control language (DCL), the execution result further comprises output parameters corresponding to input parameters in the one or more manipulation instructions.

12. The computer-implemented system of claim 11 , further comprising:

determining, by the server, a subgroup code of the subgroup of the SQL format of the one or more manipulation instructions, wherein the one or more data records further comprises the subgroup code for identifying the subgroup associated with the one or more manipulation instructions.

13. A non-transitory, computer-readable medium storing one or more instructions executable by a computer system to perform operations for data manipulation record storage, comprising:

sending, by a server, one or more manipulation instructions to a database, wherein the one or more manipulation instructions are in a structured query language (SQL) format;

receiving, by the server from the database, an execution result of the one or more manipulation instructions;

generating, by the server, one or more data records comprising the one or more manipulation instructions and the execution result;

performing, by the server, classified storage based on one or more types of the one or more manipulation instructions in each data record, wherein performing classified storage comprises:

determining, by the server, that a predetermined condition of generating a data block is satisfied;

determining, by the server, a type of manipulation instructions that the data block stores;

determining, by the server, at least a portion of the data records that includes the type of manipulation instructions and corresponding execution results;

calculating, by the server, a first hash value based on the at least a portion of the data records and a second hash value of a newest data block of a blockchain-type ledger;

generating, by the server, the data block that includes the at least a portion of the data records and the second hash value, wherein, data records comprising the same type of manipulation instructions are written into the same data block;

appending the data block to the blockchain-type ledger;

receiving, by the server, a request to verify the at least a portion of the data records from a user terminal, wherein the request includes a third hash value calculated by the user terminal;

determining, by the server based on searching the blockchain-type ledger, that the first hash value matches the third hash value; and

sending, by the server to the user terminal, the at least a portion of the data records and an indication indicating that the at least a portion of the data records are correct.

14. The non-transitory, computer-readable medium of claim 13 , wherein the data block is a starting data block of the blockchain-type ledger, the data block has a predetermined block-height.

15. The non-transitory, computer-readable medium of claim 13 , wherein the data block is not a starting data block of a blockchain-type ledger, and a block height of the data block is greater than a block height of an immediately preceding data block of the newest data block.

16. The non-transitory, computer-readable medium of claim 13 , wherein the predetermined condition of generating a data block is one of a volume of the data records reaches a predetermined threshold and a last data block has been generated for a predetermined time.

17. The non-transitory, computer-readable medium of claim 13 , wherein the one or more manipulation instructions are in a subgroup of the SQL format selected from a data definition language (DDL), a data manipulation language (DML), and a data control language (DCL), the execution result further comprises output parameters corresponding to input parameters in the one or more manipulation instructions.

18. The non-transitory, computer-readable medium of claim 17 , further comprising:

determining, by the server, a subgroup code of the subgroup of the SQL format of the one or more manipulation instructions, wherein the one or more data records further comprises the subgroup code for identifying the subgroup associated with the one or more manipulation instructions.

Assignments (4)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Feb 18, 2025
From: ADVANCED NEW TECHNOLOGIES CO., LTD.
To: ANTCHAIN TECHNOLOGY PTE. LTD.
Reel/Frame 070253/0064 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Sep 10, 2020
From: ADVANTAGEOUS NEW TECHNOLOGIES CO., LTD.
To: ADVANCED NEW TECHNOLOGIES CO., LTD.
Reel/Frame 053754/0625 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Aug 31, 2020
From: ALIBABA GROUP HOLDING LIMITED
To: ADVANTAGEOUS NEW TECHNOLOGIES CO., LTD.
Reel/Frame 053743/0464 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Mar 31, 2020
From: YANG, XINYING
To: ALIBABA GROUP HOLDING LIMITED
Reel/Frame 052271/0201 →
Priority Claims (1)
CN 201910435841.8 · May 23, 2019 · national
Continuity (2)
Continuation PCTCN2020071559 · Jan 11, 2020
Related Publication 20200372037A1 · Nov 26, 2020