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

Database and object storage transaction consistency processing method and system

A technology of object storage and processing methods, applied in the database field, can solve problems such as garbage files, deletion failures, database garbage data, etc., and achieve the effects of improving performance, shortening response time, and rigorous logic

Active Publication Date: 2020-10-02
BANK OF CHINA
View PDF4 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] This method cannot strictly guarantee the consistency of transactions. For example, insert the image metadata information into the database first, and then upload the image file to the object storage operation process. If the long-term upload of the image file to the temporary storage fails, delete the database metadata. information, deletion may fail, resulting in garbage data in the database. May cause image file deletion to fail and generate junk files
[0006] In summary, only relying on the original transaction mechanism of the database cannot guarantee the transaction consistency of the database and object storage. Therefore, a new method is urgently needed to ensure its transaction 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 and object storage transaction consistency processing method and system
  • Database and object storage transaction consistency processing method and system
  • Database and object storage transaction consistency processing method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0034] The principle and spirit of the present invention will be described below with reference to several exemplary embodiments. It should be understood that these embodiments are given only to enable those skilled in the art to better understand and implement the present invention, rather than to limit the scope of the present invention in any way. Rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the scope of the disclosure to those skilled in the art.

[0035] Those skilled in the art know that the embodiments of the present invention can be implemented as a system, device, device, method or computer program product. Therefore, the present disclosure may be embodied in the form of complete hardware, complete software (including firmware, resident software, microcode, etc.), or a combination of hardware and software.

[0036] According to an embodiment of the present invention, a transaction consistency proc...

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 discloses a database and object storage transaction consistency processing method and system, and the method comprises the steps: obtaining a transaction data file and file metadata information; recording data file storage information in the flexible transaction table; uploading the data file to an object storage position; if the uploading of the data file fails, returning transaction failure information; if the data file is uploaded successfully, continuing to execute the database transaction, recording the corresponding file metadata information in the database data table, anddeleting data file storage information corresponding to the data file in the flexible transaction table; if the database transaction is successfully executed, returning transaction success information; if the execution fails, returning transaction failure information; regularly reading data file storage information in the flexible transaction table; searching corresponding data files in the objectstorage in batches and deleting the data files; when the data file is successfully deleted or the corresponding data file is not found in the object storage, deleting the information recorded in theflexible transaction table.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a transaction consistency processing method and system for databases and object storage. Background technique [0002] In the process of IT system design and construction, technicians need to ensure the atomicity of a single user transaction, that is, a single user transaction may involve multiple database operations. It is necessary to ensure that if the transaction is successful, all database operations are successful. If the transaction fails, regardless of At any step in the transaction, it is necessary to ensure that all database operations in this operation are rolled back to the state before the operation. Existing mature commercial database products can usually use their own mechanisms to ensure the transactional consistency of all database operations in a single transaction for users. [0003] However, for a distributed image management platform, a single image upload...

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): G06F16/25G06F16/23
CPCG06F16/25G06F16/2365Y02D10/00
Inventor 牛安宇李小平张煌辉瞿欢秦荣倩李慧刘朝晨刘湘袁琳
Owner BANK OF CHINA
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