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

A data table cleaning method and device

A cleaning method and data table technology, applied in the field of database processing, can solve the problem of low cleaning efficiency and achieve the effect of improving cleaning efficiency

Active Publication Date: 2021-05-25
BANK OF CHINA
View PDF12 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The embodiment of the present invention provides a data table cleaning method and device, by invoking the database command, the data tables to be cleaned with the same batch number in the preset configuration table are cleaned in parallel according to the corresponding cleaning method, so as to solve the problems in the prior art In the case of a large number of data tables to be cleaned up, manually write and execute database instructions to clean up the data tables one by one, resulting in low cleaning efficiency technical problems

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
  • A data table cleaning method and device
  • A data table cleaning method and device
  • A data table cleaning method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0057]In order to make the object, technical solution and advantages of the present invention clearer, the present invention will be described in further detail below in conjunction with the embodiments and accompanying drawings. Here, the exemplary embodiments and descriptions of the present invention are used to explain the present invention, but not to limit the present invention.

[0058] In large banks or securities companies, there are generally large database systems to store business transaction information, which can be called historical data, and the stored form is usually in the form of a data table. In the daily operation of large banks or securities companies, a large number of daily business transaction information is continuously added to the data system, and the historical data in the database system will continue to increase. When the amount of historical data accumulated exceeds the load of the database system , the access read and write functions of the data...

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

Embodiments of the present invention provide a data table cleaning method and device, wherein the method includes: obtaining a preset configuration table, wherein the preset configuration table carries batch numbers and data to be cleaned corresponding to each batch number The table name of the table and the cleaning method of the data table to be cleaned corresponding to each batch number; according to the preset configuration table, the database command is invoked to clean up the data table to be cleaned with the same batch number in parallel according to the corresponding cleaning method. In the embodiment of the present invention, by calling the database command, the data tables to be cleaned with the same batch number in the preset configuration table are cleaned up in parallel according to the corresponding cleaning method, which solves the problem of manually writing and executing database commands in the prior art to clean up the data tables sequentially A technical issue that resulted in inefficient data table cleanup.

Description

technical field [0001] The invention relates to the technical field of database processing, in particular to a data table cleaning method and device. Background technique [0002] A large amount of historical data is generally stored in a large database, and these historical data are usually in the form of data tables. Since a large number of new data tables are stored in the database every day, if the historical data tables in the database have not been cleaned up for a long time , which will increase the storage burden of the database and degrade the read and write performance of the database. In order to clean up the historical data tables in the database in a timely manner, in the prior art, database managers manually write and execute a database command to clean up a data table. It is long and the cleaning efficiency is not high. [0003] For the above technical problems, no effective solution has been proposed yet. Contents of the invention [0004] The embodiment...

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): G06F16/215G06F16/22
Inventor 杜庆
Owner BANK OF CHINA
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