CN109902027A - A kind of TPC-DS test method and system convenient to carry out - Google Patents
A kind of TPC-DS test method and system convenient to carry out Download PDFInfo
- Publication number
- CN109902027A CN109902027A CN201910253172.2A CN201910253172A CN109902027A CN 109902027 A CN109902027 A CN 109902027A CN 201910253172 A CN201910253172 A CN 201910253172A CN 109902027 A CN109902027 A CN 109902027A
- Authority
- CN
- China
- Prior art keywords
- test
- database
- tested
- tpc
- data
- 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
- 239000008186 active pharmaceutical agent Substances 0.000 title claims abstract description 148
- 238000010998 test method Methods 0.000 title claims abstract description 22
- 238000012360 testing method Methods 0.000 claims abstract description 393
- 230000004044 response Effects 0.000 claims abstract description 29
- 238000000034 method Methods 0.000 claims abstract description 27
- 230000005540 biological transmission Effects 0.000 claims description 12
- 230000000977 initiatory effect Effects 0.000 claims description 5
- 238000005259 measurement Methods 0.000 claims description 4
- 238000012423 maintenance Methods 0.000 claims 1
- 238000004590 computer program Methods 0.000 description 11
- 238000010586 diagram Methods 0.000 description 10
- 230000006870 function Effects 0.000 description 7
- 238000010168 coupling process Methods 0.000 description 6
- 238000005859 coupling reaction Methods 0.000 description 6
- 230000008569 process Effects 0.000 description 6
- 238000012545 processing Methods 0.000 description 5
- 230000008878 coupling Effects 0.000 description 4
- 238000002955 isolation Methods 0.000 description 4
- 238000004891 communication Methods 0.000 description 3
- 238000009434 installation Methods 0.000 description 3
- 238000000926 separation method Methods 0.000 description 3
- 235000013399 edible fruits Nutrition 0.000 description 2
- 238000012544 monitoring process Methods 0.000 description 2
- 238000010276 construction Methods 0.000 description 1
- 238000000151 deposition Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 230000018109 developmental process Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000004146 energy storage Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 239000000463 material Substances 0.000 description 1
- 238000005192 partition Methods 0.000 description 1
- 238000002360 preparation method Methods 0.000 description 1
- 230000009467 reduction Effects 0.000 description 1
- 238000012163 sequencing technique Methods 0.000 description 1
- 230000009897 systematic effect Effects 0.000 description 1
- 230000017260 vegetative to reproductive phase transition of meristem Effects 0.000 description 1
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Debugging And Monitoring (AREA)
Abstract
This application provides a kind of TPC-DS test methods and system convenient to carry out, test for realizing TPC-DS convenient to carry out.Method includes: that test macro receives the test request that UE is initiated, and test request treats test database progress TPC-DS test for requesting, and test request carries wide area information server ID to be tested；Test macro obtains the backup file of database to be tested according to database ID from server；Test macro disposes the backup file of database to be tested on the physical devices；Test macro is tested according to TPC-DS, data inquiry request is sent to database to be tested and data update request, data inquiry request carries out the corresponding data query test of TPC-DS test for treating test database, and data update request and carry out the corresponding data maintaining operation of TPC-DS test for treating test database；Test macro obtains the response results that database to be tested updates data inquiry request and data request；Test macro counts response results, forms TPC-DS test result.
Description
Technical field
This application involves database fields, more particularly to a kind of TPC-DS test method and system convenient to carry out.
Background technique
With the sharp increase of information content, the scale of Database Systems (Database System, DB) is also increasing, therefore,
Transaction Processing Performance Council (Transaction Process Performance Council, TPC) provides TPC-DS survey
Benchmark is tried, the development of DB now is adapted to, to substitute the TPC-H test benchmark originally released, more truly assesses the performance of DB.
It is understood, however, that TPC-DS test benchmark is test specification, and in practical applications, how by TPC-
When DS test benchmark is implemented on actual testing tool, also need specifically to be designed and optimized, so as to number to be tested
TPC-DS test is carried out according to library.
For example, finding in practical applications, after treating test database and completing TPC-DS test, often in number to be tested
The data remanence of TPC-DS test is left according to discovery in library, it is clear that this can occupy the certain storage resource of database to be tested,
To remove these data remanences, certain manpower and material resources cost need to be expended.
Summary of the invention
This application provides a kind of TPC-DS test methods and system convenient to carry out, for realizing convenient to carry out
TPC-DS test.
In a first aspect, the application provides a kind of TPC-DS test method convenient to carry out, which comprises
Test macro receives the test request that user equipment (User Equipment, UE) is initiated, and the test request is used
Test database is treated in request and carries out TPC-DS test, and the test request carries the wide area information server mark to be tested
Know (Identification, ID)；
The test macro obtains the backup text of the database to be tested according to the database ID from server
Part；
The test macro disposes the backup file of the database to be tested on the physical devices, described to be measured to run
Try database；
The test macro is tested according to the TPC-DS, to the database to be tested send data inquiry request and
Data update request, and the data inquiry request is used to carry out the TPC-DS to the database to be tested to test corresponding number
It is investigated that asking test, the data update request and test corresponding data for carrying out the TPC-DS to the database to be tested
Update test；
The test macro obtains the database to be tested and the data inquiry request and the data is updated
The response results of request；
The test macro counts the data inquiry request and the data update the response results of request, is formed
TPC-DS test result.
Optionally, method further include:
Test macro obtains the corresponding structured query language of database to be tested according to database ID from server
(Structured Query Language, SQL) file, SQL file carry out data query survey for treating test database
Examination；
Test macro parses SQL file, obtains multiple data inquiry requests.
Optionally, method further include:
Test macro generates the corresponding SQL file of database to be tested, and SQL file is counted for treating test database
It is investigated that asking test；
Test macro parses SQL file, obtains multiple data inquiry requests.
Optionally, TPC-DS test includes power test and testing throughput,
99 data inquiry request random alignments are combined to obtain power test use-case by test macro according to power test
Collection；
Test macro successively sends power test set of uses case to database to be tested according to the sequence of power test set of uses case
In data inquiry request；
Data inquiry request and data are updated request random alignment and combine to obtain by test macro according to testing throughput
Testing throughput set of uses case, each testing throughput use-case in testing throughput set of uses case include 99 data inquiry requests with
And multiple data update request；
Test macro successively sends testing throughput to database to be tested and uses according to the sequence of testing throughput set of uses case
The testing throughput use-case that example is concentrated.Optionally, method further include:
Test macro adds database ID in TPC-DS test result；
Test macro saves TPC-DS test result；
Test macro sends TPC-DS test result to UE.
The application provides a kind of test macro in second aspect, the system comprises:
Receiving unit, for receiving the test request of UE initiation, test request treats test database progress for requesting
TPC-DS test, test request carry wide area information server ID to be tested；
Acquiring unit, for obtaining the backup file of database to be tested from server according to database ID；
Deployment unit, for disposing the backup file of database to be tested on the physical devices, to run data to be tested
Library；
Transmission unit sends data inquiry request and data more to database to be tested for testing according to TPC-DS
New request, data inquiry request are used to treat the data query test that test database carries out TPC-DS test, and data update is asked
Seek the data maintaining operation that TPC-DS test is carried out for treating test database；
Acquiring unit is also used to obtain the response that database to be tested updates data inquiry request and data request
As a result；
Statistic unit updates the response results of request for statistical data inquiry request and data, forms TPC-DS and surveys
Test result.
Optionally, acquiring unit is also used to that it is corresponding to obtain database to be tested from server according to database ID
SQL file, SQL file carry out data query test for treating test database；
System further include:
Resolution unit obtains multiple data inquiry requests for parsing SQL file.
Optionally, system further include:
Generation unit, for generating the corresponding SQL file of database to be tested according to database to be tested, SQL file is used
Data query test is carried out in treating test database；
Resolution unit obtains multiple data inquiry requests for parsing SQL file.
Optionally, TPC-DS test includes power test and testing throughput, and transmission unit is specifically used for:
According to power test, 99 data inquiry request random alignments are combined to obtain power test set of uses case；
According to the sequence of power test set of uses case, the data in power test set of uses case are successively sent to database to be tested
Inquiry request；
According to testing throughput, data inquiry request and data are updated into request random alignment and combine to obtain measurement of handling up
Set of uses case is tried, each testing throughput use-case in testing throughput set of uses case includes 99 data inquiry requests and multiple numbers
It is requested according to updating；
According to the sequence of testing throughput set of uses case, successively sent in testing throughput set of uses case to database to be tested
Testing throughput use-case.
Optionally, system further include:
Adding unit, for adding database ID in TPC-DS test result；
Storage unit, for saving TPC-DS test result；
Transmission unit is also used to send TPC-DS test result to UE.
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 TPC-DS test method convenient to carry out 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 convenient to carry out 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:
Since TPC-DS test is what the backup file based on database to be tested was realized, in other words, surveyed in TPC-DS
In examination, using the replicate data library of database to be tested as test object, realize physical isolation, avoid TPC-DS test directly with
When original database to be tested on server is test object, TPC-DS test and the normal work of former database to be tested are mutual
It impacts, replicate data library can be directly unloaded after test, avoid leaving TPC-DS test in former database to be tested
Data remanence, in addition, can maintain the normal work of former database to be tested on the server on one side, another side can also be with multiple
Database processed is completed to test the TPC-DS of former database to be tested as test object, is also convenient for the implementation of TPC-DS test,
And then can further improve the measuring accuracy of TPC-DS test, the performance for treating test database based on TPC-DS test benchmark is real
Now more accurately assess.
Detailed description of the invention
Fig. 1 shows a kind of schematic diagram of a scenario of TPC-DS test method provided by the present application；
Fig. 2 shows a kind of flow diagrams of TPC-DS test method provided by the present application；
Fig. 3 shows another flow diagram of TPC-DS test method provided by the present application；
Fig. 4 shows a kind of structural schematic diagram of test macro provided by the present application；
Fig. 5 shows another structural schematic diagram of test macro provided by the present application.
Specific embodiment
It is convenient to carry out for providing this application provides a kind of TPC-DS test method and system convenient to carry out
TPC-DS test.
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
It seeks the backup file for obtaining database to be tested from server and disposes and run on the physical devices, test macro is again to be measured
It tries database and sends data inquiry request and the data update request of TPC-DS test, and obtain database to be tested for number
The response results that request is updated according to inquiry request and data, form the TPC-DS test result of database to be tested.
Since TPC-DS test is what the backup file based on database to be tested was realized, in other words, surveyed in TPC-DS
In examination, using the replicate data library of database to be tested as test object, realizes physical isolation, can directly be unloaded after test
Replicate data library is carried, therefore can avoid leaving the data remanence of TPC-DS test in former database to be tested, is surveyed convenient for TPC-DS
The implementation of examination.
Secondly, in this application, UE may include smart phone, tablet computer, personal digital assistant (Personal
Digital Assistant, PDA), laptop, computer all-in-one machine, the terminal devices such as desktop computer, UE can be with test
The vertical network connection of construction in a systematic way, user can be initiated the test that TPC-DS is tested to test macro and be asked by the interpersonal interaction between UE
It asks.
Specifically, client/server (Client/Server) framework can be used in test macro, test macro is related to
Client-side and server side be deployed on different physical equipments respectively；Alternatively, mainframe can also be used in test macro
Structure, by client-side and server side deployment on the same physical equipment.Client-side is used to receive the test of UE initiation
Request, and request is updated to the corresponding data inquiry request of server side transmission and data, server side again looks into the data
It askes request and data updates request and are sent to database to be tested and responded and obtained response results, then by the response results
Client-side is fed back to, forms the TPC-DS test result of database to be tested by client-side.
It, can also be by modes such as container, virtual machines by the duplication of database to be tested it should be understood that in this application
Database and test macro are deployed on same physical equipment；Alternatively, by the replicate data library of database to be tested and can also survey
The server side of test system is disposed on same physical equipment, specifically it is not limited here.
Then, server shown in figure 1 is returned to, in this application, server can be deployed with former database to be tested；Or
Person can also build a cloud platform by server, be stored with the backup file of one or more database to be tested, for test
The backup file of system invocation target database to be tested carries out corresponding TPC-DS test, 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 TPC-DS test method convenient to carry out provided by the present application
Figure, specifically, TPC-DS test method convenient to carry out provided by the present application may include following steps:
Step S201, test macro receive the test request that UE is initiated；
Wherein, test request treats test database progress TPC-DS test for requesting, and test request carries to be tested
Wide area information server ID.
It is appreciated that user, is responsible for the staff of TPC-DS test in other words, can be initiated by UE to test macro
The test request of the TPC-DS test of target database to be tested.
Staff can be manually entered wide area information server ID to be tested, alternatively, can also be selected from multiple
Database to be tested is selected in database, UE can get the wide area information server ID to be tested, and database ID is for marking
Know database, server can navigate to database to be tested or database to be tested when getting database ID
Associated documents.
Step S202, test macro obtain the backup file of database to be tested according to database ID from server；
The test request of UE initiation is being received, and is obtaining wide area information server ID to be tested from the test request
Afterwards, test macro by the network connection between server, can obtain the backup text of database to be tested from server
Part.
It having been mentioned among the above, the first situation, server can directly be deployed with database to be tested, therefore, test system
The mode of sync database, replicate data library can be used in system, gets the backup file of database to be tested；Second situation,
Server is stored with the backup file of multiple databases, and test macro can get and be again provided with directly according to database ID
Database ID or the database backup file for matching database ID.
For ease of description, following the description in case where server is stored with the backup file of multiple databases, carries out
Explanation.
Step S203, test macro disposes the backup file of database to be tested on the physical devices, to be tested to run
Database；
After getting the backup file of database to be tested, test macro can be on physical equipment physical equipment top
Administration, reduction, are run, build database to be tested, for TPC-DS test.
Step S204, test macro are tested according to TPC-DS, send data inquiry request and number to database to be tested
It is requested according to updating；
Wherein, data inquiry request carries out the corresponding data query test of TPC-DS test for treating test database,
Data update request and carry out the corresponding data maintaining operation of TPC-DS test for treating test database.
After building database to be tested, the test benchmark that test macro can be tested according to TPC-DS is to be tested to this
Database sends corresponding data inquiry request and data update request, so that the database to be tested carries out TPC-DS test
Corresponding response.
Step S205, test macro obtain the sound that database to be tested updates data inquiry request and data request
Answer result；
It is appreciated that database to be tested will do it sound when receiving data inquiry request and data update request
It answers, during response, test macro can be by the modes such as retrieving, monitoring, and it is right from the database to be tested to obtain its
The response results of request are updated in data inquiry request and data.
Step S206, test macro statistical data inquiry request and data update the response results of request, form TPC-
DS test result.
Test macro updates data inquiry request and data getting database to be tested the response knot of request
After fruit, statistical disposition can be carried out, TPC-DS test result is obtained.
From the foregoing, it will be observed that since TPC-DS test is what the backup file based on database to be tested was realized, in other words
It says, in TPC-DS test, using the replicate data library of database to be tested as test object, realizes physical isolation, avoid
When TPC-DS is tested directly using the original database to be tested on server as test object, TPC-DS test and former data to be tested
The normal work in library mutually impacts, and replicate data library can be directly unloaded after test, avoids in former data to be tested
Library leaves the data remanence of TPC-DS test, in addition, the normal work of former database to be tested can be maintained on the server on one side,
Another side can also complete the TPC-DS test to former database to be tested using replicate data library as test object, be also convenient for
The implementation of TPC-DS test, and then can further improve the measuring accuracy of TPC-DS test, it is treated based on TPC-DS test benchmark
The performance realization of test database is more accurately assessed.
Another process of TPC-DS test method convenient to carry out provided by the present application is shown with continued reference to Fig. 3, Fig. 3
Schematic diagram, specifically, TPC-DS test method convenient to carry out provided by the present application may include following steps:
Step S301, UE initiate test request to test macro；
Wherein, test request treats test database progress TPC-DS test for requesting, and test request carries to be tested
Wide area information server ID.
Step S302, test macro obtain the backup file of database to be tested according to database ID from server；
It is appreciated that step S201 and step S202 in step S301 and step S302, with Fig. 2 corresponding embodiment
Duplicate contents, specific details are not described herein.
Wherein, a cloud platform or relay device can also be built between UE and test macro, realize UE and test macro it
Between the information such as test request remote transmission.
Step S303, test macro obtain the corresponding SQL text of database to be tested according to database ID from server
Part；
Wherein, SQL file carries out data query test for treating test database.
Step S304, test macro parse SQL file, obtain multiple data inquiry requests；
It is appreciated that TPC-DS test benchmark provides source code, database syntax rule to be tested is generated by compiling
Executable file, the execution file, that is, SQL file, SQL file format can be for following:
The SQL file is parsed again, 99 data inquiry requests can be obtained, which is alternatively referred to as
Data query sentence.
In this application, backup file of the server in addition to database to be tested can be stored with, while also producing and depositing
The corresponding SQL file of database to be tested is stored up, is directly called convenient for follow-up test system, TPC-DS test is carried out.
Alternatively, the generation of the SQL file can also be executed by test macro, specifically it is not limited here.
Step S305, test macro disposes the backup file of database to be tested on the physical devices, to be tested to run
Database；
After getting the backup file of database to be tested, test macro can be on physical equipment physical equipment top
Administration, is run, builds database to be tested, for TPC-DS test.
99 data inquiry request random alignments are combined to obtain by step S306, the test macro according to power test
Power test set of uses case；
Wherein, power test set of uses case is used to test database to be tested and handles the response of each data inquiry request.
Step S307, test macro successively send power to database to be tested according to the sequence of power test set of uses case
The data inquiry request that test case is concentrated；
Step S308, test macro update the random row of request according to testing throughput, by data inquiry request and data
Column combination obtains testing throughput set of uses case；
Wherein, each testing throughput use-case in testing throughput set of uses case includes 99 data inquiry requests and more
A data update request.
Step S309, test macro are successively gulped down to database to be tested transmission according to the sequence of testing throughput set of uses case
The testing throughput use-case that the amount of spitting test case is concentrated；
It is appreciated that including two stages of power test and testing throughput in TPC-DS test.
The power test stage is handled the response of each data inquiry request for testing database to be tested, therefore, first
99 data inquiry requests are subjected to random alignment combination, are sent in turn to database to be tested according still further to sequence, so as to be measured
Examination database executes data inquiry request in turn, when carrying out response of the statistics available database to be tested to each data inquiry request
Between etc. response results.
The testing throughput stage, for testing database to be tested to multiple concurrent data inquiry requests and the number
According to the response processing for updating request, i.e. therefore the concurrent test of handling capacity first updates 99 data inquiry requests and data
Random alignment combination is requested, each testing throughput use-case includes that 99 data inquiry requests and the update of multiple data are asked
It asks.
Step S310, test macro obtain the sound that database to be tested updates data inquiry request and data request
Answer result；
It is appreciated that database to be tested will do it sound when receiving data inquiry request and data update request
It answers, during response, test macro can be by the modes such as retrieving, monitoring, and it is right from the database to be tested to obtain its
The response results of request are updated in data inquiry request and data.
Step S311, test macro statistical data inquiry request and data update the response results of request, form TPC-
DS test result；
Test macro updates data inquiry request and data getting database to be tested the response knot of request
After fruit, statistical disposition can be carried out, TPC-DS test result is obtained.
Step S312, test macro add database ID in TPC-DS test result；
It is corresponding, in TPC-DS test result, wide area information server ID to be tested is added, to be identified, with
Database to be tested is bound.
It is appreciated that test macro can locally save the TPC-DS test result after adding database ID.
In addition, server is corresponding in addition to the backup file and storage database to be tested that can be stored with database to be tested
SQL file outside, the TPC-DS test result of database to be tested can be also stored, to can be reserved for data to be tested in server
The complete TPC-DS test record in library.
Step S313, test macro send TPC-DS test result to server；
After having added database ID, test macro can send TPC-DS test result to server.
Step S314, test macro send TPC-DS test result to UE.
Certainly, in addition to sending TPC-DS test result to server, test macro can also send TPC-DS test knot to UE
Fruit, so that the TPC-DS test result of database to be tested can be directly viewable in user's first time.
It is to start to introduce the application below to the introduction of TPC-DS test method convenient to carry out 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. 4, Fig. 4, specifically, the application mentions
The test macro of confession may include such as flowering structure:
Receiving unit 401, for receive UE initiation test request, test request for request treat test database into
Row TPC-DS test, test request carry wide area information server ID to be tested；
Acquiring unit 402, for obtaining the backup file of database to be tested from server according to database ID；
Deployment unit 403, for disposing the backup file of database to be tested on the physical devices, to run number to be tested
According to library；
Transmission unit 404 sends data inquiry request and data to database to be tested for testing according to TPC-DS
Request is updated, data inquiry request is used to treat the data query test that test database carries out TPC-DS test, and data update
Request the data maintaining operation that TPC-DS test is carried out for treating test database；
Acquiring unit 402 is also used to obtain database to be tested and updates request for data inquiry request and data
Response results；
Statistic unit 405 updates the response results of request for statistical data inquiry request and data, forms TPC-DS
Test result.
Further, acquiring unit 402 are also used to obtain database pair to be tested from server according to database ID
The SQL file answered, SQL file carry out data query test for treating test database；
System further include:
Resolution unit 406 obtains multiple data inquiry requests for parsing SQL file.
Further, system further include:
Generation unit 407, for generating the corresponding SQL file of database to be tested, SQL text according to database to be tested
Part carries out data query test for treating test database；
Resolution unit 408 obtains multiple data inquiry requests for parsing SQL file.
Further, TPC-DS test includes power test and testing throughput, and transmission unit 404 is specifically used for:
According to power test, 99 data inquiry request random alignments are combined to obtain power test set of uses case；
According to the sequence of power test set of uses case, the data in power test set of uses case are successively sent to database to be tested
Inquiry request；
According to testing throughput, data inquiry request and data are updated into request random alignment and combine to obtain measurement of handling up
Set of uses case is tried, each testing throughput use-case in testing throughput set of uses case includes 99 data inquiry requests and multiple numbers
It is requested according to updating；
According to the sequence of testing throughput set of uses case, successively sent in testing throughput set of uses case to database to be tested
Testing throughput use-case.
Further, system further include:
Adding unit 409, for adding database ID in TPC-DS test result；
Storage unit 410, for saving TPC-DS test result；
Transmission unit 404 is also used to send TPC-DS test result to UE.
Another structural schematic diagram of test macro provided by the present application is shown refering to Fig. 5, Fig. 5, specifically, the application
The test macro of offer includes processor 501, real when processor 501 is for executing the computer program stored in memory 502
Now such as each step of the TPC-DS test method convenient to carry out in Fig. 2 or Fig. 3 corresponding embodiment；Alternatively, processor 501 is used for
The function such as each unit in Fig. 4 corresponding embodiment is realized when executing the computer program stored in memory 502.
Illustratively, computer program can be divided into one or more module/units, and one or more module/
Unit is stored in memory 502, and is executed by processor 501, 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 501, memory 502.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 501, memory 502, input-output equipment and network access equipment etc. pass through
Bus is connected.
Processor 501 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 502 can be used for storing computer program and/or module, and processor 501 is stored in by operation or execution
Computer program and/or module in memory 502, and the data being stored in memory 502 are called, realize computer dress
The various functions of setting.Memory 502 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
It realizes when execution such as the TPC-DS test method convenient to carry out in Fig. 2 or Fig. 3 corresponding embodiment.
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 be with reference to the TPC-DS test convenient to carry out in Fig. 2 or Fig. 3 corresponding embodiment
The explanation of method, specific details are not described herein.
In conclusion TPC-DS test method, system and readable storage medium storing program for executing convenient to carry out provided by the present application, by
Testing in TPC-DS is that the backup file based on database to be tested is realized, in other words, in TPC-DS test, with to be measured
The replicate data library of database is tried as test object, physical isolation is realized, avoids TPC-DS test directly on server
When former database to be tested is test object, TPC-DS test and the normal work of former database to be tested are mutually impacted,
Replicate data library can be directly unloaded after test, avoid the data for leaving TPC-DS test in former database to be tested residual
It stays, in addition, can maintain the normal work of former database to be tested on the server on one side, another side can also be with replicate data library
It completes to test the TPC-DS of former database to be tested as test object, is also convenient for the implementation of TPC-DS test, and then can be into
One step improves the measuring accuracy of TPC-DS test, is realized based on the performance that TPC-DS test benchmark treats test database more smart
Quasi- assessment.
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 convenient to carry out, which is characterized in that the described method includes:
Test macro receive user equipment (UE) initiate test request, the test request for request treat test database into
Row TPC-DS test, the test request carry the wide area information server to be tested and identify ID；
The test macro obtains the backup file of the database to be tested according to the database ID from server；
The test macro disposes the backup file of the database to be tested on the physical devices, to run the number to be tested
According to library；
The test macro is tested according to the TPC-DS, sends data inquiry request and data to the database to be tested
Request is updated, the data inquiry request is used to carry out the TPC-DS to the database to be tested to test corresponding data and look into
Test is ask, the data update request and test corresponding data maintenance for carrying out the TPC-DS to the database to be tested
Operation；
The test macro obtains the database to be tested and updates request for the data inquiry request and the data
Response results；
The test macro counts the data inquiry request and the data update the response results of request, forms TPC-DS
Test result.
2. the method according to claim 1, wherein the method also includes:
The test macro obtains the corresponding SQL of the database to be tested according to the database ID from the server
File, the SQL file are used to carry out the data query test to the database to be tested；
The test macro parses the SQL file, obtains multiple data inquiry requests.
3. the method according to claim 1, wherein the method also includes:
The test macro generates the corresponding SQL file of the database to be tested, and the SQL file is used for described to be tested
Database carries out the data query test；
The test macro parses the SQL file, obtains multiple data inquiry requests.
4. the method according to claim 1, wherein TPC-DS test includes power test and measurement of handling up
Examination, the test macro are tested according to the TPC-DS, send data inquiry request and data to the database to be tested
Updating request includes:
The test macro combines 99 data inquiry request random alignments to obtain power survey according to the power test
Try set of uses case；
The test macro successively sends the function to the database to be tested according to the sequence of the power test set of uses case
The data inquiry request that rate test case is concentrated；
The test macro updates request at random according to the testing throughput, by the data inquiry request and the data
Permutation and combination obtains testing throughput set of uses case, and each testing throughput use-case in the testing throughput set of uses case includes 99
A data inquiry request and multiple data update request；
Described in the test macro is sent according to the sequence of the testing throughput set of uses case, successively to the database to be tested
The testing throughput use-case in testing throughput set of uses case.
5. the method according to claim 1, wherein the method also includes:
The test macro adds the database ID in the TPC-DS test result；
The test macro saves the TPC-DS test result；
The test macro sends the TPC-DS test result to the UE.
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) initiation, the test request is for requesting to number to be tested
TPC-DS test is carried out according to library, the test request carries the wide area information server to be tested and identifies ID；
Acquiring unit, for obtaining the backup file of the database to be tested from server according to the database ID；
Deployment unit, it is described to be tested to run for disposing the backup file of the database to be tested on the physical devices
Database；
Transmission unit sends data inquiry request and number to the database to be tested for testing according to the TPC-DS
It is requested according to updating, the data inquiry request is used to carry out the database to be tested the data query of the TPC-DS test
Test, the data update the data maintaining operation requested for carrying out the TPC-DS test to the database to be tested；
The acquiring unit is also used to obtain the database to be tested for the data inquiry request and the data more
The response results newly requested；
Statistic unit updates the response results of request for counting the data inquiry request and the data, forms TPC-
DS test result.
7. system according to claim 6, which is characterized in that the acquiring unit is also used to according to the database ID,
The corresponding SQL file of the database to be tested is obtained from the server, the SQL file is used for the number to be tested
The data query test is carried out according to library；
The system also includes:
Resolution unit obtains multiple data inquiry requests for parsing the SQL file.
8. system according to claim 6, which is characterized in that the system also includes:
Generation unit, it is described for generating the corresponding SQL file of the database to be tested according to the database to be tested
SQL file is used to carry out the data query test to the database to be tested；
Resolution unit obtains multiple data inquiry requests for parsing the SQL file.
9. system according to claim 6, which is characterized in that the TPC-DS test includes power test and measurement of handling up
Examination, the transmission unit are specifically used for:
According to the power test, 99 data inquiry request random alignments are combined to obtain power test set of uses case；
According to the sequence of the power test set of uses case, the power test set of uses case successively is sent to the database to be tested
In the data inquiry request；
According to the testing throughput, the data inquiry request and the data are updated into request random alignment and combine to obtain
Testing throughput set of uses case, each testing throughput use-case in the testing throughput set of uses case include that 99 data are looked into
It askes request and multiple data updates request；
According to the sequence of the testing throughput set of uses case, the testing throughput successively is sent to the database to be tested and is used
The testing throughput use-case that example is concentrated.
10. system according to claim 6, which is characterized in that the system also includes:
Adding unit, for adding the database ID in the TPC-DS test result；
Storage unit, for saving the TPC-DS test result；
The transmission unit is also used to send the TPC-DS test result to the UE.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910253172.2A CN109902027B (en) | 2019-03-29 | 2019-03-29 | TPC-DS testing method and system convenient to implement |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910253172.2A CN109902027B (en) | 2019-03-29 | 2019-03-29 | TPC-DS testing method and system convenient to implement |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109902027A true CN109902027A (en) | 2019-06-18 |
| CN109902027B CN109902027B (en) | 2020-05-29 |
Family
ID=66955042
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910253172.2A Active CN109902027B (en) | 2019-03-29 | 2019-03-29 | TPC-DS testing method and system convenient to implement |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109902027B (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110457188A (en) * | 2019-06-28 | 2019-11-15 | 武汉迎风聚智科技有限公司 | It can keep the TPC-E test method and test macro of transaction types ratio |
| CN110457187A (en) * | 2019-06-28 | 2019-11-15 | 武汉迎风聚智科技有限公司 | Based on backup test data can convenient operation TPC-E test method and testing service device |
| CN110704300A (en) * | 2019-08-27 | 2020-01-17 | 武汉迎风聚智科技有限公司 | TPC-DS automated test method and TPC-DS test system |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103186561A (en) * | 2011-12-28 | 2013-07-03 | 深圳市金蝶友商电子商务服务有限公司 | Data test method, test library generating method and related device |
| US20140122435A1 (en) * | 2012-10-31 | 2014-05-01 | International Business Machines Corporation | Intelligent restore-container service offering for backup validation testing and business resiliency |
| CN105302730A (en) * | 2015-12-09 | 2016-02-03 | 浪潮集团有限公司 | Calculation model detection method, testing server and service platform |
| CN106095624A (en) * | 2016-06-28 | 2016-11-09 | 北京金山安全软件有限公司 | Data recovery method and device, terminal equipment and server |
| CN106547646A (en) * | 2015-09-23 | 2017-03-29 | 阿里巴巴集团控股有限公司 | A kind of data backup and restoration methods, data backup and recovery device |
| CN106681867A (en) * | 2015-11-09 | 2017-05-17 | 阿里巴巴集团控股有限公司 | Testing method and device |
-
2019
- 2019-03-29 CN CN201910253172.2A patent/CN109902027B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103186561A (en) * | 2011-12-28 | 2013-07-03 | 深圳市金蝶友商电子商务服务有限公司 | Data test method, test library generating method and related device |
| US20140122435A1 (en) * | 2012-10-31 | 2014-05-01 | International Business Machines Corporation | Intelligent restore-container service offering for backup validation testing and business resiliency |
| CN106547646A (en) * | 2015-09-23 | 2017-03-29 | 阿里巴巴集团控股有限公司 | A kind of data backup and restoration methods, data backup and recovery device |
| CN106681867A (en) * | 2015-11-09 | 2017-05-17 | 阿里巴巴集团控股有限公司 | Testing method and device |
| CN105302730A (en) * | 2015-12-09 | 2016-02-03 | 浪潮集团有限公司 | Calculation model detection method, testing server and service platform |
| CN106095624A (en) * | 2016-06-28 | 2016-11-09 | 北京金山安全软件有限公司 | Data recovery method and device, terminal equipment and server |
Non-Patent Citations (1)
| Title |
|---|
| 何磊: ""基于TPC-DS的测试系统研发"", 《中国优秀硕士学位论文全文数据库 信息科技辑》 * |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110457188A (en) * | 2019-06-28 | 2019-11-15 | 武汉迎风聚智科技有限公司 | It can keep the TPC-E test method and test macro of transaction types ratio |
| CN110457187A (en) * | 2019-06-28 | 2019-11-15 | 武汉迎风聚智科技有限公司 | Based on backup test data can convenient operation TPC-E test method and testing service device |
| CN110457188B (en) * | 2019-06-28 | 2021-02-23 | 武汉迎风聚智科技有限公司 | TPC-E test method and system capable of keeping transaction type proportion |
| CN110704300A (en) * | 2019-08-27 | 2020-01-17 | 武汉迎风聚智科技有限公司 | TPC-DS automated test method and TPC-DS test system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109902027B (en) | 2020-05-29 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112527848B (en) | Report data query method, device and system based on multiple data sources and storage medium | |
| CN112800095A (en) | Data processing method, device, equipment and storage medium | |
| CN110347596A (en) | A kind of test method, device, system, electronic equipment and medium | |
| CN110830234B (en) | User traffic distribution method and device | |
| CN107645562A (en) | Data transmission processing method, device, equipment and system | |
| CN109074362A (en) | Fractionation and moving range in distributed system | |
| EP3660665A1 (en) | Business processing method, apparatus, device and system using the same, and readable storage medium of the same | |
| CN110659206A (en) | Simulation architecture establishing method, device, medium and electronic equipment based on microservice | |
| CN114401187B (en) | Gray scale issuing method, device, computer equipment and storage medium | |
| CN105988926A (en) | Method and device for processing multi-version test data | |
| CN109902027A (en) | A kind of TPC-DS test method and system convenient to carry out | |
| CN111431818B (en) | Cross-domain request flow distribution method and device, storage medium and computer equipment | |
| CN114168360A (en) | Operating method, device, electronic device and storage medium of client system | |
| CN110069406A (en) | The TPC-DS test method and system of automatic trigger | |
| CN108304321A (en) | A kind of method, system and device creating front and back end exploitation joint debugging environment | |
| CN113691618A (en) | Message notification method, device, message center and storage medium | |
| CN112199113A (en) | Software service access control method and device | |
| CN113190460A (en) | Method and device for automatically generating test cases | |
| CN118427201A (en) | Method and device for executing update statement, electronic equipment and computer storage medium | |
| CN117251170A (en) | Processing method and device for extensible markup language file | |
| CN114706635A (en) | Application program logic processing method, device and equipment | |
| CN113687965B (en) | Data interaction method, device, equipment and storage medium | |
| CN113656484A (en) | Database access system, method and device, electronic equipment and storage medium | |
| CN115994080A (en) | Application request processing method, device, medium and equipment | |
| US20140358850A1 (en) | Open feedback apparatus and method of operating the same |
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 |