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

Application performance detection method and device in database upgrading scene

A technology of application performance and detection method, applied in the field of application performance detection in database upgrade scenarios, can solve problems such as low efficiency, and achieve the effect of shortening time period and improving test efficiency

Pending Publication Date: 2020-06-19
INDUSTRIAL AND COMMERCIAL BANK OF CHINA
View PDF5 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] This application provides an application performance detection method and device in a database upgrade scenario to solve the problem that traditional benchmarking tools for distributed database platforms need to comprehensively verify the performance of case statements, resulting in low efficiency

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
  • Application performance detection method and device in database upgrading scene
  • Application performance detection method and device in database upgrading scene
  • Application performance detection method and device in database upgrading scene

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0058] 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 persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

[0059] For the shortcomings of the existing technology involved in the background technology, this application provides an application performance detection method in the database upgrade scenario, which overcomes the inflexibility, long cycle and low efficiency of the current industry benchmark test tools defect. Such as figure 1As shown, this application provides an application performance detection method in a database upgrade scenario, including:

[0060...

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 an application performance detection method and device in a database upgrading scene. The method comprises the steps that an obtained SQL statement is stored in an SQL information base; screening core SQL statements from an SQL information base and storing the core SQL statements in the core SQL information base; comparing whether the execution plan of the core SQL statementis changed or not before and after the database is upgraded; and performing comparison verification on the core SQL statement of which the execution plan is changed through a benchmark test tool. Themethod is highly automated, rapid verification of the performance in a distributed database platform upgrading scene is realized without depending on testers and unattended operation, the test efficiency is effectively improved, and the test requirements are rapidly responded.

Description

technical field [0001] The application belongs to the technical field of application performance inspection before and after the upgrade of a distributed database platform, and specifically relates to an application performance detection method and device in a database upgrade scenario. Background technique [0002] With the widespread rise of big data platforms, in the face of the technical challenges brought about by massive data and massive transactions, the performance and scalability of distributed database platforms are listed as important indicators for measuring platform quality, and are increasingly valued by the industry . Due to the continuous complexity of platform business types, the performance requirements for distributed database platforms are also constantly increasing. In order to better serve various applications in distributed database platforms, technicians need to continuously upgrade the platform to improve performance. Due to the complex types of cas...

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
IPC IPC(8): G06F11/34G06F11/36G06F8/65G06F16/242G06F16/27G06N20/00
CPCG06F11/3409G06F11/3452G06F11/3696G06F8/65G06F16/2433G06F16/27G06N20/00Y02D10/00
Inventor 李雪苏夏雯君
Owner INDUSTRIAL AND COMMERCIAL BANK OF CHINA