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

Database operating method and device

An operation method and database technology, applied in the field of communication, can solve problems such as the inability of data to achieve global consistency

Active Publication Date: 2017-04-26
NANJING ZHONGXING SOFTWARE
View PDF4 Cites 20 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0011] The present invention provides a method and device for operating a database to at least solve the problem in related technologies that data in distributed transactions cannot achieve global consistency

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
  • Database operating method and device
  • Database operating method and device
  • Database operating method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0036] In this embodiment, a database operation method is provided, figure 1 is a flow chart of the operation method of the database according to the embodiment of the present invention, such as figure 1 As shown, the process includes the following steps:

[0037] Step S102, receiving the first transaction information and the current transaction snapshot at the first moment, wherein the first transaction information is used to at least perform the operation indicated by the first transaction on the first database, and the current transaction snapshot includes: the database on the first moment The identification and status of the transactions that have started to be executed in the set, the set of databases is one or more databases including the first database;

[0038] Step S104, judging whether there is a target transaction in the transaction that has been executed indicated by the identifier, wherein the status of the target transaction is uncommitted, and the data items in...

Embodiment 2

[0121] In this embodiment, a database operation device is also provided, which is used to implement the above embodiments and preferred implementation modes, and what has been explained will not be repeated. As used below, the term "module" may be a combination of software and / or hardware that realizes a predetermined function. Although the devices described in the following embodiments are preferably implemented in software, implementations in hardware, or a combination of software and hardware are also possible and contemplated.

[0122] Figure 5 is a schematic diagram of the operating device of the database according to the embodiment of the present invention, such as Figure 5 shown, the device includes

[0123] 1) The receiving unit 502 is configured to receive first transaction information and a current transaction snapshot at a first moment, wherein the first transaction information is used to indicate at least performing the operation indicated by the first transact...

Embodiment 3

[0205] The embodiment of the invention also provides a storage medium. Optionally, in this embodiment, the above-mentioned storage medium may be configured to store program codes for performing the following steps:

[0206] S1. Receive the first transaction information and the current transaction snapshot at the first moment, wherein the first transaction information is used to indicate that at least the operation indicated by the first transaction is performed on the first database, and the current transaction snapshot includes: the database set at the first moment The identification and status of the transaction that has started to be executed in , the database set is one or more databases including the first database;

[0207] S2. Judging whether there is a target transaction in the transaction that has been executed indicated by the identifier, wherein the status of the target transaction is uncompleted submission, and the data items involved in the target transaction incl...

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 provides a database operating method and device. The method comprises the following steps: receiving first transaction information and a current transaction snapshot at a first moment, wherein the current transaction snapshot comprises identifiers and states of transactions that have been started to be executed in a database set at the first moment; judging whether a target transaction exists in the transactions that have been started to be executed indicated by the identifiers, wherein the state of the target transaction is non-submitted, and data items involved in the target transaction comprise all or a part of data items involved in the first transaction; if the target transaction exists in the transactions that have been started to be executed, and when the operation indicated by the first transaction comprises a deletion operation and / or a modification operation, executing the operation indicated by the first transaction on a part of or all data items involved in the first transaction after the state of the target transaction is converted into submitted. By adoption of the database operating method and device provided by the invention, the problem that the data in the distributed transaction cannot achieve global consistency is solved.

Description

technical field [0001] The present invention relates to the communication field, in particular, to a method and device for operating a database. Background technique [0002] With the maturity of traditional database technology and the rapid development of Internet applications, database applications have generally appeared on the Internet. The traditional centralized database system also shows its shortcomings: the use of centralized management will inevitably cause performance bottlenecks, and the single improvement of hardware performance can no longer meet the current needs of large data volume and high concurrent query writing on the Internet. Generate a lot of hardware maintenance and upgrade costs. In addition, the centralized management of databases often results in multi-database associations. Once a certain database crashes, it will cause the entire system to crash. Therefore, the distributed database system will gradually replace the traditional centralized data...

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
IPC IPC(8): G06F17/30
CPCG06F16/2365G06F16/00
Inventor 徐宜良贾新华李灿白涛
Owner NANJING ZHONGXING SOFTWARE
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