CN117271318A - Database compatibility testing method and device - Google Patents
Database compatibility testing method and device Download PDFInfo
- Publication number
- CN117271318A CN117271318A CN202311180382.6A CN202311180382A CN117271318A CN 117271318 A CN117271318 A CN 117271318A CN 202311180382 A CN202311180382 A CN 202311180382A CN 117271318 A CN117271318 A CN 117271318A
- Authority
- CN
- China
- Prior art keywords
- test
- data
- compatibility
- database
- module
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000012360 testing method Methods 0.000 title claims abstract description 165
- 238000000034 method Methods 0.000 claims abstract description 13
- 230000002159 abnormal effect Effects 0.000 claims abstract description 8
- 238000012545 processing Methods 0.000 claims abstract description 7
- 238000013500 data storage Methods 0.000 claims description 17
- 238000007726 management method Methods 0.000 claims description 9
- 238000011161 development Methods 0.000 claims description 6
- 230000005540 biological transmission Effects 0.000 claims description 3
- 238000010998 test method Methods 0.000 claims description 3
- 230000000694 effects Effects 0.000 abstract description 3
- 230000007547 defect Effects 0.000 description 2
- 238000005259 measurement Methods 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000013459 approach Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000006835 compression Effects 0.000 description 1
- 238000007906 compression Methods 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/36—Preventing errors by testing or debugging software
- G06F11/3668—Software testing
- G06F11/3672—Test management
- G06F11/3684—Test management for test design, e.g. generating new test cases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/36—Preventing errors by testing or debugging software
- G06F11/3668—Software testing
- G06F11/3672—Test management
- G06F11/3688—Test management for test execution, e.g. scheduling of test suites
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Computer Hardware Design (AREA)
- Quality & Reliability (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention relates to the technical field of database testing, in particular to a database compatibility testing method and device, which can realize conventional operation and abnormal operation on data or application programs in the process of database compatibility testing, can enable the data and the application programs to carry out compatibility testing operation under different pressures based on an Oracle database, has good compatibility testing effect and is convenient for compatibility testing; according to the invention, the result comparison module and the report output module are arranged, after the database compatibility test is completed, the result comparison module can be used for summarizing, counting and analyzing the structure of the compatibility test, and then the report output module can be used for outputting the result summarized, counted and analyzed by the comparison module, so that the steps of manually rechecking and counted are reduced, and the database compatibility test is convenient to use. The invention has the advantages of capability of performing compatible test operation on the database and automatic statistical processing on the data.
Description
Technical Field
The invention relates to a testing method and device, in particular to a database compatibility testing method and device.
Background
The data compatibility test tests the compatibility of application programs under different databases (relational databases, noSQL databases, etc.) and data formats (JSON, XML, etc.). The method and the device mainly aim to ensure that the application program can normally run and interact when using different data storage and formats, and ensure the integrity and accuracy of the data.
The prior art can only realize that the database compatibility test operation can be carried out on a single aspect, namely can only realize that the compatibility test operation under a single test scheme can be carried out on the basis of a single database, has lower efficiency and comprehensiveness for the compatibility test of the database, is unfavorable for realizing the database compatibility diversified test operation, and can generate a large amount of compatibility test data after the traditional database compatibility test, the data need to be manually output, summarized, counted and analyzed, the data volume is numerous and inconvenient to operate, and data errors are extremely easy to occur in the manual operation process, so that deviation appears on the result of the later compatibility test, and the operation of the database compatibility test is unfavorable.
Based on the reasons, the invention provides a database compatibility testing method and device for solving the defects in the prior art.
Disclosure of Invention
Aiming at the defects of the prior art, the invention provides a database compatibility testing method and device.
In order to solve the technical problems, the invention provides the following technical scheme:
a database compatibility testing method, comprising the steps of:
s1: determining a test environment, and determining related information of a database and a data format used by a test application program;
s2: determining a test scheme, determining a test scheme of data compatibility test at a designated place according to requirements and characteristics, and determining a test method and a test tool;
s3: importing test data, namely importing the data to be tested into different databases;
s4: performing data compatibility test, testing whether the conventional business operation of the application program under different databases and data formats can be normally performed or not, and further testing the processing of abnormal conditions;
s5: comparing the test results, comparing the test results under the same test environment, comparing the compatibility of test data storage and formats, finding out the difference and solving the problem;
s6: and outputting a test report, testing according to the test scheme, and finishing test results and outputting the test report.
As a preferable technical scheme of the invention, the test environment used in the step 1 is realized based on an Oracle database, and the data types of the Oracle database comprise a numerical value type, a character type and a date and time type.
As a preferable technical scheme of the invention, the test scheme in the step 2 is used for compatibility test based on the requirements and characteristics of pressure test, and the pressure compatibility test adopts two configuration schemes of computationally intensive and I/O intensive.
As a preferred technical scheme of the invention, the conventional business operation in the step 4 comprises four aspects of adding, modifying, deleting and inquiring operation, and the abnormal condition processing comprises two aspects of data type mismatch and length limitation.
As a preferred embodiment of the present invention, the comparison test mode in the step 5 includes three modes, namely an oltp_read_only mode, an oltp_read_write mode and an oltp_write_only mode.
The database compatibility testing device comprises a test development and debugging module, a connection management module, a data storage module, a test execution module, a result comparison module and a report output module;
the development and debugging module is used for debugging the Oracle database environment for testing, so that an application program and data which need to be subjected to database compatibility test can be established on the Oracle database for testing, and the application program has a foundation for carrying out compatibility test;
the connection management module is used for realizing connection between the Oracle database and the application program, uploading connection operation of the application program and data, and connection and uploading of different equipment ports can be realized through the connection management module, so that the database compatibility is convenient to use;
the data storage module is used for carrying out storage operation on data and application programs for carrying out compatibility pressure test;
the test execution module is used for executing application programs and data on the Oracle database, and can realize adjustment operation on each item of data in the data test process according to actual test requirements, so that the accuracy and the diversity of the test are further improved;
the result comparison module is used for performing multi-aspect comparison operation on the compatibility test result, and can summarize, count and analyze various different comparison results, so that the test result can be conveniently used and checked;
and the report output module is used for outputting the results of summarizing, counting and analyzing by the comparison module.
As a preferable technical scheme of the invention, the data storage module is a flash memory device capable of realizing data storage, the data storage module is a hard disk, the result comparison module comprises a display device and a comparison program, the display device is a display, and the report output module is a printing device or a wireless data transmission device.
The embodiment of the invention provides a database compatibility testing method and device, which have the following beneficial effects:
1. the method and the device have the advantages that through the steps of determining the test environment and determining the test scheme, the database of the test environment can be determined firstly according to actual requirements when the method and the device are used, so that compatibility test operation can be carried out under different databases according to different test schemes, the stability and the feasibility of data or application program compatibility test can be effectively improved, the implementation of database compatibility operation is facilitated, and the use effect is good;
2. the invention can realize the conventional operation and abnormal operation of the data or the application program in the process of the database compatibility test, can lead the data and the application program to carry out the compatibility test operation under different pressures based on the Oracle database, has good compatibility test effect and is convenient for compatibility test use;
3. according to the invention, the result comparison module and the report output module are arranged, after the database compatibility test is completed, the result comparison module can be used for summarizing, counting and analyzing the structure of the compatibility test, and then the report output module can be used for outputting the result summarized, counted and analyzed by the comparison module, so that the steps of manually rechecking and counted are reduced, and the database compatibility test is convenient to use.
Drawings
The accompanying drawings are included to provide a further understanding of the invention and are incorporated in and constitute a part of this specification, illustrate the invention and together with the embodiments of the invention, serve to explain the invention. In the drawings:
FIG. 1 is a flow chart of a database compatibility testing method of the present invention;
fig. 2 is a block diagram showing the construction of a database compatibility test apparatus according to the present invention.
Detailed Description
The preferred embodiments of the present invention will be described below with reference to the accompanying drawings, it being understood that the preferred embodiments described herein are for illustration and explanation of the present invention only, and are not intended to limit the present invention.
Examples: as shown in fig. 1-2, a database compatibility testing method includes the following steps:
s1: determining a test environment, and determining related information of a database and a data format used by a test application program, wherein the used test environment is realized based on an Oracle database, and the data types of the Oracle database comprise a numerical value type, a character type and a date and time type;
s2: determining a test scheme, namely determining a test scheme of a data compatibility test at a designated place according to requirements and characteristics, and determining a test method and a test tool, wherein the test scheme is used for carrying out the compatibility test based on the requirements and the characteristics of a pressure test, and the pressure compatibility test adopts two configuration schemes of computationally intensive type and I/O intensive type;
for a computationally intensive configuration scheme, compatibility pressure testing for an Oracle database involves the following formats:
case: the database read-write mode adopted when the database is pressed is represented;
database name: the name of the database appointed during the database compression measurement is tpk_s when the database is compressed in a computationally intensive configuration mode;
number of data tables: the number of data tables in the specified database is 10 when the database is pressed in a computationally intensive configuration mode;
data table size: designating the data size in each data table when the database is pressed, wherein the data size in each data table is 10000000 when the database is pressed by adopting a computationally intensive configuration mode;
number of threads: when the database is pressed, designating how many threads are adopted to start the pressing measurement, and when the database is pressed in a computationally intensive configuration mode, the maximum number of threads is 128 under the 8C64GB specification, the minimum number of threads is 1, and the maximum number of threads is 300 under the 64C512GB specification, and the minimum number of threads is 1;
cloud service instance name: the name of the cloud server instance where the database is located;
qps corresponding to the number of threads: and the QPS corresponding to the maximum thread number and the minimum thread number are respectively output according to the format.
For an I/O intensive configuration scheme, when a compatibility pressure test is performed on an Oracle database, the following formats are included:
the compute intensive mode database name is tpk_s, and the I/O intensive configuration mode database name is tpk_l;
the data table size for the compute intensive approach is 10000000, while the data table size for the I/O intensive configuration is 40000000 under the 8C64GB specification. At the 64C512GB specification, the data table size is 300000000.
S3: importing test data, namely importing the data to be tested into different databases;
s4: performing data compatibility test to test whether the conventional business operation of the application program under different databases and data formats can be normally performed or not, and further testing the processing of abnormal conditions, wherein the conventional business operation comprises four aspects of adding, modifying, deleting and inquiring operations, and the abnormal condition processing comprises two aspects of data type mismatch and length limitation;
s5: comparing test results, comparing test data storage and format compatibility under the same test environment, finding out differences and solving problems, wherein the comparison test modes comprise an oltp_read_only mode, an oltp_read_write mode and an oltp_write_only mode;
s6: and outputting a test report, testing according to the test scheme, and finishing test results and outputting the test report.
The database compatibility testing device comprises a test development and debugging module, a connection management module, a data storage module, a test execution module, a result comparison module and a report output module;
the development and debugging module is used for debugging the Oracle database environment for testing, so that an application program and data which need to be subjected to database compatibility test can be established on the Oracle database for testing, and the application program has a foundation for carrying out compatibility test;
the connection management module is used for realizing connection between the Oracle database and the application program, uploading connection operation of the application program and data, and connection and uploading of different equipment ports can be realized through the connection management module, so that the database compatibility is convenient to use;
the data storage module is used for carrying out storage operation on data and application programs for carrying out compatibility pressure test, is a flash memory device capable of realizing data storage and is a hard disk;
the test execution module is used for executing application programs and data on the Oracle database, and can realize adjustment operation on each item of data in the data test process according to actual test requirements, so that the accuracy and the diversity of the test are further improved;
the result comparison module is used for performing multi-aspect comparison operation on the compatibility test result, can summarize, count and analyze various different comparison results, and is convenient for using and checking the test result, and comprises a display device and a comparison program, wherein the display device is a display;
the report output module is used for outputting the results of summarizing, counting and analyzing the comparison module, and is composed of printing equipment or wireless data transmission equipment.
The foregoing description is only a preferred embodiment of the present invention, and the present invention is not limited thereto, but it is to be understood that modifications and equivalents of some of the technical features described in the foregoing embodiments may be made by those skilled in the art, although the present invention has been described in detail with reference to the foregoing embodiments. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present invention should be included in the protection scope of the present invention.
Claims (7)
1. A database compatibility testing method, comprising the steps of:
s1: determining a test environment, and determining related information of a database and a data format used by a test application program;
s2: determining a test scheme, determining a test scheme of data compatibility test at a designated place according to requirements and characteristics, and determining a test method and a test tool;
s3: importing test data, namely importing the data to be tested into different databases;
s4: performing data compatibility test, testing whether the conventional business operation of the application program under different databases and data formats can be normally performed or not, and further testing the processing of abnormal conditions;
s5: comparing the test results, comparing the test results under the same test environment, comparing the compatibility of test data storage and formats, finding out the difference and solving the problem;
s6: and outputting a test report, testing according to the test scheme, and finishing test results and outputting the test report.
2. The method according to claim 1, wherein the test environment used in the step 1 is implemented based on an Oracle database, and the data types of the Oracle database include a numeric type, a character type, and a date-time type.
3. The method according to claim 1, wherein the test scheme in step 2 is a compatibility test based on the requirements and characteristics of a pressure test, and the pressure compatibility test adopts two configuration schemes, namely computationally intensive and I/O intensive.
4. The method according to claim 1, wherein the regular business operations in the step 4 include four aspects of adding, modifying, deleting and querying operations, and the abnormal condition processing includes two aspects of data type mismatch and length limitation.
5. The method according to claim 1, wherein the comparison test pattern in the step 5 includes three patterns, namely an oltp_read_only pattern, an oltp_read_write pattern and an oltp_write_only pattern.
6. The database compatibility testing device according to claim 1, comprising a test development and debugging module, a connection management module, a data storage module, a test execution module, a result comparison module and a report output module;
the development and debugging module is used for debugging the Oracle database environment for testing, so that an application program and data which need to be subjected to database compatibility test can be established on the Oracle database for testing, and the application program has a foundation for carrying out compatibility test;
the connection management module is used for realizing connection between the Oracle database and the application program, uploading connection operation of the application program and data, and connection and uploading of different equipment ports can be realized through the connection management module, so that the database compatibility is convenient to use;
the data storage module is used for carrying out storage operation on data and application programs for carrying out compatibility pressure test;
the test execution module is used for executing application programs and data on the Oracle database, and can realize adjustment operation on each item of data in the data test process according to actual test requirements, so that the accuracy and the diversity of the test are further improved;
the result comparison module is used for performing multi-aspect comparison operation on the compatibility test result, and can summarize, count and analyze various different comparison results, so that the test result can be conveniently used and checked;
and the report output module is used for outputting the results of summarizing, counting and analyzing by the comparison module.
7. The database compatibility testing apparatus of claim 6, wherein the data storage module is a flash memory device capable of realizing data storage, the data storage module is a hard disk, the result comparison module comprises a display device and a comparison program, the display device is a display, and the report output module is a printing device or a wireless data transmission device.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311180382.6A CN117271318A (en) | 2023-09-13 | 2023-09-13 | Database compatibility testing method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311180382.6A CN117271318A (en) | 2023-09-13 | 2023-09-13 | Database compatibility testing method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN117271318A true CN117271318A (en) | 2023-12-22 |
Family
ID=89205419
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202311180382.6A Pending CN117271318A (en) | 2023-09-13 | 2023-09-13 | Database compatibility testing method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN117271318A (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109240926A (en) * | 2018-09-06 | 2019-01-18 | 郑州云海信息技术有限公司 | A kind of software compatibility system safety testing device and method |
| CN112148591A (en) * | 2020-08-28 | 2020-12-29 | 南京轩世琪源软件科技有限公司 | Office software compatibility test system and method |
| CN114817213A (en) * | 2022-05-31 | 2022-07-29 | 苏州浪潮智能科技有限公司 | Server database tuning test method, device, terminal and storage medium |
| CN114936145A (en) * | 2022-04-07 | 2022-08-23 | 支付宝(杭州)信息技术有限公司 | Database test method and device, storage medium and database pressure test device |
| CN115114165A (en) * | 2022-07-04 | 2022-09-27 | 扬州拜客特信息科技有限公司 | Office software compatibility testing method |
-
2023
- 2023-09-13 CN CN202311180382.6A patent/CN117271318A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109240926A (en) * | 2018-09-06 | 2019-01-18 | 郑州云海信息技术有限公司 | A kind of software compatibility system safety testing device and method |
| CN112148591A (en) * | 2020-08-28 | 2020-12-29 | 南京轩世琪源软件科技有限公司 | Office software compatibility test system and method |
| CN114936145A (en) * | 2022-04-07 | 2022-08-23 | 支付宝(杭州)信息技术有限公司 | Database test method and device, storage medium and database pressure test device |
| CN114817213A (en) * | 2022-05-31 | 2022-07-29 | 苏州浪潮智能科技有限公司 | Server database tuning test method, device, terminal and storage medium |
| CN115114165A (en) * | 2022-07-04 | 2022-09-27 | 扬州拜客特信息科技有限公司 | Office software compatibility testing method |
Non-Patent Citations (2)
| Title |
|---|
| 冰河: "我在真实场景下对几款主流云原生数据库进行极限性能压测的一次总结！！！", pages 1 - 11, Retrieved from the Internet <URL:https://www.51cto.com/article/714557.html> * |
| 泽众云测试: "什么是数据兼容性测试", pages 1, Retrieved from the Internet <URL:https://blog.sina.com.cn/s/blog_d72279e901030hot.html> * |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US8386419B2 (en) | Data extraction and testing method and system | |
| US20110153594A1 (en) | Apparatus and Method for Analyzing Query Optimizer Performance | |
| CN111863649B (en) | Finished product testing method and device of chip, terminal equipment and storage medium | |
| CN111813653B (en) | Data exception testing method and automatic testing tool related to field content | |
| CN113656174A (en) | Resource allocation method, system, computer device and storage medium | |
| CN112328483A (en) | Report testing method and device, computer equipment and computer readable storage medium | |
| CN108897765A (en) | A kind of batch data introduction method and its system | |
| CN108984575B (en) | Three-dimensional system integrated circuit wafer test probe station data structure storage method | |
| CN115329556A (en) | Transformer substation CAD drawing auditing method and device | |
| CN114996127A (en) | Intelligent test method and system for solid state disk firmware module | |
| CN111737148A (en) | Automatic regression testing method and device, computer equipment and storage medium | |
| CN117271318A (en) | Database compatibility testing method and device | |
| CN114185867A (en) | Method and device for confirming data consistency and electronic equipment | |
| CN116991750A (en) | Pressure test method for realizing large concurrency simulation by utilizing multithreading and distributed agents | |
| CN109116263B (en) | Multi-power supply product load test equipment and test method | |
| CN116627844A (en) | Database testing method and system | |
| CN108399196B (en) | Automatic sql execution method and system of database sql statement automatic generation tool | |
| CN107273293B (en) | Big data system performance test method and device and electronic equipment | |
| CN115794639A (en) | Visual test and visual simulation test system and method based on process | |
| CN114077600A (en) | ARM (advanced RISC machine) kernel-based data heterogeneous migration visual analysis method | |
| CN113538725A (en) | Hardware product testing method and related equipment | |
| CN113220726A (en) | Data quality detection method and system | |
| CN115879665B (en) | Method and equipment for determining inspection requirements of product configuration and identifying product configuration | |
| CN115640208A (en) | Test data processing system | |
| CN114637762A (en) | Method and device for generating operation record and electronic equipment |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |