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

Data storage method and device and data query method and device

A data storage and data query technology, applied in the database field, can solve problems such as discarding, data destruction, and misoperation

Pending Publication Date: 2022-06-07
ALIBABA CLOUD COMPUTING LTD
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The database has a large number of user groups and a complete community ecology. Many users may make some misoperations during the online operation and maintenance of the database. The common ones are update operations or delete statements without restrictions or specifying wrong restrictions. , resulting in data being destroyed or discarded due to manual misoperation. At this time, it is often necessary to quickly query the historical version data before the operation for recovery. Therefore, it is necessary to provide a faster or more reliable data query solution.

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
  • Data storage method and device and data query method and device
  • Data storage method and device and data query method and device
  • Data storage method and device and data query method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0035] In the following description, numerous specific details are set forth in order to provide a thorough understanding of this specification. However, this specification can be implemented in many other ways different from those described herein, and those skilled in the art can make similar promotions without departing from the connotation of this specification, so this specification is not limited by the specific implementation disclosed below.

[0036] The terminology used in one or more embodiments of this specification is for the purpose of describing a particular embodiment only and is not intended to limit the one or more embodiments of this specification. As used in the specification or embodiments and the appended claims, the singular forms "a," "the," and "the" are intended to include the plural forms as well, unless the context clearly dictates otherwise. It will also be understood that the term "and / or" as used in this specification in one or more embodiments re...

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 embodiment of the invention provides a data storage method and device and a data query method and device.The data storage method comprises the steps that when a target transaction is started, a corresponding transaction information line can be allocated to the target transaction in a transaction description information table, and the address of the transaction information line is recorded in a transaction operation record; when the target transaction is submitted, the transaction description information related to the target transaction can be backfilled into the transaction information row allocated to the target transaction, so that the transaction information needing to be queried can be found in the transaction description information table subsequently based on the address in the transaction operation record. Therefore, the transaction description information of the target transaction can be persistently stored in the transaction description information table, the transaction information related to the required historical version data can be queried directly based on the transaction description information table subsequently, and the accurate historical version information can be quickly queried for recovery under the condition that a user performs misoperation, so that the user experience is improved. And the use complexity is greatly reduced.

Description

technical field [0001] The embodiments of the present specification relate to the technical field of databases, and in particular, to a data storage method and device, and a data query method and device. Background technique [0002] With the rapid development of computer technology and Internet technology, online tasks have become more and more common, followed by a surge in data storage requirements, and various databases have been born accordingly. The database has a large number of user groups and a perfect community ecology. Many users may encounter some misoperations in the process of online operation and maintenance of the database, such as update operations or delete statements without qualifications or specifying wrong qualifications, etc. , causing the data to be destroyed or discarded due to manual misoperation. At this time, it is often necessary to quickly query the historical version data before the operation for recovery, so it is necessary to provide a faster...

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/22G06F16/23G06F16/242G06F16/2455G06F16/28
CPCG06F16/2282G06F16/2322G06F16/2329G06F16/2365G06F16/2455G06F16/2445G06F16/284
Inventor 赵建伟张纪杨刘永平马国庆
Owner ALIBABA CLOUD COMPUTING 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