Database data deletion method and device, electronic equipment and storage medium

A deletion method and database technology, applied in the database field, can solve the problems of excessive deletion of data, deletion blocking, database downtime, etc., and achieve the effect of improving deletion efficiency and avoiding blocking.

Active Publication Date: 2017-11-21
BEIJING QIHOO TECH CO LTD
View PDF8 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

When the amount of data stored in it is large, the deletion may cause slow deletion or even deletion blocking, and in severe cases, the database may not be connected or even the database may be down.
[0003] Therefore, there is a need for a gentle database deletion method that can solve the problems of slow deletion, deletion blocking, and database inaccessibility caused by the above-mentioned large amount of deleted data.

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 data deletion method and device, electronic equipment and storage medium
  • Database data deletion method and device, electronic equipment and storage medium
  • Database data deletion method and device, electronic equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0026] Exemplary embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. Although exemplary embodiments of the present disclosure are shown in the drawings, it should be understood that the present disclosure may be embodied in various forms and should not be limited by the embodiments set forth herein. Rather, these embodiments are provided for more thorough understanding of the present disclosure and to fully convey the scope of the present disclosure to those skilled in the art.

[0027] The database in the present invention is a key-value pair database, and data is stored in the database in the form of data key-value pairs. There are many kinds of key-value pair databases, and the databases in the following embodiments are described by taking the redis database as an example, but the present invention is not limited to the redis database.

[0028] figure 1 A flow chart of a method for deleting database dat...

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 data deletion method and device, electronic equipment and storage medium. Data in a database is stored in a key value pair way. The method comprises the following steps that: receiving a data deletion request, wherein the data deletion request at least carries a data key; obtaining a data size contained in a data value corresponding to the data key; judging whether the data size contained in the data value exceeds a first preset quantity of threshold values or not; and if the data size contained in the data value exceeds the first preset quantity of threshold values, submitting the data deletion request to a background to carry out deletion processing for multiple times. Therefore, during deletion, the problems of blockage, database crash and the like due to the deletion of a big data size can be avoided.

Description

technical field [0001] The invention relates to the field of databases, in particular to a method and device for deleting database data, electronic equipment, and a storage medium. Background technique [0002] The database is used to store and manage data, and realize various operations on data. Types of databases include, for example, relational databases and non-relational databases. Different types of databases store different data structures. Key-value databases in non-relational databases, such as Redis databases, store data in key-value pairs. Data values ​​can include multiple data types, such as string (string), list (linked list), set (set), zset (sorted set--ordered set) and hash (hash type). Among them, data types such as list (linked list), set (set), zset (sorted set--ordered set) and hash (hash type) can store multiple data. When deleting data of these data types, multiple data stored in it need to be deleted together. When the amount of data stored in it...

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
CPCG06F16/215
Inventor 杨艳杰
Owner BEIJING QIHOO TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap