CN110069390A - It is a kind of can accurate statistical disposition efficiency TPC-E test method and system - Google Patents
It is a kind of can accurate statistical disposition efficiency TPC-E test method and system Download PDFInfo
- Publication number
- CN110069390A CN110069390A CN201910165026.4A CN201910165026A CN110069390A CN 110069390 A CN110069390 A CN 110069390A CN 201910165026 A CN201910165026 A CN 201910165026A CN 110069390 A CN110069390 A CN 110069390A
- Authority
- CN
- China
- Prior art keywords
- test
- database
- tested
- tpc
- client application
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/30—Monitoring
- G06F11/34—Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment
- G06F11/3452—Performance evaluation by statistical analysis
Landscapes
- Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- Probability & Statistics with Applications (AREA)
- Evolutionary Biology (AREA)
- Bioinformatics & Computational Biology (AREA)
- Computer Hardware Design (AREA)
- Bioinformatics & Cheminformatics (AREA)
- Quality & Reliability (AREA)
- General Physics & Mathematics (AREA)
- Life Sciences & Earth Sciences (AREA)
- Debugging And Monitoring (AREA)
Abstract
This application provides it is a kind of can accurate statistical disposition efficiency TPC-E test method and system, for easy and accurate geo-statistic database to be tested for the treatment effeciency of transaction request.Method includes: that test macro obtains the transaction request that client application is initiated, the simulation affairs that transaction request is used to that database processing client application to be tested to be requested to generate, and simulation affairs carry out TPC-E test for treating test database；Test macro is detected with the presence or absence of idle connection in connection pool, and the free time is connected as the network connection pre-established between test macro and database to be tested；If it exists, then test macro is connected to database to be tested by the free time and forwards transaction request；Test macro obtains database to be tested response results corresponding with multiple transaction requests；Test macro sends response results to client application, so that client application is according to response as a result, form the TPC-E test result of database to be tested, and to management platform output.
Description
Technical field
This application involves database field, more particularly to it is a kind of can accurate statistical disposition efficiency TPC-E test method with
And system.
Background technique
With update of the database technology in business application scene, Transaction Processing Performance Council (Transaction
Process Performance Council, TPC) database test benchmark is also updated, to adapt to enterprise now using ring
The performance of database is accurately assessed in border.
Database test benchmark now is proposed TPC-E test benchmark, intersects original TPC-C test benchmark, has
Biggish advantage, therefore, on the market gradually in substitution TPC-C test benchmark.
And found in the popularization and application of TPC-E test benchmark, in the TPC-E test result that practical TPC-E is tested,
The test result for the treatment of effeciency corresponding with the response time, often there is floating, error in other words, it is clear that this is for TPC-E
The practical application of test benchmark, needs go to overcome.
Summary of the invention
This application provides it is a kind of can accurate statistical disposition efficiency TPC-E test method and system, for it is easy with
And accurate geo-statistic database to be tested is for the treatment effeciency of transaction request.
In a first aspect, the application provide it is a kind of can accurate statistical disposition efficiency TPC-E test method, method includes:
Test macro obtains the transaction request that client application is initiated, and transaction request is for requesting number to be tested
According to the simulation affairs that library processing client application generates, simulation affairs carry out TPC-E test for treating test database；
Test macro is detected with the presence or absence of idle connection in connection pool, and the free time is connected as test macro and database to be tested
Between the network connection that pre-establishes；
If it exists, then test macro is connected to database to be tested by the free time and forwards transaction request；
Test macro monitors database to be tested response results corresponding with multiple transaction requests；
Test macro to client application send response results so that client application according to response as a result, formed to
The TPC-E test result of test database, and TPC-E test result is exported to management platform.
Optionally, client and test macro are set to same physical equipment.
Optionally, before the transaction request that test macro obtains that client application is initiated, method further include:
The N item free time that test macro is established between database to be tested connects, and N is the positive integer not less than 1, N and visitor
The quantity M of family end application is corresponding；
The N item free time is connected and is stored in connection pool by test macro.
Optionally, method further include:
Test macro sends instruction information to client application, and instruction information is used to indicate client application and establishes present count
According to the data file of structure, data file is for storing TPC-E test result and transaction request.
Optionally, TPC-E test result is specially JSON file, TXT file or form document.
Second aspect, the application provide a kind of test macro, and system includes:
Acquiring unit, for obtain client application initiation transaction request, transaction request for request to
Test database handles the simulation affairs that client application generates, and simulation affairs carry out TPC-E survey for treating test database
Examination；
Detection unit, for detecting with the presence or absence of idle connection in connection pool, the free time be connected as test macro with it is to be tested
The connection pre-established between database, and if it exists, then trigger retransmission unit；
Retransmission unit forwards transaction request for connecting by the free time to database to be tested；
Monitoring unit, for monitoring database to be tested response results corresponding with multiple transaction requests；
Transmission unit, for sending response results to client application, so that client application is according to response as a result, shape
TPC-E test result is exported at the TPC-E test result of database to be tested, and to management platform.
Optionally, client application and test macro are set to same physical equipment.
Optionally, system further include:
Unit is established, the N item free time established between database to be tested connects, and N is the positive integer not less than 1, N and visitor
The quantity M of family end application is corresponding；
Storage unit is stored in connection pool for connecting the N item free time.
Optionally, transmission unit, is also used to send instruction information to client application, and instruction information is used to indicate client
Using the data file for establishing preset data structure, data file is for storing TPC-E test result and transaction request.
Optionally, TPC-E test result is specially JSON file, TXT file or form document.
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 can accurate statistical disposition efficiency TPC-E test method any step
Suddenly.
Fourth aspect, the application provide a kind of readable storage medium storing program for executing, are stored thereon with computer program, computer program quilt
Realized when processor executes as above-mentioned first aspect can accurate statistical disposition efficiency TPC-E test method either step.
As can be seen from the above technical solutions, the application has the following advantages:
During TPC-E test, client application initiates the transaction request for TPC-E test, test system
System again by pre-established between database to be tested free time connect, forward the request to database to be tested, due to by
Test macro is docked with database to be tested, the transaction request that forwarding client application is initiated, therefore be can guarantee and surveyed
Test system can easy and accurate geo-statistic database to be tested for transaction request treatment effeciency, thus it is available more
Add accurate TPC-E test result.
In addition, can also save the time cost and letter for establishing network connection between client application and database to be tested
Cost is enabled, saves and establishes the network connection institute between client application and database to be tested for each transaction request
The Internet resources needed, and then improve and treat the testing efficiency that test database carries out TPC-E test.
Detailed description of the invention
Fig. 1 shows a kind of schematic diagram of a scenario of TPC-E test provided by the present application；
Fig. 2 shows it is provided by the present application can accurate statistical disposition efficiency TPC-E test method a kind of signal of process
Figure；
Fig. 3 show it is provided by the present application can another process of TPC-E test method of accurate statistical disposition efficiency show
It is intended to；
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
This application provides it is a kind of can accurate statistical disposition efficiency TPC-E test method and system, for it is easy with
And accurate geo-statistic database to be tested is for the treatment effeciency of transaction request.
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 a kind of field of TPC-E test provided by the present application before introducing the application
Scape schematic diagram, as shown in Figure 1, test macro, database to be tested and client application are deployed in different physics respectively
Run in equipment, under the control management of management platform side, client application initiates transaction request, carry in request for
The simulation affairs of test database response, test macro forwards the request to database to be tested, then obtains database to be tested
For simulating the response results of affairs, to form the TPC-E test result of database to be tested.Wherein, due to by test macro
It is docked with database to be tested, the transaction request that forwarding client application is initiated, therefore can guarantee that test macro can
Treatment effeciency of the easy and accurate geo-statistic database to be tested for transaction request.
Secondly, this application involves TPC-E test, test philosophy include: so that database to be tested execute TPC-E survey
Corresponding simulation affairs are tried, further according to database to be tested to the response results of simulation affairs, form TPC-E test result.Mould
It include that brokered transaction counts affairs (Broker-Volume), customer value statistics affairs (Customer- in quasi- affairs
Position), market watch affairs (Market-Watch), data maintenance affairs (Data-Maintenance), securities information
Affairs (Security-Detail), Transaction Inquiries affairs (Trade-Lookup), transaction execute affairs (Trade-Order), hand over
Easy status transactions (Trade-Status), transaction amendment affairs (Trade-Update), market track affairs (Market-
Feed), transaction results update affairs (Trade-Result) and transaction cleaning affairs (Trade-Cleanup), affairs kind
The mixed proportion of class is adjustable, and the mixed proportion finally executed is not done specifically herein in the reference range that TPC-E is tested
It limits.Wherein, in this application, the simulation affairs that client application is initiated include in the above 12 class affairs except market tracks thing
Business, transaction results update the affairs except affairs and transaction cleaning affairs.
In the following, then be based on above-mentioned schematic diagram of a scenario shown in fig. 1, start to data library test method provided by the present application into
Row is discussed in detail.
Referring to Fig.2, Fig. 2 shows it is provided by the present application can accurate statistical disposition efficiency TPC-E test method one kind
Flow diagram, specifically, it is provided by the present application can the TPC-E test method of accurate statistical disposition efficiency may include walking as follows
It is rapid:
Step S201, test macro obtain the transaction request that client application is initiated；
Wherein, the simulation affairs that transaction request is used to that database processing client application to be tested to be requested to generate, mould
Quasi- affairs carry out TPC-E test for treating test database.
In the test process for carrying out TPC-E test, multiple transaction requests are initiated in multiple client application respectively, are surveyed
Test system gets multiple requests of client application side initiation by preset multiple data-interfaces.
Step S202, test macro detect in connection pool with the presence or absence of idle connection, and if it exists, then trigger step S203；
Wherein, idle to be connected as the network connection pre-established between test macro and database to be tested.
Test macro get client application side initiation transaction request after, be with can be detected in connection pool
It is no to there is idle connection, it will be understood that the connection pool is used to storing to be pre-established between test macro and database to be tested
Network connection.
When detecting the presence of idle connection, that is, it can determine that a target free time connects, carry out the forwarding of transaction request.
Step S203, test macro are connected to database to be tested by the free time and forward transaction request；
After test macro determines the connection of target free time, the thing of client application side initiation can be forwarded to database to be tested
Business processing request, and can accurately determine that transaction request is sent to the time of database to be tested.
After having forwarded transaction request by free time connection, which can be arranged free mark, put back in connection pool.
Step S204, test macro monitor database to be tested response results corresponding with multiple transaction requests；
In the storing process of the simulation affairs entrained by database response transaction request to be tested, test macro can
According to the connection with database to be tested, the corresponding response results of simulation affairs are monitored.
Wherein, test macro can monitor the generation of response results in database to be tested, thus according to above-mentioned office
The delivery time of request is managed, and the deadline of the correspondence response results real-time monitored, it can accurate geo-statistic number to be tested
The accurate geo-statistic database to be tested of processing according to library for the response time of simulation affairs, so as to to(for) transaction request
Efficiency.
Certainly, it is to be understood that in addition to the above-mentioned 9 analoglike affairs and its corresponding response initiated by client application
As a result, test macro also may make database to be tested to execute market tracking affairs, transaction results that client application is not directed to
Affairs and transaction cleaning affairs are updated, and obtain corresponding response results, to be tested according to database to be tested TPC-E
The response results of the 12 class affairs standardized in benchmark complete TPC-E test.
Step S205, test macro sends response results to client application, so that client application is tied according to response
Fruit forms the TPC-E test result of database to be tested, and exports TPC-E test result to management platform.
After getting response results, client application can form complete TPC-E test result, characterize number to be tested
According to the performance indicator in library.
After obtaining TPC-E test result, client application can be to management platform output, with to relevant staff's exhibition
Show.
Wherein, management platform can be built by server apparatus, realize the effect of long-range management TPC-E test.
From the foregoing, it will be observed that it is provided by the present application can accurate statistical disposition efficiency TPC-E test method, surveyed in TPC-E
During examination, client application initiate for TPC-E test transaction request, test macro again by with number to be tested
According to the free time connection pre-established between library, the request is forwarded to database to be tested, due to by test macro and number to be tested
It is docked according to library, the transaction request that forwarding client application is initiated, therefore can guarantee that test macro can easy and essence
True geo-statistic database to be tested tests the treatment effeciency of transaction request so that more accurate TPC-E can be obtained
As a result.
In addition, can also save the time cost and letter for establishing network connection between client application and database to be tested
Cost is enabled, saves and establishes the network connection institute between client application and database to be tested for each transaction request
The Internet resources needed, and then improve and treat the testing efficiency that test database carries out TPC-E test.
With continued reference to Fig. 3, Fig. 3 show it is provided by the present application can accurate statistical disposition efficiency TPC-E test method
Another flow diagram, specifically, it is provided by the present application can accurate statistical disposition efficiency TPC-E test method may include as
Lower step:
Step S301, management platform initiate test request；
Wherein, test request treats test database for request for test system and carries out TPC-E test.
In practical applications, client application can be also set on same physical equipment with test macro, physical equipment difference
Network connection between the two is connected by virtual network and is realized by both operations, to save the hardware cost of TPC-E test,
Meanwhile management platform also may make more can easily to control the fortune of client application and test macro on same physical equipment
Row.
Step S302, client application initiate transaction request；
After treating the TPC-E test assignment of test database according to test request determination, client application initiates affairs
Processing request.
In this application, management platform can also send above-mentioned test request to test macro, and test macro can trigger visitor
It applies to itself and initiates transaction request in family end；Alternatively, test macro can also be sent out in client application to database to be tested
When playing transaction request, the transaction request is intercepted and captured, then carry out subsequent processing.
Step S303, test macro detect in connection pool with the presence or absence of idle connection, and if it exists, then trigger step S304；
Step S304, test macro are connected to database to be tested by the free time and forward transaction request；
It is appreciated that step S203 and step S204 class in step S303 and step S304, with Fig. 2 corresponding embodiment
Seemingly, specifically details are not described herein for duplicate contents.
Wherein it is possible to understand, test macro can be established and number to be tested before client application initiates transaction request
It is connected to the network (N >=1) according to the N item between library, makees idle processing, is stored in connection pool.
In practical applications, the quantity of N specifically can be corresponding with the quantity M of client application, for example, can N > M, guarantee different
The transaction request initiated simultaneously of client application can be forwarded to database to be tested by different idle connections；Or
Person, can also N < M, by the setting of preset ratio or default connection strap number, in the thing for guaranteeing that different client applications is initiated
When business processing request can be connected by the cross-reference free time and can swimmingly be forwarded to database to be tested, can also further it save
The quantity for saving idle connection, reduces the occupancy of Internet resources.
If monitoring, the network connection for being transmitted across transaction request does not carry out transaction request in threshold value duration
It sends, then free mark can be arranged in the connection by test macro, connected and be retracted in connection pool labeled as the free time.
Step S305, test macro monitor database to be tested response results corresponding with multiple transaction requests；
In the storing process of the simulation affairs entrained by database response transaction request to be tested, test macro can
According to the connection with database to be tested, the corresponding response results of simulation affairs are monitored.
Step S306, test macro sends response results to client application, so that client application is tied according to response
Fruit forms the TPC-E test result of database to be tested, and exports TPC-E test result to management platform；
After getting response results, client application can form complete TPC-E test result, characterize number to be tested
According to the performance indicator in library.
Step S307, client application is according to response as a result, form TPC-E test result；
In practical applications, TPC-E test result can be specially that different file formats exists, to adapt to different applications
The file formats such as scene, such as JSON file, TXT file or diagram file.
Step S308, client application export TPC-E test result to management platform；
After obtaining TPC-E test result, test macro can be to management platform output, with to relevant staff's exhibition
Show.
In this application, management platform can also send TPC-E test knot to user equipment (User Equipment, UE)
Fruit checks for staff.
UE can be specially the equipment such as desktop computer, laptop, smart phone or tablet computer, and UE includes that input is defeated
The structures such as equipment out so that user initiates test request, and show TPC-E test result to user, wherein UE can be used
The different types of operating systems such as Mac OS, Windows, Android, IOS, Tizen, Ubuntu or Windows Phone,
Specifically it is not limited here.
Wherein, it is to be understood that management platform also directly can test corresponding application by the TPC-E including UE, alternatively, pipe
Platform can test corresponding application by the TPC-E of UE and build realizations, thus, relevant staff can directly by UE and
Manage platform docking, the execution of management TPC-E test and the TPC-E test result for checking management platform feedback.
Step S309, test macro send instruction information to client application；
Wherein, instruction information is used to indicate the data file that client application establishes preset data structure, data file is used
The TPC-E test result and transaction request that test database carries out TPC-E test are treated in memory test system
It is appreciated that not only facilitating dilatation, and can test through current TPC-E will by establishing above-mentioned data file
Significant data is polymerize, so that the subsequent test process that can restore current TPC-E test according to the data file, is conducive to
The information of related personnel is inquired and test and management.
Step S310, client application establish data file.
After the instruction information for receiving test macro transmission, client application can be built according to the instruction of instruction information
Found the data file of the preset data structure.
The data file test macro can be saved locally, or also be can be transmitted to management platform and carried out cloud storage, specifically be existed
This is without limitation.
Be above to it is provided by the present application can accurate statistical disposition efficiency TPC-E test method introduction, start below
Introduce test macro provided by the present application.
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:
Acquiring unit 401, for obtaining the transaction request of client application initiation, transaction request is for requesting
The simulation affairs that database processing client application to be tested generates, simulation affairs carry out TPC-E for treating test database
Test；
Detection unit 402, for detecting with the presence or absence of idle connection in connection pool, the free time be connected as test macro with it is to be measured
The connection pre-established between examination database, and if it exists, then trigger retransmission unit 403；
Retransmission unit 403 forwards transaction request for connecting by the free time to database to be tested；
Monitoring unit 404, for monitoring database to be tested response results corresponding with multiple transaction requests；
Transmission unit 405, for sending response results to client application, so that client application is tied according to response
Fruit forms the TPC-E test result of database to be tested, and exports TPC-E test result to management platform.
Optionally, client application and test macro are set to same physical equipment.
Optionally, system further include:
Establish unit 406, the N item free time established between database to be tested connect, and N is the positive integer greater than 1, N and
The quantity M of client application is corresponding；
Storage unit 407 is stored in connection pool for connecting the N item free time.
Optionally, transmission unit 405, are also used to send instruction information to client application, and instruction information is used to indicate visitor
The data file of preset data structure is established in the application of family end, and data file is for storing TPC-E test result and issued transaction
Request.
Optionally, TPC-E test result is specially JSON file, TXT file or form document.
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 as Fig. 2 or Fig. 3 corresponds to each step of the data library test method in any embodiment；Alternatively, processor 501 is deposited for executing
The function such as each unit in Fig. 4 corresponding embodiment is realized when the computer program stored in reservoir 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
Realized when execution as Fig. 2 or Fig. 3 correspond in any embodiment can accurate statistical disposition efficiency TPC-E test method.
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 with reference in Fig. 2 or Fig. 3 corresponding embodiment can accurate statistical disposition efficiency
The explanation of TPC-E test method, specific details are not described herein.
In conclusion provided by the present application the TPC-E test method of accurate statistical disposition efficiency, system and readable can deposit
Storage media, during TPC-E test, client application initiates the transaction request for TPC-E test, test macro
It is connect again by the free time pre-established between database to be tested, the request is forwarded to database to be tested, due to by surveying
Test system is docked with database to be tested, the transaction request that forwarding client application is initiated, therefore can guarantee test
System can easy and accurate geo-statistic database to be tested for transaction request treatment effeciency, thus it is available more
Accurate TPC-E test result.
In addition, can also save the time cost and letter for establishing network connection between client application and database to be tested
Cost is enabled, saves and establishes the network connection institute between client application and database to be tested for each transaction request
The Internet resources needed, and then improve and treat the testing efficiency that test database carries out TPC-E 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. one kind can accurate statistical disposition efficiency TPC-E test method, which is characterized in that the described method includes:
Test macro obtains the transaction request that client application is initiated, and the transaction request is for requesting number to be tested
The simulation affairs that the client application generates are handled according to library, the simulation affairs are used to carry out the database to be tested
TPC-E test；
With the presence or absence of idle connection in test macro detection connection pool, the free time be connected as the test macro with it is described
The network connection pre-established between database to be tested；
If it exists, then the test macro is connected to the database to be tested by the free time issued transaction is forwarded to ask
It asks；
The test macro monitors the database to be tested response results corresponding with multiple transaction requests；
The test macro sends the response results to the client application, so that the client application is according to
Response results form the TPC-E test result of the database to be tested, and export the TPC-E test knot to management platform
Fruit.
2. the method according to claim 1, wherein the client application and the test macro are set to together
One physical equipment.
3. the method according to claim 1, wherein obtaining the thing that client application is initiated in the test macro
Before business processing request, the method also includes:
Free time described in the N item that the test macro is established between the database to be tested connects, and the N is not less than 1
Positive integer, the N are corresponding with the quantity M of the client application；
The connection of free time described in the N item is stored in the connection pool by the test macro.
4. the method according to claim 1, wherein the method also includes:
The test macro sends instruction information to the client application, and the instruction information is used to indicate the client and answers
With the data file for establishing preset data structure, the data file is for storing the TPC-E test result and the thing
Business processing request.
5. the method according to claim 1, wherein the TPC-E test result is specially JSON file, TXT
File or diagram file.
6. a kind of test macro, which is characterized in that the system comprises:
Acquiring unit, for obtain client application initiation transaction request, the transaction request for request to
Test database handles the simulation affairs that the client application generates, and the simulation affairs are used for the database to be tested
Carry out TPC-E test；
Detection unit, for detecting with the presence or absence of idle connection in connection pool, the free time is connected as the test macro and institute
State the connection pre-established between database to be tested, and if it exists, then trigger retransmission unit；
The retransmission unit forwards the transaction request for connecting by the free time to the database to be tested；
Monitoring unit, for monitoring the database to be tested response results corresponding with multiple transaction requests；
Transmission unit, for sending the response results to the client application, so that the client application is according to institute
Response results are stated, form the TPC-E test result of the database to be tested, and export the TPC-E test to management platform
As a result.
7. system according to claim 6, which is characterized in that the client application and the test macro are set to together
One physical equipment.
8. system according to claim 6, which is characterized in that the system also includes:
Unit is established, establishes and is connected the free time described in the N item between the database to be tested, the N is just whole not less than 1
Number, the N are corresponding with the quantity M of the client application；
Storage unit, for the connection of free time described in the N item to be stored in the connection pool.
9. system according to claim 6, which is characterized in that the transmission unit is also used to:
Instruction information is sent to the client application, the instruction information is used to indicate the client application and establishes present count
According to the data file of structure, the data file is for storing the TPC-E test result and the transaction request.
10. system according to claim 6, which is characterized in that the TPC-E test result is specially JSON file, TXT
File or diagram file.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910165026.4A CN110069390A (en) | 2019-03-05 | 2019-03-05 | It is a kind of can accurate statistical disposition efficiency TPC-E test method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910165026.4A CN110069390A (en) | 2019-03-05 | 2019-03-05 | It is a kind of can accurate statistical disposition efficiency TPC-E test method and system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110069390A true CN110069390A (en) | 2019-07-30 |
Family
ID=67366051
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910165026.4A Pending CN110069390A (en) | 2019-03-05 | 2019-03-05 | It is a kind of can accurate statistical disposition efficiency TPC-E test method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110069390A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111143198A (en) * | 2019-12-10 | 2020-05-12 | 湖北大学 | Test data processing method and device |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102158373A (en) * | 2011-05-12 | 2011-08-17 | 哈尔滨工业大学 | Performance evaluation system of high-end server for intermediary business of bank |
| CN102385582A (en) * | 2010-08-31 | 2012-03-21 | 中兴通讯股份有限公司 | Method, server and system for processing production test data |
| CN107193632A (en) * | 2017-05-16 | 2017-09-22 | 上海斐讯数据通信技术有限公司 | A kind of reference test method and system for simulating securities trading |
-
2019
- 2019-03-05 CN CN201910165026.4A patent/CN110069390A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102385582A (en) * | 2010-08-31 | 2012-03-21 | 中兴通讯股份有限公司 | Method, server and system for processing production test data |
| CN102158373A (en) * | 2011-05-12 | 2011-08-17 | 哈尔滨工业大学 | Performance evaluation system of high-end server for intermediary business of bank |
| CN107193632A (en) * | 2017-05-16 | 2017-09-22 | 上海斐讯数据通信技术有限公司 | A kind of reference test method and system for simulating securities trading |
Non-Patent Citations (1)
| Title |
|---|
| 杨超: "TPC-E测试系统的设计与实现", 《中国优秀硕士学位论文全文数据库 信息科技辑》 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111143198A (en) * | 2019-12-10 | 2020-05-12 | 湖北大学 | Test data processing method and device |
| CN111143198B (en) * | 2019-12-10 | 2023-04-28 | 湖北大学 | Test data processing method and device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105005521B (en) | Method of testing and device | |
| US10997063B1 (en) | System testing from production transactions | |
| WO2021129367A1 (en) | Method and apparatus for monitoring distributed storage system | |
| CN103761309B (en) | Operation data processing method and system | |
| CN110417558A (en) | Verification method and device, the storage medium and electronic device of signature | |
| CN105027108B (en) | Example host is configured | |
| CN110428325A (en) | Transaction tracking and device | |
| US8756269B2 (en) | Monitoring a path of a transaction across a composite application | |
| CN106470133A (en) | System pressure method of testing and device | |
| CN105979007A (en) | Acceleration resource processing method and device and network function virtualization system | |
| CN202918339U (en) | Ground test-launch-control system of carrier rocket based on cloud computing | |
| CN108920948A (en) | A kind of anti-fraud streaming computing device and method | |
| CN108595316A (en) | Life cycle management method, manager, equipment and the medium of Distributed Application | |
| CN109542781A (en) | Block chain common recognition test of heuristics method, apparatus, computing device and storage medium | |
| CN110069390A (en) | It is a kind of can accurate statistical disposition efficiency TPC-E test method and system | |
| CN104537284A (en) | Software protecting system and method based on remote service | |
| CN110489334A (en) | A kind of system integration and test test processing method and device | |
| CN109359034A (en) | A kind of operation system test method, computer readable storage medium and terminal device | |
| CN112612496A (en) | Intelligent contract operation management method, device, equipment and computer storage medium | |
| CN110532810A (en) | Information processing method, device, electronic equipment and readable storage medium storing program for executing | |
| CN104735134B (en) | A kind of method and apparatus serviced for providing calculating | |
| CN110363638A (en) | The method for processing business, device and electronic equipment of non-targeted user in financial business | |
| CN114331446A (en) | Method, device, equipment and medium for realizing out-of-chain service of block chain | |
| CN113986710A (en) | Big data platform monitoring method and device | |
| CN110266564A (en) | The method of the method and control device and its execution of detection device and its execution |
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 |