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

Method and device for database transaction processing

A technology for processing transactions and databases, applied in the computer field, can solve problems such as direct locking, and achieve the effects of ensuring isolation, speeding up throughput, and improving processing efficiency

Active Publication Date: 2021-06-11
YUSUR TECH CO LTD
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Unfortunately, on the special acceleration hardware database side, it is impossible to lock directly like on the CPU, but hardware support must be provided to determine whether hardware-side instructions can read or modify table data in the hardware memory

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
  • Method and device for database transaction processing
  • Method and device for database transaction processing
  • Method and device for database transaction processing

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0032] In order to make the purpose, technical solutions and advantages of the embodiments of the present invention more clear, the embodiments of the present invention will be further described in detail below in conjunction with the accompanying drawings. Here, the exemplary embodiments and descriptions of the present invention are used to explain the present invention, but not to limit the present invention.

[0033] Some current methods of accelerating database performance cannot fundamentally solve the problems of low efficiency and excessive power consumption of general-purpose processors when solving domain-specific problems, so it is necessary to turn to domain-specific hardware accelerators. Although the main purpose of a dedicated hardware accelerator is to complete some complex and specific functional parts, it must also provide hardware support for some functions that were originally implemented on the CPU software.

[0034] The current software database system run...

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 present invention provides a method and device for database transaction processing, wherein the method includes: successively receiving the processing instructions of the first transaction and the processing instructions of the second transaction; according to all processing instructions of the first transaction and the processing instructions of the Whether there is an intersection of the accessed data tables in all processing instructions of the second transaction and / or whether there is a modification type instruction, confirm whether the first transaction and the second transaction are related; in the first transaction and the second transaction In the case that the transaction is not related, execute the processing instruction of the first transaction and the processing instruction of the second transaction in parallel; in the case that the first transaction is related to the second transaction, execute the first transaction After all the processing instructions of the transaction are executed, the processing instructions of the second transaction are executed. Through the above solution, the transaction processing efficiency of the hardware database can be improved under the condition of ensuring transaction isolation.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a method and device for database processing transactions. Background technique [0002] With the advent of the digital society, various application scenarios require more and more frequent access to massive data, and the demand for accelerated database processing is more abundant. People's demand for real-time data processing has greatly increased, so the demand for database acceleration is imminent. At the current stage, it is a trend to use customizable or dedicated hardware such as FPGA (Field Programmable Gate Array, Field Programmable Gate Array), ASIC (Application Specific Integrated Circuit, Application Specific Integrated Circuit) to accelerate the processing speed of the database. The ability of a dedicated accelerator naturally hopes that it can support multiple threads or processes to send processing instructions and data to it. At this time, the database is shown t...

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 Patents(China)
IPC IPC(8): G06F16/21G06F16/242
CPCG06F16/21G06F16/2433
Inventor 鄢贵海周康康江树浩
Owner YUSUR TECH CO LTD
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