Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Operation method and operating system for database table

An operation method and operating system technology, applied in the operation field of database tables, can solve problems such as data operation conflicts

Active Publication Date: 2017-09-15
BEIJING ZHONGXIANG BIT TECH
View PDF5 Cites 7 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

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
  • Operation method and operating system for database table
  • Operation method and operating system for database table
  • Operation method and operating system for database table

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] Such as 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] Such as 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 on 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 s...

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

No 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
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
Inventor 严挺吴飞鹏卢小明陈姝
Owner BEIJING ZHONGXIANG BIT TECH
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com