CN110457202A - Quickly establish the TPC-E test method and actuator device of ODBC connection - Google Patents
Quickly establish the TPC-E test method and actuator device of ODBC connection Download PDFInfo
- Publication number
- CN110457202A CN110457202A CN201910572311.8A CN201910572311A CN110457202A CN 110457202 A CN110457202 A CN 110457202A CN 201910572311 A CN201910572311 A CN 201910572311A CN 110457202 A CN110457202 A CN 110457202A
- Authority
- CN
- China
- Prior art keywords
- database
- actuator device
- test
- target
- target database
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/36—Preventing errors by testing or debugging software
- G06F11/3668—Software testing
- G06F11/3672—Test management
- G06F11/3688—Test management for test execution, e.g. scheduling of test suites
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Computational Linguistics (AREA)
- Computer Hardware Design (AREA)
- Quality & Reliability (AREA)
- Debugging And Monitoring (AREA)
Abstract
This application provides the TPC-E test methods and actuator device of quickly establishing ODBC connection, for quickly establishing the ODBC connection of actuator device and target database when triggering TPC-E test assignment.The TPC-E test method that the application quickly establishes ODBC connection is applied to actuator device, comprising: actuator device receives the test request from client, and test request is the TPC-E test assignment of target database for request for test object；Actuator device identifies the type of database of target database according to test request；Actuator device generates link information needed for establishing ODBC connection between actuator device and target database according to the type of database of target database；DSN file is written in link information by actuator device；Actuator device starts ODBC driver, establishes the connection of the ODBC between actuator device and target database according to DSN file；Actuator device is based on ODBC connection, carries out TPC-E test to target database, obtains the TPC-E test result of target database.
Description
Technical field
This application involves testing fields, more particularly to quickly establish the TPC-E test method and driver of ODBC connection
Equipment.
Background technique
Based on Transaction Processing Performance Council (Transaction Processing Performance Council,
TPC) the TPC-E test benchmark released for the assessment of database performance, can develop corresponding TPC-E testing tool.
It is readily appreciated that, if the automation performance and testing efficiency of TPC-E can be improved, work can be tested to improve TPC-E
The practicability of tool, convenient for promoting and applying.
In TPC-E test, existing TPC-E testing tool needs the net between staff's manual configuration and database
Network connection can be into one based on foregoing teachings it will be appreciated that if manual operation needed for being avoided that Configuration network connection
Step promotes the automation performance of TPC-E testing tool, for this reason, it may be necessary to carry out corresponding corrective measure.
Summary of the invention
This application provides quickly establish open CNC (Open Database Connectivity, ODBC) even
The TPC-E test method and actuator device connect, for quickly establishing actuator device when triggering TPC-E test assignment
It is connect with the ODBC of target database.
In a first aspect, method is applied to driver this application provides the TPC-E test method for quickly establishing ODBC connection
Equipment, method include:
Actuator device receives the test request from client, and test request is target data for request for test object
The TPC-E test assignment in library；
Actuator device identifies the type of database of target database according to test request；
Actuator device is generated and is built between actuator device and target database according to the type of database of target database
Link information needed for vertical ODBC connection；
Data source title (Data Source Name, DSN) file is written in link information by actuator device；
Actuator device starts ODBC driver, is established between actuator device and target database according to DSN file
ODBC connection；
Actuator device is based on ODBC connection, carries out TPC-E test to target database, obtains the TPC- of target database
E test result.
Optionally, actuator device establishes the ODBC connection packet between driver and target database according to DSN file
It includes:
Actuator device is established between CEServer component and target database, MEEServer respectively according to DSN file
ODBC connection between component and target database, CEServer component and MEEServer component are all deployed in driver and set
It is standby upper.
Optionally, actuator device identifies that the type of database of target database includes: according to test request
Actuator device extracts the type of database mark for the target database that test request carries；
Actuator device identifies the type of database of identification target database according to type of database；Alternatively,
Actuator device extracts the Database Identification for the target database that test request carries；
Actuator device is according to the attribute information of database identification query target database；
Actuator device determines the type of database of target database according to attribute information.
Optionally, method further include:
Actuator device receives and stores the corresponding category of Database Identification that staff first passes through management interface write-in in advance
Property information；Alternatively,
Actuator device includes: according to the attribute information of database identification query target database
Actuator device sends the corresponding inquiry request of Database Identification to test platform；
Actuator device receives the attribute information that test platform is fed back according to inquiry request.
Optionally, method further include:
Actuator device identifies the version number of target database according to test request；
Actuator device is generated and is built between actuator device and target database according to the type of database of target database
Founding the required link information of ODBC connection includes:
Actuator device generates connection letter according to the type of database of target database and the version number of target database
Breath.
Second aspect, this application provides actuator device, equipment includes:
Receiving unit, for receiving the test request from client, test request is target for request for test object
The TPC-E test assignment of database；
Recognition unit, for identifying the type of database of target database according to test request；
Generation unit, for the type of database according to target database, generate actuator device and target database it
Between establish the link information needed for ODBC connection；
Writing unit, for DSN file to be written in link information；
Establish unit, for starting ODBC driver, according to DSN file establish actuator device and target database it
Between ODBC connection；
Test cell carries out TPC-E test to target database, obtains target database for being based on ODBC connection
TPC-E test result.
Optionally, unit is established, is specifically used for:
According to DSN file, established between CEServer component and target database respectively, MEEServer component and target
ODBC connection between database, CEServer component and MEEServer component are all deployed on actuator device.
Optionally, receiving unit is also used to:
Receive and store the corresponding attribute information of Database Identification that staff first passes through management interface write-in in advance；Or
Person,
Recognition unit is specifically used for:
According to by sending the corresponding inquiry request of Database Identification to test platform；
Receive the attribute information that test platform is fed back according to inquiry request.
Optionally, receiving unit is specifically used for:
Receive the corresponding attribute information of Database Identification that staff is written by management interface；Alternatively,
Recognition unit is specifically used for:
The corresponding inquiry request of Database Identification is sent to test platform；
Receive the attribute information that test platform is fed back according to inquiry request.
Optionally, recognition unit is also used to:
According to test request, the version number of target database is identified；
Generation unit is specifically used for:
According to the type of database of target database and the version number of target database, link information is generated.
The third aspect, this application provides actuator device, including processor, processor is stored for executing in memory
Computer program when realize as above-mentioned first aspect quickly establish ODBC connection TPC-E test method 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
Reason device realizes the either step of the TPC-E test method for quickly establishing ODBC connection such as above-mentioned first aspect when executing.
As can be seen from the above technical solutions, the application has the following advantages:
In TPC-E test assignment of the triggering to target database, actuator device first identifies the data of target database
Library type generates further according to the type of database and establishes the required link information of ODBC connection, then, by the link information according to
ODBC agreement is written into DSN file, thus, actuator device can be established by ODBC driver program based on DSN file
ODBC between target database is connect, to carry out TPC-E test and obtain the TPC-E test result of target database, In
During being somebody's turn to do, actuator device avoids the manual operation of staff, can quickly establish the DBC between target database
Connection, and then realize higher automation performance.
Detailed description of the invention
Fig. 1 shows a kind of flow diagram that the application quickly establishes the TPC-E test method of ODBC connection；
Fig. 2 shows another flow diagrams that the application quickly establishes the TPC-E test method of ODBC connection；
Fig. 3 shows another flow diagram that the application quickly establishes the TPC-E test method of ODBC connection；
Fig. 4 shows another flow diagram that the application quickly establishes the TPC-E test method of ODBC connection；
Fig. 5 shows another flow diagram that the application quickly establishes the TPC-E test method of ODBC connection；
Fig. 6 shows a kind of structural schematic diagram of the application actuator device；
Fig. 7 shows another structural schematic diagram of the application actuator device.
Specific embodiment
This application provides the TPC-E test methods and actuator device of quickly establishing ODBC connection, for triggering
When TPC-E test assignment, the ODBC connection of actuator device and target database is quickly established.
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 actuator device.
In this application, TPC-E test macro includes test platform and actuator device, and user can log in or pass through
Client on user equipment (User Equipment, UE) accesses test platform, triggers actuator device for target data
The TPC-E test assignment in library, actuator device are obtained by applying the application quickly to establish the TPC-E test method of ODBC connection
To realize higher automation performance.
UE is specifically as follows smart phone, tablet computer, desktop computer, laptop, computer all-in-one machine, individual digital
The terminal devices such as assistant (Personal Digital Assistant, PDA), Intelligent bracelet or smartwatch, UE have people
Machine interaction capabilities.
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 shows a kind of process signal that the application quickly establishes the TPC-E test method of ODBC connection
Figure, specifically, the TPC-E test method that the application quickly establishes ODBC connection may include following steps:
Step S101, actuator device receive the test request from client；
Wherein, test request is the TPC-E test assignment of target database for request for test object.
It is appreciated that staff in the management work to target database, can directly be connected by the client of the side UE
Driver connected equipment, or actuator device is remotely connected by test platform, and initiate test request, trigger actuator device
TPC-E test is carried out to target database.
Step S102, actuator device identify the type of database of target database according to test request；
After receiving test request, connect with the network between staff's configuration and target database is waited in the prior art
Unlike connecing, in this application, actuator device first identifies the type of database of target database.
It is understood that the database of disparate databases type, the implementation being externally connected to the network is not quite similar,
For this purpose, actuator device when carrying out intelligent link, first identifies the type of database in current target data library.
Step S103, actuator device generate actuator device and number of targets according to the type of database of target database
According to link information needed for establishing ODBC connection between library；
After the type of database for recognizing current target data library, actuator device is on the basis of the type of database
On, generate the link information needed for connection ODBC connection between target database.
The link information includes the essential information of actuator device linking objective database, can from local data base root
It is read according to the type of database of target database, or the disparate databases type stored from test platform is corresponding different basic
It is extracted in information.
DSN file is written in link information by step S104, actuator device；
Then, actuator device is written according to ODBC agreement to DSN text in the link information for obtaining above-mentioned steps S103
Part.
Similar with the content of above-mentioned link information, DSN file also includes driving path, IP, user, password, port
Etc. information.
Step S105, actuator device start ODBC driver, establish actuator device and number of targets according to DSN file
According to the ODBC connection between library；
Obtaining it is current, after the corresponding DSN file of target database, actuator device can by ODBC driver,
The DSN file is loaded, the ODBC connection between target database is established.
Step S106, actuator device are based on ODBC connection, carry out TPC-E test to target database, obtain number of targets
According to the TPC-E test result in library.
After establishing ODBC connection, actuator device can initiate simulation process affairs to target database, in target data
During library responds and handles these simulation process affairs, actuator device can monitor processing result, and based on processing knot
Fruit generates the TPC-E test result of target database.
From the foregoing it is appreciated that, in TPC-E test assignment of the triggering to target database, actuator device first identifies target
Wide area information server type generates link information needed for establishing ODBC connection further according to the type of database, then, by this
Link information is written according to ODBC agreement into DSN file, thus, actuator device can be based on by ODBC driver program
DSN file establishes the ODBC connection between target database, to carry out TPC-E test and obtain the TPC-E of target database
Test result, in this process, actuator device avoid the manual operation of staff, can quickly establish and target database
Between ODBC connection, and then realize higher automation performance.
In one embodiment, it will be understood that be deployed on actuator device Driver component, CEServer component and
MEEServer component, Driver component are used to simulate guest operation type affairs for controlling TPC-E test, CEServer component,
MEEServer is used for simulation market manipulation type affairs.Specifically, establishing ODBC connection in above-mentioned steps S105 and being specifically as follows:
Actuator device is established between CEServer component and target database, MEEServer respectively according to DSN file
ODBC connection between component and target database.
Corresponding, actuator device triggers CEServer component and MEEServer component point by Driver component
Simulation process affairs are not initiated to target database, and then target database can be monitored for the sound of these simulation process affairs
It answers as a result, and obtaining TPC-E test result.
Wherein, the corresponding guest operation type affairs of CEServer component, specifically, may include that brokered transaction counts affairs
(Broker-Volume), customer value counts affairs (Customer-Position), market watch affairs (Market-
Watch), securities information affairs (Security-Detail), Transaction Inquiries affairs (Trade-Lookup), transaction execute affairs
(Trade-Order) and stateful transaction affairs (Trade-Status)；The corresponding market operation type thing of MEEServer component
Business, specifically, may include that market tracking affairs (Market-Feed) and transaction results update affairs (Trade-Result).
In another embodiment, the TPC-E of ODBC connection is quickly established refering to the application that Fig. 2 and 3 are shown respectively
A kind of flow diagram of test method, above-mentioned steps S102, actuator device identify target database according to test request
Type of database is specifically as follows following implementations:
The first,
Step S201, actuator device extract the type of database mark for the target database that test request carries；
It is appreciated that client when generating test request, can be determined the class database of target database by staff
Type, and the type of database of addition target database identifies in test request.
Step S202, actuator device identify the type of database of identification target database according to type of database.
Corresponding, actuator device can take the test request when parsing the test request that client is initiated
The type of database of band identifies, and Direct Recognition goes out the type of database of target database, and under the setting, actuator device is without inspection
The type of database for surveying target database, can obtain the number of target database in the most fast time after triggering TPC-E test assignment
According to library type.
Second,
Step S301, actuator device extract the Database Identification for the target database that test request carries；
Unlike above-mentioned type of database mark, to avoid staff for the type of database of target database
Mistake is recognized, or avoids the maloperation of staff, client is only added to the number of target database in test request
It is identified according to library, by the mark, actuator device can be located by connecting the target database in network or multiple databases, itself
The type of database of target database is detected again.
Step S302, actuator device is according to the attribute information of database identification query target database；
In monitoring objective wide area information server type, actuator device is first according to the database mark in test request
Know, inquires the attribute information of target database, which is specifically as follows the description informations such as version information, for identifying
The essential attribute of target database.
Step S303, actuator device determine the type of database of target database according to attribute information.
After obtaining the attribute information of target database, actuator device is believed from the type of database in the attribute information
Item is ceased, information is extracted and is determined as the type of database of target database.
Further, it in above-mentioned Fig. 3 corresponding embodiment step S302, is quickly established refering to the application shown in Fig. 4
Another flow diagram of the TPC-E test method of ODBC connection, actuator device is according to database identification query number of targets
Can be also specifically following implementations according to the attribute information in library:
The first,
Step S401, actuator device receive and store the Database Identification that staff first passes through management interface write-in in advance
Corresponding attribute information.
It is appreciated that different numbers can be written originally by the management interface configured in staff on actuator device
Corresponding different attribute information is identified according to library.
When actuator device first gets the Database Identification in current target data library, corresponding attribute letter can be retrieved
Breath.
Second,
Step S402, actuator device send the corresponding inquiry request of Database Identification to test platform；
Alternatively, actuator device can also carry out real-time online query, it will be understood that test platform by test platform
Query service can be remotely provided, according to the inquiry request that actuator device is sent, inquire the corresponding database of Database Identification
Attribute information.
Step S403, actuator device receive the attribute information that test platform is fed back according to inquiry request.
After the attribute information for obtaining test platform feedback, actuator device can extract target from the attribute information
Wide area information server type.
In another embodiment, the implementation being connected to the network with Database, in addition to having on type of database
Institute is different, on same type of database type different editions, it is also possible to which there are different implementations, therefore, refering to Fig. 5
The application shown quickly establishes another flow diagram of the TPC-E test method of ODBC connection, and above-mentioned Fig. 1 is corresponding to be implemented
Example, may also include the steps of:
Step S501, actuator device identify the version number of target database according to test request；
Similar with above-mentioned Fig. 1 corresponding embodiment step S102, actuator device identifies target data according to test request
The version number in library, the version number are used to indicate the current version of target database.
Corresponding, in above-mentioned Fig. 1 corresponding embodiment step S103, under current setting, actuator device is according to number of targets
According to the type of database in library, it is specific to generate link information needed for establishing ODBC connection between actuator device and target database
Can include:
Step S502, actuator device according to the type of database of target database and the version number of target database,
Generate link information.
After obtaining the version number of target database, actuator device can be based on type of database and version number two
Person generates link information needed for establishing ODBC connection between target database.
It is the introduction for quickly establishing the TPC-E test method of ODBC connection to the application above, starts to introduce this Shen below
Actuator device please.
A kind of structural schematic diagram of the application actuator device is shown refering to Fig. 6, Fig. 6, specifically, actuator device can
It comprises the following structure:
Receiving unit 601, for receiving the test request from client, test request is mesh for request for test object
Mark the TPC-E test assignment of database；
Recognition unit 602, for identifying the type of database of target database according to test request；
Generation unit 603 generates actuator device and target database for the type of database according to target database
Between establish the link information needed for ODBC connection；
Writing unit 604, for DSN file to be written in link information；
Unit 605 is established, for starting ODBC driver, actuator device and target data are established according to DSN file
ODBC connection between library；
Test cell 606 carries out TPC-E test to target database, obtains target database for being based on ODBC connection
TPC-E test result.
In one embodiment, unit 605 is established, is specifically used for:
According to DSN file, established between CEServer component and target database respectively, MEEServer component and target
ODBC connection between database, CEServer component and MEEServer component are all deployed on actuator device.
In another embodiment, receiving unit 601 are also used to:
Receive and store the corresponding attribute information of Database Identification that staff first passes through management interface write-in in advance；Or
Person,
Recognition unit 602, is specifically used for:
The corresponding inquiry request of Database Identification is sent to test platform；
Receive the attribute information that test platform is fed back according to inquiry request.
Further, receiving unit 601 are specifically used for:
Receive the corresponding attribute information of Database Identification that staff is written by management interface；Alternatively,
Recognition unit 602, is specifically used for:
The corresponding inquiry request of Database Identification is sent to test platform；
Receive the attribute information that test platform is fed back according to inquiry request.
In another embodiment, recognition unit 602 is also used to:
According to test request, the version number of target database is identified；
Generation unit 603, is specifically used for:
According to the type of database of target database and the version number of target database, link information is generated.
Another structural schematic diagram of actuator device provided by the present application is shown refering to Fig. 7, Fig. 7, specifically, this Shen
The actuator device that please be provided includes processor 701, and processor 701 is for executing the computer program stored in memory 702
Shi Shixian such as Fig. 1 to Fig. 5 corresponds to each step that the TPC-E test method of ODBC connection is quickly established in any embodiment；Alternatively,
Processor 701 realizes the function such as each unit in Fig. 6 corresponding embodiment when being used to execute the computer program stored in memory 702
Energy.
Illustratively, computer program can be divided into one or more module/units, and one or more module/
Unit is stored in memory 702, and is executed by processor 701, to complete the application.One or more module/units can
To be the series of computation machine program instruction section that can complete specific function, which is calculating for describing computer program
Implementation procedure in machine device.
Actuator device may include, but be not limited only to processor 701, memory 702.Those skilled in the art can manage
Solution, signal be only computer installation example, do not constitute the restriction to actuator device, may include than illustrate it is more or
Less component perhaps combines certain components or different components, such as actuator device can also be set including input and output
Standby, network access equipment, bus etc., processor 701, memory 702, input-output equipment and network access equipment etc. pass through
Bus is connected.
Processor 701 can be central processing unit (Central Processing Unit, CPU), can also be other
General processor, digital signal processor (Digital Signal Processor, DSP), specific integrated circuit
(Application Specific Integrated Circuit, ASIC), ready-made programmable gate array (Field-
Programmable Gate Array, FPGA) either other programmable logic device, discrete gate or transistor logic,
Discrete hardware components etc..General processor can be microprocessor or the processor is also possible to any conventional processor
Deng processor is the control centre of computer installation, utilizes each portion of various interfaces and the entire computer installation of connection
Point.
Memory 702 can be used for storing computer program and/or module, and processor 701 is stored in by operation or execution
Computer program and/or module in memory 702, and the data being stored in memory 702 are called, realize computer dress
The various functions of setting.Memory 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
It is realized when row as Fig. 1 to Fig. 5 corresponds to the TPC-E test method for quickly establishing ODBC connection in any embodiment.
If it is appreciated that integrated unit be realized in the form of SFU software functional unit and as the sale of independent product or
In use, can store in a computer readable storage medium.Based on this understanding, the technical solution sheet of the application
The all or part of the part that contributes to existing technology or the technical solution can be with software product in other words in matter
Form embodies, which is stored in a storage medium, including some instructions are used so that a meter
Calculate the whole that machine equipment (can be personal computer, server or the network equipment etc.) executes the application each method embodiment
Or part steps.And storage medium above-mentioned include: USB flash disk, mobile hard disk, read-only memory (Read-only Memory,
ROM), random access memory (Random Access Memory, RAM), magnetic or disk etc. are various can store program
The medium of code.
It is apparent to those skilled in the art that for convenience and simplicity of description, the driving of foregoing description
The specific work process of device equipment and its unit, can be referring to figs. 1 to quickly establishing ODBC connection in Fig. 5 corresponding embodiment
TPC-E test method, specific details are not described herein.
To sum up, this application provides quickly establish the TPC-E test method of ODBC connection, actuator device and readable deposit
Storage media, in TPC-E test assignment of the triggering to target database, actuator device first identifies the database of target database
Type generates further according to the type of database and establishes the required link information of ODBC connection, then, by the link information according to
ODBC agreement is written into DSN file, thus, actuator device can be established by ODBC driver program based on DSN file
ODBC between target database is connect, to carry out TPC-E test and obtain the TPC-E test result of target database, In
During being somebody's turn to do, actuator device avoids the manual operation of staff, can quickly establish the ODBC between target database
Connection, and then realize higher automation performance.
In several embodiments provided herein, it should be understood that disclosed actuator 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. a kind of TPC-E test method for quickly establishing ODBC connection, which is characterized in that the method is set applied to driver
It is standby, which comprises
Actuator device receives the test request from client, and the test request is target data for request for test object
The TPC-E test assignment in library；
The actuator device identifies the type of database of the target database according to the test request；
The actuator device generates the actuator device and the target according to the type of database of the target database
Link information needed for establishing ODBC connection between database；
DSN file is written in the link information by the actuator device；
The actuator device starts ODBC driver, establishes the actuator device and the mesh according to the DSN file
Mark the ODBC connection between database；
The actuator device is based on the ODBC connection, carries out TPC-E test to the target database, obtains the target
The TPC-E test result of database.
2. the method according to claim 1, wherein the actuator device establishes institute according to the DSN file
The ODBC connection stated between driver and the target database includes:
The actuator device according to the DSN file, established between CEServer component and the target database respectively,
The ODBC connection between MEEServer component and the target database, the CEServer component and described
MEEServer component is all deployed on the actuator device.
3. the method according to claim 1, wherein the actuator device is according to the test request, identification
The type of database of the target database includes:
The actuator device extracts the type of database mark for the target database that the test request carries；
The actuator device identifies the type of database of the target database according to type of database mark；Alternatively,
The actuator device extracts the Database Identification for the target database that the test request carries；
The attribute information of actuator device target database according to the database identification query；
The actuator device determines the type of database of the target database according to the attribute information.
4. according to the method described in claim 3, it is characterized in that, the method also includes:
The actuator device receives and stores the Database Identification correspondence that staff first passes through management interface write-in in advance
The attribute information；Alternatively,
The attribute information of actuator device target database according to the database identification query includes:
The actuator device sends the corresponding inquiry request of the Database Identification to test platform；
The actuator device receives the attribute information that the test platform is fed back according to the inquiry request.
5. the method according to claim 1, wherein the method also includes:
The actuator device identifies the version number of the target database according to the test request；
The actuator device generates the actuator device and the target according to the type of database of the target database
The required link information of ODBC connection is established between database includes:
The actuator device is raw according to the type of database of the target database and the version number of the target database
At the link information.
6. a kind of actuator device, which is characterized in that the equipment includes:
Receiving unit, for receiving the test request from client, the test request is target for request for test object
The TPC-E test assignment of database；
Recognition unit, for identifying the type of database of the target database according to the test request；
Generation unit generates the actuator device and the target for the type of database according to the target database
Link information needed for establishing ODBC connection between database；
Writing unit, for DSN file to be written in the link information；
Unit is established, for starting ODBC driver, the actuator device and the target are established according to the DSN file
The ODBC connection between database；
Test cell carries out TPC-E test to the target database, obtains the target for being based on the ODBC connection
The TPC-E test result of database.
7. equipment according to claim 6, which is characterized in that it is described to establish unit, it is specifically used for:
According to the DSN file, established between CEServer component and the target database respectively, MEEServer component with
The ODBC connection between the target database, the CEServer component and the MEEServer component are all disposed
On the actuator device.
8. equipment according to claim 6, which is characterized in that the receiving unit is also used to:
Receive and store the corresponding attribute information of the Database Identification that staff first passes through management interface write-in in advance；
Alternatively,
The recognition unit, is specifically used for:
According to by sending the corresponding inquiry request of the Database Identification to test platform；
Receive the attribute information that the test platform is fed back according to the inquiry request.
9. equipment according to claim 8, which is characterized in that the receiving unit is also used to:
Receive the corresponding attribute information of the Database Identification that staff is written by management interface；Alternatively,
The recognition unit, is specifically used for:
The corresponding inquiry request of the Database Identification is sent to test platform；
Receive the attribute information that the test platform is fed back according to the inquiry request.
10. equipment according to claim 6, which is characterized in that the recognition unit is also used to:
According to the test request, the version number of the target database is identified；
The generation unit, is specifically used for:
According to the type of database of the target database and the version number of the target database, the connection letter is generated
Breath.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910572311.8A CN110457202B (en) | 2019-06-28 | 2019-06-28 | TPC-E testing method for quickly establishing ODBC connection and driver equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910572311.8A CN110457202B (en) | 2019-06-28 | 2019-06-28 | TPC-E testing method for quickly establishing ODBC connection and driver equipment |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110457202A true CN110457202A (en) | 2019-11-15 |
| CN110457202B CN110457202B (en) | 2021-03-23 |
Family
ID=68481814
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910572311.8A Active CN110457202B (en) | 2019-06-28 | 2019-06-28 | TPC-E testing method for quickly establishing ODBC connection and driver equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110457202B (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112783785A (en) * | 2021-02-01 | 2021-05-11 | 紫光云技术有限公司 | General test method for Nosql database performance |
| CN112835778A (en) * | 2021-02-25 | 2021-05-25 | 紫光云技术有限公司 | Universal test method for RDS database performance, electronic equipment and server |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103365929A (en) * | 2012-04-10 | 2013-10-23 | 阿里巴巴集团控股有限公司 | Management method and management system of database connection |
| CN105005618A (en) * | 2015-07-21 | 2015-10-28 | 杭州合众数据技术有限公司 | Data synchronization method and system among heterogeneous databases |
-
2019
- 2019-06-28 CN CN201910572311.8A patent/CN110457202B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103365929A (en) * | 2012-04-10 | 2013-10-23 | 阿里巴巴集团控股有限公司 | Management method and management system of database connection |
| CN105005618A (en) * | 2015-07-21 | 2015-10-28 | 杭州合众数据技术有限公司 | Data synchronization method and system among heterogeneous databases |
Non-Patent Citations (1)
| Title |
|---|
| 杨超: "TPC-E测试***的设计与实现", 《万方学位论文》 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112783785A (en) * | 2021-02-01 | 2021-05-11 | 紫光云技术有限公司 | General test method for Nosql database performance |
| CN112835778A (en) * | 2021-02-25 | 2021-05-25 | 紫光云技术有限公司 | Universal test method for RDS database performance, electronic equipment and server |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110457202B (en) | 2021-03-23 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107341109B (en) | Test data generation method and system | |
| CN107102941B (en) | Test case generation method and device | |
| CN109308266A (en) | Construction method, test method, device, equipment and the medium of test case | |
| CN110347596A (en) | A kind of test method, device, system, electronic equipment and medium | |
| JP6713238B2 (en) | Electronic device, method for constructing retail store evaluation model, system and storage medium | |
| CN105099811A (en) | Interface testing method and device | |
| CN103164416A (en) | Identification method and device of user relationship | |
| US10963888B2 (en) | Payment complaint method, device, server and readable storage medium | |
| CN107862425B (en) | Wind control data acquisition method, device and system and readable storage medium | |
| CN104978172A (en) | Integrated management and control method, system and equipment of SDN (Software Defined Networking) applications | |
| CN112035350B (en) | Test method and device for block chain system and computer equipment | |
| CN109062807B (en) | Method and device for testing application program, storage medium and electronic device | |
| CN110457202A (en) | Quickly establish the TPC-E test method and actuator device of ODBC connection | |
| CN109947408A (en) | Information push method and device, storage medium and electronic equipment | |
| CN112148607A (en) | Interface testing method and device for service scene | |
| US20230267430A1 (en) | Data processing method and device, and computer-readable storage medium | |
| CN109992614B (en) | Data acquisition method, device and server | |
| CN110058995A (en) | A kind of the data library test method and system of the interference of avoidable type of database | |
| CN107730380B (en) | Method, system and server for processing joint account | |
| CN110428342A (en) | Data recovery method, server, customer side and storage medium | |
| CN110457187A (en) | Based on backup test data can convenient operation TPC-E test method and testing service device | |
| CN112328871A (en) | Reply generation method, device, equipment and storage medium based on RPA module | |
| CN109756393A (en) | Information processing method, system, medium and calculating equipment | |
| CN110704301A (en) | TPC-E automatic test method and TPC-E test system | |
| CN115242688B (en) | Network fault detection method, device and medium |
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 |