Database cleaning method, system and device and storage medium

Abstract

The invention discloses a database cleaning method. The method comprises the following steps: connecting a database to obtain a cleaning policy table; creating a sub-process, and transmitting a cleaning policy ID to that sub-process, wherein the clean policy ID is stored in the cleaning policy table; checking the state of the global parameter identification, and monitoring the global parameter identification if the global parameter identification is unexecutable; If the global parameter is identified as executable, the child process is started for cleaning. The method of the invention recordsthe information of the cleaning policy in the cleaning policy table, Changing the current situation in which cleanup strategies are scattered across scripts, The cleaning program can uniformly controland manage the cleaning strategy through the cleaning strategy table, which is flexible and convenient, and reduces the correlation degree of the cleaning between the data, reduces the risk of erroneous deletion of the data when the database is cleaned, realizes the safety, stability, efficiency of the database cleaning, and improves the stability and safety of the system.

Description

technical field [0001] The present invention relates to the field of data processing, and more specifically, to a configurable and automatic database cleaning method, system, device and storage medium. Background technique [0002] With the rapid development of information technology, the Internet of Things, cloud computing, and artificial intelligence have developed rapidly, and smart devices have become popular rapidly. At present, the data-driven business model is developing rapidly, such as guiding enterprise decision-making based on big data analysis, so as to better serve users. Big data mining plays a vital role in driving business growth and enterprise development. [0003] Big data is becoming more and more important to major Internet companies, but how to accurately, safely and quickly delete useless customer data in the database, ensure the effectiveness and completeness of business data in applications, and query efficiency has become one of the core issues face...

AI Technical Summary

Problems solved by technology

[0005] Although most databases currently support DELETE and TRUNCATE commands, for implementers, to clean up a data table, an additional cleanup program needs to be written separately. Every time a new data table is cleaned up, a cleanup program will be generated. Every time a data table is changed The cleanup strategy must find the original cleanup program, which increases the burden of use and maintenance of the implementer, and increases the risk of application errors

Images