CN110069406B - Automatic triggering TPC-DS test method and system - Google Patents
Automatic triggering TPC-DS test method and system Download PDFInfo
- Publication number
- CN110069406B CN110069406B CN201910252079.XA CN201910252079A CN110069406B CN 110069406 B CN110069406 B CN 110069406B CN 201910252079 A CN201910252079 A CN 201910252079A CN 110069406 B CN110069406 B CN 110069406B
- Authority
- CN
- China
- Prior art keywords
- target database
- test
- database
- tpc
- test system
- 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
Images
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/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 application provides an automatic triggering TPC-DS test method and system, which are used for automatically triggering TPC-DS test on a target database which is updated. The TPC-DS testing method capable of being triggered automatically provided by the application comprises the following steps: the method comprises the steps that a test system receives a test request sent by UE, the test request is used for requesting TPC-DS test on a target database when the target database executes a database updating event, and the database updating event is used for updating system data of the target database; the test system monitors whether a target database executes a database updating event or not; if so, the test system triggers a TPC-DS test task of the target database; the test system sends a data processing request to a target database, and the data processing request is used for carrying out TPC-DS test on the target database; the test system acquires a response result of the target database to the data processing request; and the test system analyzes and processes the response result of the data processing request to obtain the TPC-DS test result of the target database.
Description
Technical Field
The present application relates to the field of databases, and in particular, to an automatic triggering TPC-DS testing method and system.
Background
In the Process of popularizing the TPC-DS test reference provided by the Transaction processing Performance Committee (TPC), the TPC-DS test is performed on a target database by mainly developing a corresponding TPC-DS test tool to test the Performance of the target database.
However, in practical applications, the TPC-DS testing tool still needs to be triggered by manual operation, so that the problem still needs to be overcome.
Disclosure of Invention
The application provides an automatic triggering TPC-DS test method and system, which are used for automatically triggering TPC-DS test on a target database which is updated.
In a first aspect, the present application provides an auto-triggered TPC-DS test method, including:
the method comprises the steps that a test system receives a test request sent by User Equipment (UE), the test request is used for requesting to carry out TPC-DS test on a target database when the target database executes a database updating event, and the database updating event is used for updating system data of the target database;
the test system monitors whether a target database executes a database updating event or not;
if so, the test system triggers a TPC-DS test task of the target database;
the test system sends a data processing request to a target database, and the data processing request is used for carrying out TPC-DS test on the target database;
the test system acquires a response result of the target database to the data processing request;
and the test system analyzes and processes the response result of the data processing request to obtain the TPC-DS test result of the target database.
Optionally, the monitoring, by the test system, whether the target database executes the database update event includes:
the testing system monitors whether the target database updates a main version number, a maintenance version number, a component version number or a platform version number;
if so, the test system determines that the target database executes a database update event.
Optionally, the test request carries a database identifier (Identification, ID) of the target database, and the monitoring, by the test system, whether the target database executes a database update event includes:
the test system acquires the installation record of the target database from the server according to the database ID of the target database;
the test system determines at least one physical device of an installation target database according to the installation record;
the testing system monitors whether target physical equipment exists in the physical equipment or not to update a locally installed target database;
if yes, the test system determines that the target database executes a database updating event;
the TPC-DS test task of the test system triggering the target database comprises the following steps:
and the test system triggers the TPC-DS test task with the task object as the target physical equipment.
Optionally, the monitoring, by the test system, whether the target database executes the database update event includes:
the test system monitors whether a program installation package of a target database stored on a server executes a database updating event or not;
before the test system sends the data processing request to the target database, the method further comprises:
the test system acquires a program installation package of a target database from a server;
the test system runs the program installation package to run the target database.
Optionally, the monitoring, by the test system, whether the target database executes the database update event includes:
the test system monitors whether a program installation package of a target database stored on a server executes a database updating event or not;
before the test system sends the data processing request to the target database, the method further comprises:
and the test system sends indication information to the server, wherein the indication information is used for indicating the server to operate the program installation package of the target database so as to operate the target database.
In a second aspect, the present application provides a test system, the system comprising:
a receiving unit, configured to receive a test request sent by a UE, where the test request is used to request that a TPC-DS test be performed on a target database when the target database executes a database update event, and the database update event is used to update system data of the target database;
the monitoring unit is used for monitoring whether the target database executes a database updating event or not, and if so, the triggering unit is triggered;
the trigger unit is used for triggering a TPC-DS test task of the target database;
the device comprises a sending unit, a receiving unit and a processing unit, wherein the sending unit is used for sending a data processing request to a target database, and the data processing request is used for carrying out TPC-DS test on the target database;
the acquisition unit is used for acquiring a response result of the target database to the data processing request;
and the analysis unit is used for carrying out analysis processing on the basis of the response result of the data processing request to obtain the TPC-DS test result of the target database.
Optionally, the monitoring unit is specifically configured to:
monitoring whether the target database updates a main version number, a maintenance version number, a component version number or a platform version number;
if yes, determining that the target database executes the database updating event.
Optionally, the test request carries a database ID of the target database, and the monitoring unit is specifically configured to:
acquiring an installation record of the target database from the server according to the database ID of the target database;
determining at least one physical device of an installation target database according to the installation record;
monitoring whether target physical equipment exists in the physical equipment or not to update a target database installed locally;
if yes, determining that the target database executes a database updating event;
the trigger unit is specifically configured to:
and the trigger task object is a TPC-DS test task of the target physical equipment.
Optionally, the monitoring unit is specifically configured to:
monitoring whether a program installation package of a target database stored on a server executes a database update event;
an acquisition unit further configured to:
acquiring a program installation package of a target database from a server;
the system further comprises:
and the operation unit is used for operating the program installation package so as to operate the target database.
Optionally, the monitoring unit is specifically configured to:
monitoring whether a program installation package of a target database stored on a server executes a database update event;
a sending unit, further configured to:
and sending indication information to the server, wherein the indication information is used for indicating the server to run the program installation package of the target database so as to run the target database.
In a third aspect, the present application provides a test system comprising a processor for implementing any of the steps of the auto-triggering TPC-DS test method according to the first aspect as described above 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 auto-triggering TPC-DS testing method according to the first aspect described above.
According to the technical scheme, the method has the following advantages:
when the test request is received, the test system can trigger a monitoring task of updating the target database, and when the target database is monitored to be updated, the TPC-DS test is automatically carried out on the target database of the latest version at the first time to test the latest performance of the target database, so that the manual trigger of carrying out the TPC-DS test on the target database of the latest version is avoided, the manual operation of workers is greatly simplified, and the test efficiency of the TPC-DS test is improved.
Drawings
FIG. 1 is a schematic diagram illustrating a scenario of an auto-triggering TPC-DS test method provided in the present application;
FIG. 2 is a flow chart illustrating an auto-triggering TPC-DS test method provided by the present application;
FIG. 3 is a schematic flow chart of an auto-triggering TPC-DS test method provided by the present application;
FIG. 4 is a schematic flow chart illustrating a TPC-DS testing method with automatic triggering provided by the present application;
FIG. 5 is a schematic flow chart illustrating a TPC-DS testing method with automatic triggering provided by the present application;
FIG. 6 is a schematic diagram of an embodiment of a test system provided herein;
fig. 7 shows a schematic structural diagram of a test system provided in the present application.
Detailed Description
The application provides an automatic triggering TPC-DS test method and system, which are used for automatically triggering TPC-DS test on a target database which is updated.
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, and the testing system performs a TPC-DS test on a target database after monitoring that the target database executes a database update event according to a trigger of the request, so as to obtain a TPC-DS test result of the target database. As the test system automatically carries out TPC-DS test on the latest version of target database at the first time, the manual trigger of carrying out TPC-DS test on the latest version of target database is avoided, and the test efficiency of the TPC-DS test is greatly improved.
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 Personal computer, a desktop computer, and the like, 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.
The test system can 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 processing request to the server side, the server side sends the data processing request to the target database for response and obtaining a response result, the response result is fed back to the client side, and the client side carries out analysis processing and obtains a TPC-DS test result of the target database.
The server can install a target database; alternatively, the server may also store a program installation package of the target database, 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 shows a flowchart of the auto-triggered TPC-DS testing method provided by the present application, and in particular, the auto-triggered TPC-DS testing method provided by the present application may include the following steps:
step S201, a test system receives a test request sent by UE;
the test request is used for requesting TPC-DS test on the target database when the target database executes a database updating event, and the database updating event is used for updating system data of the target database.
It is understood that the test request may carry a database ID of the target database, identifying the target database to which the test request corresponds.
The data of the database includes system data and user data, and in the present application, the update of the system data of the target database is used as a trigger condition for the TPC-DS test.
In practical applications, the database update event may specifically include database backup, database recovery, lifting of a database version or increasing or decreasing of a functional component, and the like, and is not limited herein.
Step S202, the test system monitors whether the target database executes a database updating event, if so, the step S203 is started;
after receiving the test request, the test system can trigger a monitoring task of the target database, monitor the execution of the target database about a database updating event, and perform subsequent TPC-DS test after monitoring that the target database executes the database updating event.
Step S203, the test system triggers a TPC-DS test task of the target database;
the test system may generate a TPC-DS test task for the target database in the task list and trigger the task to begin performing the TPC-DS test.
Step S204, the test system sends a data processing request to a target database;
and the data processing request is used for carrying out TPC-DS test on the target database.
It is understood that under the test benchmark of the TPC-DS, the data processing request may include a data query statement and a data update statement to test the response of the target database to the data query statement and the data update statement.
Step S205, the test system obtains the response result of the target database to the data processing request;
it can be understood that, in the process of the target database responding to the data processing request, the test system can obtain the response result of the target database to the data processing request through the monitoring of the keyword.
And step S206, the test system carries out analysis processing on the basis of the response result of the data processing request to obtain the TPC-DS test result of the target database.
After the response result of the target database to the data processing request is obtained, the test system can perform analysis processing, such as summary, statistics and conversion processing, so as to obtain an outputtable TPC-DS test result.
It can be seen from the above that, in the TPC-DS testing method provided by the present application, the testing system may trigger the task of monitoring the update of the target database when receiving the test request, and when it is monitored that the target database is updated, the TPC-DS test is automatically performed on the latest version of the target database at the first time to test the latest performance of the target database, so as to avoid manual triggering of the TPC-DS test on the latest version of the target database, greatly simplify manual operations of workers, and improve the testing efficiency of the TPC-DS test.
With continuing reference to fig. 3, fig. 3 is a schematic flow chart of the auto-triggering TPC-DS testing method provided by the present application, and in particular, the auto-triggering TPC-DS testing method provided by the present application may include the following steps:
step S301, a test system receives a test request sent by UE;
the test request is used for requesting TPC-DS test on the target database when the target database executes a database updating event, and the database updating event is used for updating system data of the target database.
It can be understood that the repetition of step S301 and step S201 in fig. 2 is not repeated herein.
Step S302, the test system obtains the installation record of the target database from the server according to the database ID of the target database;
the server can be used for storing installation records of different databases, and each installation record is recorded with physical equipment for installing a corresponding database, so that the test system can obtain the installation records of the target database from the server according to the database ID of the target database.
Step S303, the test system determines at least one physical device for installing the target database according to the installation record;
after obtaining the installation record of the target database from the server, the test system may determine one or more physical devices in which the target database is installed according to the installation record.
Step S304, the test system monitors that the target physical equipment exists in the physical equipment to update the locally installed target database;
it can be understood that, after determining the physical devices installed with the target database, the test system may monitor the physical devices, determine whether there is a physical device in the physical devices that updates the locally installed target database, to determine whether the target database executes a database update event, and if so, determine that the corresponding physical device is the target physical device.
When it is monitored that the target physical device updates the locally installed target database, the test system can determine that the target database executes a database update event.
The test system can specifically monitor whether the target database executes a database update event by monitoring whether the target database updates a major version number, a maintenance version number, a component version number or a platform version number.
Step S305, the test system triggers a TPC-DS test task with a task object as target physical equipment;
after the target physical device is monitored, a TPC-DS test task with a task object as the target physical device can be generated in the task list, and the task is triggered to start to execute TPC-DS test.
Step S306, the test system sends a data processing request to a target database;
and the data processing request is used for carrying out TPC-DS test on the target database.
Step S307, the test system acquires the response result of the target database to the data processing request;
step S308, the test system analyzes and processes the response result of the data processing request to obtain the TPC-DS test result of the target database;
it can be understood that the contents of steps S306 to S308 are repeated from step S204 to step S206 in fig. 2, and are not repeated herein.
The data processing request is sent to a target object of the TPC-DS test task, namely a target database in the target physical device, and correspondingly, a response result required by the TPC-DS test is obtained from the target database in the target physical device.
Step S309, the test system sends the TPC-DS test result to the UE.
After the TPC-DS test result is obtained, the TPC-DS test result can be sent to the UE, so that a user at the UE side can obtain the TPC-DS test result of the target database at the first time.
With continuing reference to fig. 4, fig. 4 is a schematic flow chart of another auto-triggering TPC-DS testing method provided by the present application, and in particular, the auto-triggering TPC-DS testing method provided by the present application may include the following steps:
step S401, a test system receives a test request sent by UE;
the test request is used for requesting TPC-DS test on the target database when the target database executes a database updating event, and the database updating event is used for updating system data of the target database.
It is understood that the repetition of step S401 and step S201 in fig. 2 is not repeated herein.
Step S402, the test system monitors a program installation package of a target database stored on a server to execute a database updating event;
the server may store the program installation package of different databases, in addition to the installation records of different databases as in step S302.
Thus, the test system can locate the program installation package of the target database from the storage space of the server according to the database ID of the target database.
When the program installation package of the target database on the server is monitored to be updated and a database updating event is executed, the test system can determine that the target database executes the database updating event.
The test system can monitor whether the target database updates a main version number, a maintenance version number, a component version number or a platform version number by monitoring the program installation package of the target database to monitor whether the target database executes a database updating event.
Step S403, triggering a TPC-DS test task by the test system;
after monitoring that the program installation package of the target database on the server executes a database updating event, generating a TPC-DS test task in a task list, triggering the task and starting to execute TPC-DS test.
Step S404, the test system obtains an installation package of the target database from the server;
it is understood that the test system may first obtain the installation package of the target database from the server to run the installation package, i.e., run the target database, for the TPC-DS test.
Step S405, the test system sends an installation package of the target database to the physical device;
it should be noted that the test system may run the program installation package of the target database on the physical device where the system is located, and communicate with the target database in a virtual network connection manner; or, other physical devices may be selected to run the program installation package of the target database, which is not limited herein.
For ease of understanding, as shown in fig. 4, the program installation package of the target database is run by a physical device other than the physical device where the test system is located as an example, and the following description is continued.
After the test system acquires the program installation package of the target database from the server, the test system selects to send the program installation package in a preset physical equipment queue, so that the physical equipment runs the target database and assists TPC-DS test.
Step S406, the physical device runs the installation package of the target database to run the target database;
after receiving the program installation package of the target database sent by the test system, the physical device can operate the program installation package and operate the target database.
Step S407, the test system sends a data processing request to a target database;
and the data processing request is used for carrying out TPC-DS test on the target database.
Step S408, the test system acquires the response result of the target database to the data processing request;
step S409, the test system carries out analysis processing on the basis of the response result of the data processing request to obtain the TPC-DS test result of the target database;
it can be understood that the contents of steps S407 to S409, and the contents of steps S204 to S206 in fig. 2 are not repeated herein.
The data processing request is sent to a target database running in the physical device, and correspondingly, a response result required by the TPC-DS test is obtained from the target database running in the physical device.
Step S410, the test system sends the TPC-DS test result to the UE.
After the TPC-DS test result is obtained, the TPC-DS test result can be sent to the UE, so that a user at the UE side can obtain the TPC-DS test result of the target database at the first time.
With continuing reference to fig. 5, fig. 5 is a schematic flow chart of another auto-triggering TPC-DS testing method provided by the present application, and in particular, the auto-triggering TPC-DS testing method provided by the present application may include the following steps:
step S501, a test system receives a test request sent by UE;
the test request is used for requesting TPC-DS test on the target database when the target database executes a database updating event, and the database updating event is used for updating system data of the target database.
Step S502, the test system monitors a program installation package of a target database stored on a server to execute a database updating event;
step S503, the test system triggers a TPC-DS test task;
step S504, the test system sends instruction information to the server;
the indication information is used for indicating the server to operate the program installation package of the target database so as to operate the target database.
It can be understood that, in addition to the deployment of the program installation package of the target database by the test system and the operation of the target database, the program installation package of the target database can be directly operated by the server, the target database can be operated, and the TPC-DS test can be performed, so that the transmission cost required by the program installation package, including the network bandwidth cost and the transmission time cost, can be avoided, and the test efficiency of the TPC-DS can be further improved.
Step S505, the server runs the program installation package of the target database to run the target database;
after receiving the indication information sent by the test system, the server can operate the program installation package of the target database according to the indication of the indication information, and operate the target database.
Step S506, the test system sends a data processing request to a target database;
and the data processing request is used for carrying out TPC-DS test on the target database.
Step S507, the test system obtains the response result of the target database to the data processing request;
step S508, the test system analyzes and processes on the basis of the response result of the data processing request to obtain the TPC-DS test result of the target database;
it can be understood that the repetition of steps S501 to S503, and steps S506 to step 508, and steps S401 to S403, and steps S407 to S409 in fig. 4 are not repeated herein.
The data processing request is sent to a target database running in the server, and correspondingly, a response result required by the TPC-DS test is obtained from the target database running in the server.
Step S509, the test system sends the TPC-DS test result to the UE.
After the TPC-DS test result is obtained, the TPC-DS test result can be sent to the UE, so that a user at the UE side can obtain the TPC-DS test result of the target database at the first time.
The above is an introduction to the automatic triggering TPC-DS test method provided by the present application, and the following begins to introduce the test system provided by the present application.
Referring to fig. 6, fig. 6 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 601, configured to receive a test request sent by a UE, where the test request is used to request that a TPC-DS test be performed on a target database when the target database executes a database update event, and the database update event is used to update system data of the target database;
a monitoring unit 602, configured to monitor whether a target database executes a database update event, and if so, trigger the triggering unit 603;
a triggering unit 603, configured to trigger a TPC-DS test task of the target database;
a sending unit 604, configured to send a data processing request to a target database, where the data processing request is used to perform a TPC-DS test on the target database;
an obtaining unit 605, configured to obtain a response result of the target database to the data processing request;
and the analysis unit 606 is configured to perform analysis processing on the basis of the response result of the data processing request to obtain the TPC-DS test result of the target database.
Optionally, the monitoring unit 602 is specifically configured to:
monitoring whether the target database updates a main version number, a maintenance version number, a component version number or a platform version number;
if yes, determining that the target database executes the database updating event.
Optionally, the test request carries a database ID of the target database, and the monitoring unit 602 is specifically configured to:
acquiring an installation record of the target database from the server according to the database ID of the target database;
determining at least one physical device of an installation target database according to the installation record;
monitoring whether target physical equipment exists in the physical equipment or not to update a target database installed locally;
if yes, determining that the target database executes a database updating event;
the triggering unit 603 is specifically configured to:
and the trigger task object is a TPC-DS test task of the target physical equipment.
Optionally, the monitoring unit 602 is specifically configured to:
monitoring whether a program installation package of a target database stored on a server executes a database update event;
the obtaining unit 605 is further configured to:
acquiring a program installation package of a target database from a server;
the system further comprises:
the execution unit 607 executes the program installation package to execute the target database.
Optionally, the monitoring unit 602 is specifically configured to:
monitoring whether a program installation package of a target database stored on a server executes a database update event;
the sending unit 604 is further configured to:
and sending indication information to the server, wherein the indication information is used for indicating the server to run the program installation package of the target database so as to run the target database.
Referring to fig. 7, fig. 7 is a schematic diagram illustrating another structure of the test system provided in the present application, specifically, the test system provided in the present application includes a processor 701, and when the processor 701 is configured to execute a computer program stored in a memory 702, each step of the automatic triggering TPC-DS test method in any embodiment corresponding to fig. 2 to fig. 5 is implemented; alternatively, the processor 701 is configured to implement the functions of the units in the corresponding embodiment of fig. 6 when executing the computer program stored in the memory 702.
Illustratively, a computer program may be partitioned into one or more modules/units, which are stored in the memory 702 and executed by the processor 701 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 701, a memory 702. 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 that the test system may include more or less components than those illustrated, or some components may be combined, or different components, for example, the test system may further include an input output device, a network access device, a bus, etc., and the processor 701, the memory 702, the input output device, the network access device, etc., are connected via the bus.
The Processor 701 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, discrete hardware components, 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 702 may be used to store computer programs and/or modules, and the processor 701 may implement various functions of the computer apparatus by running or executing the computer programs and/or modules stored in the memory 702 and invoking data stored in the memory 702. The memory 702 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 the auto-triggered TPC-DS testing method as in any of the embodiments corresponding to fig. 2 to 5.
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 can be clearly understood by 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 automatic triggering TPC-DS test method in any embodiment corresponding to fig. 2 to fig. 5, and details thereof are not repeated herein.
In summary, in the TPC-DS testing method, system, and readable storage medium provided by the present application, the testing system may trigger the task of monitoring the update of the target database when receiving the test request, and automatically perform the TPC-DS test on the latest version of the target database at the first time when monitoring that the target database is updated, so as to test the latest performance of the target database, thereby avoiding the manual trigger of performing the TPC-DS test on the latest version of the target database, greatly simplifying the manual operation of the worker, and improving the testing efficiency of the TPC-DS test.
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 (7)
1. An auto-triggering TPC-DS test method, the method comprising:
the method comprises the steps that a test system receives a test request sent by User Equipment (UE), the test request is used for requesting to carry out TPC-DS test on a target database when the target database executes a database updating event, and the database updating event is used for updating system data of the target database;
the test system monitors whether the target database executes the database update event;
if so, triggering a TPC-DS test task of the target database by the test system;
the test system sends a data processing request to the target database, wherein the data processing request is used for carrying out the TPC-DS test on the target database;
the test system acquires a response result of the target database to the data processing request;
the test system carries out analysis processing on the basis of the response result of the data processing request to obtain a TPC-DS test result of the target database;
the test request carries a database identifier ID of the target database, and the monitoring, by the test system, whether the target database executes the database update event includes:
the test system acquires the installation record of the target database from a server according to the database identification ID of the target database;
the test system determines at least one physical device for installing the target database according to the installation record;
the test system monitors whether target physical equipment exists in the physical equipment or not to update the locally installed target database; if yes, the test system determines that the target database executes the database updating event;
the test system triggering the TPC-DS test task of the target database comprises the following steps:
and the test system triggers a task object to be the TPC-DS test task of the target physical equipment.
2. The method of claim 1, wherein the testing system monitoring whether the target database performs the database update event comprises:
the test system monitors whether the target database updates a main version number, a maintenance version number, a component version number or a platform version number;
if yes, the test system determines that the target database executes the database updating event.
3. The method of claim 1, wherein the testing system monitoring whether the target database performs the database update event comprises:
the test system monitors whether a program installation package of the target database stored on a server executes the database updating event;
before the test system executes the data processing request sent to the target database, the method further includes:
the test system acquires a program installation package of the target database from the server;
and the test system runs the program installation package to run the target database.
4. The method of claim 1, wherein the testing system monitoring whether the target database performs the database update event comprises:
the test system monitors whether a program installation package of the target database stored on a server executes the database updating event;
before the test system executes the data processing request sent to the target database, the method further includes:
and the test system sends indication information to the server, wherein the indication information is used for indicating the server to run the program installation package so as to run the target database.
5. A test system, the system comprising:
a receiving unit, configured to receive a test request sent by a user equipment UE, where the test request is used to request that a TPC-DS test be performed on a target database when the target database executes a database update event, where the database update event is used to update system data of the target database;
the monitoring unit is used for monitoring whether the target database executes the database updating event or not, and if so, the triggering unit is triggered;
the trigger unit is used for triggering a TPC-DS test task of the target database;
a sending unit, configured to send a data processing request to the target database, where the data processing request is used to perform the TPC-DS test on the target database;
an obtaining unit, configured to obtain a response result of the target database to the data processing request;
the analysis unit is used for carrying out analysis processing on the basis of the response result of the data processing request to obtain the TPC-DS test result of the target database;
the monitoring unit is specifically configured to:
monitoring whether the target database updates a main version number, a maintenance version number, a component version number or a platform version number;
if yes, determining that the target database executes the database updating event;
the test request carries a database identifier ID of the target database, and the monitoring unit is specifically configured to:
acquiring an installation record of the target database from a server according to the database identification ID of the target database;
determining at least one physical device for installing the target database according to the installation record;
monitoring whether a target physical device exists in the physical devices to update the target database installed locally;
if yes, determining that the target database executes the database updating event;
the trigger unit is specifically configured to:
and triggering a task object to be the TPC-DS test task of the target physical equipment.
6. The system according to claim 5, wherein the monitoring unit is specifically configured to:
monitoring whether a program installation package of the target database stored on a server executes the database update event;
the obtaining unit is further configured to:
acquiring a program installation package of the target database from the server;
the system further comprises:
and the running unit runs the program installation package so as to run the target database.
7. The system according to claim 6, wherein the monitoring unit is specifically configured to:
monitoring whether a program installation package of the target database stored on a server executes the database update event;
the sending unit is further configured to:
and sending indication information to the server, wherein the indication information is used for indicating the server to run the program installation package so as to run the target database.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910252079.XA CN110069406B (en) | 2019-03-29 | 2019-03-29 | Automatic triggering TPC-DS test method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910252079.XA CN110069406B (en) | 2019-03-29 | 2019-03-29 | Automatic triggering TPC-DS test method and system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110069406A CN110069406A (en) | 2019-07-30 |
| CN110069406B true CN110069406B (en) | 2020-08-11 |
Family
ID=67366891
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910252079.XA Active CN110069406B (en) | 2019-03-29 | 2019-03-29 | Automatic triggering TPC-DS test method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110069406B (en) |
Families Citing this family (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110704300A (en) * | 2019-08-27 | 2020-01-17 | 武汉迎风聚智科技有限公司 | TPC-DS automatic test method and TPC-DS test system |
| CN110737594B (en) * | 2019-09-19 | 2021-02-05 | 武汉迎风聚智科技有限公司 | Database standard conformance testing method and device for automatically generating test cases |
| CN113360418B (en) * | 2021-08-10 | 2021-11-05 | 武汉迎风聚智科技有限公司 | System testing method and device |
Family Cites Families (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104951399B (en) * | 2015-06-19 | 2017-11-07 | 北京齐尔布莱特科技有限公司 | A kind of software testing system and method |
| CN106681867B (en) * | 2015-11-09 | 2019-08-30 | 阿里巴巴集团控股有限公司 | A kind of test method and device |
| JP6848340B2 (en) * | 2016-10-25 | 2021-03-24 | 株式会社リコー | Information processing system, update method, information processing device and program |
-
2019
- 2019-03-29 CN CN201910252079.XA patent/CN110069406B/en active Active
Also Published As
| Publication number | Publication date |
|---|---|
| CN110069406A (en) | 2019-07-30 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110069406B (en) | Automatic triggering TPC-DS test method and system | |
| EP2838228B1 (en) | Alarm correlation analysis method, apparatus, and system | |
| US20160154665A1 (en) | Virtual machine deployment method, virtual machine deployment program, and virtual machine deployment system | |
| CN111258680B (en) | Resource loading method and device, storage medium and electronic device | |
| CN107678948B (en) | Test case generation method, terminal and storage medium | |
| CN110286997B (en) | Multi-container application creation method, device, computer equipment and storage medium | |
| CN109672722B (en) | Data deployment method and device, computer storage medium and electronic equipment | |
| CN109802842B (en) | Application topology generation method and related equipment | |
| CN109902027B (en) | TPC-DS testing method and system convenient to implement | |
| CN112148606A (en) | Embedded point testing method, device, equipment and computer readable medium | |
| CN107885634B (en) | Method and device for processing abnormal information in monitoring | |
| CN111061448A (en) | Log information display method and device, electronic equipment and storage medium | |
| CN110209548B (en) | Service control method, system, electronic device and computer readable storage medium | |
| CN110874301A (en) | Method and device for acquiring program pause information | |
| CN111159131A (en) | Performance optimization method, device, equipment and computer readable storage medium | |
| CN106685708B (en) | Method, device and system for determining service relationship | |
| CN110569157B (en) | Storage testing method, device, server and storage medium | |
| CN104506636A (en) | Method and device for synchronizing data | |
| CN115858484A (en) | Log processing method, device, equipment and program product | |
| JP6872919B2 (en) | Sensor network management method and sensor network management system | |
| CN110457187B (en) | TPC-E test method and test server capable of conveniently running based on backup test data | |
| CN111190964B (en) | Data docking method, device, equipment and storage medium | |
| CN112328363A (en) | Cloud hard disk mounting method and device | |
| CN110825477A (en) | Method, device and equipment for loading graphical interface and storage medium | |
| CN114371866A (en) | Version reconfiguration test method, device and equipment of service system |
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 |