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

Automatization method for testing schooling pressure on database application

A stress testing and database technology, applied in the field of database application cluster stress testing automation, which can solve problems such as error-prone, time-consuming and inefficient

Active Publication Date: 2007-12-26
上海全成通信技术有限公司
View PDF0 Cites 28 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

In the absence of testing tools, manual records were used in the past, which was extremely time-consuming, inefficient, and prone to mistakes

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
  • Automatization method for testing schooling pressure on database application

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0020] As shown in Figure 1, a database application cluster stress test automation method, the method includes reading the scheme configuration file, generating data of a specified scale, determining the way to connect to the database instance, concurrently executing a specified number of stored procedures in the background, and executing OS monitoring commands Output to the specified file, record database performance snapshot and other steps. Specifically, the method includes the following:

[0021] 1. Test preparation:

[0022] Write stored procedures to generate test data of specified scale.

[0023] Simulate the actual application to write a stored procedure for processing large amounts of data.

[0024] 2. Function points of the test technical solution:

[0025] a) The client can choose to connect to a single instance or a cluster

[0026] In the database connection configuration file, configure three connection services: configure a service name for a separate connec...

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

A method for automatically testing pressure of databank application cluster carries out integration of connection mode and connection number as well as cocurrent process then records performance data of databank in process operation in order to analyze performance difference of databank application cluster and single host under multi-cocurrent treatment pressure.

Description

technical field [0001] The invention relates to a testing method of a computer database, in particular to an automatic method of database application cluster pressure testing. Background technique [0002] Nowadays, large-scale project databases usually adopt a cluster architecture. In order to analyze the performance difference between a cluster and a single host under the pressure of large data volume and concurrent processing, it is necessary to combine various factors such as connection mode, number of connections, and concurrent processes, and record them before and after running Performance data for the database. In the absence of testing tools, manual records were used in the past, which was extremely time-consuming, inefficient, and error-prone. Contents of the invention [0003] The purpose of the present invention is to provide an automated method for stress testing of database application clusters in order to overcome the above-mentioned defects in the prior ar...

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/34
Inventor 冯谧
Owner 上海全成通信技术有限公司
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