CN110457187A - Based on backup test data can convenient operation TPC-E test method and testing service device - Google Patents
Based on backup test data can convenient operation TPC-E test method and testing service device Download PDFInfo
- Publication number
- CN110457187A CN110457187A CN201910572315.6A CN201910572315A CN110457187A CN 110457187 A CN110457187 A CN 110457187A CN 201910572315 A CN201910572315 A CN 201910572315A CN 110457187 A CN110457187 A CN 110457187A
- Authority
- CN
- China
- Prior art keywords
- database
- backup
- test
- target
- service device
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/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
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
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)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
This application provides based on backup test data can convenient operation TPC-E test method and testing service device, for further liberating the human cost of staff, easily to target database carry out TPC-E test.Method includes: that testing service device receives the test instruction that UE is initiated；The Database Identification that the test of testing service device is carried according to test instruction positions the target database of pending TPC-E test from device network；The corresponding target backup test data of target database whether are stored in the local preset DB Backup table of testing service device detection；If so, then testing service device extracts target backup test data from DB Backup table；Testing service device imports target backup test data in the database formal table of target database；Testing service device is based on target backup test data, carries out TPC-E test to target database, obtains the TPC-E test report of target database；Testing service device issues TPC-E test report to UE.
Description
Technical field
This application involves testing fields, more particularly to based on backup test data can convenient operation TPC-E test method
And testing service device.
Background technique
In the performance test of database, Transaction Processing Performance Council (Transaction Processing
Performance Council, TPC) it is proposed TPC-E test benchmark, to adapt to Database Systems now, to database
Performance is comprehensively and accurately tested.
When TPC-E benchmark is from theoretic landing to practical application, the service provider of TPC-E test need to be according to TPC-E
Test benchmark provides actual testing tool, such as test platform or test program.For this purpose, the service of TPC-E test provides
Side need to be directed to the landing application of TPC-E, carry out debugging optimization, can meet application requirement.
It is found in the application of existing TPC-E testing tool, when carrying out TPC-E test, needs staff's hand
Trend database to be tested imports relevant test data, and this has obviously limited the degree of automation of TPC-E testing tool.
Summary of the invention
This application provides based on backup test data can convenient operation TPC-E test method and testing service device, use
In the human cost of further liberation staff, TPC-E test easily is carried out to target database.
In a first aspect, this application provides based on backup test data can convenient operation TPC-E test method, method packet
It includes:
Testing service device receives the test instruction that user equipment (User Equipment, UE) is initiated；
The Database Identification that the test of testing service device is carried according to test instruction, positions pending TPC- from device network
The target database of E test；
The corresponding target of target database whether is stored in the local preset DB Backup table of testing service device detection
Backup test data, wherein target database Backup Data is number of users needed for carrying out TPC-E test for target database
According to user data includes customer data, securities broker company's data and stock exchange data；
If so, then testing service device extracts target backup test data from DB Backup table；
Testing service device imports target backup test data in the database formal table of target database, so that target
Database loads target backup test data；
Testing service device is based on target backup test data, carries out TPC-E test to target database, obtains target data
The TPC-E test report in library；
Testing service device issues TPC-E test report to UE.
Preferably, method further include:
Testing service device monitors disparate databases and carries out tune used test data when TPC-E test；
Testing service device extracts test data；
Test data is stored in multiple TXT text files by testing service device by separator；
Testing service device imports TXT text file in DB Backup table, obtains backup test database.
Preferably, the corresponding different backup test of database of disparate databases type is stored in DB Backup table
Data, testing service device extract target backup test data from DB Backup table and include:
The type of database of testing service device identification target database；
The corresponding target backup of type of database that testing service device extracts target database from DB Backup table is surveyed
Try data.
Preferably, testing service device will include: in the database formal table of backup test data importing target database
The type of database of testing service device acquisition target database；
Testing service device obtains the compatible rule of database of the type of database of target database；
Target backup test data are imported the database of target database according to the compatible rule of database by testing service device
In formal table.
Preferably, target database whether is stored in the local preset DB Backup table of testing service device detection to correspond to
Target backup test data before, method further include:
Target backup test data whether are stored in database formal table in test database detection target database,
If so, then triggering in testing service device Test database backup table whether be stored with target backup test data.
Second aspect, this application provides testing service device, testing service device includes:
Receiving unit, for receiving the test instruction of UE initiation；
Positioning unit positions pending for testing the Database Identification carried according to test instruction from device network
The target database of TPC-E test；
Detection unit, for detecting in local preset DB Backup table whether be stored with the corresponding mesh of target database
Mark backup test data, wherein target database Backup Data is user needed for carrying out TPC-E test for target database
Data, user data includes customer data, securities broker company's data and stock exchange data, if so, then triggering extraction unit；
Extraction unit, for extracting target backup test data from DB Backup table；
Import unit, for target backup test data being imported in the database formal table of target database, so that
Target database loads target backup test data；
Test cell carries out TPC-E test to target database, obtains target for being based on target backup test data
The TPC-E test report of database；
Issuance unit issues TPC-E test report to UE.
Preferably, testing service device further include:
Monitoring unit, tune used test data when for monitoring disparate databases progress TPC-E test；
Extraction unit is also used to extract test data；
Testing service device further include:
Storage unit, for test data to be stored in multiple TXT text files by separator；
Import unit is also used to import TXT text file in DB Backup table, obtains backup test database.
Preferably, the corresponding different backup test of database of disparate databases type is stored in DB Backup table
Data, extraction unit are specifically used for:
Identify the type of database of target database；
The corresponding target backup test data of type of database of target database are extracted from DB Backup table.
Preferably, import unit is specifically used for:
Obtain the type of database of target database；
Obtain the compatible rule of database of the type of database of target database；
According to the compatible rule of database, target backup test data are imported in the database formal table of target database.
Preferably, detection unit is also used to detect in the database formal table in target database whether be stored with target
Backup test data, if so, then whether being stored with target backup test data in detection trigger DB Backup table.
The third aspect, this application provides testing service device, including processor, processor is stored for executing in memory
Computer program when realize that above-mentioned first aspect such as can be the TPC-E test method of convenient operation based on backup test data
Either step.
Fourth aspect, this application provides readable storage medium storing program for executing, are stored thereon with computer program, and computer program is located
Manage realized when device executes as above-mentioned first aspect based on backup test data can convenient operation TPC-E test method any
Step.
As can be seen from the above technical solutions, the application has the following advantages:
On the one hand, testing service device is when carrying out TPC-E test to target database, directly from local preset database
The corresponding target backup test data of target database are extracted in backup table, and the database for importing target database is formal
Table, human cost needed for manually importing test data so as to avoid staff；
On the other hand, since testing service device is to instruct entrained Database Identification according to the test that UE is initiated, automatically
Positioning and linking objective database from device network, therefore, also can avoid staff's manual configuration testing service device with
Human cost needed for the connection of target database.
The people of staff has further been liberated in the landing application of TPC-E test benchmark by above-mentioned two setting
Power cost promotes TPC-E testing tool (being applied to testing service device) easily can carry out TPC-E test to target database.
Detailed description of the invention
Fig. 1 show the application based on backup test data can a kind of process of TPC-E test method of convenient operation show
It is intended to；
Fig. 2 shows the application based on backup test data can convenient operation TPC-E test method another process
Schematic diagram；
Fig. 3 show the application based on backup test data can convenient operation TPC-E test method another process
Schematic diagram；
Fig. 4 show the application based on backup test data can convenient operation TPC-E test method another process
Schematic diagram；
Fig. 5 shows a kind of structural schematic diagram of the application testing service device；
Fig. 6 shows another structural schematic diagram of the application testing service device.
Specific embodiment
This application provides based on backup test data can convenient operation TPC-E test method and testing service device, use
In the human cost of further liberation staff, TPC-E test easily is carried out to target database.
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, before introducing the application, introduce first this application involves testing service device and UE.
In this application, testing service device be deploy the application based on backup test data can convenient operation TPC-E
The server apparatus of test method, the server apparatus also are understood as host equipment, therefore, testing service device it will be understood that
To test host.
Server apparatus has communication capacity and data-handling capacity, and server apparatus is specifically as follows independently operated
Equipment, or can also be device clusters, specifically it is not limited here.
UE is specially smart phone, tablet computer, desktop computer, laptop, computer all-in-one machine, personal digital assistant
The terminal devices such as (Personal Digital Assistant, PDA), Intelligent bracelet or smartwatch, UE have man-machine friendship
Mutual ability, and UE may also access testing service device, carry out initiation or reception of TPC-E test report of test instruction etc.
Sequence of operations.
In the following, the introduction then based on above-mentioned simple background, starts the particular content for introducing the application.
Refering to fig. 1, Fig. 1 show the application based on backup test data can convenient operation TPC-E test method one
Kind of flow diagram, specifically, the application based on backup test data can the TPC-E test method of convenient operation may include as follows
Step:
Step S101, testing service device receive the test instruction that UE is initiated；
It is appreciated that the staff of the side UE, can be by UE, to survey in the TPC-E testing requirement with database
It tries server and initiates test instruction, trigger TPC-E test assignment.
The Database Identification of target database can be carried in test instruction, so that testing service device determines data to be tested
Library.
Step S102, the Database Identification that the test of testing service device is carried according to test instruction, positions from device network
The target database of pending TPC-E test；
In the test instruction triggers TPC-E test assignment initiated according to UE, which is tested personage by testing service device
It is added in the progress of work.
Testing service device reads the Database Identification of target database from the reserved field that the test instructs, further according to
The connection device identification of device network table, positions target database from device network.
It should be understood that target database is generally deployed on database server, target database is an independence
Server apparatus, by network it is online, carry out database work.
Testing service device can be added in above-mentioned device network, alternatively, can also be in outside device network, it is only necessary to be had and be adjusted
With the device network table of the device network.
After navigating to target database, testing service device can automatically configure the company of the network between target database
It connects, to carry out subsequent TPC-E test.
Step S103, testing service device detect in local preset DB Backup table whether be stored with target database pair
The target backup test data answered；
Wherein, target database Backup Data is user data needed for carrying out TPC-E test for target database, is used
User data includes customer data, securities broker company's data and stock exchange data.
It is and manual from staff to target database in the prior art when carrying out TPC-E test to target database
It imports unlike test data, testing service device is locally being preset with a DB Backup table, which is used for
It is previously stored the backup file of user data needed for database carries out TPC-E test, i.e. backup test data, testing service device
First there are the corresponding target backup test data of target database by no for detection in the DB Backup table, and if it exists,
The step S104 of triggering following.
Step S104, testing service device extract target backup test data from DB Backup table；
Testing service device extracts the corresponding target backup test of the target database detected from the DB Backup table
Data.
Step S105, testing service device import target backup test data in the database formal table of target database,
So that target database loads target backup test data；
After obtaining the corresponding target backup test data of target database, testing service device can by with target data
Target backup test data are imported target database, so that target database loads the mesh by the network connection configured between library
Backup test data are marked, the actual treatment scene of processing affairs involved in reduction TPC-E.
Step S106, testing service device are based on target backup test data, carry out TPC-E test to target database, obtain
To the TPC-E test report of target database；
After importing target backup test data, testing service device can be right according to TPC-E test mode in the prior art
Target database carries out TPC-E test, by the network connection configured between target database, trigger target database for
The responsive operation of affairs is simulated, and monitors, collect the response results of target database, processing obtains the TPC-E of target database
Test report.
Step S107, testing service device issue TPC-E test report to UE.
Finally, testing service device issues TPC-E test to UE after obtaining the TPC-E test report of target database
A TPC-E test assignment can be completed in report, terminates the progress of work of TPC-E test assignment.
From the foregoing it is appreciated that, it is provided by the present application based on backup test data can convenient operation TPC-E test method, one
Aspect, testing service device are directly mentioned from local preset DB Backup table when carrying out TPC-E test to target database
The corresponding target backup test data of target database are taken out, and import the database formal table of target database, to avoid
Human cost needed for staff manually imports test data；
On the other hand, since testing service device is to instruct entrained Database Identification according to the test that UE is initiated, automatically
Positioning and linking objective database from device network, therefore, also can avoid staff's manual configuration testing service device with
Human cost needed for the connection of target database.
The people of staff has further been liberated in the landing application of TPC-E test benchmark by above-mentioned two setting
Power cost promotes TPC-E testing tool (being applied to testing service device) easily can carry out TPC-E test to target database.
In further optimization design, refering to Fig. 2 shows the application can convenient operation based on backup test data
Another flow diagram of TPC-E test method, above-mentioned the application based on backup test data can convenient operation TPC-E survey
Method for testing may also include the steps of:
Step S201, testing service device monitor disparate databases and carry out tune used test data when TPC-E test；
It is appreciated that in the TPC-E test assignment handled before testing service device, i.e., do not apply or certain applications sheet
Apply for backup test data can convenient operation TPC-E test method when, it is corresponding not that different TPC-E test assignments can be monitored
With database when TPC-E is tested the used test data of tune, i.e. the monitoring personnel test data that manually imported in the past.
Step S202, testing service device extract test data；
When monitoring test data, testing service device can automatically extract the test data.
Test data is stored in multiple TXT text files by step S203, testing service device by separator；
Then, the test data that testing service device again monitors these is stored by TXT text file.
Step S204, testing service device import TXT text file in DB Backup table, obtain backup test data
Library.
Finally, these TXT text files for being stored with test data are directed into testing service device local by testing service device
In preset DB Backup table, when so as to the new TPC-E test assignment of follow-up test server triggers, local data can be passed through
Library backup table, using the application based on backup test data can convenient operation TPC-E test method.
In practical applications, the database that can carry out TPC-E test, can be corresponding with different type of database, therefore, In
In further optimization design, the corresponding different backup of database of disparate databases type is stored in DB Backup table
Test data, corresponding, step S104 in embodiment illustrated in fig. 1 are based on backup test refering to the application the application shown in Fig. 3
Data can convenient operation TPC-E test method another flow diagram, can specifically be achieved by the steps of:
Step S301, testing service device identify the type of database of target database；
Testing service device can by modes such as the identification of programming language, the inquiry instruction of type of database, keyword recognitions,
Identify the type of database of target database.
Step S302, testing service device extract the corresponding mesh of type of database of target database from DB Backup table
Mark backup test data.
Testing service device is in the type of database according to target database, from DB Backup table, extracts the data
The corresponding target backup test data of library type, to carry out subsequent TPC-E test.
In further optimization design, for the database of TPC-E test can be carried out, different databases can be corresponding with
The case where type, the also generally applicable a backup test data of testing service device are corresponding, refering to this Shen of the application shown in Fig. 4
Please based on backup test data can convenient operation TPC-E test method another flow diagram, in this case, Fig. 1
Step S105 in illustrated embodiment can be specifically achieved by the steps of:
Step S401, testing service device obtain the type of database of target database；
Testing service device can by modes such as the identification of programming language, the inquiry instruction of type of database, keyword recognitions,
Identify the type of database of target database.
Step S402, testing service device obtain the compatible rule of database of the type of database of target database；
After determining the type of database of target database, it is corresponding preset that testing service device can obtain the database
The compatible rule of database, compatibility rule, for testing service device by content information possessed by general backup test data,
With compatibility mode, import in the database of disparate databases type.
Target backup test data are imported target data according to the compatible rule of database by step S403, testing service device
In the database formal table in library.
By the compatible rule of above-mentioned acquisition, testing service device completely can inerrably import target backup test data
In the database formal table of target database, to carry out subsequent TPC-E test.
In further optimization design, in executing embodiment described in Fig. 1 before step S103, the application is based on backup
Test data can the TPC-E test method of convenient operation may also include the steps of:
Target backup test data whether are stored in database formal table in test database detection target database,
If so, then triggering step S103, target backup test data whether are stored in Test database backup table.
It is appreciated that backup test data can be mutually consistent with test data, for this purpose, testing service device can first verify mesh
Whether mark database has been loaded with test data, if so, then no longer needing to execute embodiment illustrated in fig. 1 step S103 to step
S105, cost needed for importing backup test data to avoid the local detection of backup test data and to target database.
Be above to the application based on backup test data can convenient operation TPC-E test method introduction, open below
Beginning introduces the testing service device of the application.
A kind of structural schematic diagram of the application testing service device is shown refering to Fig. 5, Fig. 5, specifically, testing service device can
It comprises the following structure:
Receiving unit 501, for receiving the test instruction of UE initiation；
Positioning unit 502, for test according to test instruction carry Database Identification, from device network positioning into
The target database of row TPC-E test；
Whether detection unit 503 is stored with target database correspondence for detecting in the preset DB Backup table in local
Target backup test data, wherein target database Backup Data be for target database carry out TPC-E test needed for
User data, user data includes customer data, securities broker company's data and stock exchange data, if so, then triggering extraction
Unit 504；
Extraction unit 504, for extracting target backup test data from DB Backup table；
Import unit 505, for target backup test data being imported in the database formal table of target database, so that
It obtains target database and loads target backup test data；
Test cell 506 carries out TPC-E test to target database, obtains mesh for being based on target backup test data
Mark the TPC-E test report of database；
Issuance unit 507 issues TPC-E test report to UE.
In further optimization design, testing service device further include:
Monitoring unit 508, tune used test data when for monitoring disparate databases progress TPC-E test；
Extraction unit 504 is also used to extract test data；
Testing service device further include:
Storage unit 509, for test data to be stored in multiple TXT text files by separator；
Import unit 505 is also used to import TXT text file in DB Backup table, obtains backup test database.
In further optimization design, the database that disparate databases type is stored in DB Backup table is corresponding
Different backup test data, extraction unit 504 are specifically used for:
Identify the type of database of target database；
The corresponding target backup test data of type of database of target database are extracted from DB Backup table.
In further optimization design, import unit 505 is specifically used for:
Obtain the type of database of target database；
Obtain the compatible rule of database of the type of database of target database；
According to the compatible rule of database, target backup test data are imported in the database formal table of target database.
In further optimization design, detection unit 506 is also used to detect the database formal table in target database
In whether be stored with target backup test data, if so, then whether be stored in detection trigger DB Backup table target backup
Test data.
Another structural schematic diagram of testing service device provided by the present application is shown refering to Fig. 6, Fig. 6, specifically, this Shen
The testing service device that please be provided includes processor 601, and processor 601 is for executing the computer program stored in memory 602
Shi Shixian correspond to as shown in Figure 1 to Figure 4 in any embodiment based on backup test data can convenient operation TPC-E test method it is each
Step；Alternatively, being realized when processor 601 is for executing the computer program stored in memory 602 as in Fig. 5 corresponding embodiment
The function of each unit.
Illustratively, computer program can be divided into one or more module/units, and one or more module/
Unit is stored in memory 602, and is executed by processor 601, 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.
Testing service device may include, but be not limited only to processor 601, memory 602.Those skilled in the art can manage
Solution, signal be only computer installation example, do not constitute the restriction to testing service device, may include than illustrate it is more or
Less component perhaps combines certain components or different components, such as testing service device can also be set including input and output
Standby, network access equipment, bus etc., processor 601, memory 602, input-output equipment and network access equipment etc. pass through
Bus is connected.
Processor 601 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 602 can be used for storing computer program and/or module, and processor 601 is stored in by operation or execution
Computer program and/or module in memory 602, and the data being stored in memory 602 are called, realize computer dress
The various functions of setting.Memory 602 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.
Present invention also provides readable storage medium storing program for executing, are stored thereon with computer program, and computer program is held by processor
Realized when row in corresponding any embodiment as shown in Figure 1 to Figure 4 based on backup test data can convenient operation 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 server and its unit, can referring to figs. 1 in Fig. 4 corresponding embodiment be based on backup test data can be just
The TPC-E test method of express agency, specific details are not described herein.
To sum up, this application provides can the TPC-E test method of convenient operation, testing service device based on backup test data
And readable storage medium storing program for executing, on the one hand, testing service device is when carrying out TPC-E test to target database, directly from local pre-
If DB Backup table in extract the corresponding target backup test data of target database, and import the number of target database
According to library formal table, human cost needed for manually importing test data so as to avoid staff；
On the other hand, since testing service device is to instruct entrained Database Identification according to the test that UE is initiated, automatically
Positioning and linking objective database from device network, therefore, also can avoid staff's manual configuration testing service device with
Human cost needed for the connection of target database.
The people of staff has further been liberated in the landing application of TPC-E test benchmark by above-mentioned two setting
Power cost promotes TPC-E testing tool (being applied to testing service device) easily can carry out TPC-E test to target database.
In several embodiments provided herein, it should be understood that disclosed testing service device and its unit, it can
To realize by another way.For example, the apparatus embodiments described above are merely exemplary, for example, unit is drawn
Point, only a kind of logical function partition, there may be another division manner in actual implementation, such as multiple units or components can
To combine or be desirably integrated into another system, or some features can be ignored or not executed.Another point, it is shown or beg for
The mutual coupling, direct-coupling or communication connection of opinion can be through some interfaces, the INDIRECT COUPLING of device or unit
Or communication connection, it can be electrical property, mechanical or other forms.
Unit may or may not be physically separated as illustrated by the separation member, shown as a unit
Component may or may not be physical unit, it can and it is in one place, or may be distributed over multiple networks
On unit.It can some or all of the units may be selected to achieve the purpose of the solution of this embodiment according to the actual needs.
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.
More than, above embodiments are only to illustrate the technical solution of the application, rather than its limitations；Although referring to aforementioned reality
Example is applied the application is described in detail, those skilled in the art should understand that: it still can be to aforementioned each
Technical solution documented by embodiment is modified or equivalent replacement of some of the technical features；And these are modified
Or replacement, 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. it is a kind of based on backup test data can convenient operation TPC-E test method, which is characterized in that the described method includes:
Testing service device receives the test instruction that user equipment (UE) is initiated；
The Database Identification that the testing service device test is carried according to the test instruction, positions pending from device network
The target database of TPC-E test；
It is corresponding that the target database whether is stored in the local preset DB Backup table of testing service device detection
Target backup test data, wherein the target database Backup Data is to carry out the TPC-E for the target database
User data needed for test, the user data includes customer data, securities broker company's data and stock exchange data；
If so, then the testing service device extracts the target backup test data from the DB Backup table；
The testing service device imports the target backup test data in the database formal table of the target database, with
So that the target database loads the target backup test data；
The testing service device is based on the target backup test data, carries out the TPC-E test to the target database,
Obtain the TPC-E test report of the target database；
The testing service device issues the TPC-E test report to the UE.
2. the method according to claim 1, wherein the method also includes:
The testing service device monitoring disparate databases carry out tune used test data when TPC-E test；
The testing service device extracts the test data；
The test data is stored in multiple TXT text files by the testing service device by separator；
The testing service device imports the TXT text file in the DB Backup table, obtains the backup test number
According to library.
3. the method according to claim 1, wherein being stored with disparate databases class in the DB Backup table
The corresponding different backup test data of the database of type, described in the testing service device is extracted from the DB Backup table
Target backup test data include:
The testing service device identifies the type of database of the target database；
The testing service device extracts the corresponding institute of type of database of the target database from the DB Backup table
State target backup test data.
4. the method according to claim 1, wherein the testing service device imports the backup test data
Include: in the database formal table of the target database
The testing service device obtains the type of database of the target database；
The testing service device obtains the compatible rule of database of the type of database of the target database；
The target backup test data are imported the number of targets according to the compatible rule of the database by the testing service device
According in the database formal table in library.
5. the method according to claim 1, wherein the local preset database of testing service device detection is standby
Whether it is stored with before the corresponding target backup test data of the target database in part table, the method also includes:
The test database detects the target backup whether is stored in the database formal table in the target database
Test data, if so, then triggering the testing service device detects whether to be stored with the target in the DB Backup table standby
Part test data.
6. a kind of testing service device, which is characterized in that the testing service device includes:
Receiving unit, for receiving the test instruction of user equipment (UE) initiation；
Positioning unit positions pending for testing the Database Identification carried according to the test instruction from device network
The target database of TPC-E test；
Detection unit, for detecting in local preset DB Backup table whether be stored with the corresponding mesh of the target database
Mark backup test data, wherein the target database Backup Data is to carry out the TPC-E survey for the target database
User data needed for examination, the user data includes customer data, securities broker company's data and stock exchange data, if
Have, then triggers extraction unit；
The extraction unit, for extracting the target backup test data from the DB Backup table；
Import unit, for the target backup test data to be imported in the database formal table of the target database, with
So that the target database loads the target backup test data；
Test cell carries out the TPC-E test to the target database for being based on the target backup test data,
Obtain the TPC-E test report of the target database；
The testing service device issues the TPC-E test report to the UE.
7. testing service device according to claim 6, which is characterized in that the testing service device further include:
Monitoring unit carries out tune used test data when the TPC-E is tested for monitoring disparate databases；
The extraction unit is also used to extract the test data；
The testing service device further include:
Storage unit, for the test data to be stored in multiple TXT text files by separator；
The import unit is also used to import the TXT text file in the DB Backup table, obtains the backup and surveys
Try database.
8. testing service device according to claim 6, which is characterized in that be stored with different numbers in the DB Backup table
According to the corresponding different backup test data of the database of library type, the extraction unit is specifically used for:
Identify the type of database of the target database；
The corresponding target backup test of type of database of the target database is extracted from the DB Backup table
Data.
9. testing service device according to claim 6, which is characterized in that the import unit is specifically used for:
Obtain the type of database of the target database；
Obtain the compatible rule of database of the type of database of the target database；
According to the compatible rule of the database, the target backup test data are being imported into the database of the target database just
In formula table.
10. testing service device according to claim 6, which is characterized in that the detection unit is also used to detect the mesh
The target backup test data whether are stored in database formal table in mark database, if so, then described in detection trigger
Whether the target backup test data are stored in DB Backup table.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910572315.6A CN110457187B (en) | 2019-06-28 | 2019-06-28 | TPC-E test method and test server capable of conveniently running based on backup test data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910572315.6A CN110457187B (en) | 2019-06-28 | 2019-06-28 | TPC-E test method and test server capable of conveniently running based on backup test data |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110457187A true CN110457187A (en) | 2019-11-15 |
| CN110457187B CN110457187B (en) | 2023-05-12 |
Family
ID=68481812
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910572315.6A Active CN110457187B (en) | 2019-06-28 | 2019-06-28 | TPC-E test method and test server capable of conveniently running based on backup test data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110457187B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111767286A (en) * | 2020-06-29 | 2020-10-13 | 携程旅游网络技术（上海）有限公司 | Data mirror image backup method, test method and system based on order |
Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20120059919A1 (en) * | 2010-09-03 | 2012-03-08 | Salesforce.Com, Inc. | Web services environment testing framework |
| CN103001693A (en) * | 2012-12-25 | 2013-03-27 | 索尔思光电（成都）有限公司 | Light module test method |
| US20170116220A1 (en) * | 2015-10-23 | 2017-04-27 | Oracle International Corporation | Synchronized test master |
| CN107329890A (en) * | 2017-06-06 | 2017-11-07 | 北京金山安全软件有限公司 | Test method and device based on Mock and server |
| US20170351746A1 (en) * | 2016-06-06 | 2017-12-07 | International Business Machines Corporation | Test data management |
| WO2017215432A1 (en) * | 2016-06-15 | 2017-12-21 | 腾讯科技（深圳）有限公司 | Data retracement method, device and system |
| WO2018049912A1 (en) * | 2016-09-14 | 2018-03-22 | 广东欧珀移动通信有限公司 | Data transmission method and related devices |
| CN108197021A (en) * | 2017-12-28 | 2018-06-22 | 深圳市彬讯科技有限公司 | A kind of web system automated testing method, device, equipment and storage medium |
| CN109324959A (en) * | 2018-08-13 | 2019-02-12 | 中国平安人寿保险股份有限公司 | A kind of method, server and the computer readable storage medium of automatic transfer data |
| CN109902027A (en) * | 2019-03-29 | 2019-06-18 | 梁俊杰 | A kind of TPC-DS test method and system convenient to carry out |
-
2019
- 2019-06-28 CN CN201910572315.6A patent/CN110457187B/en active Active
Patent Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20120059919A1 (en) * | 2010-09-03 | 2012-03-08 | Salesforce.Com, Inc. | Web services environment testing framework |
| CN103001693A (en) * | 2012-12-25 | 2013-03-27 | 索尔思光电（成都）有限公司 | Light module test method |
| US20170116220A1 (en) * | 2015-10-23 | 2017-04-27 | Oracle International Corporation | Synchronized test master |
| US20170351746A1 (en) * | 2016-06-06 | 2017-12-07 | International Business Machines Corporation | Test data management |
| WO2017215432A1 (en) * | 2016-06-15 | 2017-12-21 | 腾讯科技（深圳）有限公司 | Data retracement method, device and system |
| WO2018049912A1 (en) * | 2016-09-14 | 2018-03-22 | 广东欧珀移动通信有限公司 | Data transmission method and related devices |
| CN107329890A (en) * | 2017-06-06 | 2017-11-07 | 北京金山安全软件有限公司 | Test method and device based on Mock and server |
| CN108197021A (en) * | 2017-12-28 | 2018-06-22 | 深圳市彬讯科技有限公司 | A kind of web system automated testing method, device, equipment and storage medium |
| CN109324959A (en) * | 2018-08-13 | 2019-02-12 | 中国平安人寿保险股份有限公司 | A kind of method, server and the computer readable storage medium of automatic transfer data |
| CN109902027A (en) * | 2019-03-29 | 2019-06-18 | 梁俊杰 | A kind of TPC-DS test method and system convenient to carry out |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111767286A (en) * | 2020-06-29 | 2020-10-13 | 携程旅游网络技术（上海）有限公司 | Data mirror image backup method, test method and system based on order |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110457187B (en) | 2023-05-12 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20200183811A1 (en) | Automatically Performing and Evaluating Pilot Testing of Software | |
| CN106201288A (en) | Storage method, device and the mobile terminal of a kind of finger print information | |
| CN104182683B (en) | A kind of monitoring method of online transaction, apparatus and system | |
| CN106096926B (en) | Event processing method, device, electronic device and storage medium | |
| CN109062807B (en) | Method and device for testing application program, storage medium and electronic device | |
| CN107402720B (en) | Hard disk processing method and device and terminal | |
| CN115187331A (en) | Product recommendation method, device, equipment and storage medium based on multi-modal data | |
| CN112148607A (en) | Interface testing method and device for service scene | |
| CN110457187A (en) | Based on backup test data can convenient operation TPC-E test method and testing service device | |
| CN110069406A (en) | The TPC-DS test method and system of automatic trigger | |
| CN110457202A (en) | Quickly establish the TPC-E test method and actuator device of ODBC connection | |
| CN109639755A (en) | Interconnected system server decoupling method, device, medium and electronic equipment | |
| CN112612496A (en) | Intelligent contract operation management method, device, equipment and computer storage medium | |
| CN111831682A (en) | Method, device, equipment and computer readable medium for processing accumulation fund service | |
| CN106095400A (en) | A kind of application program method for down loading and terminal, communication equipment | |
| CN114285786B (en) | Construction method and device of network link library | |
| CN105403221A (en) | Method for generating navigation route and mobile terminal | |
| CN110704301B (en) | TPC-E automatic test method and TPC-E test system | |
| CN104426708A (en) | Method and system for executing security detection service | |
| CN110457188A (en) | It can keep the TPC-E test method and test macro of transaction types ratio | |
| CN104992093A (en) | Information management method and apparatus | |
| CN106376096A (en) | Wireless network connection method and device thereof | |
| CN110992044A (en) | Data processing method and device, electronic equipment and readable storage medium | |
| CN105930722B (en) | A kind of security of mobile terminal detection method and device based on formalized description | |
| CN110618920B (en) | Communication method applied to TPC-E test and driver 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 |