CN110457188B - TPC-E test method and system capable of keeping transaction type proportion - Google Patents
TPC-E test method and system capable of keeping transaction type proportion Download PDFInfo
- Publication number
- CN110457188B CN110457188B CN201910572321.1A CN201910572321A CN110457188B CN 110457188 B CN110457188 B CN 110457188B CN 201910572321 A CN201910572321 A CN 201910572321A CN 110457188 B CN110457188 B CN 110457188B
- Authority
- CN
- China
- Prior art keywords
- transaction
- simulated
- different
- transactions
- tpc
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/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/3409—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 for performance assessment
- G06F11/3428—Benchmarking
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F2201/00—Indexing scheme relating to error detection, to error correction, and to monitoring
- G06F2201/80—Database-specific techniques
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F2201/00—Indexing scheme relating to error detection, to error correction, and to monitoring
- G06F2201/87—Monitoring of transactions
Landscapes
- Engineering & Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Computer Hardware Design (AREA)
- Quality & Reliability (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Debugging And Monitoring (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The application provides a TPC-E test method and a test system capable of keeping transaction type proportion, which are used for ensuring that different processing proportions of simulated transactions of different transaction types can be kept in different time periods when a database is subjected to TPC-E test. Triggering a TPC-E test task aiming at a target database by a test system; the test system obtains different processing proportions of simulated transactions of different transaction types in the TPC-E test task; the test system establishes a transaction sequencing table; the test system randomly arranges the simulated transactions of different transaction types in the transaction ordering table, and the test system can meet the proportion limit of different processing proportions of the simulated transactions of different transaction types in different processing time periods; the test system sequentially triggers the target database to process simulated transactions of different transaction types according to the simulated transaction sequence in the transaction sorting table; the test system monitors the processing results of the target database for the simulated transactions of different transaction types to obtain the TPC-E test result of the target database.
Description
Technical Field
The present application relates to the field of testing, and in particular, to a TPC-E testing method and a TPC-E testing system capable of maintaining transaction type ratios.
Background
The TPC-E test benchmarks are new database test benchmarks derived by the Transaction Processing Performance Council (TPC).
Based on TPC-E test reference, a related TPC-E test tool needs to be developed, and in the TPC-E test reference, TPC-E test meets the mixing proportion of different simulation transactions so as to restore the real application scene of the database and reasonably test the performance of the database.
In application, the test duration of the TPC-E test is often as long as several hours, and if the TPC-E test is temporarily suspended or interrupted, the mixing ratio of the actually processed simulation transactions of the database often does not meet the requirement of the TPC-E reference, so that the working time of the TPC-E test tool is obviously limited, and the popularization and the application of the TPC-E test tool are obviously disadvantageous.
Disclosure of Invention
The application provides a TPC-E test method and a test system capable of keeping transaction type proportion, which are used for ensuring that different processing proportions of simulation transactions of different transaction types can be kept in different time periods when a database is subjected to TPC-E test, so that the TPC-E test is more flexible in working time.
In a first aspect, the present application provides a TPC-E testing method capable of maintaining transaction type ratios, the method comprising:
triggering a TPC-E test task aiming at a target database by a test system;
the test system obtains different processing proportions of simulated transactions of different transaction types in the TPC-E test task;
the test system establishes a transaction sequencing table;
the test system randomly arranges simulated transactions of different transaction types in the transaction ordering table, and enables the simulated transaction sequences in the transaction ordering table to meet the proportion limit of different processing proportions of the simulated transactions of different transaction types in different processing time periods;
the test system sequentially triggers the target database to process simulated transactions of different transaction types according to the simulated transaction sequence in the transaction sorting table;
the test system monitors the processing results of the target database for the simulated transactions of different transaction types to obtain the TPC-E test result of the target database.
Preferably, the different processing proportions of the simulated transactions of different transaction types in the simulated transaction sequence include:
the CESERVER component corresponds to a broker trade statistical transaction of 4.9% proportion, a customer value statistical transaction of 13% proportion, a market observation transaction of 18% proportion, a security information transaction of 14% proportion, a trade inquiry transaction of 8% proportion, a trade execution transaction of 10.1% proportion, a trade state transaction of 19% proportion and a trade correction transaction of 2% proportion;
the transaction execution transaction is used for triggering and generating a transaction result updating transaction corresponding to the MEEserver component, the number of the transaction execution transaction is 101% of the number of the transaction result updating transaction, the transaction result updating transaction is used for triggering and generating a market tracking transaction corresponding to the MEEserver component, and the number of the market tracking transaction is 10% of the number of the transaction result updating transaction.
Preferably, the test system randomly arranges the simulated transactions of different transaction types in the transaction ordering table, and the limiting of the different processing proportions of the simulated transactions of different transaction types to be satisfied in different processing time periods comprises:
the testing system randomly arranges N rounds of simulation transaction sequences in the transaction ordering table to form simulation transaction sequences, and enables the sub-simulation transaction sequences to meet the proportion limit of different processing proportions of simulation transactions of different transaction types in different processing time periods, wherein N is a positive integer, and the sub-simulation transaction sequences comprise 890 simulation transactions of different transaction types;
the test system sequentially triggers the target database to process simulated transactions of different transaction types according to the simulated transaction sequence in the transaction sorting table, and the method comprises the following steps:
and the test system sequentially triggers the target database to process simulated transactions of different transaction types according to the N rounds of simulated transaction sequences.
Preferably, the broker trade statistical transaction has a floating range of 4.875% to 4.925%, the customer value statistical transaction has a floating range of 12.935% to 13.065%, the market observation transaction has a floating range of 17.910% to 18.090%, the securities information transaction has a floating range of 13.930% to 14.070%, the trade inquiry transaction has a floating range of 7.960% to 8.040%, the trade execution transaction has a floating range of 10.049% to 10.151%, the trade status transaction has a floating range of 18.905% to 19.095%, the trade correction transaction has a floating range of 1.990% to 2.010%, the market tracking transaction has a floating range of 0.995% to 1.005%, and the trade result update transaction has a floating range of 9.950% to 10.050%.
Preferably, the method further comprises:
when the test system pauses or interrupts the TPC-E test in the TPC-E test process of the target database, the test system outputs different processing proportions of the simulation transactions of different transaction types which are processed by the target database at present and the current TPC-E test result.
In a second aspect, the present application provides a test system comprising:
the trigger unit is used for triggering a TPC-E test task aiming at the target database;
the acquisition unit is used for acquiring different processing proportions of simulated transactions of different transaction types in the TPC-E test task;
the establishing unit is used for establishing a transaction sorting table;
the arrangement unit is used for randomly arranging simulated transactions of different transaction types in the transaction ordering table, and enabling the simulated transaction sequences in the transaction ordering table to meet the proportion limit of different processing proportions of the simulated transactions of different transaction types in different processing time periods;
the triggering unit is also used for sequentially triggering the target database to process simulated transactions of different transaction types according to the simulated transaction sequence in the transaction sorting table;
and the monitoring unit is used for monitoring the processing result of the target database for the simulated transactions of different transaction types so as to obtain the TPC-E test result of the target database.
Preferably, the different processing proportions of the simulated transactions of different transaction types in the simulated transaction sequence include:
the CESERVER component corresponds to a broker trade statistical transaction of 4.9% proportion, a customer value statistical transaction of 13% proportion, a market observation transaction of 18% proportion, a security information transaction of 14% proportion, a trade inquiry transaction of 8% proportion, a trade execution transaction of 10.1% proportion, a trade state transaction of 19% proportion and a trade correction transaction of 2% proportion;
the transaction execution transaction is used for triggering and generating a transaction result updating transaction corresponding to the MEEserver component, the number of the transaction execution transaction is 101% of the number of the transaction result updating transaction, the transaction result updating transaction is used for triggering and generating a market tracking transaction corresponding to the MEEserver component, and the number of the market tracking transaction is 10% of the number of the transaction result updating transaction.
Preferably, the arrangement unit is specifically configured to:
randomly arranging N rounds of simulation transaction sequences in a transaction ordering table to form simulation transaction sequences, and enabling sub simulation transaction sequences to meet the proportion limit of different processing proportions of simulation transactions of different transaction types in different processing time periods, wherein N is a positive integer, and the sub simulation transaction sequences comprise 890 simulation transactions of different transaction types;
the test system sequentially triggers the target database to process simulated transactions of different transaction types according to the simulated transaction sequence in the transaction sorting table, and the method comprises the following steps:
and the test system sequentially triggers the target database to process simulated transactions of different transaction types according to the N rounds of simulated transaction sequences.
Preferably, the broker trade statistical transaction has a floating range of 4.875% to 4.925%, the customer value statistical transaction has a floating range of 12.935% to 13.065%, the market observation transaction has a floating range of 17.910% to 18.090%, the securities information transaction has a floating range of 13.930% to 14.070%, the trade inquiry transaction has a floating range of 7.960% to 8.040%, the trade execution transaction has a floating range of 10.049% to 10.151%, the trade status transaction has a floating range of 18.905% to 19.095%, the trade correction transaction has a floating range of 1.990% to 2.010%, the market tracking transaction has a floating range of 0.995% to 1.005%, and the trade result update transaction has a floating range of 9.950% to 10.050%.
Preferably, the test system further comprises:
and the output unit is used for outputting different processing proportions of the currently processed simulated transactions of different transaction types of the target database and a current TPC-E test result when the test system pauses or interrupts the TPC-E test in the TPC-E test process of the target database.
In a third aspect, the present application provides a test system comprising a processor for implementing any of the steps of the method for TPC-E testing with maintainable transaction type ratios as described above in relation to the first aspect when executing a computer program stored in memory.
In a fourth aspect, the present application provides a readable storage medium having stored thereon a computer program which, when executed by a processor, performs any of the steps of the method for TPC-E testing with maintainable transaction type ratios as described above in relation to the first aspect.
According to the technical scheme, the method has the following advantages:
when the test system acquires different processing proportions of simulated transactions of different transaction types in the TPC-E test task of the target database, the simulated transactions of different transaction types are randomly arranged in the local transaction sequencing table, and the simulated transaction sequence in the transaction sequencing table meets the proportion limit of the different processing proportions of the simulated transactions of different transaction types in different processing time periods, so that the target database can be sequentially triggered to process the simulated transactions of different transaction types according to the simulated transaction sequence in the transaction sequencing table, under the setting, the different processing proportions of the simulated transactions of different transaction types can be kept in different time periods when the TPC-E test is carried out on the database, and the requirement of the mixing proportion of the simulated transactions of different transaction types can be met even if the TPC-E test is suspended or interrupted, and then, the TPC-E test of the target database can be more flexible in working time, and particularly can be satisfactorily completed under the condition of working time with tense temporary test tasks.
Drawings
FIG. 1 is a flow chart illustrating a TPC-E testing method capable of maintaining transaction type ratios according to the present application;
FIG. 2 is a schematic flow chart of a TPC-E test method for maintaining transaction type ratios according to the present application;
FIG. 3 is a schematic diagram of one configuration of the test system of the present application;
fig. 4 shows another schematic structure of the test system of the present application.
Detailed Description
The application provides a TPC-E test method and a test system capable of keeping transaction type proportion, which are used for ensuring that different processing proportions of simulation transactions of different transaction types can be kept in different time periods when a database is subjected to TPC-E test, so that the TPC-E test is more flexible in working time.
The technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only a part of the embodiments of the present application, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.
The terms "first," "second," and the like in the description and in the claims of the present application and in the above-described drawings are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It will be appreciated that the data so used may be interchanged under appropriate circumstances such that the embodiments described herein may be practiced otherwise than as specifically illustrated or described herein. Moreover, the terms "comprises," "comprising," and any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or modules is not necessarily limited to those steps or modules explicitly listed, but may include other steps or modules not expressly listed or inherent to such process, method, article, or apparatus. The naming or numbering of the steps appearing in the present application does not mean that the steps in the method flow have to be executed in the chronological/logical order indicated by the naming or numbering, and the named or numbered process steps may be executed in a modified order depending on the technical purpose to be achieved, as long as the same or similar technical effects are achieved.
The division of the modules presented in this application is a logical division, and in practical applications, there may be another division, for example, multiple modules may be combined or integrated into another system, or some features may be omitted, or not executed, and in addition, the shown or discussed coupling or direct coupling or communication connection between each other may be through some interfaces, and the indirect coupling or communication connection between the modules may be in an electrical or other similar form, which is not limited in this application. The modules or sub-modules described as separate components may or may not be physically separated, may or may not be physical modules, or may be distributed in a plurality of circuit modules, and some or all of the modules may be selected according to actual needs to achieve the purpose of the present disclosure.
First, before the present application is described, a test system related to the present application will be described.
In the application, the test system is deployed on the server equipment or the physical host equipment, and the TPC-E test method capable of keeping the transaction type proportion is applied to realize more flexible TPC-E test.
The server device or the physical host device has a communication capability and a data processing capability, and may specifically be an independently operating device, or may also be a device cluster, which is not limited herein.
Next, the present application will be described in detail based on the above description of the simple background.
Referring to fig. 1, fig. 1 shows a flowchart of the TPC-E testing method for maintaining transaction type ratio according to the present application, and specifically, the TPC-E testing method for maintaining transaction type ratio according to the present application may include the following steps:
step S101, a test system triggers a TPC-E test task aiming at a target database;
it will be appreciated that in the event that there is a TPC-E test requirement for the target database, the worker may log into the test system and trigger a TPC-E test task for the target database on the test system.
Alternatively, the staff may also access the test system through User Equipment (UE), and initiate a TPC-E test task for the target database to the test system.
The TPC-E test task can carry the database identification of the target database so that the test system can identify the target database and add the TPC-E test task aiming at the target database into the current working process.
In the application, the UE may specifically be a terminal device such as a smart phone, a tablet computer, a desktop computer, a notebook computer, a computer all-in-one machine, a Personal Digital Assistant (PDA), a smart band, or a smart watch, and the UE has a human-computer interaction capability.
Step S102, the test system obtains different processing proportions of simulation transactions of different transaction types in the TPC-E test task;
before initiating the processing of the simulation transaction to the target database, the test system firstly obtains different processing proportions of the simulation transactions of different transaction types required in the current TPC-E test task, wherein the processing proportions are the mixing proportions specified by the TPC-E reference.
Step S103, the test system establishes a transaction sequencing table;
after obtaining different processing proportions of the simulated transactions of different transaction types required in the TPC-E test task, the test system can establish a transaction sequencing list of the user storage transaction sequence.
Step S104, the test system randomly arranges the simulated transactions of different transaction types in the transaction ordering table, and the simulated transaction sequences in the transaction ordering table meet the proportion limits of different processing proportions of the simulated transactions of different transaction types in different processing time periods;
it will be appreciated that N sequences may be included in the transaction ordering table, and that each sequence may be written with a transaction identification for a simulated transaction, such as represented by the letter A, B, C, D ….
The test system randomly arranges the simulated transactions of different transaction types in the transaction ordering table under the condition that the proportion limit of different processing proportions of the simulated transactions of different transaction types is met in different processing time periods, so as to obtain a simulated transaction sequence.
Step S105, the test system sequentially triggers the target database to process simulated transactions of different transaction types according to the simulated transaction sequence in the transaction sorting table;
subsequently, the test system may sequentially trigger the target database to process the simulated transactions of different transaction types in the simulated transaction sequence according to the simulated transaction sequence in the transaction sorting table obtained in step S104.
And step S106, monitoring the processing result of the target database for the simulated transactions of different transaction types by the test system to obtain the TPC-E test result of the target database.
When the target database responds to the simulated transactions of different transaction types in the simulated transaction sequence and processes the simulated transactions, the test system can monitor the processing results of the simulated transactions, and acquire, sort and analyze the processing results to obtain the TPC-E test result of the target database.
Thus, the TPC-E test result may be output to a user logging in the test system, or may be issued to a UE accessing the test system.
From the above, it can be seen that in the TPC-E testing method capable of maintaining transaction type ratios according to the present application, when acquiring different processing ratios of simulated transactions of different transaction types in the current TPC-E testing task of the target database, the testing system randomly arranges the simulated transactions of different transaction types in the local transaction sorting table, and makes the simulated transaction sequences in the transaction sorting table meet the ratio limits of different processing ratios of the simulated transactions of different transaction types in different processing time periods, so as to sequentially trigger the target database to process the simulated transactions of different transaction types according to the simulated transaction sequences in the transaction sorting table, and under this setting, it can be ensured that different processing ratios of the simulated transactions of different transaction types can be maintained in different time periods when the TPC-E testing is performed on the database, even if the TPC-E test is suspended or interrupted, the requirement of the mixing ratio of the TPC-E reference simulation affairs can be met, so that the TPC-E test of the target database can be more flexible in working time, and particularly, the TPC-E test of the target database can be satisfactorily completed under the condition of working time with tense temporary test task.
In a possible implementation manner, in step S102 in the embodiment corresponding to fig. 1, the different processing proportions of the simulated transactions of different transaction types may specifically include the following contents:
the CESERVER component corresponds to a 4.9% proportion of Broker Trade statistical transactions (Broker-Volume), a 13% proportion of Customer-value statistical transactions (Customer-Position), an 18% proportion of Market observation transactions (Market-Watch), a 14% proportion of Security information transactions (Security-Detail), an 8% proportion of Trade inquiry transactions (Trade-Lookup), a 10.1% proportion of Trade execution transactions (Trade-Order), a 19% proportion of Trade Status transactions (Trade-Status) and a 2% proportion of Trade correction transactions (Trade-Update).
It can be understood that, in the test system, the ceerver component and the MEEServer component are included, and are respectively used for a simulated client operation type transaction and a Market operation type transaction related to TPC-E test, and the target database is enabled to process the simulated client operation type transaction and the Market operation type transaction, and a transaction Result update transaction (Trade-Result) and a Market tracking transaction (Market-Feed) corresponding to the MEEServer component are generated by directly or indirectly triggering a transaction execution transaction corresponding to the ceerver component, so that in the simulated transaction sequence, the test system can automatically trigger the generation and the proportion of the transaction Result update transaction and the Market tracking transaction corresponding to the MEEServer component only by determining different processing proportions of the simulated transactions of different transaction types corresponding to the ceerver component.
Specifically, the transaction execution transaction is used for triggering and generating a transaction result updating transaction corresponding to the MEEserver component, the number of the transaction execution transaction is 101% of the number of the transaction result updating transaction, the transaction result updating transaction is used for triggering and generating a market tracking transaction corresponding to the MEEserver component, and the number of the market tracking transaction is 10% of the number of the transaction result updating transaction.
Based on the different processing proportions among the simulated transactions of different transaction types, with continuing reference to fig. 2, fig. 2 shows another flow chart of the TPC-E testing method for maintaining a transaction type proportion of the present application, specifically, the TPC-E testing method for maintaining a transaction type proportion of the present application may further include the following steps:
step S201, a test system triggers a TPC-E test task aiming at a target database;
step S202, the test system obtains different processing proportions of simulation transactions of different transaction types in the TPC-E test task;
step S203, the test system establishes a transaction sorting table;
it can be understood that the contents of step S201 to step S203 may refer to step S101 to step S103 in the embodiment corresponding to fig. 1, and repeated contents are not repeated herein.
Step S204, the testing system randomly arranges N rounds of simulated transaction sequences in the transaction ordering table to form simulated transaction sequences, and enables the sub-simulated transaction sequences to meet the proportion limits of different processing proportions of simulated transactions of different transaction types in different processing time periods;
where N is a positive integer, the sub-simulated transaction sequence includes 890 simulated transactions.
In the present application, the simulated transaction sequence in the transaction ordering table includes a plurality of simulated transaction sequences with small capacity, i.e., N rounds of simulated transaction sequences.
It can be understood that based on the above-mentioned simulated transaction transactions of 8 transaction types corresponding to the ceerver component and the processing ratios thereof, the sub-simulated transaction sequence of each round can be set to satisfy the order of magnitude of the processing ratio, i.e., 890 sub-simulated transaction sequences, so that the test system can perform N rounds of 890 simulated transaction tests according to the requirements of specific test time or test quantity of the TPC-E test, and sub-simulated transaction sequences of different rounds, wherein the specific arrangement of the simulated transaction transactions can be different, and only the correct ratio between the simulated transaction sequences needs to be ensured. For setting the sub-simulation transaction sequence, reference may be made to the following list of examples:
the A to H are used for representing 8 simulation processing transactions corresponding to the CESERVER component, and the A to H are randomly filled in by the test system through 890 identification bits in a sub simulation transaction sequence and meet the processing proportion of the simulation processing transactions of the 8 transaction types corresponding to the CESERVER component.
It can be understood that the test system can perform the TPC-E test on the target database more finely in time by setting the sub-simulation transaction sequences, and for different specific test times or test quantity requirements, the test system can obtain the TPC-E test result of the target database under the fragmentation processing of the N rounds of sub-simulation transaction sequences, and especially can obtain the TPC-E test result meeting the requirement of the mixing ratio of the simulation transactions according with the TPC-E reference by only removing the last round of simulation transaction sequences which are not completely processed even in the emergency situation of pausing or interrupting the TPC-E test.
And S205, the test system sequentially triggers the target database to process simulated transactions of different transaction types according to the N rounds of simulated transaction sequences.
Subsequently, the test system may sequentially trigger the target database to process simulated transactions of different transaction types in the N round of simulated transaction sequences according to the N round of simulated transaction sequences in the transaction sorting table obtained in step S204. Further, considering that the magnitude of the simulation processing transaction is larger, or the actual error when the number of rounds of the sub-simulation transaction sequence is larger, and the allowable error range, in different processing proportions of the simulation transactions of different transaction types, an error compatibility policy may be further set, and the compatibility policy may specifically include the following contents:
the floating range of the broker trade statistical transaction is 4.875% -4.925%, the floating range of the customer value statistical transaction is 12.935% -13.065%, the floating range of the market observation transaction is 17.91% -18.09%, the floating range of the securities information transaction is 13.93% -14.07%, the floating range of the trade inquiry transaction is 7.96% -8.04%, the floating range of the trade execution transaction is 10.049% -10.151%, the floating range of the trade state transaction is 18.905% -19.095%, the floating range of the trade correction transaction is 1.99% -2.01%, the floating range of the market tracking transaction is 0.995% -1.005% and the floating range of the trade result update transaction is 9.95% -10.05%.
Step S206, when the test system pauses or interrupts the TPC-E test in the TPC-E test process of the target database, the test system outputs different processing proportions of the simulation transactions of different transaction types which are processed by the target database at present and the current TPC-E test result.
As mentioned in the corresponding implementation content of fig. 1, in the process of performing the TPC-E test on the target database by the test system, a temporary interruption or pause may be encountered, in which case, different processing ratios of the simulated transactions of different transaction types currently processed by the target database and the current TPC-E test result may be obtained based on the processing result of the processed simulated transaction, so as to be output to the user logging in the test system, or issued to the UE accessing the test system, so as to facilitate to preliminarily know the test condition of the target database in advance and to consider whether to resume the subsequent TPC-E test in the case of the temporary interruption or pause.
When the suspend or interrupt procedure is resumed, the subsequent TPC-E test is performed and the preset TPC-E test is completed, the following step S207 may be performed.
Step S207, the test system monitors the processing result of the target database for the simulated transactions of different transaction types to obtain the TPC-E test result of the target database.
When the target database responds to and processes at least 1000 simulated transactions of different transaction types in the simulated transaction sequence, the test system can monitor the processing result, and acquire, sort and analyze the processing result to obtain the TPC-E test result of the target database.
Thus, the TPC-E test result may be output to a user logging in the test system, or may be issued to a UE accessing the test system.
The above is an introduction of the TPC-E test method for maintaining transaction type ratios of the present application, and the following is a description of the test system of the present application.
Referring to fig. 3, fig. 3 shows a schematic structural diagram of the test system of the present application, specifically, the test system may include the following structures:
a triggering unit 301, configured to trigger a TPC-E test task for a target database;
an obtaining unit 302, configured to obtain different processing proportions of simulated transactions of different transaction types in the current TPC-E test task;
an establishing unit 303, configured to establish a transaction ordering table;
an arranging unit 304, configured to randomly arrange simulated transactions of different transaction types in the transaction ordering table, and enable the simulated transaction sequence in the transaction ordering table to meet the ratio limits of different processing ratios of the simulated transactions of different transaction types in different processing time periods;
the triggering unit 301 is further configured to sequentially trigger the target database to process simulated transactions of different transaction types according to the simulated transaction sequence in the transaction sorting table;
and a monitoring unit 305, configured to monitor processing results of the target database for simulated transactions of different transaction types, so as to obtain TPC-E test results of the target database.
Preferably, the different processing proportions of the simulated transactions of different transaction types in the simulated transaction sequence include:
the CESERVER component corresponds to a broker trade statistical transaction of 4.9% proportion, a customer value statistical transaction of 13% proportion, a market observation transaction of 18% proportion, a security information transaction of 14% proportion, a trade inquiry transaction of 8% proportion, a trade execution transaction of 10.1% proportion, a trade state transaction of 19% proportion and a trade correction transaction of 2% proportion;
the transaction execution transaction is used for triggering and generating a transaction result updating transaction corresponding to the MEEserver component, the number of the transaction execution transaction is 101% of the number of the transaction result updating transaction, the transaction result updating transaction is used for triggering and generating a market tracking transaction corresponding to the MEEserver component, and the number of the market tracking transaction is 10% of the number of the transaction result updating transaction.
Preferably, the arranging unit 304 is specifically configured to:
randomly arranging N rounds of simulation transaction sequences in a transaction ordering table to form simulation transaction sequences, and enabling sub simulation transaction sequences to meet the proportion limit of different processing proportions of simulation transactions of different transaction types in different processing time periods, wherein N is a positive integer, and the sub simulation transaction sequences comprise 890 simulation transactions of different transaction types;
the test system sequentially triggers the target database to process simulated transactions of different transaction types according to the simulated transaction sequence in the transaction sorting table, and the method comprises the following steps:
and the test system sequentially triggers the target database to process simulated transactions of different transaction types according to the N rounds of simulated transaction sequences.
Preferably, the broker trade statistical transaction has a floating range of 4.875% to 4.925%, the customer value statistical transaction has a floating range of 12.935% to 13.065%, the market observation transaction has a floating range of 17.910% to 18.090%, the securities information transaction has a floating range of 13.930% to 14.070%, the trade inquiry transaction has a floating range of 7.960% to 8.040%, the trade execution transaction has a floating range of 10.049% to 10.151%, the trade status transaction has a floating range of 18.905% to 19.095%, the trade correction transaction has a floating range of 1.990% to 2.010%, the market tracking transaction has a floating range of 0.995% to 1.005%, and the trade result update transaction has a floating range of 9.950% to 10.050%.
Preferably, the test system further comprises:
and the output unit 306 is configured to output different processing proportions of the currently processed simulated transactions of different transaction types of the target database and a current TPC-E test result when the test system suspends or interrupts the TPC-E test in the TPC-E test process for the target database.
Referring to fig. 4, fig. 4 shows another schematic structural diagram of the system provided in the present application, specifically, the test system provided in the present application includes a processor 401, and the processor 601 is configured to implement the steps of the TPC-E test method capable of maintaining the transaction type ratio in any embodiment corresponding to fig. 1 or fig. 2 when executing the computer program stored in the memory 402; alternatively, the processor 401 is configured to implement the functions of the units in the corresponding embodiment of fig. 3 when executing the computer program stored in the memory 402.
Illustratively, a computer program may be partitioned into one or more modules/units, which are stored in memory 402 and executed by processor 401 to accomplish the present application. One or more modules/units may be a series of computer program instruction segments capable of performing certain functions, the instruction segments being used to describe the execution of a computer program in a computer device.
The test system may include, but is not limited to, a processor 401, a memory 402. It will be appreciated by those skilled in the art that the illustration is merely an example of a computer apparatus and does not constitute a limitation of the test system, and that the test system may include more or less components than those illustrated, or some components may be combined, or different components, for example, the test system may further include an input output device, a network access device, a bus, etc., and the processor 401, the memory 402, the input output device, the network access device, etc., are connected via the bus.
The Processor 401 may be a Central Processing Unit (CPU), other general purpose Processor, a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), an off-the-shelf Programmable Gate Array (FPGA) or other Programmable logic device, discrete Gate or transistor logic, discrete hardware components, etc. The general purpose processor may be a microprocessor or the processor may be any conventional processor or the like, the processor being the control center of the computer device and the various interfaces and lines connecting the various parts of the overall computer device.
The memory 402 may be used to store computer programs and/or modules, and the processor 401 may implement various functions of the computer device by running or executing the computer programs and/or modules stored in the memory 402 and invoking data stored in the memory 402. The memory 402 may mainly include a program storage area and a data storage area, wherein the program storage area may store an operating system, an application program required by at least one function (such as a sound playing function, an image playing function, etc.), and the like; the storage data area may store data (such as audio data, video data, etc.) created according to the use of the cellular phone, etc. In addition, the memory may include high speed random access memory, and may also include non-volatile memory, such as a hard disk, a memory, a plug-in hard disk, a Smart Media Card (SMC), a Secure Digital (SD) Card, a Flash memory Card (Flash Card), at least one magnetic disk storage device, a Flash memory device, or other volatile solid state storage device.
The application also provides a readable storage medium, on which a computer program is stored, and the computer program is executed by a processor to implement the TPC-E testing method capable of maintaining the transaction type ratio in any embodiment corresponding to fig. 1 or fig. 2.
It will be appreciated that the integrated unit, if implemented as a software functional unit and sold or used as a stand-alone product, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present application may be substantially implemented or contributed to by the prior art, or all or part of the technical solution may be embodied in the form of a software product stored in a storage medium and including instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method embodiments of the present application. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-only Memory (ROM), a Random Access Memory (RAM), a magnetic disk or an optical disk, and other various media capable of storing program codes.
It is clear to those skilled in the art that, for convenience and brevity of description, the specific working process of the test system and the units thereof described above may refer to the TPC-E test method capable of maintaining the transaction type ratio in the corresponding embodiment of fig. 1 or fig. 2, and details thereof are not repeated herein.
In summary, the present application provides a TPC-E testing method, a testing system and a readable storage medium capable of maintaining transaction type ratios, where the testing system randomly arranges the simulated transactions of different transaction types in a local transaction sorting table when acquiring different processing ratios of the simulated transactions of different transaction types in the current TPC-E testing task of a target database, and makes the simulated transaction sequences in the transaction sorting table meet the ratio limits of different processing ratios of the simulated transactions of different transaction types in different processing time periods, so as to sequentially trigger the target database to process the simulated transactions of different transaction types according to the simulated transaction sequences in the transaction sorting table, and under the setting, it can be ensured that different processing ratios of the simulated transactions of different transaction types can be maintained in different time periods when the TPC-E testing is performed on the database, even if the TPC-E test is suspended or interrupted, the requirement of the mixing ratio of the TPC-E reference simulation affairs can be met, so that the TPC-E test of the target database can be more flexible in working time, and particularly, the TPC-E test of the target database can be satisfactorily completed under the condition of working time with tense temporary test task.
In the embodiments provided in the present application, it should be understood that the disclosed test system and its units may be implemented in other ways. For example, the above-described apparatus embodiments are merely illustrative, and for example, a division of a unit is merely a logical division, and an actual implementation may have another division, for example, a plurality of units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, devices or units, and may be in an electrical, mechanical or other form.
Units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.
In addition, functional units in the embodiments of the present application may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit.
The above embodiments are only used to illustrate the technical solutions of the present application, and not to limit the same; although the present application has been described in detail with reference to the foregoing embodiments, it should be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; and such modifications or substitutions do not depart from the spirit and scope of the corresponding technical solutions in the embodiments of the present application.
Claims (8)
1. A TPC-E testing method capable of maintaining transaction type ratios, the method comprising:
triggering a TPC-E test task aiming at a target database by a test system;
the test system obtains different processing proportions of simulated transactions of different transaction types in the TPC-E test task at the current time;
the test system establishes a transaction sequencing table;
the test system randomly arranges the simulated transactions of different transaction types in the transaction ordering table, and enables the simulated transaction sequences in the transaction ordering table to meet the proportion limit of different processing proportions of the simulated transactions of different transaction types in different processing time periods;
the testing system randomly arranges N rounds of simulated transaction sequences in the transaction ordering table to form the simulated transaction sequences, and enables the sub-simulated transaction sequences to meet the proportion limit of different processing proportions of the simulated transactions of different transaction types in different processing time periods, wherein N is a positive integer, the sub-simulated transaction sequences comprise 890 simulated transactions of different transaction types, and 890 is the minimum and optimal value of the total number of the transactions included in the sub-simulated transaction sequences;
the test system sequentially triggers the target database to process the simulated transactions of different transaction types according to the simulated transaction sequence in the transaction sorting table;
the test system sequentially triggers the target database to process the simulated transactions of different transaction types according to the N rounds of sub-simulated transaction sequences;
and the test system monitors the processing result of the target database for the simulated transactions of different transaction types to obtain the TPC-E test result of the target database.
2. The method of claim 1, wherein the different processing proportions of the simulated transactions of different transaction types in the sequence of simulated transactions comprise:
the CESERVER component corresponds to a broker trade statistical transaction of 4.9% proportion, a customer value statistical transaction of 13% proportion, a market observation transaction of 18% proportion, a security information transaction of 14% proportion, a trade inquiry transaction of 8% proportion, a trade execution transaction of 10.1% proportion, a trade state transaction of 19% proportion and a trade correction transaction of 2% proportion;
the transaction execution transaction is used for triggering generation of a transaction result updating transaction corresponding to the MEEserver component, the number of the transaction execution transaction is 101% of the number of the transaction result updating transaction, the transaction result updating transaction is used for triggering generation of a market tracking transaction corresponding to the MEEserver component, and the number of the market tracking transaction is 10% of the number of the transaction result updating transaction.
3. The method of claim 2, wherein the broker trade statistical transaction has a float range of 4.875% to 4.925%, the customer value statistical transaction has a float range of 12.935% to 13.065%, the market observation transaction has a float range of 17.910% to 18.090%, the securities information transaction has a float range of 13.930% to 14.070%, the trade query transaction has a float range of 7.960% to 8.040%, the trade execution transaction has a float range of 10.049% to 10.151%, the trade status transaction has a float range of 18.905% to 19.095%, and the trade correction transaction has a float range of 1.990% to 2.010%.
4. The method of claim 1, further comprising:
when the test system pauses or interrupts the TPC-E test in the TPC-E test process of the target database, the test system outputs different processing proportions of the simulated transactions of different transaction types which are processed by the target database at present and a current TPC-E test result.
5. A test system, characterized in that the test system comprises:
the trigger unit is used for triggering a TPC-E test task aiming at the target database;
the obtaining unit is used for obtaining different processing proportions of simulated transactions of different transaction types in the TPC-E test task at the current time;
the establishing unit is used for establishing a transaction sorting table;
the arrangement unit is used for randomly arranging the simulated transactions of different transaction types in the transaction ordering table, and enabling the simulated transaction sequences in the transaction ordering table to meet the proportion limit of different processing proportions of the simulated transactions of different transaction types in different processing time periods;
randomly arranging N rounds of simulated transaction sequences in the transaction ordering table to form the simulated transaction sequences, and enabling the sub-simulated transaction sequences to meet the proportion limit of different processing proportions of the simulated transactions of different transaction types in different processing time periods, wherein N is a positive integer, and the sub-simulated transaction sequences comprise 890 simulated transactions of different transaction types;
the triggering unit is further configured to sequentially trigger the target database to process the simulated transactions of different transaction types according to the simulated transaction sequence in the transaction sorting table;
the test system sequentially triggers the target database to process the simulated transactions of different transaction types according to the N rounds of sub-simulated transaction sequences;
and the monitoring unit is used for monitoring the processing result of the target database on the simulated transactions of different transaction types to obtain the TPC-E test result of the target database.
6. The test system of claim 5, wherein the different processing proportions of the simulated transactions of different transaction types in the sequence of simulated transactions comprise:
the CESERVER component corresponds to a broker trade statistical transaction of 4.9% proportion, a customer value statistical transaction of 13% proportion, a market observation transaction of 18% proportion, a security information transaction of 14% proportion, a trade inquiry transaction of 8% proportion, a trade execution transaction of 10.1% proportion, a trade state transaction of 19% proportion and a trade correction transaction of 2% proportion;
the transaction execution transaction is used for triggering generation of a transaction result updating transaction corresponding to the MEEserver component, the number of the transaction execution transaction is 101% of the number of the transaction result updating transaction, the transaction result updating transaction is used for triggering generation of a market tracking transaction corresponding to the MEEserver component, and the number of the market tracking transaction is 10% of the number of the transaction result updating transaction.
7. The testing system of claim 6, wherein the broker trade statistical transactions have a float range of 4.875% to 4.925%, the customer value statistical transactions have a float range of 12.935% to 13.065%, the market observation transactions have a float range of 17.910% to 18.090%, the securities information transactions have a float range of 13.930% to 14.070%, the trade query transactions have a float range of 7.960% to 8.040%, the trade execution transactions have a float range of 10.049% to 10.151%, the trade status transactions have a float range of 18.905% to 19.095%, and the trade modification transactions have a float range of 1.990% to 2.010%.
8. The test system of claim 5, further comprising:
and the output unit is used for outputting different processing proportions of the simulated transactions of different transaction types which are processed by the target database at present and the current TPC-E test result when the test system suspends or interrupts the TPC-E test in the TPC-E test process of the target database.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910572321.1A CN110457188B (en) | 2019-06-28 | 2019-06-28 | TPC-E test method and system capable of keeping transaction type proportion |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910572321.1A CN110457188B (en) | 2019-06-28 | 2019-06-28 | TPC-E test method and system capable of keeping transaction type proportion |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110457188A CN110457188A (en) | 2019-11-15 |
| CN110457188B true CN110457188B (en) | 2021-02-23 |
Family
ID=68481825
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910572321.1A Active CN110457188B (en) | 2019-06-28 | 2019-06-28 | TPC-E test method and system capable of keeping transaction type proportion |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110457188B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111143196A (en) * | 2019-12-05 | 2020-05-12 | 武汉迎风聚智科技有限公司 | Database testing method and device |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102184133A (en) * | 2011-05-12 | 2011-09-14 | 哈尔滨工业大学 | Load generation server for bearing bank intermediary business simulation model |
| US10082975B1 (en) * | 2017-03-02 | 2018-09-25 | Micron Technology, Inc. | Obfuscation-enhanced memory encryption |
| CN109902027A (en) * | 2019-03-29 | 2019-06-18 | 梁俊杰 | A kind of TPC-DS test method and system convenient to carry out |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7159060B2 (en) * | 2003-12-30 | 2007-01-02 | Intel Corporation | PCI standard hot-plug controller (SHPC) with user programmable command execution timing |
| CN106919498A (en) * | 2017-02-20 | 2017-07-04 | 上海斐讯数据通信技术有限公司 | The method for showing interface and system of the test index information of Benchmark test system |
-
2019
- 2019-06-28 CN CN201910572321.1A patent/CN110457188B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102184133A (en) * | 2011-05-12 | 2011-09-14 | 哈尔滨工业大学 | Load generation server for bearing bank intermediary business simulation model |
| US10082975B1 (en) * | 2017-03-02 | 2018-09-25 | Micron Technology, Inc. | Obfuscation-enhanced memory encryption |
| CN109902027A (en) * | 2019-03-29 | 2019-06-18 | 梁俊杰 | A kind of TPC-DS test method and system convenient to carry out |
Non-Patent Citations (3)
| Title |
|---|
| TPC-E测试系统的设计与实现;杨超;《万方学术期刊数据库》;20120426;文章第10-14、16-18、20、31、44页 * |
| 周鹏.数据库系统性能和可靠性评测技术的研究与设计.《中国优秀硕士学位论文全文数据库 信息科技辑》.2014, * |
| 数据库系统性能和可靠性评测技术的研究与设计;周鹏;《中国优秀硕士学位论文全文数据库 信息科技辑》;20140415;文章摘要、第6-12页、第38-44页 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110457188A (en) | 2019-11-15 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107343047B (en) | Application promotion system and method | |
| CN110737594B (en) | Database standard conformance testing method and device for automatically generating test cases | |
| CN109951547B (en) | Transaction request parallel processing method, device, equipment and medium | |
| US20160283357A1 (en) | Call stack relationship acquiring method and apparatus | |
| CN111064712B (en) | Game resource packaging method and system | |
| CN110474820B (en) | Flow playback method and device and electronic equipment | |
| CN113485999A (en) | Data cleaning method and device and server | |
| CN110457188B (en) | TPC-E test method and system capable of keeping transaction type proportion | |
| CN109902027B (en) | TPC-DS testing method and system convenient to implement | |
| US11003538B2 (en) | Automatically configuring boot order in recovery operations | |
| CN114448972A (en) | Distributed storage log compression downloading method, system, terminal and storage medium | |
| CN110058995B (en) | Database testing method and system capable of avoiding interference of database types | |
| CN111597093B (en) | Exception handling method, device and equipment thereof | |
| CN112463519A (en) | Flatter-based page use behavior data non-buried point statistical method, equipment and storage medium | |
| CN111381905A (en) | Program processing method, device and equipment | |
| CN110704301A (en) | TPC-E automatic test method and TPC-E test system | |
| CN110389977B (en) | Database connection creating method and device and terminal equipment | |
| CN110891097B (en) | Cross-device user identification method and device | |
| CN110674491B (en) | Method and device for real-time evidence obtaining of android application and electronic equipment | |
| US9483241B2 (en) | Method ranking based on code invocation | |
| CN110703988B (en) | Storage pool creating method, system, terminal and storage medium for distributed storage | |
| CN111427778A (en) | Test method, test device, terminal equipment and storage medium | |
| CN110825477A (en) | Method, device and equipment for loading graphical interface and storage medium | |
| CN111381977A (en) | Message processing method and device | |
| CN110716747B (en) | Program operation efficiency optimization method based on function parameter statistics and terminal equipment |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |