Method and device for cleaning database

A database and data technology, applied in the field of database cleaning, can solve the problems of low efficiency and heavy workload of cleaning invalid data, achieve good cleaning effect and improve cleaning efficiency

Inactive Publication Date: 2017-10-03
WUXI TVMINING MEDIA SCI & TECH
View PDF5 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] Embodiments of the present invention provide a method and device for cleaning up a database to solve the problems of low efficiency and heavy workload in cleaning up invalid data existing in the prior art

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 device for cleaning database
  • Method and device for cleaning database
  • Method and device for cleaning database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0021] In the embodiment of the present invention, the failure conditions or time conditions of the data in each database are uniformly configured, and after the table to be cleaned is determined, the SQL command for cleaning invalid data can be automatically generated according to the configuration information and the structure of the table to be cleaned, and automatically Perform a cleanup operation.

[0022] The method for clearing the database provided by the embodiment of the present invention is described in detail below.

[0023] figure 1 Shown is a schematic diagram of the method for clearing the database provided by an embodiment of the present invention. According to the figure, the steps are described in detail as follows:

[0024] Step 101, read the configuration information in each database, and determine the database to be cleaned;

[0025] In another embodiment of the present invention, before reading the configuration information in each database in this step...

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 embodiment of the invention provides a method for cleaning databases. The method comprises the following steps: reading configuration information in each database, and determining to-be-cleaned databases; linking to the to-be-cleaned databases according to the configuration information, and mapping to-be-cleaned tables; generating an SQL (Structured Query Language) command according to the configuration information and the to-be-cleaned tables; executing the SQL command, and cleaning the to-be-cleaned tables. The embodiment of the invention further provides a corresponding device for cleaning the databases. According to the method and the device for cleaning the databases, disclosed by the embodiment of the invention, the cleaning efficiency of invalid data can be improved, and a better cleaning effect is guaranteed.

Description

technical field [0001] The present invention relates to the field of computer technology, in particular to a method and device for clearing a database. Background technique [0002] With the development of Internet technology, many industries have entered the era of massive data. At present, most technologies related to big data focus on data mining and utilization. The mining of big data must be premised on the existence of a large amount of data, but an excessive amount of data will obviously bring considerable difficulties to mining and utilization. In the context of the contemporary information explosion, the rapid increase in the amount of data is accompanied by rapid data updates. In other words, while mastering the latest data, it is also necessary to clean up outdated or invalid data in a timely manner. Otherwise, not only will the amount of data be too large, which will greatly increase the difficulty of data mining, but more importantly, it may directly lead to er...

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
CPCG06F16/215
Inventor 沈镇张芳芳吴承丞任野飞杨贺郑凤娟
Owner WUXI TVMINING MEDIA SCI & TECH
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

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap