Eureka AIR delivers breakthrough ideas for toughest innovation challenges, trusted by R&D personnel around the world.

Bank system historical data cleaning method and device

A data cleaning and historical data technology, applied in data processing applications, electrical digital data processing, special data processing applications, etc., can solve problems affecting the normal application of the system, low cleaning efficiency of direct cleaning solutions, inconsistent system data, etc., to achieve convenient Analyze data processing problems, reduce the probability of normal application, and ensure the effect of efficient and safe operation

Active Publication Date: 2018-12-07
BANK OF CHINA
View PDF3 Cites 15 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, the above-mentioned solutions all have the following problems or parts: the historical data is not cleaned up, and for a system with a large transaction volume and a rapid increase in the database data volume, the pressure on the database is increased, which affects the operating efficiency of the system; the direct cleaning solution has low cleaning efficiency and is not compatible with online transactions The contention for resources (CPU, database) is serious, which affects the normal application of the system; each table is cleaned up separately, due to differences in the cleaning speed and progress of different data tables, especially associated data tables, it will bring data inconsistency to the system

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
  • Bank system historical data cleaning method and device
  • Bank system historical data cleaning method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0018] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative efforts fall within the protection scope of the present invention.

[0019] Those skilled in the art know that the embodiments of the present invention can be implemented as a system, device, device, method or computer program product. Therefore, the present disclosure may be embodied in the form of complete hardware, complete software (including firmware, resident software, microcode, etc.), or a combination of hardware and software.

[0020] According to an embodiment of the present invention, a method and device for cleaning historical 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

The invention provides a bank system historical data cleaning method and device, used for cleaning historical data of a database data table. The bank system historical data cleaning method comprises the following steps: formulating a data cleaning rule according to the life cycle and association relationship of the data table of the database; screening data and key values of the data table to be cleaned according to the data cleaning rule, and determining the cleaned data index of the data table to be cleaned; cleaning the data of the data table of the database according to the data cleaning index, and writing the key values of the cleaned data into a backup index file; and generating a cleaning statistics report and recording the cleaned data in the file to save for a set time according to the backup index file, so as to support recovering the file from the file as needed. Through the bank system historical data method and device disclosed by the invention, the cleaning of the historical data can be realized, and efficient and safe operation of the production environment system can be ensured; therefore, the impact of the historical data cleaning process on normal business applications is avoided to the greatest extent, and the probability of affecting the normal applications in the normal production environment after the data cleaning is reduced.

Description

technical field [0001] The invention relates to the field of bank database storage, in particular to a method and device for cleaning historical data of a bank system. Background technique [0002] The core banking system has a large number of businesses and transactions every day. As time goes by, the background database business and transaction data continue to increase. After the life cycle of various data entities in the banking system ends, the related data will no longer be processed. However, they are still kept in the system database, occupying a large amount of storage space after a long period of accumulation, increasing the pressure of system data processing, affecting the execution efficiency of the system, and posing hidden dangers to the safe operation of the system. At present, the commonly used historical data processing methods include: do not process, keep in the database; directly clean up, run batch programs directly on the production environment, locate ...

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): G06F17/30G06Q40/02
CPCG06Q40/02
Inventor 周畅王和燕张阳孙凯
Owner BANK OF CHINA
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
Eureka Blog
Learn More
PatSnap group products