Unlock instant, AI-driven research and patent intelligence for your innovation.
Operation method and operating system of a database table
What is Al technical title?
Al technical title is built by PatSnap Al team. It summarizes the technical point description of the patent document.
An operation method and operating system technology, applied in the field of database table operation, can solve problems such as data operation conflicts
Active Publication Date: 2019-10-18
BEIJING ZHONGXIANG BIT TECH
View PDF5 Cites 0 Cited by
Summary
Abstract
Description
Claims
Application Information
AI Technical Summary
This helps you quickly interpret patents by identifying the three key elements:
Problems solved by technology
Method used
Benefits of technology
Problems solved by technology
[0004] Therefore, the current database-based blockchain system has the problem of data operation conflicts
Method used
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more
Image
Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
Click on the blue label to locate the original text in one second.
Reading with bidirectional positioning of images and text.
Smart Image
Examples
Experimental program
Comparison scheme
Effect test
no. 1 approach
[0026] figure 1 A topology of a blockchain system is shown, including a database and multiple transaction nodes. Each database table and a record of each transaction are maintained in the database.
[0027] like figure 2 Shown, method of the present invention comprises:
[0028] Step S1, creating a table object: the blockchain system generates an object for the database table, and the object records the attributes of the database table. All attributes of the database table can be recorded in the object, including the basic hash value of the database table described later.
[0029] When the transaction node initiates the first operation on a database table, the transaction node sends the table operation statement to the blockchain system. The information sent by the transaction node to the blockchain system includes: table operation statements, and the basic hash value in step S1. How the transaction node obtains the basic hash value will be described in detail below.
...
no. 2 approach
[0047] like image 3 As shown, according to another aspect of the invention, the first embodiment is improved.
[0048] In step A1, a map table is created locally at the transaction node sending the transaction, the key value of the map table is the table name of the database table, and the corresponding value includes the basic hash value generated in step S2 of the first embodiment. The map table may be stored in a local cache.
[0049] Step A2, when a transaction node sends a transaction to the blockchain system, it first checks in the local map table.
[0050] In the first case, step A3, if it can be found in the map table, use the cached basic hash value as the latest basic hash value, and perform subsequent operations as in the first embodiment.
[0051] In the second case, step A4, if it cannot be found, the transaction node requests the block chain system to obtain the basic hash value recorded in the object of the database table as the latest basic hash value, as show...
no. 3 approach
[0060] The present invention also proposes an operating system based on a database table, including a blockchain system and transaction nodes, and the blockchain system is configured to execute steps S1-S5 in the first and second implementation manners. The transaction node includes a processor configured to execute A1-A4 in the first and second implementation manners.
[0061] The present invention also proposes a storage medium, which stores a program that can run on a processor, and the program is steps S1-S5 and A1-A4 in the first and second embodiments.
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More
PUM
Login to View More
Abstract
The invention puts forward an operation method and an operating system for a database table. The method comprises the following steps that: S1: generating an object for each database table, wherein the object records the attribute of the database table; S2: carrying out Hash operation on the table operation statement of the first operation of each database table to obtain a Hash value, taking the Hash value as a basic Hash value, and recording the basic Hash value in the object of the database table; S3: after a subsequent operation which aims at a database table is received, connecting the table operation statement which aims at the subsequent operation with the basic Hash value of the database table, and carrying out the Hash operation to obtain a new Hash value; S4: comparing whether the basic Hash value recorded in the subsequent operation is the same with the basic Hash value which is calculated at present or not, and if the basic Hash value recorded in the subsequent operation is different from the basic Hash value which is calculated at present, judging that transaction fails; and S5: if the basic Hash value recorded in the subsequent operation is the same with the basic Hash value which is calculated at present, proving that checking is successful, and updating the basic Hash value in the object of the database table. By use of the method, the transaction carried out by the user at present can be guaranteed to be operated on the basis of the state of the database table seen on the own.
Description
technical field [0001] The present invention relates to the operation technology of the database table, more specifically, relates to the operation method and the operating system of the database table. Background technique [0002] At present, there is a system that combines the blockchain with the database. Through this system, users can send corresponding transactions to the blockchain like operating ordinary databases. The transactions will be recorded in the blockchain network and will be recorded in the underlying database. reflected in. The system realizes the separation of database operation records and implementation, which greatly improves the security and flexibility of traditional databases. [0003] In some cases, if multiple people operate on the same database table at the same time, it will cause conflicts. For example, a piece of data in the table is: Xiaohong's salary is 2000, and user A wants to increase her salary by 10% based on 2000. During this transa...
Claims
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More
Application Information
Patent Timeline
Application Date:The date an application was filed.
Publication Date:The date a patent or application was officially published.
First Publication Date:The earliest publication date of a patent with the same application number.
Issue Date:Publication date of the patent grant document.
PCT Entry Date:The Entry date of PCT National Phase.
Estimated Expiry Date:The statutory expiry date of a patent right according to the Patent Law, and it is the longest term of protection that the patent right can achieve without the termination of the patent right due to other reasons(Term extension factor has been taken into account ).
Invalid Date:Actual expiry date is based on effective date or publication date of legal transaction data of invalid patent.
Login to View More 
Login to View More 
