Database compatibility test device and method for server

A compatibility testing and database technology, applied in the database field, can solve the problems of inability to test database fault-tolerant performance, cannot represent practical significance, and limited reference value, and achieve the effect of wide testing range, high degree of automation, and release performance.

Active Publication Date: 2010-07-28
SUZHOU LANGCHAO INTELLIGENT TECH CO LTD
View PDF0 Cites 39 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] In the existing technology, a model data is often used for simulation, which cannot represent the actual meaning. The obtained test results deviate greatly from the actual, and the refer

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
  • Database compatibility test device and method for server
  • Database compatibility test device and method for server

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0055] Embodiment 1, a device for database compatibility testing on a server, such as figure 1 shown, including:

[0056] Database building module, functional component testing module, fault tolerance module, stress testing module and data collection module;

[0057] The database building module is used to build a database on the server, and uses the generated data or actual data to fill in the data of the database, and starts the functional component testing module after completion;

[0058] The functional component testing module is used to simulate the daily operation of the database administrator to adjust and test the functional components provided by the database to verify whether the functional components of the database can run normally; after the test is completed, start the fault-tolerant module or stress test module;

[0059] The fault-tolerant module is used to delete the data in the database, and test whether the database can be accessed after deletion, and wheth...

Embodiment 2

[0087] Embodiment 2. A method for database compatibility testing on a server, comprising:

[0088] A. Build a database on the server, and fill the database with generated data or actual data;

[0089] B. Simulate the operation of the database administrator to adjust and test the functional components provided by the database; first perform any step in C1 and C2, and then perform another step after completing C1 and C2; perform D after completing both C1 and C2;

[0090] C1, delete the data in the database, and test whether the database can be accessed after deletion, and whether it can be restored;

[0091] C2, simulating the access of multiple clients to the database to test the extreme performance of the server, and to test the maximum concurrency and transaction processing capability that the hardware platform can provide;

[0092] D. Judging whether the established database is compatible with the server according to the test results of the functional component testing mod...

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 relates to a database compatibility test device and a method for a server. The method comprises the following steps: building a database on the server and carrying out data sufficiency on the database by generated data or actual data; simulating operation of a database administrator to regulate and test functional units provided by the database; deleting data in the database, testing whether the deleted database can be accessed and restored; simulating database access by a plurality of clients to test limitation performance of the server and maximum concurrent number and transaction ability of a hardware platform; and judging whether the built database is compatible with the server based on test results of the functional unit test module, fault-tolerant module and pressure test module. The invention has strong promptness, accuracy and flexibility, can be unmanned, and conducts test based on true database protocol.

Description

technical field [0001] The invention relates to the field of databases, in particular to a device and method for database compatibility testing on a server. Background technique [0002] At present, due to the asynchronous update of hardware products and software and the performance of software products depends on the support of the hardware platform, these require high-end server developers to need the relationship between different versions and different platforms in the process of server design and development. Database products are tested for compatibility to ensure that the database products are compatible on high-end server platforms. In addition, during the bidding test for server procurement or new product testing, customers need to understand the performance of database products based on a certain application on the server platform, determine whether the new hardware platform can meet customer business needs and select database products Whether the hardware platfor...

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): G06F17/30G06F11/16
Inventor 王友升
Owner SUZHOU LANGCHAO INTELLIGENT TECH CO LTD
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
Try Eureka
PatSnap group products