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

A method and system for automatically deleting expired data

A technology of automatic deletion and data, applied in the direction of input/output to the record carrier, etc., can solve the problem of prone to misoperation, increase the workload of data management personnel, etc., and achieve the effect of avoiding misoperation

Active Publication Date: 2018-10-02
BEIJING JINGDONG SHANGKE INFORMATION TECH CO LTD +1
View PDF6 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, the existing method of manually deleting expired data will lead to misoperations when deleting, and will also increase the workload of data management personnel

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
  • A method and system for automatically deleting expired data
  • A method and system for automatically deleting expired data
  • A method and system for automatically deleting expired data

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0021] The present invention will be described in detail below in conjunction with examples. Wherein the same components are denoted by the same reference numerals.

[0022] figure 1 It is the first preferred embodiment of the method for automatically deleting expired data of the present invention. Such as figure 1 As shown, the method for automatically deleting expired data provided by the present invention includes the following steps.

[0023] Step S100, determine the partition value according to the loading time of the data in the partition; Step S200, calculate the partition threshold of the partition; Step S300, judge whether the partition value is smaller than the partition threshold; Step S400, delete according to the judgment result in step S300 data in this partition.

[0024] In step S100, data can be loaded into preset partitions and stored in the partitions. This design of storing different data in different partitions can realize orderly management of data, f...

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 discloses a method and a system for automatically deleting stale data. The method comprises: determining a partition value according to loading time of data in the partition; calculating a partition threshold value of the partition; determining whether the partition value is smaller than the partition threshold value; and deleting the data in the partition according to a judgement result. The system comprises a partition value determining module, a partition threshold value calculating module, a judging module and a data deleting module. The method and the system for automatically deleting the stale data, provided by the present invention, can automatically perform management on a storage period of a database entity; the misoperation caused by artificial deletion can be effectively avoided; and during a specific application process, a retention period only needs to be defined when a table is established, and storage and deletion of the data do not need to be considered later, thereby achieving the effect of putting things right once and for all.

Description

technical field [0001] The invention relates to a method and system for automatically deleting expired data. Background technique [0002] In industries involved in data warehouses and big data (Big Data), data is usually stored for a long time in a partitioned (or sub-table) manner. However, as time goes by, the amount of data stored becomes larger and larger, and the time period for which data is retained becomes longer and longer. How to manage massive amounts of data has brought great challenges to traditional data management technologies, and the key link of data management is how to delete expired data to release unnecessary storage resources and reduce business operating costs. [0003] At present, the traditional data cycle management method generally performs maintenance and management by manually deleting expired data. Specifically, manual cleaning of expired data can be performed within a certain period of time according to the approximate retention period deter...

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): G06F3/06
Inventor 颜博
Owner BEIJING JINGDONG SHANGKE INFORMATION 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