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

Method and system for cleaning historical data of database

A technology for historical data and databases, applied in the field of database management, can solve the problems of cleaning that cannot support special needs, and cannot perform automatic recovery and cleaning of exceptions. Restore and personalize specified cleanup, impact-reducing effects

Active Publication Date: 2016-03-16
ADVANCED NEW TECH CO LTD
View PDF8 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0010] Further, automatic exception recovery and personalized specified cleaning are realized, which solves the problems in the prior art that cannot be automatically restored and cleaned up when cleaning fails and cannot support special needs cleaning

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 system for cleaning historical data of database
  • Method and system for cleaning historical data of database
  • Method and system for cleaning historical data of database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0053] The embodiment of the present application provides a method and system for cleaning historical data in a database, which uses a task queue to clean up historical data in a database, and solves the problem of low efficiency and easy omission of cleaning tasks in the prior art due to manual operations;

[0054] Further, automatic exception recovery and personalized specified cleaning are realized, which solves the problems in the prior art that automatic recovery and cleaning of abnormalities cannot be performed when cleaning fails and cleaning of special requirements cannot be supported.

[0055] The main realization principles, specific implementation methods and corresponding beneficial effects that can be achieved of the technical solutions of the embodiments of the present application will be described in detail below in conjunction with each accompanying drawing.

[0056] Please refer to figure 1 , Embodiment 1 of the present application provides a method for cleani...

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 method of cleaning database history data and a system of the method of cleaning the database history data. The method of cleaning the database history data includes the following steps: obtaining a data cleaning task from a data cleaning task queue established by a sub-data base of the database, wherein the data cleaning task comprises history data index information needing cleaning, the data base is divided into more than two sub-data base, and each sub-data base of all the sub-data base corresponds to the data cleaning task queue established by each sub-data base; cleaning history data needing cleaning in the database according to the obtained history data index information of the data cleaning task. Due to the technical scheme, efficiency of cleaning the data is improved.

Description

technical field [0001] The present application relates to database management technology, in particular to a method and system for cleaning historical data in a database. Background technique [0002] With the continuous development of computer and network technology, the amount of data and business types processed by computers is also increasing. In order to better improve the efficiency of data processing for users and better realize the processing of business, The database came into being. [0003] However, with the further development of the computer business and the network, many new services based on the network have emerged, such as: online shopping, online video on demand, etc.; with the continuous increase of new services, the database has become larger and larger. Many technical problems have occurred, such as: the access efficiency of the database tables in the database is significantly reduced, resulting in very poor access efficiency of the outer application, a...

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): G06F17/30
Inventor 樊振华
Owner ADVANCED NEW 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