Historical data cleaning system and method

A technology of historical data and cleaning methods, which is applied in the direction of electronic digital data processing, special data processing applications, digital data information retrieval, etc., can solve the problems of cumbersome testing and use, high testing and updating costs, etc., so as to facilitate subsequent viewing and improve efficiency Effect

Pending Publication Date: 2022-07-22
INSPUR SOFTWARE CO LTD
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

At present, most of the solutions have the problem of tight coupling, the test and use are relatively cumbersome, and the cost of test and update is relatively high

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
  • Historical data cleaning system and method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0037] The present invention is a historical data cleaning system, comprising a historical task module and a timed task module, the historical task module and the timed task module interact with the rest interface or in the way of DUBBO service.

[0038] The historical task module interacts with the database, and interacts with the user through the historical task interface. It is used to analyze historical data based on the database dictionary, and extract the historical data as a historical cleaning service. The historical cleaning service is used to clean the historical data and return the execution result.

[0039] The historical task module corresponds to a historical task configuration file, and the historical task interface is a web interface; the historical task module is started and run by modifying the historical task configuration file and starting the web program.

[0040] As a specific implementation, the historical task module is used to extract historical data in...

Embodiment 2

[0053] A historical data cleaning method of the present invention is applied to a historical data cleaning system disclosed in Embodiment 1, and the method includes the following steps:

[0054] S100, calling the database through the historical task module, and analyzing the historical data based on the database dictionary, and extracting the historical data as a historical cleaning service, where the historical cleaning service is used for cleaning the historical data and returning an execution result;

[0055] S200. For each history cleaning service, configure a corresponding timing task for the history cleaning service through the timing task module, and the timing task is used to define the execution period of the corresponding history cleaning service;

[0056] S300, the historical data cleaning service cleans the historical data based on the corresponding timing task, returns the execution result to the timing task module, records the execution result through the executio...

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 historical data cleaning system and method, belongs to the technical field of data cleaning, and aims to solve the technical problem of how to automatically and accurately clean historical data in a database. Comprising a historical task module used for analyzing historical data based on a database dictionary and extracting the historical data as a historical cleaning service; the timed task module is used for configuring a timed task for a historical cleaning service, the timed task is used for defining an execution period corresponding to the historical cleaning service, and the historical cleaning service is used for cleaning historical data based on the corresponding timed task and returning an execution result to the timed task module; and the timed task module records the execution result through an execution log and displays the execution result through the timed task interface.

Description

technical field [0001] The invention relates to the technical field of data cleaning, in particular to a historical data cleaning system and method. Background technique [0002] A large amount of historical data is stored in the database. Based on business requirements, the historical data needs to be cleaned up. At present, most of the solutions have the problem of tight coupling, which is relatively cumbersome to test and use, and the cost of testing and updating is relatively high. [0003] How to automatically and accurately clean the historical data in the database is a technical problem that needs to be solved. SUMMARY OF THE INVENTION [0004] The technical task of the present invention is to solve the technical problem of how to automatically and accurately clean the historical data in the database by providing a system and method for cleaning historical data in view of the above deficiencies. [0005] In a first aspect, a historical data cleaning system of the ...

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/215G06F9/48
CPCG06F16/215G06F9/4887G06F9/485
Inventor 张连友王柏华赵绍祥陈兆亮
Owner INSPUR SOFTWARE 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