Unlock instant, AI-driven research and patent intelligence for your innovation.

Business data inspection method and system for upgrading database system

A technology of business data and inspection methods, which is applied in the field of database upgrades, can solve problems such as error-prone, running batches, time-consuming and labor-intensive problems, and achieve the effect of ensuring accuracy and improving efficiency

Active Publication Date: 2019-12-27
BANK OF CHINA
View PDF8 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] 1. Manual inspection is time-consuming, error-prone, and inefficient
[0006] 2. For a system with a large amount of report data, a large amount of manpower is required to participate, and each person writes the test case and input data separately. It is often necessary to wait for the input data of each report to be prepared before the system performs batch processing in a unified manner so as not to affect each other. Unable to run batches in parallel, which will affect the progress of the project

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
  • Business data inspection method and system for upgrading database system
  • Business data inspection method and system for upgrading database system
  • Business data inspection method and system for upgrading database system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0070] Take a database system upgrade as an example, such as image 3 As shown, the business data inspection process for upgrading the database system is:

[0071] First, in combination with step S1001, sort out the DML (Data Manipulation Language, Data Manipulation Language) involved in system processing, use custom tools to list the ORACLE user-defined procedures and functions used in each CSH program and stored procedure, and process them through the system Analyze the situation of the Input and Output tables used step by step, and obtain the list of Input tables and the list of Output tables.

[0072] Among them, this step is a one-time job in practical application. After sorting out the table list, it can be reused to check business data in multiple rounds.

[0073] Combined with step S1002, the EXP / IMP statement is automatically generated for DMP (Data Management Platform, data management platform) operation. Among them, the EXP / IMP statement can be automatically gener...

Embodiment 2

[0078] Taking a certain database system as an example, the system involves a total of 36 reports, and the business personnel provide a business data checklist, and the reports need to be checked.

[0079] The first step is to sort out the source table data required for each report processing to form a list of input data. The source table corresponding to each report is recorded in the list, and each report corresponds to multiple source tables.

[0080] According to the list of input data tables, the data corresponding to these tables in the pre-upgrade database system are exported by DMP using the business data inspection method for upgrading the database system proposed by the present invention, and imported into the post-upgrade database system. Invoke the two systems in batches, and after the batches are executed, export the output data of the database system before the upgrade using DMP and import it to different users of the database system after the upgrade for comparis...

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 business data inspection method and system for upgrading a database system, and the method comprises the following steps: obtaining a business report inspection list; generating a business input data list according to the business report inspection list; respectively inputting the business input data list into the database system before and after upgrading, and obtaining first business output data and second business output data after processing; synchronizing the first business output data to the upgraded database system, and automatically comparing the second business output data with the first business output data to obtain comparison results; if the comparison results are different, judging that the database upgrading is abnormal, and quickly positioning an abnormal report to further analyze reasons; and if the comparison results are the same, determining that the database is successfully upgraded. According to the method and system, automatic scripts are adopted for comparing the business data, the accuracy of the processing data before and after database upgrading is guaranteed, and the business data inspection efficiency is improved.

Description

technical field [0001] The invention relates to the technical field of database upgrading, in particular to a business data checking method and system for upgrading a database system. Background technique [0002] At present, the database versions used by many enterprises' ERP systems (Enterprise Resource Planning, Enterprise Resource Planning) are relatively old, and the system will gradually slow down as the amount of data increases. In order to improve system performance, it is necessary to upgrade the database version or even upgrade the database software. Necessary choice. [0003] However, in the process of upgrading the database, how to ensure the accuracy of the business data of the upgraded database system becomes the key. The method for business data inspection is usually to use manual inspection, that is, each person is responsible for several reports, each enters the same data in the old system and the new system, and then waits for the system to process in batc...

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): G06F8/65
CPCG06F8/65
Inventor 张宁宁
Owner BANK OF CHINA