CN110069406A - The TPC-DS test method and system of automatic trigger - Google Patents
The TPC-DS test method and system of automatic trigger Download PDFInfo
- Publication number
- CN110069406A CN110069406A CN201910252079.XA CN201910252079A CN110069406A CN 110069406 A CN110069406 A CN 110069406A CN 201910252079 A CN201910252079 A CN 201910252079A CN 110069406 A CN110069406 A CN 110069406A
- Authority
- CN
- China
- Prior art keywords
- database
- test
- target database
- tpc
- target
- 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.)
- Granted
Links
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
This application provides the TPC-DS test methods and system of a kind of automatic trigger, test for TPC-DS of the automatic trigger for the target database updated.A kind of TPC-DS test method of automatic trigger provided by the present application includes: that test macro receives the test request that UE is sent, test request is for requesting when target database executes database update event, TPC-DS test is carried out to target database, database update event is used to update the system data of target database；Whether test macro monitoring objective database executes database update event；If so, the TPC-DS test assignment of test macro triggering target database；Test macro sends data processing request to target database, and data processing request is used to carry out TPC-DS test to target database；Test macro obtains target database for the response results of data processing request；Test macro is analyzed and processed on the basis of the response results of data processing request, obtains the TPC-DS test result of target database.
Description
Technical field
This application involves database field more particularly to the TPC-DS test methods and system of a kind of automatic trigger.
Background technique
It is mentioned in Transaction Processing Performance Council (Transaction Process Performance Council, TPC)
In the extension process of the TPC-DS test benchmark of confession, mainly by developing corresponding TPC-DS testing tool, to target data
Library carries out TPC-DS test, the performance of test target database.
Existing TPC-DS testing tool can send data processing request from trend target database, to carry out automation TPC-DS
Test, however, in practical applications, still need to trigger the TPC-DS test assignment of TPC-DS testing tool by manual operation, because
This problem is still to be overcome.
Summary of the invention
This application provides the TPC-DS test methods and system of a kind of automatic trigger, for automatic trigger for occurring
The TPC-DS of the target database of update is tested.
In a first aspect, the application provides a kind of TPC-DS test method of automatic trigger, method includes:
Test macro receives the test request that user equipment (User Equipment, UE) is sent, and test request is for asking
It asks when target database executes database update event, TPC-DS test, database update event is carried out to target database
For updating the system data of target database；
Whether test macro monitoring objective database executes database update event；
If so, the TPC-DS test assignment of test macro triggering target database；
Test macro sends data processing request to target database, and data processing request is used to carry out target database
TPC-DS test；
Test macro obtains target database for the response results of data processing request；
Test macro is analyzed and processed on the basis of the response results of data processing request, obtains target database
TPC-DS test result.
Optionally, whether test macro monitoring objective database executes database update event and includes:
Whether test macro monitoring objective database updates major version number, maintenance release number, version component version number or platform
Version number；
If so, test macro determines that target database executes database update event.
Optionally, test request carries the Database Identification (Identification, ID) of target database, test macro
Whether monitoring objective database executes database update event
Test macro obtains the installation record of target database from server according to the database ID of target database；
Test macro is recorded according to installation, determines at least one physical equipment of installation targets database；
Locally-installed target database is updated with the presence or absence of target physical device in test macro monitoring physical equipment；
If so, test macro determines that target database executes database update event；
Test macro triggering target database TPC-DS test assignment include:
Test macro triggers the TPC-DS test assignment that task object is target physical device.
Optionally, whether test macro monitoring objective database executes database update event and includes:
Whether the program installation kit for the target database that test macro monitoring is stored on server executes database update
Event；
Test macro executes before target database transmission data processing request, method further include:
Test macro obtains the program installation kit of target database from server；
Test macro runs program installation kit, with operational objective database.
Optionally, whether test macro monitoring objective database executes database update event and includes:
Whether the program installation kit for the target database that test macro monitoring is stored on server executes database update
Event；
Test macro executes before target database transmission data processing request, method further include:
Test macro sends instruction information to server, and instruction information is used to indicate the journey of server operational objective database
Sequence installation kit, with operational objective database.
Second aspect, the application provide a kind of test macro, and system includes:
Receiving unit, for receiving the test request of UE transmission, test request executes number when target database for requesting
When according to library update event, TPC-DS test is carried out to target database, database update event is for updating target database
System data；
Whether monitoring unit executes database update event for monitoring objective database, if so, triggering triggering is single
Member；
Trigger unit, for triggering the TPC-DS test assignment of target database；
Transmission unit, for sending data processing request to target database, data processing request is used for target data
Library carries out TPC-DS test；
Acquiring unit, for obtaining target database for the response results of data processing request；
Analytical unit obtains number of targets for being analyzed and processed on the basis of the response results of data processing request
According to the TPC-DS test result in library.
Optionally, monitoring unit is specifically used for:
Whether monitoring objective database updates major version number, maintenance release number, version component version number or platform release number；
If so, determining that target database executes database update event.
Optionally, test request carries the database ID of target database, and monitoring unit is specifically used for:
According to the database ID of target database, the installation record of target database is obtained from server；
It is recorded according to installation, determines at least one physical equipment of installation targets database；
Locally-installed target database is updated with the presence or absence of target physical device in monitoring physical equipment；
If so, determining that target database executes database update event；
Trigger unit is specifically used for:
Trigger the TPC-DS test assignment that task object is target physical device.
Optionally, monitoring unit is specifically used for:
Whether the program installation kit for monitoring the target database being stored on server executes database update event；
Acquiring unit is also used to:
The program installation kit of target database is obtained from server；
System further include:
Running unit runs program installation kit, with operational objective database.
Optionally, monitoring unit is specifically used for:
Whether the program installation kit for monitoring the target database being stored on server executes database update event；
Transmission unit is also used to:
Instruction information is sent to server, instruction information is used to indicate the program installation of server operational objective database
Packet, with operational objective database.
The third aspect, the application provide a kind of test macro, including processor, and processor is stored for executing in memory
Computer program when realize as above-mentioned first aspect automatic trigger TPC-DS test method either step.
Fourth aspect, the application provide a kind of readable storage medium storing program for executing, are stored thereon with computer program, computer program quilt
The either step of the TPC-DS test method of the automatic trigger such as above-mentioned first aspect is realized when processor executes.
As can be seen from the above technical solutions, the application has the following advantages:
Test macro can trigger the monitoring task to target database in update when receiving test request, when
When monitoring that target database updates, TPC-DS test is carried out in target database of the first time to latest edition automatically,
The newest performance of test target database avoids the artificial touching that TPC-DS test is carried out for the target database of latest edition with this
Hair enormously simplifies the manual operation of staff, improves the testing efficiency of TPC-DS test.
Detailed description of the invention
Fig. 1 shows a kind of schematic diagram of a scenario of the TPC-DS test method of automatic trigger provided by the present application；
Fig. 2 shows a kind of flow diagrams of the TPC-DS test method of automatic trigger provided by the present application；
Fig. 3 shows another flow diagram of the TPC-DS test method of automatic trigger provided by the present application；
Fig. 4 shows another flow diagram of the TPC-DS test method of automatic trigger provided by the present application；
Fig. 5 shows another flow diagram of the TPC-DS test method of automatic trigger provided by the present application；
Fig. 6 shows a kind of structural schematic diagram of test macro provided by the present application；
Fig. 7 shows another structural schematic diagram of test macro provided by the present application.
Specific embodiment
This application provides the TPC-DS test methods and system of a kind of automatic trigger, for automatic trigger for occurring
The TPC-DS of the target database of update is tested.
Below in conjunction with the attached drawing in the embodiment of the present application, technical solutions in the embodiments of the present application carries out clear, complete
Site preparation description, it is clear that described embodiments are only a part of embodiments of the present application, instead of all the embodiments.It is based on
Embodiment in the application, those skilled in the art's every other implementation obtained without creative efforts
Example, shall fall in the protection scope of this application.
The description and claims of this application and term " first " in above-mentioned attached drawing, " second " etc. are for distinguishing
Similar object, without being used to describe a particular order or precedence order.It should be understood that the data used in this way are in appropriate feelings
It can be interchanged under condition, so that the embodiments described herein can be real with the sequence other than the content for illustrating or describing herein
It applies.In addition, term " includes " and " having " and their any deformation, it is intended that cover it is non-exclusive include, for example, packet
The process, method, system, product or equipment for having contained series of steps or module those of be not necessarily limited to be clearly listed step or
Module, but may include other steps being not clearly listed or intrinsic for these process, methods, product or equipment or
Module.Occur in this application to step carry out name perhaps number be not meant to must according to name or number
Indicated time/logic sequencing executes the step in method flow, and named or number process step can be with
Execution order is changed according to the technical purpose to be realized, as long as identical or similar technical effect can be reached.
The division of module appeared in the application is a kind of division in logic, can have when realizing in practical application
Other division mode, such as multiple modules can be combined into or are integrated in another system, or some features can be ignored,
Or do not execute, in addition, shown or discussion mutual coupling, direct-coupling or communication connection can be by one
A little interfaces, the indirect coupling or communication connection between module can be electrical or other similar form, do not make in the application
It limits.Also, module or submodule can be the separation that may not be physically as illustrated by the separation member, can be
It can not be physical module, or can be distributed in multiple circuit modules, portion therein can be selected according to the actual needs
Point or whole module realize the purpose of application scheme.
Firstly, refering to fig. 1, Fig. 1 shows the one of TPC-DS test method provided by the present application before introducing the application
Kind schematic diagram of a scenario, as shown in Figure 1, user can initiate test request to test macro by UE, and test macro is asked according to this
The triggering asked carries out TPC-DS test to target database, obtains after monitoring that target database executes database update event
To the TPC-DS test result of target database.Due to test macro automatically first time to the target database of latest edition into
Row TPC-DS test avoids the artificial triggering for carrying out TPC-DS test for the target database of latest edition, greatly improves TPC-
The testing efficiency of DS test.
In this application, UE may include smart phone, tablet computer, personal digital assistant (Personal Digital
Assistant, PDA), laptop, computer all-in-one machine, terminal devices, the UE such as desktop computer can establish net with test macro
Network connection, user can initiate the test request that TPC-DS is tested to test macro by the interpersonal interaction between UE.
Client/server (Client/Server) framework, the client that test macro is related to can be used in test macro
Side and server side are deployed in respectively on different physical equipments；Alternatively, host framework can also be used in test macro, by client
End side and server side deployment are on the same physical equipment.The test request that client-side is initiated for receiving UE, and to
Server side sends corresponding data processing request, which is sent to target database again and carried out by server side
Response results are responded and obtained, then the response results are fed back into client-side, is analyzed and processed by client-side and is obtained
TPC-DS test result to target database.
The mountable target database of server；Alternatively, server can also store the program installation kit of target database, specifically
It is not limited here.
In the following, being then based on above-mentioned schematic diagram of a scenario shown in fig. 1, start to be situated between to method provided by the present application in detail
It continues.
Referring to Fig.2, Fig. 2 shows a kind of signals of process of the TPC-DS test method of automatic trigger provided by the present application
Figure, specifically, the TPC-DS test method of automatic trigger provided by the present application may include following steps:
Step S201, test macro receive the test request that UE is sent；
Wherein, test request for request when target database execute database update event when, to target database into
Row TPC-DS test, database update event are used to update the system data of target database.
It is appreciated that the database ID of target database can be carried in test request, the corresponding target of mark test request
Database.
The data of database include system data and user data, in this application, with the system number of target database
According to the trigger condition tested as TPC-DS of update.
In practical applications, database update event specifically may include DB Backup, database recovery, version database
This lifting or the increase and decrease of functional unit etc., specifically it is not limited here.
Step S202, whether test macro monitoring objective database executes database update event, if so, step of setting out
S203；
After receiving test request, test macro is that can trigger the monitoring task of target database, monitoring objective data
Execution of the library about database update event, after monitoring that target database executes database update event, after can carrying out
Continuous TPC-DS test.
Step S203, test macro trigger the TPC-DS test assignment of target database；
Test macro in task list, can generate the TPC-DS test assignment of target database, and trigger the task, open
Begin to execute TPC-DS test.
Step S204, test macro send data processing request to target database；
Wherein, data processing request is used to carry out TPC-DS test to target database.
It is appreciated that data processing request may include data query sentence and data under the test benchmark of TPC-DS
Sentence is updated, with test target database data query sentence and data are updated with the response of sentence.
Step S205, test macro obtain target database for the response results of data processing request；
It is appreciated that test macro can pass through keyword during the processing of target database response data is requested
Monitoring, it is obtained from target database for the response results of data processing request.
Step S206, test macro are analyzed and processed on the basis of the response results of data processing request, obtain mesh
Mark the TPC-DS test result of database.
Test macro can carry out at analysis after getting target database for the response results of data processing request
Reason, such as summarize, count and conversion processing, and then obtain exportable TPC-DS test result.
From the foregoing, it will be observed that test macro is receiving test request in TPC-DS test method provided by the present application
When, that is, it can trigger and exist automatically to monitoring task of the target database in update when monitoring that target database updates
TPC-DS test is carried out to the target database of latest edition at the first time, the newest performance of test target database is avoided with this
The artificial triggering that TPC-DS test is carried out for the target database of latest edition, enormously simplifies the manual operation of staff,
Improve the testing efficiency of TPC-DS test.
Another process of the TPC-DS test method of automatic trigger provided by the present application is shown with continued reference to Fig. 3, Fig. 3
Schematic diagram, specifically, the TPC-DS test method of automatic trigger provided by the present application may include following steps:
Step S301, test macro receive the test request that UE is sent；
Wherein, test request for request when target database execute database update event when, to target database into
Row TPC-DS test, database update event are used to update the system data of target database.
It is appreciated that the duplicate contents of the step S201 in step S301 and Fig. 2, specific details are not described herein.
Step S302, test macro obtain the peace of target database from server according to the database ID of target database
Dress record；
Server can be used for storing the installation record of disparate databases, and record has installation corresponding data in each installation record
The physical equipment in library, so that test macro can obtain target database from server according to the database ID of target database
Installation record.
Step S303, test macro are recorded according to installation, determine at least one physical equipment of installation targets database；
After the installation record for obtaining target database from server, test macro can be recorded according to the installation, be determined
It is mounted with one or more physical equipment of target database.
Step S304, test macro monitor to update locally-installed number of targets in physical equipment there are target physical device
According to library；
It is appreciated that test macro can set these physics after determination is mounted with the physical equipment of target database
It is standby to be monitored, it determines in these physical equipments and has updated locally-installed target database with the presence or absence of physical equipment, to sentence
Whether disconnected target database performs database update event, and if it exists, then corresponding physical equipment is target physical device.
When monitoring that target target physical device updates locally-installed target database, test macro can determine mesh
It marks database and executes database update event.
Wherein, whether test macro specifically can update major version number, maintenance release number, component by monitoring objective database
Whether version number or platform release number, Lai Shixian monitoring objective database execute database update event.
Step S305, test macro trigger the TPC-DS test assignment that task object is target physical device；
After monitoring target physical device, it is target physical device that task object can be generated in task list
TPC-DS test assignment, and the task is triggered, start to execute TPC-DS test.
Step S306, test macro send data processing request to target database；
Wherein, data processing request is used to carry out TPC-DS test to target database.
Step S307, test macro obtain target database for the response results of data processing request；
Step S308, test macro are analyzed and processed on the basis of the response results of data processing request, obtain mesh
Mark the TPC-DS test result of database；
It is appreciated that step S306 to step S308, the duplicate contents with the step S204 to step S206 in Fig. 2, tool
Details are not described herein for body.
Wherein, data processing request is the mesh being sent in target object-target physical device of TPC-DS test assignment
Database is marked, it is corresponding, the required response results of TPC-DS test are obtained from the target database in target physical device.
Step S309, test macro send TPC-DS test result to UE.
It after obtaining TPC-DS test result, can be sent to UE, learn target data at the first time for the user of the side UE
The TPC-DS test result in library.
Another process of the TPC-DS test method of automatic trigger provided by the present application is shown with continued reference to Fig. 4, Fig. 4
Schematic diagram, specifically, the TPC-DS test method of automatic trigger provided by the present application may include following steps:
Step S401, test macro receive the test request that UE is sent；
Wherein, test request for request when target database execute database update event when, to target database into
Row TPC-DS test, database update event are used to update the system data of target database.
It is appreciated that the duplicate contents of the step S201 in step S401 and Fig. 2, specific details are not described herein.
Step S402, test macro monitor that the program installation kit for the target database being stored on server executes database
Update event；
Installation record of the server in addition to that can store disparate databases such as step S302, can also store the journey of disparate databases
Sequence installation kit.
To which test macro can navigate to mesh from the memory space of server according to the database ID of target database
Mark the program installation kit of database.
When the program installation kit of target database on monitoring server is updated, executes database update event,
Test macro can determine that target database executes database update event.
Wherein, test macro specifically can be by the program installation kit of monitoring objective database, and whether monitoring objective database
Update whether major version number, maintenance release number, version component version number or platform release number, Lai Shixian monitoring objective database execute
Database update event.
Step S403, test macro trigger TPC-DS test assignment；
It, can be in task after the program installation kit of target database executes database update event on monitoring server
TPC-DS test assignment is generated in list, and triggers the task, starts to execute TPC-DS test.
Step S404, test macro obtain the installation kit of target database from server；
It is appreciated that test macro can first obtain the installation kit of target database from server, to run the installation kit,
That is operational objective database, to carry out TPC-DS test.
Step S405, test macro send the installation kit of target database to physical equipment；
It should be noted that test macro can be installed in the physical equipment where system, the program of operational objective database
Packet is communicated in a manner of virtual network connection with target database；Alternatively, other physical equipments also may be selected, mesh is run
The program installation kit of database is marked, specifically it is not limited here.
For ease of understanding, as shown in Figure 4, the physical equipment operational objective other than physical equipment locating for test macro
For the program installation kit of database, continue to introduce subsequent content.
It, can be in preset physical equipment team after test macro gets the program installation kit of target database from server again
In column, a transmission program installation kit is selected, so that the physical equipment operational objective database, auxiliary TPC-DS test.
Step S406, the installation kit of physical equipment operational objective database, with operational objective database；
Physical equipment can run the program after receiving the program installation kit of target database of test macro transmission
Installation kit, operational objective database.
Step S407, test macro send data processing request to target database；
Wherein, data processing request is used to carry out TPC-DS test to target database.
Step S408, test macro obtain target database for the response results of data processing request；
Step S409, test macro are analyzed and processed on the basis of the response results of data processing request, obtain mesh
Mark the TPC-DS test result of database；
It is appreciated that step S407 to step S409, the duplicate contents with the step S204 to step S206 in Fig. 2, tool
Details are not described herein for body.
Wherein, data processing request is sent to the target database run in physical equipment, corresponding, from physical equipment
Response results needed for the target database of middle operation obtains TPC-DS test.
Step S410, test macro send TPC-DS test result to UE.
It after obtaining TPC-DS test result, can be sent to UE, learn target data at the first time for the user of the side UE
The TPC-DS test result in library.
Another process of the TPC-DS test method of automatic trigger provided by the present application is shown with continued reference to Fig. 5, Fig. 5
Schematic diagram, specifically, the TPC-DS test method of automatic trigger provided by the present application may include following steps:
Step S501, test macro receive the test request that UE is sent；
Wherein, test request for request when target database execute database update event when, to target database into
Row TPC-DS test, database update event are used to update the system data of target database.
Step S502, test macro monitor that the program installation kit for the target database being stored on server executes database
Update event；
Step S503, test macro trigger TPC-DS test assignment；
Step S504, test macro send instruction information to server；
Wherein, instruction information is used to indicate the program installation kit of server operational objective database, with operational objective data
Library.
It is appreciated that in addition to the deployment for the program installation kit for carrying out target database by test macro, operational objective data
Library, can also be directly by the program installation kit of server operational objective database, and operational objective database carries out TPC-DS test,
Transmission cost needed for avoiding the program installation kit with this, including network bandwidth cost and transmission time cost, so as into
The testing efficiency of one step raising TPC-DS.
Step S505, the program installation kit of server operational objective database, with operational objective database；
Server can be run after the instruction information for receiving test macro transmission according to the instruction of the instruction information
The program installation kit of target database, operational objective database.
Step S506, test macro send data processing request to target database；
Wherein, data processing request is used to carry out TPC-DS test to target database.
Step S507, test macro obtain target database for the response results of data processing request；
Step S508, test macro are analyzed and processed on the basis of the response results of data processing request, obtain mesh
Mark the TPC-DS test result of database；
It is appreciated that the step S401 of step S501 to step S503, step S506 into step 508, with Fig. 4 to step
The duplicate contents of S403, step S407 to step S409, specific details are not described herein.
Wherein, data processing request is sent to the target database run in server, corresponding, transports from server
Response results needed for capable target database obtains TPC-DS test.
Step S509, test macro send TPC-DS test result to UE.
It after obtaining TPC-DS test result, can be sent to UE, learn target data at the first time for the user of the side UE
The TPC-DS test result in library.
It is to start to introduce the application below to the introduction of the TPC-DS test method of automatic trigger provided by the present application above
The test macro of offer.
A kind of structural schematic diagram of test macro provided by the present application is shown refering to Fig. 6, Fig. 6, specifically, the application mentions
The test macro of confession may include such as flowering structure:
Receiving unit 601, for receiving the test request of UE transmission, test request is executed for requesting when target database
When database update event, TPC-DS test is carried out to target database, database update event is for updating target database
System data；
Whether monitoring unit 602 executes database update event for monitoring objective database, if so, triggering triggering
Unit 603；
Trigger unit 603, for triggering the TPC-DS test assignment of target database；
Transmission unit 604, for sending data processing request to target database, data processing request is used for number of targets
TPC-DS test is carried out according to library；
Acquiring unit 605, for obtaining target database for the response results of data processing request；
Analytical unit 606 obtains target for being analyzed and processed on the basis of the response results of data processing request
The TPC-DS test result of database.
Optionally, monitoring unit 602 are specifically used for:
Whether monitoring objective database updates major version number, maintenance release number, version component version number or platform release number；
If so, determining that target database executes database update event.
Optionally, test request carries the database ID of target database, and monitoring unit 602 is specifically used for:
According to the database ID of target database, the installation record of target database is obtained from server；
It is recorded according to installation, determines at least one physical equipment of installation targets database；
Locally-installed target database is updated with the presence or absence of target physical device in monitoring physical equipment；
If so, determining that target database executes database update event；
Trigger unit 603, is specifically used for:
Trigger the TPC-DS test assignment that task object is target physical device.
Optionally, monitoring unit 602 are specifically used for:
Whether the program installation kit for monitoring the target database being stored on server executes database update event；
Acquiring unit 605, is also used to:
The program installation kit of target database is obtained from server；
System further include:
Running unit 606 runs program installation kit, with operational objective database.
Optionally, monitoring unit 602 are specifically used for:
Whether the program installation kit for monitoring the target database being stored on server executes database update event；
Transmission unit 604, is also used to:
Instruction information is sent to server, instruction information is used to indicate the program installation of server operational objective database
Packet, with operational objective database.
Another structural schematic diagram of test macro provided by the present application is shown refering to Fig. 7, Fig. 7, specifically, the application
The test macro of offer includes processor 701, real when processor 701 is for executing the computer program stored in memory 702
Now as Fig. 2 to Fig. 5 corresponds to each step of the TPC-DS test method of the automatic trigger in any embodiment；Alternatively, processor 701
The function such as each unit in Fig. 6 corresponding embodiment is realized when for executing the computer program stored in memory 702.
Illustratively, computer program can be divided into one or more module/units, and one or more module/
Unit is stored in memory 702, and is executed by processor 701, to complete the application.One or more module/units can
To be the series of computation machine program instruction section that can complete specific function, which is calculating for describing computer program
Implementation procedure in machine device.
Test macro may include, but be not limited only to processor 701, memory 702.It will be understood by those skilled in the art that
It is described signal be only computer installation example, do not constitute the restriction to test macro, may include than illustrate it is more or
Less component perhaps combines certain components or different components, such as test macro can also be set including input and output
Standby, network access equipment, bus etc., processor 701, memory 702, input-output equipment and network access equipment etc. pass through
Bus is connected.
Processor 701 can be central processing unit (Central Processing Unit, CPU), can also be other
General processor, digital signal processor (Digital Signal Processor, DSP), specific integrated circuit
(Application Specific Integrated Circuit, ASIC), ready-made programmable gate array (Field-
Programmable Gate Array, FPGA) either other programmable logic device, discrete gate or transistor logic,
Discrete hardware components etc..General processor can be microprocessor or the processor is also possible to any conventional processor
Deng processor is the control centre of computer installation, utilizes each portion of various interfaces and the entire computer installation of connection
Point.
Memory 702 can be used for storing computer program and/or module, and processor 701 is stored in by operation or execution
Computer program and/or module in memory 702, and the data being stored in memory 702 are called, realize computer dress
The various functions of setting.Memory 702 can mainly include storing program area and storage data area, wherein storing program area can store
Application program needed for operating system, at least one function (such as sound-playing function, image player function etc.) etc.；Store number
It can be stored according to area and created data (such as audio data, video data etc.) etc. are used according to mobile phone.In addition, memory can
It can also include nonvolatile memory, such as hard disk, memory, plug-in type hard disk, intelligence to include high-speed random access memory
Energy storage card (Smart Media Card, SMC), secure digital (Secure Digital, SD) card, flash card (Flash
Card), at least one disk memory, flush memory device or other volatile solid-state parts.
The application also provides a kind of readable storage medium storing program for executing, is stored thereon with computer program, computer program is by processor
Realize that Fig. 2 to Fig. 5 such as corresponds to the TPC-DS test method of the automatic trigger in any embodiment when execution.
If it is appreciated that integrated unit be realized in the form of SFU software functional unit and as the sale of independent product or
In use, can store in a computer readable storage medium.Based on this understanding, the technical solution sheet of the application
The all or part of the part that contributes to existing technology or the technical solution can be with software product in other words in matter
Form embodies, which is stored in a storage medium, including some instructions are used so that a meter
Calculate the whole that machine equipment (can be personal computer, server or the network equipment etc.) executes the application each method embodiment
Or part steps.And storage medium above-mentioned include: USB flash disk, mobile hard disk, read-only memory (Read-only Memory,
ROM), random access memory (Random Access Memory, RAM), magnetic or disk etc. are various can store program
The medium of code.
It is apparent to those skilled in the art that for convenience and simplicity of description, the test of foregoing description
The specific work process of system and its unit can correspond to the TPC-DS of the automatic trigger in any embodiment referring to figs. 2 to Fig. 5
The explanation of test method, specific details are not described herein.
In conclusion in TPC-DS test method provided by the present application, system and readable storage medium storing program for executing, test macro
When receiving test request, that is, it can trigger monitoring task to target database in update, when monitoring target database
When updating, TPC-DS test is carried out in target database of the first time to latest edition automatically, test target database
Newest performance is avoided the artificial triggering for carrying out TPC-DS test for the target database of latest edition with this, enormously simplifies work
Make the manual operation of personnel, improves the testing efficiency of TPC-DS test.
In several embodiments provided herein, it should be understood that disclosed test macro and its unit, it can be with
It realizes by another way.For example, the apparatus embodiments described above are merely exemplary, for example, the unit
It divides, only a kind of logical function partition, there may be another division manner in actual implementation, such as multiple units or components
It can be combined or can be integrated into another system, or some features can be ignored or not executed.Another point, it is shown or
The mutual coupling, direct-coupling or communication connection discussed can be through some interfaces, the indirect coupling of device or unit
It closes or communicates to connect, can be electrical property, mechanical or other forms.
The unit as illustrated by the separation member may or may not be physically separated, aobvious as unit
The component shown may or may not be physical unit, it can and it is in one place, or may be distributed over multiple
In network unit.It can select some or all of unit therein according to the actual needs to realize the mesh of this embodiment scheme
's.
It, can also be in addition, each functional unit in each embodiment of the application can integrate in one processing unit
It is that each unit physically exists alone, can also be integrated in one unit with two or more units.Above-mentioned integrated list
Member both can take the form of hardware realization, can also realize in the form of software functional units.
The above, above embodiments are only to illustrate the technical solution of the application, rather than its limitations；Although referring to before
Embodiment is stated the application is described in detail, those skilled in the art should understand that: it still can be to preceding
Technical solution documented by each embodiment is stated to modify or equivalent replacement of some of the technical features；And these
It modifies or replaces, the spirit and scope of each embodiment technical solution of the application that it does not separate the essence of the corresponding technical solution.
Claims (10)
1. a kind of TPC-DS test method of automatic trigger, which is characterized in that the described method includes:
Test macro receives the test request that user equipment (UE) is sent, and the test request is executed for requesting when target database
When database update event, TPC-DS test is carried out to the target database, the database update event is for updating institute
State the system data of target database；
The test macro monitors whether the target database executes the database update event；
If so, the test macro triggers the TPC-DS test assignment of the target database；
The test macro sends data processing request to the target database, and the data processing request is used for the mesh
It marks database and carries out the TPC-DS test；
The test macro obtains the target database for the response results of the data processing request；
The test macro is analyzed and processed on the basis of the response results of the data processing request, obtains the target
The TPC-DS test result of database.
2. the method according to claim 1, wherein the test macro monitors whether the target database is held
The row database update event includes:
The test macro monitor the target database whether update major version number, maintenance release number, version component version number or
Platform release number；
If so, the test macro determines that the target database executes the database update event.
3. the method according to claim 1, wherein the test request carries the data of the target database
Library identifies ID, and whether the test macro monitoring target database, which executes the database update event, includes:
The test macro obtains the installation of the target database from server according to the database ID of the target database
Record；
The test macro is recorded according to the installation, determines at least one physical equipment for installing the target database；
The test macro, which monitors in the physical equipment, updates the locally-installed target with the presence or absence of target physical device
Database；If so, the test macro determines that the target database executes the database update event；
The TPC-DS test assignment that the test macro triggers the target database includes:
The test macro triggering task object is the TPC-DS test assignment of the target physical device.
4. the method according to claim 1, wherein the test macro monitors whether the target database is held
The row database update event includes:
Whether the program installation kit for the target database that the test macro monitoring is stored on server executes the number
According to library update event；
The test macro executes before target database transmission data processing request, the method also includes:
The test macro obtains the program installation kit of the target database from the server；
The test macro runs described program installation kit, to run the target database.
5. the method according to claim 1, wherein the test macro monitors whether the target database is held
The row database update event includes:
Whether the program installation kit for the target database that the test macro monitoring is stored on server executes the number
According to library update event；
The test macro executes before target database transmission data processing request, the method also includes:
The test macro sends instruction information described in instruction information to the server and is used to indicate server operation institute
Program installation kit is stated, to run the target database.
6. a kind of test macro, which is characterized in that the system comprises:
Receiving unit, for receiving the test request of user equipment (UE) transmission, the test request works as target data for requesting
When library executes database update event, TPC-DS test is carried out to the target database, the database update event is used for
Update the system data of the target database；
Monitoring unit, for monitoring whether the target database executes the database update event, if so, triggering triggering
Unit；
The trigger unit, for triggering the TPC-DS test assignment of the target database；
Transmission unit, for sending data processing request to the target database, the data processing request is used for described
Target database carries out the TPC-DS test；
Acquiring unit, for obtaining the target database for the response results of the data processing request；
Analytical unit obtains the mesh for being analyzed and processed on the basis of the response results of the data processing request
Mark the TPC-DS test result of database.
7. system according to claim 6, which is characterized in that the monitoring unit is specifically used for:
Monitor whether the target database updates major version number, maintenance release number, version component version number or platform release number；
If so, determining that the target database executes the database update event.
8. system according to claim 6, which is characterized in that the test request carries the data of the target database
Library identifies ID, and the monitoring unit is specifically used for:
According to the database ID of the target database, the installation record of the target database is obtained from server；
It is recorded according to the installation, determines at least one physical equipment for installing the target database；
It monitors in the physical equipment and updates the locally-installed target database with the presence or absence of target physical device；
If so, determining that the target database executes the database update event；
The trigger unit, is specifically used for:
Trigger the TPC-DS test assignment that task object is the target physical device.
9. system according to claim 6, which is characterized in that the monitoring unit is specifically used for:
Whether the program installation kit for monitoring the target database being stored on server executes the database update event；
The acquiring unit, is also used to:
The program installation kit of the target database is obtained from the server；
The system also includes:
Running unit runs described program installation kit, to run the target database.
10. system according to claim 6, which is characterized in that the monitoring unit is specifically used for:
Whether the program installation kit for monitoring the target database being stored on server executes the database update event；
The transmission unit, is also used to:
Instruction information is sent to the server, the instruction information is used to indicate the server operation described program installation
Packet, 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 true CN110069406A (en) | 2019-07-30 |
| CN110069406B 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) |
Cited By (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 |
| CN110737594A (en) * | 2019-09-19 | 2020-01-31 | 武汉迎风聚智科技有限公司 | Database standard conformance testing method and device for automatically generating test cases |
| CN113360418A (en) * | 2021-08-10 | 2021-09-07 | 武汉迎风聚智科技有限公司 | System testing method and device |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104951399A (en) * | 2015-06-19 | 2015-09-30 | 北京齐尔布莱特科技有限公司 | Software test system and method |
| CN106681867A (en) * | 2015-11-09 | 2017-05-17 | 阿里巴巴集团控股有限公司 | Testing method and device |
| US20180113792A1 (en) * | 2016-10-25 | 2018-04-26 | Ricoh Company, Ltd. | Information processing system and updating method |
-
2019
- 2019-03-29 CN CN201910252079.XA patent/CN110069406B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104951399A (en) * | 2015-06-19 | 2015-09-30 | 北京齐尔布莱特科技有限公司 | Software test system and method |
| CN106681867A (en) * | 2015-11-09 | 2017-05-17 | 阿里巴巴集团控股有限公司 | Testing method and device |
| US20180113792A1 (en) * | 2016-10-25 | 2018-04-26 | Ricoh Company, Ltd. | Information processing system and updating method |
Cited By (5)
| 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 |
| CN110737594A (en) * | 2019-09-19 | 2020-01-31 | 武汉迎风聚智科技有限公司 | Database standard conformance testing method and device for automatically generating test cases |
| CN110737594B (en) * | 2019-09-19 | 2021-02-05 | 武汉迎风聚智科技有限公司 | Database standard conformance testing method and device for automatically generating test cases |
| CN113360418A (en) * | 2021-08-10 | 2021-09-07 | 武汉迎风聚智科技有限公司 | System testing method and device |
| CN113360418B (en) * | 2021-08-10 | 2021-11-05 | 武汉迎风聚智科技有限公司 | System testing method and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110069406B (en) | 2020-08-11 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102195970B (en) | Based on the debugging of client session | |
| CN111124850A (en) | MQTT server performance testing method, system, computer equipment and storage medium | |
| CN110083455B (en) | Graph calculation processing method, graph calculation processing device, graph calculation processing medium and electronic equipment | |
| JP6286345B2 (en) | System design support apparatus and system design support method | |
| CN110069406A (en) | The TPC-DS test method and system of automatic trigger | |
| CN111897638A (en) | Distributed task scheduling method and system | |
| CN108509333A (en) | Adjustment method and device | |
| US20170048115A1 (en) | SDN Application Integration, Management and Control Method, System and Device | |
| US20100058319A1 (en) | Agile deployment of server | |
| US20160224322A1 (en) | Dynamic agent delivery | |
| CN109672722B (en) | Data deployment method and device, computer storage medium and electronic equipment | |
| CN104765621A (en) | Method and system for deploying program on cluster node | |
| US11509527B1 (en) | Assisted and context-driven network changes | |
| CN102834806A (en) | System structure managing device, method of managing system structure, and program | |
| CN103973470A (en) | Cluster management method and equipment for shared-nothing cluster | |
| CN105095103A (en) | Storage device management method and device used for cloud environment | |
| CN105302709B (en) | Test data generating method and equipment | |
| CN112788112A (en) | Automatic publishing method, device and platform for equipment health management micro-service | |
| CN112363938A (en) | Data processing method and device, electronic equipment and storage medium | |
| CN109962914B (en) | Firewall configuration method and device | |
| CN112558972B (en) | Application management platform, system, method, storage medium and program product | |
| CN109902027A (en) | A kind of TPC-DS test method and system convenient to carry out | |
| CN112153146B (en) | Operation notification method and apparatus, storage medium, and electronic apparatus | |
| CN114064435A (en) | Database test method, device, medium and electronic equipment | |
| CN112416698B (en) | Expansion method and device of monitoring system, storage medium and electronic equipment |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |