Method for cleaning junk data

Abstract

The invention relates to an information maintenance technology in the field of computers, in particular to a method for cleaning junk data. The method comprises the steps of establishing a junk data cleaning rule system and detecting error data and repeating data from a data source so as to filter information of a database. The method has the following benefits: 1, the rules have expansibility, so a new rule can be supplemented at any time; 2, the rules and the data form a many-to-many mapping relationship so as to allow one data item to correspond to multiple rules and also allow one rule to correspond to multiple data items; 3, the rules are semantic, so the established rules are shown in an easily understood form and stored in a computer language manner; 4, the junk data processing scheme is configured flexibly and allows to process the junk data in multiple self-defining modes comprising deleting, jumping, manual processing and the like; and 5, multi-database support is adopted so as to allow to process support of main stream databases comprising oracle, mysql, db2 and the like.

Description

technical field [0001] The invention relates to information maintenance technology in the field of computers, in particular to a method for cleaning garbage data. Background technique [0002] During the operation of the computer, a large amount of application data needs to be invoked and executed, and some application data is either stored or deleted after being executed. [0003] With the development of computer technology, there are more and more types of application information, and more and more data are stored in the database. However, due to the limitation of capacity, the data stored in the database cannot be unlimited, and when the amount of data in the database reaches a certain amount It is likely to cause a decrease in computer work efficiency and affect the work process. Generally, data is deleted manually, and the operator manually deletes some unnecessary or erroneous data; another method is to periodically aging and delete some unnecessary or low-frequency d...

AI Technical Summary

Problems solved by technology

[0004] However, manual data deletion often requires the operator to have a higher understanding of the database and be able to distinguish which data is junk data and which data is normal data. The operator needs to check and proofread the database data from time to time, which is cumbersome and inefficient; The aging mechanism periodically ages and deletes some unnecessary or low-frequency data, which cannot be timely and completely identified as garbage data caused by input errors, malicious entries, and repeated storage, and the efficiency of checking database garbage data Low

Images