CN109902027B - TPC-DS testing method and system convenient to implement - Google Patents
TPC-DS testing method and system convenient to implement Download PDFInfo
- Publication number
- CN109902027B CN109902027B CN201910253172.2A CN201910253172A CN109902027B CN 109902027 B CN109902027 B CN 109902027B CN 201910253172 A CN201910253172 A CN 201910253172A CN 109902027 B CN109902027 B CN 109902027B
- Authority
- CN
- China
- Prior art keywords
- test
- database
- tested
- tpc
- data query
- 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.)
- Active
Links
- 238000012360 testing method Methods 0.000 title claims abstract description 405
- 239000008186 active pharmaceutical agent Substances 0.000 title claims abstract description 148
- 230000004044 response Effects 0.000 claims abstract description 32
- 238000000034 method Methods 0.000 claims abstract description 25
- 238000010998 test method Methods 0.000 claims abstract description 8
- 238000012423 maintenance Methods 0.000 claims abstract description 6
- 238000004590 computer program Methods 0.000 description 10
- 238000012545 processing Methods 0.000 description 8
- 238000010586 diagram Methods 0.000 description 7
- 230000008878 coupling Effects 0.000 description 6
- 238000010168 coupling process Methods 0.000 description 6
- 238000005859 coupling reaction Methods 0.000 description 6
- 230000006870 function Effects 0.000 description 6
- 230000008569 process Effects 0.000 description 6
- 238000004891 communication Methods 0.000 description 4
- 238000002955 isolation Methods 0.000 description 4
- 238000012544 monitoring process Methods 0.000 description 2
- 230000005540 biological transmission Effects 0.000 description 1
- 230000001413 cellular effect Effects 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 239000000463 material Substances 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 239000007787 solid Substances 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 238000012546 transfer Methods 0.000 description 1
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Debugging And Monitoring (AREA)
Abstract
The application provides a TPC-DS test method and a TPC-DS test system which are convenient to implement. The method comprises the following steps: the method comprises the steps that a test system receives a test request initiated by UE, the test request is used for requesting to carry out TPC-DS test on a database to be tested, and the test request carries a database ID of the database to be tested; the test system acquires a backup file of the database to be tested from the server according to the database ID; the testing system deploys backup files of a database to be tested on physical equipment; the test system sends a data query request and a data update request to a database to be tested according to the TPC-DS test, wherein the data query request is used for carrying out the data query test corresponding to the TPC-DS test on the database to be tested, and the data update request is used for carrying out the data maintenance operation corresponding to the TPC-DS test on the database to be tested; the test system acquires the response results of the database to be tested to the data query request and the data update request; and the test system counts the response result to form a TPC-DS test result.
Description
Technical Field
The present application relates to the field of databases, and in particular, to a TPC-DS testing method and system that are easy to implement.
Background
With the rapid increase of information amount, the size of a Database System (DB) is also getting larger, and therefore, a Transaction Process Performance committee (TPC) provides a TPC-DS test reference, which is adapted to the development of the DB nowadays to replace the originally derived TPC-H test reference, so as to more truly evaluate the Performance of the DB.
However, it is understood that the TPC-DS test standard is a test specification, and in practical applications, how to implement the TPC-DS test standard on an actual test tool needs to be specifically designed and optimized so as to perform TPC-DS test on the database to be tested.
For example, in practical applications, after a TPC-DS test is performed on a database to be tested, it is often found that data residues of the TPC-DS test are left in the database to be tested, obviously, certain storage resources of the database to be tested are occupied, and if the data residues are to be removed, certain costs of manpower and material resources are consumed.
Disclosure of Invention
The application provides a TPC-DS test method and a TPC-DS test system which are convenient to implement.
In a first aspect, the present application provides a TPC-DS testing method that is easy to implement, the method comprising:
a test system receives a test request initiated by User Equipment (UE), wherein the test request is used for requesting to carry out TPC-DS test on a database to be tested, and the test request carries a database Identification (ID) of the database to be tested;
the test system acquires the backup file of the database to be tested from a server according to the database ID;
the test system deploys the backup files of the database to be tested on physical equipment to run the database to be tested;
the test system sends a data query request and a data update request to the database to be tested according to the TPC-DS test, wherein the data query request is used for carrying out the data query test corresponding to the TPC-DS test on the database to be tested, and the data update request is used for carrying out the data update test corresponding to the TPC-DS test on the database to be tested;
the test system acquires the response results of the database to be tested to the data query request and the data update request;
and the test system counts the response results of the data query request and the data update request to form a TPC-DS test result.
Optionally, the method further comprises:
the testing system acquires a Structured Query Language (SQL) file corresponding to the database to be tested from the server according to the database ID, wherein the SQL file is used for carrying out data Query testing on the database to be tested;
the test system analyzes the SQL file to obtain a plurality of data query requests.
Optionally, the method further comprises:
the test system generates an SQL file corresponding to the database to be tested, and the SQL file is used for carrying out data query test on the database to be tested;
the test system analyzes the SQL file to obtain a plurality of data query requests.
Optionally, the TPC-DS test includes a power test and a throughput test,
the test system randomly arranges and combines 99 data query requests according to the power test to obtain a power test case set;
the test system sequentially sends data query requests in the power test case set to a database to be tested according to the sequence of the power test case set;
the test system randomly arranges and combines the data query requests and the data update requests according to the throughput test to obtain a throughput test case set, wherein each throughput test case in the throughput test case set comprises 99 data query requests and a plurality of data update requests;
and the test system sequentially sends the throughput test cases in the throughput test case set to the database to be tested according to the sequence of the throughput test case set. Optionally, the method further comprises:
the test system adds a database ID in the TPC-DS test result;
the test system saves the TPC-DS test result;
and the test system sends the TPC-DS test result to the UE.
In a second aspect, the present application provides a test system, the system comprising:
the receiving unit is used for receiving a test request initiated by the UE, the test request is used for requesting to carry out TPC-DS test on a database to be tested, and the test request carries a database ID of the database to be tested;
the acquisition unit is used for acquiring the backup file of the database to be tested from the server according to the database ID;
the deployment unit is used for deploying the backup files of the database to be tested on the physical equipment so as to run the database to be tested;
the device comprises a sending unit, a data updating unit and a data processing unit, wherein the sending unit is used for sending a data query request and a data updating request to a database to be tested according to a TPC-DS test, the data query request is used for carrying out the data query test of the TPC-DS test on the database to be tested, and the data updating request is used for carrying out the data maintenance operation of the TPC-DS test on the database to be tested;
the acquisition unit is also used for acquiring the response results of the database to be tested to the data query request and the data update request;
and the statistical unit is used for counting the response results of the data query request and the data update request to form a TPC-DS test result.
Optionally, the obtaining unit is further configured to obtain, according to the database ID, an SQL file corresponding to the database to be tested from the server, where the SQL file is used to perform a data query test on the database to be tested;
the system further comprises:
and the analysis unit is used for analyzing the SQL file to obtain a plurality of data query requests.
Optionally, the system further comprises:
the generating unit is used for generating an SQL file corresponding to the database to be tested according to the database to be tested, and the SQL file is used for carrying out data query test on the database to be tested;
and the analysis unit is used for analyzing the SQL file to obtain a plurality of data query requests.
Optionally, the TPC-DS test includes a power test and a throughput test, and the transmitting unit is specifically configured to:
according to the power test, 99 data query requests are randomly arranged and combined to obtain a power test case set;
sequentially sending data query requests in the power test case set to a database to be tested according to the sequence of the power test case set;
according to the throughput test, randomly arranging and combining the data query requests and the data updating requests to obtain a throughput test case set, wherein each throughput test case in the throughput test case set comprises 99 data query requests and a plurality of data updating requests;
and sequentially sending the throughput test cases in the throughput test case set to the database to be tested according to the sequence of the throughput test case set.
Optionally, the system further comprises:
the adding unit is used for adding the database ID in the TPC-DS test result;
the storage unit is used for storing the TPC-DS test result;
and the sending unit is also used for sending the TPC-DS test result to the UE.
In a third aspect, the present application provides a test system comprising a processor for implementing any of the steps of the TPC-DS test method as described above in relation to the first aspect when executing a computer program stored in a memory.
In a fourth aspect, the present application provides a readable storage medium having stored thereon a computer program which, when executed by a processor, performs any of the steps of the TPC-DS testing method as described above in relation to the first aspect, which is convenient to implement.
According to the technical scheme, the method has the following advantages:
because the TPC-DS test is realized based on the backup file of the database to be tested, in other words, in the TPC-DS test, the copy database of the database to be tested is taken as a test object, physical isolation is realized, the influence of the TPC-DS test and the normal work of the original database to be tested caused by each other is avoided when the TPC-DS test directly takes the original database to be tested on the server as the test object, the copy database can be directly unloaded after the test is finished, the data residue of the TPC-DS test is avoided being left in the original database to be tested, in addition, the normal work of the original database to be tested can be maintained on the server, the TPC-DS test of the original database to be tested can be finished by taking the copy database as the test object on the other side, the implementation of the TPC-DS test is facilitated, and the test accuracy of the TPC-DS test can be, and the performance of the database to be tested is more accurately evaluated based on the TPC-DS test standard.
Drawings
FIG. 1 is a schematic diagram illustrating a scenario of a TPC-DS testing method provided by the present application;
FIG. 2 is a schematic flow chart of a TPC-DS testing method provided by the present application;
FIG. 3 is a schematic flow chart illustrating a TPC-DS testing method provided by the present application;
FIG. 4 is a schematic diagram of an embodiment of a test system provided herein;
fig. 5 shows a schematic structural diagram of a test system provided in the present application.
Detailed Description
The application provides a TPC-DS test method and a TPC-DS test system which are convenient to implement.
The technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only a part of the embodiments of the present application, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.
The terms "first," "second," and the like in the description and in the claims of the present application and in the above-described drawings are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It will be appreciated that the data so used may be interchanged under appropriate circumstances such that the embodiments described herein may be practiced otherwise than as specifically illustrated or described herein. Moreover, the terms "comprises," "comprising," and any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or modules is not necessarily limited to those steps or modules explicitly listed, but may include other steps or modules not expressly listed or inherent to such process, method, article, or apparatus. The naming or numbering of the steps appearing in the present application does not mean that the steps in the method flow have to be executed in the chronological/logical order indicated by the naming or numbering, and the named or numbered process steps may be executed in a modified order depending on the technical purpose to be achieved, as long as the same or similar technical effects are achieved.
The division of the modules presented in this application is a logical division, and in practical applications, there may be another division, for example, multiple modules may be combined or integrated into another system, or some features may be omitted, or not executed, and in addition, the shown or discussed coupling or direct coupling or communication connection between each other may be through some interfaces, and the indirect coupling or communication connection between the modules may be in an electrical or other similar form, which is not limited in this application. The modules or sub-modules described as separate components may or may not be physically separated, may or may not be physical modules, or may be distributed in a plurality of circuit modules, and some or all of the modules may be selected according to actual needs to achieve the purpose of the present disclosure.
First, before introducing the present application, referring to fig. 1, fig. 1 shows a scene schematic diagram of a TPC-DS testing method provided by the present application, as shown in fig. 1, a user may initiate a test request to a testing system through a UE, the testing system obtains a backup file of a database to be tested from a server according to the request and deploys the backup file on a physical device to operate, the testing system sends a data query request and a data update request of a TPC-DS test to the database to be tested, and obtains a response result of the database to be tested to the data query request and the data update request, so as to form a TPC-DS testing result of the database to be tested.
The TPC-DS test is realized based on the backup file of the database to be tested, in other words, in the TPC-DS test, the copy database of the database to be tested is taken as a test object, physical isolation is realized, and the copy database can be directly unloaded after the test is finished, so that the data residue of the TPC-DS test left in the original database to be tested can be avoided, and the implementation of the TPC-DS test is facilitated.
Secondly, in the present application, the UE may include a terminal device such as a smart phone, a tablet computer, a Personal Digital Assistant (PDA), a laptop computer, a computer all-in-one machine, and a desktop computer, and the UE may establish a network connection with the test system, and the user may initiate a test request of the TPC-DS test to the test system through interpersonal interaction with the UE.
Specifically, the test system may adopt a Client/Server (Client/Server) architecture, and a Client side and a Server side related to the test system are respectively deployed on different physical devices; alternatively, the test system may also adopt a host architecture, and deploy the client side and the server side on the same physical device. The client side is used for receiving the test request initiated by the UE and sending a corresponding data query request and a data update request to the server side, the server side sends the data query request and the data update request to the database to be tested for response and obtaining a response result, the response result is fed back to the client side, and the client side forms a TPC-DS test result of the database to be tested.
It should be understood that, in the present application, the duplicate database of the database to be tested and the test system may also be deployed on the same physical device by means of a container, a virtual machine, or the like; or, the duplicate database of the database to be tested and the server side of the test system may also be deployed on the same physical device, which is not limited herein.
Then, returning to the server shown in fig. 1, in the present application, the server may be deployed with the original database to be tested; or, a cloud platform may be established through the server, the cloud platform stores one or more backup files of the database to be tested, and the test system calls the backup file of the target database to be tested to perform the corresponding TPC-DS test, which is not limited herein.
Next, a detailed description of the method provided in the present application is started based on the scene diagram shown in fig. 1.
Referring to fig. 2, fig. 2 is a schematic flow chart of the TPC-DS testing method convenient to implement, and in particular, the TPC-DS testing method convenient to implement may include the following steps:
step S201, a test system receives a test request initiated by UE;
the test request is used for requesting to carry out TPC-DS test on the database to be tested, and the test request carries the database ID of the database to be tested.
It can be understood that a user, or a worker responsible for the TPC-DS test, may initiate a test request for the TPC-DS test of the target database to be tested to the test system through the UE.
The method includes the steps that a worker can manually input a database ID of a database to be tested, or the database to be tested can be selected from a plurality of databases available for selection, UE can obtain the database ID of the database to be tested, the database ID is used for identifying the database, and a server can locate the database to be tested or a related file of the database to be tested when the server obtains the database ID.
Step S202, the test system obtains a backup file of a database to be tested from a server according to the database ID;
after receiving a test request initiated by the UE and obtaining the database ID of the database to be tested from the test request, the test system can obtain the backup file of the database to be tested from the server through network connection with the server.
In the first case, the server may directly deploy the database to be tested, so that the test system may obtain the backup file of the database to be tested by synchronizing and copying the database; in the second case, the server stores backup files of a plurality of databases, and the test system can directly obtain the database backup files which are also provided with the database ID or matched with the database ID according to the database ID.
For convenience of description, the following description will be given taking a case where a server stores backup files of a plurality of databases as an example.
Step S203, the test system deploys backup files of the database to be tested on the physical equipment to run the database to be tested;
after the backup file of the database to be tested is obtained, the testing system can be deployed and restored on the physical equipment of the physical equipment, and then the testing system runs to build the database to be tested for TPC-DS testing.
Step S204, the test system sends a data query request and a data update request to a database to be tested according to the TPC-DS test;
the data query request is used for carrying out data query tests corresponding to the TPC-DS tests on the database to be tested, and the data update request is used for carrying out data maintenance operations corresponding to the TPC-DS tests on the database to be tested.
After the database to be tested is built, the test system can send a corresponding data query request and a data update request to the database to be tested according to the test reference of the TPC-DS test, so that the database to be tested carries out corresponding response of the TPC-DS test.
Step S205, the test system obtains the response results of the database to be tested to the data query request and the data update request;
it can be understood that the database to be tested responds when receiving the data query request and the data update request, and in the response process, the test system can obtain the response result of the database to be tested to the data query request and the data update request through retrieval, monitoring and other modes.
Step S206, the test system counts the response results of the data query request and the data update request to form a TPC-DS test result.
After the response results of the database to be tested to the data query request and the data update request are obtained, the test system can perform statistical processing to obtain the TPC-DS test result.
It can be seen from the above that, since the TPC-DS test is implemented based on the backup file of the database to be tested, in other words, in the TPC-DS test, the duplicate database of the database to be tested is used as the test object, physical isolation is implemented, so as to avoid the influence between the TPC-DS test and the normal operation of the original database to be tested when the TPC-DS test directly uses the original database to be tested on the server as the test object, the duplicate database can be directly unloaded after the test is finished, so as to avoid leaving the data residue of the TPC-DS test in the original database to be tested, besides, the normal operation of the original database to be tested can be maintained on the server, and the duplicate database can be used as the test object to complete the TPC-DS test on the original database to be tested, which is convenient for the implementation of the TPC-DS test, and further improves the test accuracy of the TPC-DS test, and the performance of the database to be tested is more accurately evaluated based on the TPC-DS test standard.
With continued reference to fig. 3, fig. 3 is a schematic flow chart of a TPC-DS testing method convenient to implement, and in particular, the TPC-DS testing method convenient to implement may include the following steps:
step S301, UE initiates a test request to a test system;
the test request is used for requesting to carry out TPC-DS test on the database to be tested, and the test request carries the database ID of the database to be tested.
Step S302, the test system obtains a backup file of a database to be tested from a server according to the database ID;
it is understood that step S301 and step S302 are the same as the repetition of step S201 and step S202 in the embodiment corresponding to fig. 2, and detailed description thereof is omitted here.
A cloud platform or transfer equipment can be further built between the UE and the test system, and remote transmission of information such as test requests between the UE and the test system is achieved.
Step S303, the test system acquires an SQL file corresponding to the database to be tested from the server according to the database ID;
the SQL file is used for carrying out data query test on the database to be tested.
Step S304, the test system analyzes the SQL file to obtain a plurality of data query requests;
it can be understood that the TPC-DS test reference provides a source code, and generates an executable file of the syntax rule of the database to be tested by compiling, where the executable file is an SQL file, and the format of the SQL file may be as follows:
and then, the SQL file is analyzed to obtain 99 data query requests, which may also be referred to as data query statements.
In the application, the server can store the backup file of the database to be tested, and can also generate and store the SQL file corresponding to the database to be tested, so that a subsequent test system can be conveniently and directly called to perform TPC-DS test.
Alternatively, the generation of the SQL file may be performed by the test system, which is not limited herein.
Step S305, the test system deploys the backup files of the database to be tested on the physical equipment to run the database to be tested;
after the backup file of the database to be tested is obtained, the testing system can be deployed on the physical equipment of the physical equipment, operates, and builds the database to be tested for TPC-DS testing.
Step S306, the test system randomly arranges and combines 99 data query requests according to the power test to obtain a power test case set;
the power test case set is used for testing response processing of the database to be tested to each data query request.
Step S307, the test system sends data query requests in the power test case set to the database to be tested in sequence according to the sequence of the power test case set;
step S308, the test system randomly arranges and combines the data query request and the data update request according to the throughput test to obtain a throughput test case set;
each throughput test case in the throughput test case set comprises 99 data query requests and a plurality of data update requests. .
Step S309, the test system sends the throughput test cases in the throughput test case set to the database to be tested in sequence according to the sequence of the throughput test case set;
it is understood that in the TPC-DS test, two stages of power test and throughput test are included.
And a power test stage, which is used for testing the response processing of the to-be-tested database to each data query request, so that 99 data query requests are randomly arranged and combined, and then are sent to the to-be-tested database one by one according to the sequence, so that the to-be-tested database executes the data query requests one by one, and the response results such as the response time of the to-be-tested database to each data query request can be counted.
And a throughput testing stage, configured to test response processing of the database to be tested to the multiple concurrent data query requests and the data update requests, that is, throughput concurrent testing, so that first, 99 data query requests and data update requests are randomly arranged and combined, and each throughput testing example includes 99 data query requests and multiple data update requests.
Step S310, the test system obtains the response results of the database to be tested to the data query request and the data update request;
it can be understood that the database to be tested responds when receiving the data query request and the data update request, and in the response process, the test system can obtain the response result of the database to be tested to the data query request and the data update request through retrieval, monitoring and other modes.
Step S311, the test system counts the response results of the data query request and the data update request to form a TPC-DS test result;
after the response results of the database to be tested to the data query request and the data update request are obtained, the test system can perform statistical processing to obtain the TPC-DS test result.
Step S312, the test system adds a database ID in the TPC-DS test result;
correspondingly, the database ID of the database to be tested is added in the TPC-DS test result so as to be identified and bound with the database to be tested.
It will be appreciated that after the addition of the database ID, the test system may locally save the TPC-DS test results.
In addition, the server can store the backup file of the database to be tested and the SQL file corresponding to the database to be tested, and can also store the TPC-DS test result of the database to be tested, so that the complete TPC-DS test record of the database to be tested can be stored in the server.
Step S313, the test system sends the TPC-DS test result to the server;
after the database ID is added, the test system can send the TPC-DS test result to the server.
Step S314, the test system sends the TPC-DS test result to the UE.
Of course, in addition to sending the TPC-DS test result to the server, the test system may also send the TPC-DS test result to the UE, so that the user can directly view the TPC-DS test result of the database to be tested in the first time.
The above is an introduction of the TPC-DS test method provided by the present application, which is easy to implement, and the following begins to introduce the test system provided by the present application.
Referring to fig. 4, fig. 4 shows a schematic structural diagram of the test system provided by the present application, specifically, the test system provided by the present application may include the following structure:
a receiving unit 401, configured to receive a test request initiated by a UE, where the test request is used to request a TPC-DS test on a database to be tested, and the test request carries a database ID of the database to be tested;
an obtaining unit 402, configured to obtain a backup file of a database to be tested from a server according to a database ID;
a deployment unit 403, configured to deploy, on the physical device, a backup file of the database to be tested to run the database to be tested;
a sending unit 404, configured to send a data query request and a data update request to a to-be-tested database according to a TPC-DS test, where the data query request is used to perform a data query test of the TPC-DS test on the to-be-tested database, and the data update request is used to perform a data maintenance operation of the TPC-DS test on the to-be-tested database;
the obtaining unit 402 is further configured to obtain response results of the database to be tested for the data query request and the data update request;
the statistic unit 405 is configured to count response results of the data query request and the data update request to form a TPC-DS test result.
Further, the obtaining unit 402 is further configured to obtain, according to the database ID, an SQL file corresponding to the database to be tested from the server, where the SQL file is used to perform data query test on the database to be tested;
the system further comprises:
the parsing unit 406 is configured to parse the SQL file to obtain a plurality of data query requests.
Further, the system further comprises:
the generating unit 407 is configured to generate an SQL file corresponding to the database to be tested according to the database to be tested, where the SQL file is used to perform a data query test on the database to be tested;
the parsing unit 408 is configured to parse the SQL file to obtain a plurality of data query requests.
Further, the TPC-DS test includes a power test and a throughput test, and the sending unit 404 is specifically configured to:
according to the power test, 99 data query requests are randomly arranged and combined to obtain a power test case set;
sequentially sending data query requests in the power test case set to a database to be tested according to the sequence of the power test case set;
according to the throughput test, randomly arranging and combining the data query requests and the data updating requests to obtain a throughput test case set, wherein each throughput test case in the throughput test case set comprises 99 data query requests and a plurality of data updating requests;
and sequentially sending the throughput test cases in the throughput test case set to the database to be tested according to the sequence of the throughput test case set.
Further, the system further comprises:
an adding unit 409, configured to add a database ID to the TPC-DS test result;
a saving unit 410, configured to save the TPC-DS test result;
the sending unit 404 is further configured to send the TPC-DS test result to the UE.
Referring to fig. 5, fig. 5 is a schematic diagram illustrating another structure of the test system provided by the present application, specifically, the test system provided by the present application includes a processor 501, and when the processor 501 is used to execute a computer program stored in a memory 502, the steps of the TPC-DS test method that are convenient to implement in the embodiment corresponding to fig. 2 or fig. 3 are implemented; alternatively, the processor 501 is configured to implement the functions of the units in the corresponding embodiment of fig. 4 when executing the computer program stored in the memory 502.
Illustratively, a computer program may be partitioned into one or more modules/units, which are stored in memory 502 and executed by processor 501 to accomplish the present application. One or more modules/units may be a series of computer program instruction segments capable of performing certain functions, the instruction segments being used to describe the execution of a computer program in a computer device.
The test system may include, but is not limited to, a processor 501, a memory 502. It will be appreciated by those skilled in the art that the illustration is merely an example of a computer apparatus and does not constitute a limitation of the test system, and may include more or less components than those illustrated, or some components in combination, or different components, for example, the test system may further include input output devices, network access devices, buses, etc., through which the processor 501, the memory 502, the input output devices, the network access devices, etc., are connected.
The Processor 501 may be a Central Processing Unit (CPU), other general purpose Processor, a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), an off-the-shelf Programmable Gate Array (FPGA) or other Programmable logic device, discrete Gate or transistor logic device, discrete hardware component, etc. The general purpose processor may be a microprocessor or the processor may be any conventional processor or the like, the processor being the control center of the computer device and the various interfaces and lines connecting the various parts of the overall computer device.
The memory 502 may be used to store computer programs and/or modules, and the processor 501 may implement various functions of the computer device by running or executing the computer programs and/or modules stored in the memory 502, as well as invoking data stored in the memory 502. The memory 502 may mainly include a program storage area and a data storage area, wherein the program storage area may store an operating system, an application program required by at least one function (such as a sound playing function, an image playing function, etc.), and the like; the storage data area may store data (such as audio data, video data, etc.) created according to the use of the cellular phone, etc. In addition, the memory may include high speed random access memory, and may also include non-volatile memory, such as a hard disk, a memory, a plug-in hard disk, a Smart Media Card (SMC), a Secure Digital (SD) Card, a flash memory Card (FlashCard), at least one magnetic disk storage device, a flash memory device, or other volatile solid state storage device.
The present application also provides a readable storage medium having stored thereon a computer program which, when executed by a processor, implements a TPC-DS testing method as in the corresponding embodiments of fig. 2 or fig. 3, which is convenient to implement.
It will be appreciated that the integrated unit, if implemented as a software functional unit and sold or used as a stand-alone product, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present application may be substantially implemented or contributed to by the prior art, or all or part of the technical solution may be embodied in the form of a software product stored in a storage medium and including instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method embodiments of the present application. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-only Memory (ROM), a Random Access Memory (RAM), a magnetic disk or an optical disk, and other various media capable of storing program codes.
It is clear to those skilled in the art that, for convenience and brevity of description, the above-described specific working process of the test system and the units thereof may refer to the description of the TPC-DS test method which is convenient to implement in the embodiment corresponding to fig. 2 or fig. 3, and details thereof are not repeated herein.
In summary, the TPC-DS testing method, system and readable storage medium provided by the present application are easy to implement, because the TPC-DS testing is implemented based on the backup file of the database to be tested, in other words, in the TPC-DS testing, the duplicate database of the database to be tested is used as the testing object, physical isolation is implemented, so as to avoid the influence between the TPC-DS testing and the normal operation of the original database to be tested when the TPC-DS testing directly uses the original database to be tested on the server as the testing object, the duplicate database can be directly unloaded after the testing is finished, so as to avoid leaving the data residue of the TPC-DS testing in the original database to be tested, besides, the normal operation of the original database to be tested can be maintained on the server, and the TPC-DS testing on the original database can be completed by using the duplicate database as the testing object, the implementation of TPC-DS test is facilitated, the test precision of the TPC-DS test can be further improved, and the performance of the database to be tested is more accurately evaluated based on the TPC-DS test standard.
In the embodiments provided in the present application, it should be understood that the disclosed test system and its units may be implemented in other ways. For example, the above-described apparatus embodiments are merely illustrative, and for example, the division of the units is only one logical division, and other divisions may be realized in practice, for example, a plurality of units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, devices or units, and may be in an electrical, mechanical or other form.
The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.
In addition, functional units in the embodiments of the present application may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit.
The above embodiments are only used for illustrating the technical solutions of the present application, and not for limiting the same; although the present application has been described in detail with reference to the foregoing embodiments, it should be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; and such modifications or substitutions do not depart from the spirit and scope of the corresponding technical solutions in the embodiments of the present application.
Claims (8)
1. A TPC-DS test method that is easy to implement, the method comprising:
the method comprises the steps that a test system receives a test request initiated by User Equipment (UE), wherein the test request is used for requesting to carry out TPC-DS test on a database to be tested, and the test request carries a database Identification (ID) of the database to be tested;
the test system acquires a backup file of the database to be tested, which is also provided with the database ID or matched with the database ID, from a server according to the database ID;
the test system deploys the backup files of the database to be tested on physical equipment to run the database to be tested;
the test system sends a data query request and a data update request to the database to be tested according to the TPC-DS test, wherein the data query request is used for carrying out the data query test corresponding to the TPC-DS test on the database to be tested, and the data update request is used for carrying out the data maintenance operation corresponding to the TPC-DS test on the database to be tested;
the test system acquires the response results of the database to be tested to the data query request and the data update request;
the test system counts the response results of the data query request and the data update request to form a TPC-DS test result;
the TPC-DS test comprises a power test and a throughput test, and the step of sending a data query request and a data update request to the database to be tested by the test system according to the TPC-DS test comprises the following steps: the test system randomly arranges and combines 99 data query requests according to the power test to obtain a power test case set; the test system sequentially sends the data query requests in the power test case set to the database to be tested according to the sequence of the power test case set; the test system randomly arranges and combines the data query requests and the data update requests according to the throughput test to obtain a throughput test case set, wherein each throughput test case in the throughput test case set comprises 99 data query requests and a plurality of data update requests; the test system sequentially sends the throughput test cases in the throughput test case set to the database to be tested according to the sequence of the throughput test case set;
and unloading the backup file after the test is finished.
2. The method of claim 1, further comprising:
the test system acquires an SQL file corresponding to the database to be tested from the server according to the database ID, wherein the SQL file is used for carrying out data query test on the database to be tested;
and the test system analyzes the SQL file to obtain a plurality of data query requests.
3. The method of claim 1, further comprising:
the test system generates an SQL file corresponding to the database to be tested, and the SQL file is used for carrying out data query test on the database to be tested;
and the test system analyzes the SQL file to obtain a plurality of data query requests.
4. The method of claim 1, further comprising:
the test system adds the database ID in the TPC-DS test result;
the test system saves the TPC-DS test result;
and the test system sends the TPC-DS test result to the UE.
5. A test system, the system comprising:
a receiving unit, configured to receive a test request initiated by a user equipment UE, where the test request is used to request a TPC-DS test on a database to be tested, and the test request carries a database identifier ID of the database to be tested;
the acquisition unit is used for acquiring the backup file of the database to be tested, which is also provided with the database ID or matched with the database ID, from a server according to the database ID;
the deployment unit is used for deploying the backup files of the database to be tested on the physical equipment so as to run the database to be tested;
a sending unit, configured to send a data query request and a data update request to the database to be tested according to the TPC-DS test, where the data query request is used to perform a data query test of the TPC-DS test on the database to be tested, and the data update request is used to perform a data maintenance operation of the TPC-DS test on the database to be tested;
the obtaining unit is further configured to obtain response results of the database to be tested to the data query request and the data update request;
the statistical unit is used for counting the response results of the data query request and the data update request to form a TPC-DS test result;
the TPC-DS test includes a power test and a throughput test, and the transmitting unit is specifically configured to:
according to the power test, randomly arranging and combining 99 data query requests to obtain a power test case set;
according to the sequence of the power test case set, sequentially sending the data query requests in the power test case set to the database to be tested;
according to the throughput test, randomly arranging and combining the data query requests and the data updating requests to obtain a throughput test case set, wherein each throughput test case in the throughput test case set comprises 99 data query requests and a plurality of data updating requests;
sequentially sending the throughput test cases in the throughput test case set to the database to be tested according to the sequence of the throughput test case set;
and the unloading unit is used for unloading the backup file after the test is finished.
6. The system according to claim 5, wherein the obtaining unit is further configured to obtain, from the server, an SQL file corresponding to the database to be tested according to the database ID, where the SQL file is used to perform the data query test on the database to be tested;
the system further comprises:
and the analysis unit is used for analyzing the SQL file to obtain a plurality of data query requests.
7. The system of claim 5, further comprising:
the generating unit is used for generating an SQL file corresponding to the database to be tested according to the database to be tested, and the SQL file is used for carrying out the data query test on the database to be tested;
and the analysis unit is used for analyzing the SQL file to obtain a plurality of data query requests.
8. The system of claim 5, further comprising:
an adding unit, configured to add the database ID to the TPC-DS test result;
the storage unit is used for storing the TPC-DS test result;
the sending unit is further configured to send the TPC-DS test result to the UE.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910253172.2A CN109902027B (en) | 2019-03-29 | 2019-03-29 | TPC-DS testing method and system convenient to implement |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910253172.2A CN109902027B (en) | 2019-03-29 | 2019-03-29 | TPC-DS testing method and system convenient to implement |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109902027A CN109902027A (en) | 2019-06-18 |
| CN109902027B true CN109902027B (en) | 2020-05-29 |
Family
ID=66955042
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910253172.2A Active CN109902027B (en) | 2019-03-29 | 2019-03-29 | TPC-DS testing method and system convenient to implement |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109902027B (en) |
Families Citing this family (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110457188B (en) * | 2019-06-28 | 2021-02-23 | 武汉迎风聚智科技有限公司 | TPC-E test method and system capable of keeping transaction type proportion |
| CN110457187B (en) * | 2019-06-28 | 2023-05-12 | 武汉迎风聚智科技有限公司 | TPC-E test method and test server capable of conveniently running based on backup test data |
| CN110704300A (en) * | 2019-08-27 | 2020-01-17 | 武汉迎风聚智科技有限公司 | TPC-DS automated test method and TPC-DS test system |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103186561A (en) * | 2011-12-28 | 2013-07-03 | 深圳市金蝶友商电子商务服务有限公司 | Data test method, test library generating method and related device |
| CN105302730A (en) * | 2015-12-09 | 2016-02-03 | 浪潮集团有限公司 | Calculation model detection method, testing server and service platform |
| CN106095624A (en) * | 2016-06-28 | 2016-11-09 | 北京金山安全软件有限公司 | Data recovery method and device, terminal equipment and server |
| CN106547646A (en) * | 2015-09-23 | 2017-03-29 | 阿里巴巴集团控股有限公司 | A kind of data backup and restoration methods, data backup and recovery device |
| CN106681867A (en) * | 2015-11-09 | 2017-05-17 | 阿里巴巴集团控股有限公司 | Testing method and device |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US9858157B2 (en) * | 2012-10-31 | 2018-01-02 | International Business Machines Corporation | Intelligent restore-container service offering for backup validation testing and business resiliency |
-
2019
- 2019-03-29 CN CN201910253172.2A patent/CN109902027B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103186561A (en) * | 2011-12-28 | 2013-07-03 | 深圳市金蝶友商电子商务服务有限公司 | Data test method, test library generating method and related device |
| CN106547646A (en) * | 2015-09-23 | 2017-03-29 | 阿里巴巴集团控股有限公司 | A kind of data backup and restoration methods, data backup and recovery device |
| CN106681867A (en) * | 2015-11-09 | 2017-05-17 | 阿里巴巴集团控股有限公司 | Testing method and device |
| CN105302730A (en) * | 2015-12-09 | 2016-02-03 | 浪潮集团有限公司 | Calculation model detection method, testing server and service platform |
| CN106095624A (en) * | 2016-06-28 | 2016-11-09 | 北京金山安全软件有限公司 | Data recovery method and device, terminal equipment and server |
Non-Patent Citations (1)
| Title |
|---|
| "基于TPC-DS的测试系统研发";何磊;《中国优秀硕士学位论文全文数据库 信息科技辑》;20150115;第I138-397页 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109902027A (en) | 2019-06-18 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20160283357A1 (en) | Call stack relationship acquiring method and apparatus | |
| CN109902027B (en) | TPC-DS testing method and system convenient to implement | |
| CN108920370B (en) | Compatibility problem detection method, device and equipment | |
| CN110134583B (en) | Software testing and data processing method and device | |
| CN110502513B (en) | Data acquisition method, device, equipment and computer readable storage medium | |
| CN110716866A (en) | Code quality scanning method and device, computer equipment and storage medium | |
| CN112306872A (en) | Method, apparatus, and computer apparatus for locating source code in a production environment | |
| CN105871998A (en) | Data displaying method and device | |
| CN111324510B (en) | Log processing method and device and electronic equipment | |
| CN111124480B (en) | Method and device for generating application program package, electronic equipment and storage medium | |
| CN110058995B (en) | Database testing method and system capable of avoiding interference of database types | |
| CN110069406B (en) | Automatic triggering TPC-DS test method and system | |
| CN112380115A (en) | Regression testing method and device, electronic equipment and storage medium | |
| CN110457187B (en) | TPC-E test method and test server capable of conveniently running based on backup test data | |
| US7506212B2 (en) | Distributed exception handling testing | |
| CN113504912A (en) | Real-time task processing method and device, storage medium and electronic device | |
| CN112422682A (en) | Data transmission method and device, storage medium, and electronic device | |
| CN109086145B (en) | Data generation method and device and computer storage medium | |
| CN111552634A (en) | Method and device for testing front-end system and storage medium | |
| CN114840400B (en) | Abnormal component identification method, device, equipment, storage medium and program product | |
| CN114942873B (en) | Capacity detection method and related equipment based on full-link online stress testing | |
| CN110764997B (en) | Database interface conformance testing method and device | |
| CN116303627A (en) | Inquiry method, device, electronic equipment and storage medium for semiconductor test data | |
| CN115437891A (en) | Method and device for generating alarm mail, storage medium and computer equipment | |
| CN115543227B (en) | Cross-system data migration method, system, electronic device and storage medium |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |