CN103020132B - The testing result display packing of database performance and device - Google Patents
The testing result display packing of database performance and device Download PDFInfo
- Publication number
- CN103020132B CN103020132B CN201210472970.2A CN201210472970A CN103020132B CN 103020132 B CN103020132 B CN 103020132B CN 201210472970 A CN201210472970 A CN 201210472970A CN 103020132 B CN103020132 B CN 103020132B
- Authority
- CN
- China
- Prior art keywords
- repeatedly
- update
- database
- performance
- time
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 238000012360 testing method Methods 0.000 title claims abstract description 93
- 238000012856 packing Methods 0.000 title claims abstract description 10
- 238000001514 detection method Methods 0.000 claims abstract description 61
- 238000011056 performance test Methods 0.000 claims abstract description 17
- 238000000034 method Methods 0.000 claims description 42
- 230000008569 process Effects 0.000 claims description 20
- 238000005070 sampling Methods 0.000 claims description 12
- 238000005259 measurement Methods 0.000 claims description 10
- 230000008878 coupling Effects 0.000 claims description 6
- 238000010168 coupling process Methods 0.000 claims description 6
- 238000005859 coupling reaction Methods 0.000 claims description 6
- 238000012545 processing Methods 0.000 claims description 5
- 238000012731 temporal analysis Methods 0.000 claims description 2
- 238000000700 time series analysis Methods 0.000 claims description 2
- 230000000875 corresponding effect Effects 0.000 description 62
- 230000006870 function Effects 0.000 description 7
- 230000006399 behavior Effects 0.000 description 6
- 238000005516 engineering process Methods 0.000 description 6
- 230000008901 benefit Effects 0.000 description 4
- 230000001747 exhibiting effect Effects 0.000 description 4
- 238000011156 evaluation Methods 0.000 description 3
- 230000002688 persistence Effects 0.000 description 3
- 230000009471 action Effects 0.000 description 2
- 238000004590 computer program Methods 0.000 description 2
- 238000012217 deletion Methods 0.000 description 2
- 230000037430 deletion Effects 0.000 description 2
- 238000010586 diagram Methods 0.000 description 2
- 238000007667 floating Methods 0.000 description 2
- 238000002360 preparation method Methods 0.000 description 2
- 241000208340 Araliaceae Species 0.000 description 1
- 238000012935 Averaging Methods 0.000 description 1
- 235000005035 Panax pseudoginseng ssp. pseudoginseng Nutrition 0.000 description 1
- 235000003140 Panax quinquefolius Nutrition 0.000 description 1
- 238000004422 calculation algorithm Methods 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 238000001035 drying Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 235000008434 ginseng Nutrition 0.000 description 1
- 210000000582 semen Anatomy 0.000 description 1
- 230000009897 systematic effect Effects 0.000 description 1
Landscapes
- Debugging And Monitoring (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses testing result display packing and the device of a kind of database performance, device therein includes: operation executing module, be suitable to read data from internal memory, according to the data read, database table performed multi-pass operation, and by result write disk corresponding for multi-pass operation；Wherein, operation executing module includes: be adapted in use at least one affairs to perform the update implementation sub-module of the repeatedly update for database table；Time logging modle, is suitable to record the time of multi-pass operation；Result acquisition module, is suitable to, according to the time completing multi-pass operation recorded, obtain corresponding database performance testing result；And result presentation module, the request of the database performance detection triggers on according to user interface, demonstrating data storehouse performance test results.The present invention can improve the stability of database performance testing result, and can be asked by the click of user interface, shows the testing result of customer data base performance in real time.
Description
Technical field
The present invention relates to field of computer technology, be specifically related to testing result display packing and the dress of a kind of database performance
Put.
Background technology
Along with the rise of mobile Internet, the mobile terminal such as smart mobile phone has been increasingly becoming can not in people's daily life
One of instrument lacked, user is the strongest for the purchasing demand of mobile terminal.But, user is buying mobile terminal
During, at most can problem is encountered that: the performance of the unclear mobile terminal preparing to buy is how.
For the problems referred to above, more existing inspection software can detect the performance obtaining mobile terminal, and these performances are concrete
May include that CPU integer performance, CPU floating-point performance, 2D(two dimension, Two Dimensions) drawing performance, 3D(be three-dimensional,
Three Dimensions) drawing performance, database performance, SD card (safe digital card, Secure Digital Memory
Card) speed etc..
The Mobile solution overwhelming majority can use database function at present, and database performance can affect to a certain extent
Performance to Mobile solution.Since the performance of mobile terminal refers to the performance of each Mobile solution run thereon, then
Database performance is also an important indicator of mobile device performance..
The detection method of existing database performance usually, perform in data base form repeatedly to insert, revise and
The operations such as renewal, and the performance of data base is obtained according to the time completing all operations.Find after tested, at different detection rings
The testing result fluctuation that under border, the detection method of existing database performance obtains is bigger；Even for same type, using not
In the case of ROM, also can there is bigger difference in the testing result obtained, and difference namely the instability of testing result are easy to
Cause the inaccurate of testing result.And database performance detection will definitely not affect the fairness of overall performance, such as, obviously low side hands
The overall performance score of machine is but high than the overall performance score of middle-end mobile phone, and this is unfair.
In a word, the technical problem that those skilled in the art urgently solve is needed exactly: how can improve data base
The stability of performance test results.
Summary of the invention
In view of the above problems, it is proposed that the present invention in case provide one overcome the problems referred to above or at least in part solve on
State testing result display packing and the device of a kind of database performance of problem.
According to one aspect of the present invention, it is provided that the testing result display packing of a kind of database performance, including:
From internal memory, read data, according to the data that read, database table performed multi-pass operation, by described repeatedly
The result write disk that operation is corresponding, and recorded the time of described multi-pass operation；Wherein, described multi-pass operation includes repeatedly
Update, repeatedly inquiry operate and repeatedly update operation；The execution process of described repeatedly update includes: use at least one
Individual affairs perform for repeatedly update described in database table；
According to the time completing described multi-pass operation recorded, obtain corresponding database performance testing result；
According to the request of the database performance detection triggers in user interface, represent described database performance detection knot
Really.
Alternatively, described repeatedly update includes taking turns repeatedly update more, and update of often taking turns repeatedly therein is
The update performed for many data record；
At least one affairs of the most described use perform for described in database table repeatedly the step of update concrete
For, use successively affairs for many data record in database table perform described take turns repeatedly in update every
Take turns repeatedly update.
Alternatively, one affairs of described use perform the step for repeatedly update described in database table, bag
Include:
Affairs start；
Update is performed for many data record in database table；
Affairs terminate.
Alternatively, described foundation completes the time that described multi-pass operation is spent, and obtains the detection of corresponding database performance
The step of result, including:
According to completing the time that described multi-pass operation is spent, weight system according to database performance score=record strip number *
Corresponding relation described by the number/cost time, is calculated database performance score, as corresponding database performance detection knot
Really:
Wherein, described record strip number is the bar number of the targeted data record of described multi-pass operation, and described weight coefficient is
Obtain according to the weight coefficient data matching of the terminal sample obtained of sampling.
Alternatively, the described weight coefficient data matching according to the terminal sample obtained of sampling obtains described weight coefficient
Step, including:
The usage frequency of whole operating system is accounted for according to the performance scores of preset whole operating system and database manipulation,
Obtain the preferable score of database performance；
Collect the terminal sample meeting preset customer volume condition；
Database table is performed repeatedly test operation by the operating system of collection terminal sample, and calls timer
The time that described in having recorded, repeatedly test operation is spent, as the database performance measurement time that each terminal sample is corresponding；
Utilize the corresponding relation that described database performance score=record strip number * weight coefficient/cost time describes, foundation
Database performance measurement time that the preferable score of described database performance, described each terminal sample are corresponding and described repeatedly test
Operating the bar number of targeted data record, coupling obtains the weight coefficient that each terminal sample is corresponding；
It is fitted the weight coefficient corresponding from described each terminal sample processing, obtains final weight coefficient.
According to a further aspect in the invention, it is provided that the testing result display device of a kind of database performance, including:
Operation executing module, is suitable to read data from internal memory, performs many according to the data read to database table
Secondary operation, and by result write disk corresponding for described multi-pass operation；Wherein, described multi-pass operation include repeatedly update,
Repeatedly inquiry operates and repeatedly updates operation；Described operation executing module includes: be adapted in use at least one affairs perform for
The update implementation sub-module of the described repeatedly update of database table；
Time logging modle, is suitable to record the time of described multi-pass operation；
Result acquisition module, is suitable to, according to the time completing described multi-pass operation recorded, obtain corresponding data base
Performance test results；And
Result presentation module, the request of the database performance detection triggers on according to user interface, represent institute
State database performance testing result.
Alternatively, described repeatedly update includes taking turns repeatedly update more, and update of often taking turns repeatedly therein is
The update performed for many data record；
The most described update implementation sub-module, is particularly adapted to use affairs for a plurality of in database table successively
The execution of data record is described takes turns repeatedly the often wheel repeatedly update in update more.
Alternatively, described update implementation sub-module, including:
Start unit, be suitable to start affairs；
Process unit, is suitable to perform update for many data record in database table；And
End unit, is suitable to end transaction.
Alternatively, described result acquisition module, it is particularly adapted to according to completing the time that described multi-pass operation is spent, foundation
Corresponding relation described by database performance score=record strip number * weight coefficient/cost time, is calculated database performance
Score, as corresponding database performance testing result:
Wherein, described weight coefficient is to obtain according to the weight coefficient data matching of the terminal sample obtained of sampling.
Alternatively, described device also includes: be suitable to obtain according to the weight coefficient data matching of the terminal sample obtained of sampling
The data fitting module arrived；
Described analytic statistics module includes:
Preferable score obtains submodule, is suitable to the performance scores according to preset whole operating system and database manipulation accounts for
The usage frequency of whole operating system, obtains the preferable score of database performance；
Collect submodule, be suitable to collect the terminal sample meeting preset customer volume condition；
Test submodule, is suitable to perform repeatedly to test behaviour to database table in the operating system of collection terminal sample
Make, and call timer record complete described in time that repeatedly test operation is spent, as the data that each terminal models is corresponding
The storehouse performance test time；
Matched sub-block, is suitable to utilize that database performance score=record strip number * weight coefficient/spend is time taking corresponding closes
System, database performance measurement time corresponding according to the preferable score of described database performance, described each terminal sample and described
The repeatedly bar number of the data record that test operation is targeted, coupling obtains the weight coefficient that each terminal models is corresponding；And
Process of fitting treatment submodule, is suitable to be fitted the weight coefficient corresponding from described each terminal sample processing, obtains
Final weight coefficient.
Testing result display packing and the device of a kind of database performance of the present invention have the advantages that
The present invention uses the repeatedly update during the detection of an affairs execution database performance, according to affairs
Atomicity, affairs are indivisible work units, all operations that affairs include or all do, or the most not
Do；So, the embodiment of the present invention uses the repeatedly update during the detection of the database performance of an affairs execution, no
By other thread applied, therefore can be prevented effectively from the CPU waiting time that prior art spends；Further, the present invention is real
Execute the disk operating related to described in affairs of example will not be interrupted, specifically, only need to disposably read from internal memory and repeatedly insert
Enter the data needed for operation, again property write disk, therefore the time-consuming phenomenon of disk of the prior art can be prevented effectively from；
Therefore, the embodiment of the present invention can effectively reduce the fluctuation of database performance testing result, and, it is possible to it is effectively improved data base
The stability of performance test results；
Further, the stability of database performance testing result improves, it is also possible to improve data base to a certain extent
The accuracy of performance test results, it is to avoid database performance detection will definitely be on the impact of the fairness of terminal populations performance；
Further, the present invention can also pass through demonstrating data storehouse performance test results, to display to the user that feedback one
The most fair, real data base's evaluation result.
Described above is only the general introduction of technical solution of the present invention, in order to better understand the technological means of the present invention,
And can be practiced according to the content of description, and in order to allow above and other objects of the present invention, the feature and advantage can
Become apparent, below especially exemplified by the detailed description of the invention of the present invention.
Accompanying drawing explanation
By reading the detailed description of hereafter preferred implementation, various other advantage and benefit common for this area
Technical staff will be clear from understanding.Accompanying drawing is only used for illustrating the purpose of preferred implementation, and is not considered as the present invention
Restriction.And in whole accompanying drawing, it is denoted by the same reference numerals identical parts.In the accompanying drawings:
Fig. 1 shows the flow chart of the detection method of a kind of database performance；
Fig. 2 shows the flow chart of the detection method of a kind of database performance；
Fig. 3 shows the flow process of the testing result display packing of a kind of database performance
Figure；
Fig. 4 shows the exhibiting method signal of a kind of database performance testing result
Figure；
Fig. 5 shows the exhibiting method signal of a kind of database performance testing result
Figure；
Fig. 6 shows the structure chart of the detection device of a kind of database performance；And
Fig. 7 shows the structure of the testing result display device of a kind of database performance
Figure.
Detailed description of the invention
It is more fully described the exemplary embodiment of the disclosure below with reference to accompanying drawings.Although accompanying drawing shows the disclosure
Exemplary embodiment, it being understood, however, that may be realized in various forms the disclosure and should be by embodiments set forth here
Limited.On the contrary, it is provided that these embodiments are able to be best understood from the disclosure, and can be by the scope of the present disclosure
Complete conveys to those skilled in the art.
The embodiment of the present invention is applicable to computer system/server, and they can be with other universal or special calculating systems numerous
Environment or configuration operate together.Be suitable to well-known calculating system, the environment being used together with computer system/server
And/or the example of configuration includes but not limited to: personal computer system, server computer system, thin client, thick client
Machine, hand-held or laptop devices, system based on microprocessor, Set Top Box, programmable consumer electronics, NetPC Network PC,
Minicomputer system large computer system and the distributed cloud computing technology environment including any of the above described system, etc..
Computer system/server can be in computer system executable instruction (the such as journey performed by computer system
Sequence module) general linguistic context under describe.Generally, program module can include routine, program, target program, assembly, logic, number
According to structure etc., they perform specific task or realize specific abstract data type.Computer system/server is permissible
Distributed cloud computing environment is implemented, in distributed cloud computing environment, task be by by communication network links remotely
Reason equipment performs.In distributed cloud computing environment, program module may be located at the Local or Remote meter including storage device
On calculation system storage medium.
The parts of computer system/server can include but not limited to: one or more processor or process are single
Unit, system storage, connect the input/output interface etc. of different system parts.
For the storage mediums such as disk, owing to data base is that data persistence on disk embodies, to data base
Operation be required for accessing disk, and internal memory is the intermediary using database engine to access concrete data, therefore of the prior art
Update is required for reading the data (such as the data of a record) needed for time update from internal memory every time, then write should
Data are to disk, and when supporting a limited number of CPU for common terminal hardware (such as smart mobile phone), at any time
One CPU can only perform a machine instruction, and each thread only obtains the right to use of CPU could perform instruction；So, if
A limited number of CPU is scheduled to other threads applied, the most accordingly by the time interval internal operating system at twice update
Repeatedly update be interrupted, the detection thread of database performance then has to wait for the right to use of CPU and could perform next time
Update, disk operating is then interrupted；Presence or absence or the length of CPU waiting time that above-mentioned CPU waits are likely to cause
The fluctuation of database performance testing result；Further, disk speed than internal memory slow a lot, once disk operating is interrupted and will be subject to
Large effect, increases the time-consuming of disk operating, this fluctuation being easier to cause database performance testing result.
With reference to Fig. 1, it is shown that the flow chart of the detection method of a kind of database performance,
Specifically may include that
Step 101, from internal memory, read data, according to the data that read, database table is performed multi-pass operation, will
The result write disk that described multi-pass operation is corresponding, and recorded the time of described multi-pass operation；Wherein, described multi-pass operation
Specifically can include repeatedly update, repeatedly inquiry operation and repeatedly update operation；The execution of described repeatedly update
Journey specifically may include that at least one affairs of use perform for repeatedly update described in database table；
The embodiment of the present invention can apply to smart mobile phone, panel computer, notebook computer, PDA(personal digital assistant
Personal Digital Assistant) etc. the detection of database performance on mobile terminal, it is also possible to be applied to desktop computer
Deng the detection of database performance on fixed terminal, terminal residing for the detection of concrete database performance is not added with by the embodiment of the present invention
To limit.
In terminal, the detection process of database performance typically requires and database table is performed multi-pass operation, the most repeatedly
Operation specifically can include repeatedly inquiring about operation, repeatedly inquiry operation and repeatedly updating operation etc..It is appreciated that art technology
Personnel can also select the multi-pass operation involved by detection of database performance according to the actual requirements；Such as, the present invention's
In some embodiments, in addition to above-mentioned three kinds of multi-pass operations, the detection of database performance also needs to relate to repeatedly deletion action.
One inventive point of the embodiment of the present invention is then that the execution process to repeatedly update improves, and uses at least
One affairs performs the repeatedly update for database table.In implementing, those skilled in the art can basis
It is actually needed the number determining used affairs.
Such as, in an embodiment of the present invention, described repeatedly update only needs one to take turns can to complete, concrete and
Speech, repeatedly update now is to take turns update in database table the one of the execution of many data record, then this kind
In the case of use affairs to complete this and take turns update.
And for example, in one preferred embodiment of the invention, described repeatedly update specifically can include taking turns repeatedly more
Update, many wheels repeatedly update here is carried out taking turns repeatedly update more, therein often takes turns repeatedly update
For the update performed for many data record, that is, often take turns repeatedly update for the number of data record be
Identical；At least one affairs of the most described use perform for described in database table repeatedly the step of update specifically may be used
Think, use successively affairs for many data record in database table perform described in the repeatedly often wheel in update
Repeatedly update.
In a word, one of the main object of the present invention is, during using affairs to perform the detection of database performance
Repeatedly update, as during the detection of database performance repeatedly update use several affairs complete, this
Inventive embodiments is not any limitation as.
In one preferred embodiment of the invention, what one affairs of described use performed for database table is described many
The step of secondary update, specifically may include that
Step S101, affairs start；
Step S102, in database table many data record perform update；
Step S103, affairs terminate.
During described in assuming, repeatedly update is required for database table, M data record performs update, M=
500；
Do not have the concept of affairs in prior art, then update is required to read a data record from internal memory every time,
Write disk again, circulate 500 times；Assuming the thread interrupt all applied by other between every twice update, i & lt inserts behaviour
Thread latency and disk short time consumption that interruption between work with i+1 time update causes are designated as Ti, the most existing skill
What art obtained completes the time error relative to the time ideally completing 500 updates of 500 updates
For: T1+T2+...Ti+Ti+1+...+T499；Above-mentioned ideal situation refers to the situation not having any interruption；So, prior art
The time completing 500 updates obtained floats between 0～T1+T2+...Ti+Ti+1+...+T499；Using not
In the case of ROM, above-mentioned floating is easily subject to more serious impact；
In the embodiment of the present invention uses affairs for database table, 500 data records perform update
Time, according to the atomicity of affairs, affairs are indivisible work units, all operations that affairs include or all
Do, or do not do；So, during the detection of the database performance that one affairs of embodiment of the present invention use perform repeatedly
Update, will not be affected by other thread applied, therefore when can be prevented effectively from the CPU wait that prior art spends
Between；Further, the disk operating related to described in affairs of the embodiment of the present invention will not be interrupted, specifically, and only need to be from internal memory
Disposably read repeatedly the data needed for update, again property write disk；Therefore, under different detection environment
The time of what the embodiment of the present invention obtained complete 500 updates does not the most float；Even if in the situation using different ROM
Under, the floating of the time completing 500 updates is also very little.
It should be noted that in the embodiment of the present invention, for repeatedly update, the data disposably read from internal memory are
The repeatedly data needed for update, the data of one-time write disk are in the data base that corresponding repeatedly update produces
Result data, in this data base, result data is that data persistence on disk embodies；
In like manner, for repeatedly inquiring about operation, repeatedly updating operation or repeatedly deletion action, the data read from internal memory are also
Data needed for corresponding multi-pass operation, the data of write disk are result data in the data base that corresponding multi-pass operation produces, should
In data base, result data is that data persistence on disk embodies.
In implementing, can use timer record complete described in time of repeatedly update, such as can be
Step S101 affairs start timing before starting, and terminate timing after step S103 affairs terminate, and now the numerical value of timer is just
The time of repeatedly update described in being.Or, current time can be obtained before step S101 affairs start, and in step
Rapid S103 affairs obtain current time after terminating, the difference of two current times be exactly described in repeatedly update time
Between.In a word, the present invention concrete record is completed described in time of repeatedly update be not any limitation as.
It addition, in order to reduce database performance testing result influence further, the most real in the one of the present invention
Execute in example, existing data in data base can be cleaned out before every time detection, and, every kind or often before wheel multi-pass operation clear
Reason falls existing data in data base.
The time completing described multi-pass operation that step 102, foundation are recorded, obtain corresponding database performance detection knot
Really.
Owing to, in step 101, what under different detection environment, the embodiment of the present invention was recorded completes described multi-pass operation
Time the most do not float, therefore the corresponding database performance obtained according to time completing described multi-pass operation of being recorded
Testing result, also has less fluctuation under different detection environment.
In one preferred embodiment of the invention, described foundation completes the time that described multi-pass operation is spent, and obtains
The step of corresponding database performance testing result, specifically may include that
Step S201, foundation complete the time that described multi-pass operation is spent, can be according to database performance score=record
Corresponding relation described by bar number * weight coefficient/cost time, is calculated database performance score, as corresponding data
Storehouse performance test results；
Wherein, described record strip number is the bar number of the targeted data record of described multi-pass operation, and described weight coefficient is
Obtain according to the weight coefficient data matching of the terminal sample obtained of sampling.
In another preferred embodiment of the invention, the weight coefficient data of the described terminal sample obtained according to sampling
Matching obtains the step of described weight coefficient, specifically may include that
Step S301, performance scores and database manipulation according to preset whole operating system account for whole operating system
Usage frequency, obtains the preferable score of database performance；
The model of terminal is varied at present, and as a example by smart mobile phone, its model specifically may include that i9300, Nexus
One, Moto Defy, LG LU640, Google Nexus S, Galaxy Nexus, Semen setariae etc., therefore, implement in the present invention
In example, the performance scores of preset whole operating system can be directed to specific terminal models.
In actual applications, it is possible to use similar inspection software carries out detection and obtains corresponding property specific terminal models
Energy score, and this performance scores is adjusted obtaining the performance scores of preset whole operating system；Such as, in order to improve use
The experience at family, described adjustment can be small up adjustment；It is appreciated that the present invention is to concrete whole operating system
The pre-setting method of performance scores be not any limitation as.
In the embodiment of the present invention, described preset database manipulation accounts for the usage frequency of whole operating system specifically for table
Showing that in actual application, database manipulation accounts for the usage frequency of whole operating system, they can be by those skilled in the art according to actual feelings
Condition is arranged, such as 3% etc.；Further, described preset database manipulation account for whole operating system usage frequency can with specifically
Terminal models is corresponding；In a word, the present invention accounts for the use frequency of whole operating system to concrete described preset database manipulation
The method to set up of degree is not any limitation as.
Step S302, collection meet the terminal sample of preset customer volume condition；
In the embodiment of the present invention, customer volume can be used for representing the quantity that terminal sample is used by a user, people in the art
Member arranges preset customer volume condition according to practical situation, and concrete preset customer volume condition is not any limitation as by the present invention；Example
As, the terminal sample of collection can be ranked up from the fewest order by customer volume, come some positions above and just meet pre-
Put customer volume condition；And for example, in order to expand the range of database performance of the present invention detection, in described preset customer volume condition
May include that covering senior middle school end terminal etc.；Or, above two preset customer volume condition can be used in combination etc..
Step S303, database table is performed repeatedly test operation in the operating system of collection terminal sample, and
Call timer record complete described in time that repeatedly test operation is spent, as the database performance that each terminal models is corresponding
Testing time；
Here step S303 can use the flow process identical with step 101, and therefore not to repeat here.
Step S304, utilize the corresponding pass described by database performance score=record strip number * weight coefficient/cost time
System, database performance measurement time corresponding according to the preferable score of described database performance, described each terminal sample and described
The repeatedly bar number of the data record that test operation is targeted, coupling obtains the weight coefficient that each terminal sample is corresponding；
Here in the corresponding relation described by database performance score=record strip number * weight coefficient/cost time, institute
When stating the preferable score of database performance as the database performance measurement that database performance score, described each terminal sample are corresponding
Between as spending the bar number of the targeted data record of time, described repeatedly test operation as record strip number as known ginseng
Number, therefore can mate and obtain the weight coefficient that each terminal sample is corresponding.
Step S305, the weight coefficient corresponding from described each terminal sample is fitted process, obtain final weighting
Coefficient.
Data fit to the technology of field of statistics, so-called matching refer to certain function known some discrete function values f1,
F2 ..., fn}, by adjust some undetermined coefficients f in this function (λ 1, λ 2 ..., λ n) so that this function and known point set
Difference (least square meaning) is minimum.Specific to the embodiment of the present invention, then treat that the function of matching is database performance score=record
Bar number * weight coefficient/cost time, the numerical value of some discrete points is exactly each terminal sample that the sampling of step 301-step 304 obtains
The weight coefficient of this correspondence.It should be noted that the method for concrete process of fitting treatment is not any limitation as by the present invention.Such as, institute
Stating the meansigma methods that process of fitting treatment can be weight coefficient corresponding to all terminal models, this meansigma methods is as final weighting system
Number；Or, the weight coefficient that all terminal models are corresponding is ranked up, takes maximum and minima, adjust obtain one
Final weight coefficient between this maximum and minima；Or, the weight coefficient that all terminal models are corresponding is arranged
Sequence, takes maximum, minima and an intermediate value, is averaging and obtains final weight coefficient, etc..
It should be noted that the above-mentioned weight coefficient data matching according to the terminal sample obtained of sampling obtains described weighting
Coefficient is intended only as the preferred embodiments of the present invention, and the application that should not be construed as the embodiment of the present invention limits；It practice, ability
Field technique personnel empirically can arrange described weight coefficient by the alternate manner such as value, and such as, one of described weight coefficient is shown
Example is 8000, etc., in a word, the concrete method obtaining described weight coefficient is not any limitation as by the present invention.
The embodiment of the present invention uses Transaction(affairs) perform the detection of database performance during many
Secondary update, according to the atomicity of affairs, affairs are indivisible work units, affairs include each
Operate or all do, or not doing；So, the detection of the database performance that one affairs of embodiment of the present invention use perform
Repeatedly update in journey, will not be affected by other thread applied, therefore can be prevented effectively from what prior art spent
The CPU waiting time；Further, the disk operating related to described in affairs of the embodiment of the present invention will not be interrupted, specifically, only
Need to disposably read repeatedly the data needed for update, again property write disk from internal memory, therefore can be prevented effectively from
The time-consuming phenomenon of disk of the prior art；Therefore, the embodiment of the present invention can effectively reduce the ripple of database performance testing result
Dynamic, and, it is possible to it is effectively improved the stability of database performance testing result；
Further, the stability of database performance testing result improves, it is also possible to improve data base to a certain extent
The accuracy of performance test results, it is to avoid database performance detection will definitely be on the impact of the fairness of terminal populations performance；
Further, the present invention can also pass through demonstrating data storehouse performance test results, to display to the user that feedback one
The most fair, real data base's evaluation result.
It should be noted that the database performance testing result of the embodiment of the present invention is not affected by CPU number, that is,
No matter terminal hardware supports one or multiple CPU, and the database performance testing result of the embodiment of the present invention is all accurately.
With reference to Fig. 2, it is shown that the flow chart of the detection method of a kind of database performance,
Specifically may include that
Step 201, from internal memory, read data, according to the data that read, database table is performed many wheels and repeatedly insert
Operation, takes turns the result write disk that repeatedly update is corresponding by described more, and record described more take turns repeatedly update
Time；Wherein, during in for database table, many data record performs to take turns repeatedly update more, make successively
Repeatedly update is often taken turns with affairs are therein；
Step 202, from internal memory, read data, perform repeatedly to inquire about behaviour to database table according to the data that read
Make, by result write disk corresponding for described repeatedly inquiry operation, and repeatedly inquire about the time of operation described in having recorded；
Step 203, from internal memory, read data, perform repeatedly to update behaviour to database table according to the data that read
Make, repeatedly update, by described, the result write disk that operation is corresponding, and repeatedly update the time of operation described in having recorded；Its
In, described take turns repeatedly update, described repeatedly inquiry operation and described repeatedly update operation for data acknowledgment number mesh
Identical；
It should be noted that owing to, in actual environment, inserting, updating, select to operate the number of targeted data record
Relatively, therefore in order to closer to actual environment, described here take turns repeatedly update, described repeatedly inquiry operation and
Described repeatedly update operation for data acknowledgment number mesh identical.Be appreciated that described take turns repeatedly update, described repeatedly
Inquiry operation and described repeatedly update operate for data acknowledgment number mesh identical be intended only as example, it practice, three institute pin
To data acknowledgment number mesh meet the condition that difference is little.
Step 204, by described take turns repeatedly the time of update, the described time repeatedly inquiring about operation and described repeatedly
The summation of the time of renewal operation, as the time of cost, often takes turns repeatedly update, described repeatedly inquiry operation and institute by described
State repeatedly update operation for data acknowledgment number mesh as record strip number, utilize the weighting of database performance score=record strip number *
Corresponding relation described by coefficient/cost time, is calculated database performance score, detects as corresponding database performance
Result.
It should be noted that in order to reduce database performance testing result influence, the embodiment of the present invention further
Existing data in data base can be cleaned out before every time detection, and, at every kind or often clean out number before wheel multi-pass operation
According to data existing in storehouse, therefore in one preferred embodiment of the invention, before performing step 202, described method is all right
Including:
Step S401, empty current database；
Step S402, by database table many data record perform take turns repeatedly update, to currently more
Inserting some test data in data base, described test data are as the preparation data inquiring about operation in step 202；
Then step 202 is specifically as follows, and inquires about all data records in current database and all reads out, and note
Record the time of whole inquiry operation.
In like manner, therefore in one preferred embodiment of the invention, before performing step 203, described method can also include:
Step S501, empty current database；
Step S502, by database table many data record perform take turns repeatedly update, to currently more
Inserting some test data in data base, described test data are as the preparation data inquiring about operation in step 202；
Then step 203 is specifically as follows, and is updated field in all data records in current database, and record
Complete the described time updating operation.
It should be noted that above-mentioned preferred invention embodiment can apply to the various operation such as Windows, Android
In system.
Now in Android operation system, database table is performed multi-pass operation, and record described multi-pass operation
The process of time be described in detail.
Due in most Android operation system generally using SQLite as database storage engines, so
The performance of SQLite data base can also have an impact for systematic entirety to a certain extent, therefore at this respectively with SQLite data
As a example by storehouse is taken turns repeatedly update, the execution repeatedly inquiring about operation, repeatedly renewal operation each several part and timing more, to SQLite
The performance detection of data base illustrates, and wherein each several part is respectively with code and corresponding explanatory notes:
1, take turns repeatedly execution and the timing of update more；
2, execution and the timing of operation are repeatedly inquired about；
The execution of the most inquiry operations and timing；
In a kind of application example of the present invention, the value of MAX_ROUND and MAX_RECORDS is respectively 5 and 2000, permissible
Understanding, those skilled in the art according to actual demand, can use MAX_ROUND and MAX_RECORDS of various numerical value, this
The bright numerical value to concrete MAX_ROUND and MAX_RECORDS is not any limitation as.
With reference to Fig. 3, it is shown that the testing result display packing of a kind of database performance
Flow chart, specifically may include that
Step 301, from internal memory, read data, according to the data that read, database table is performed multi-pass operation, will
The result write disk that described multi-pass operation is corresponding, and recorded the time of described multi-pass operation；Wherein, described multi-pass operation
Operate including repeatedly update, repeatedly inquiry and repeatedly update operation；The execution process of described repeatedly update includes: make
Perform for repeatedly update described in database table by least one affairs；
The time completing described multi-pass operation that step 302, foundation are recorded, obtain corresponding database performance detection knot
Really；
The request of the database performance detection triggers in step 303, foundation user interface, represents described data base's property
Can testing result.
In a kind of application example of the present invention, can be according to the triggering of the database performance testing result in user interface
Request, represents the UI(user interface in present terminal, User Interface by described database performance testing result) on,
Check for user；The described database performance testing result represented described in user's foundation can know the data base of present terminal
Performance, such as, whether the described database performance testing result of present terminal can buy the factor of present terminal as user
One of, or, the described database performance testing result of multiple terminals can be as one of comparison factor of multiple terminal capabilities.
In a word, the present invention can pass through demonstrating data storehouse performance test results, fair, really to display to the user that one comparison of feedback
Data base's evaluation result.
It should be noted that the request of the database performance detection triggers in user interface can pass through mouse, key
The user operation such as dish, touch gestures produces, and this user operation specifically can have triggering merit for the button etc. in user interface
The interface element of energy obtains.
With reference to Fig. 4, it is shown that the exhibiting method of a kind of database performance testing result
Schematic diagram, wherein, user can send, by " starting scoring " button on interface, the request that database performance detection triggers, that
The present invention implements can be according to the detection of the database performance involved by this request execution step 301-302, simultaneously at interface
The detection progress of upper video data storehouse performance, wherein 87% example detecting progress exactly.After sending this request, interface
On " start scoring " button become " stopping scoring " button, it will be understood that user can be by clicking on " stopping scoring " button
Stop the detection of current database performance.It addition, after detection progress reaches 100%, the present invention can show automatically accordingly
Database performance testing result, or, the present invention can be according to the database performance detection triggers in user interface
Request, represents corresponding database performance testing result, and as after detection progress reaches 100%, " stopping scoring " on interface presses
Button becomes " checking scoring " button, it will be understood that user can carry out trigger data storehouse performance by clicking on " checking scoring " button
Representing of testing result.
It is appreciated that described database performance testing result can individually represent, it is also possible to float with CPU integer performance, CPU
Other performance test results of the terminals such as some performance represents together, and concrete ways of presentation is not any limitation as by the present invention.
With reference to Fig. 5, it is shown that the exhibiting method of a kind of database performance testing result
Schematic diagram, it is by data base IO(input and output, Input/output on certain mobile terminal) testing result of performance is with score
Form represents, and also have the CPU integer performance of this mobile terminal, CPU floating-point performance, 2D drawing performance, the 3D that represent draw simultaneously
The score of the performances such as performance, SD card writing speed, SD card reading speed, and total score (the obtaining of overall performance of mobile terminal
Point).
In some embodiments of the invention, detection client can be by the database performance testing result of present terminal
Offer detection server, and, the database performance testing result of multiple terminal sample can also be handed down to by detection server
Detection client, is presented to user by detection client, to facilitate user to know the database performance detection of current mobile terminal
Result ranking in multiple terminal sample etc..
Be appreciated that those skilled in the art can use various ways of presentation by described database performance testing result in
Various positions, the embodiment of the present invention represents position and concrete ways of presentation the most in addition to described database performance testing result
Limit.
The structure chart of the detection device of a kind of database performance is shown with reference to Fig. 6,
Specifically may include that
Operation executing module 601, is suitable to read data from internal memory, performs database table according to the data read
Multi-pass operation, and by result write disk corresponding for described multi-pass operation；Wherein, described multi-pass operation specifically can include repeatedly
Update, repeatedly inquiry operate and repeatedly update operation；Described operation executing module specifically may include that and is adapted in use at least
One affairs perform the update implementation sub-module 611 for repeatedly update described in database table；
Time logging modle 602, is suitable to record the time of described multi-pass operation；And
Result acquisition module 603, is suitable to, according to the time completing described multi-pass operation recorded, obtain corresponding data
Storehouse performance test results.
In one preferred embodiment of the invention, described repeatedly update specifically can include taking turns repeatedly inserting behaviour more
Making, update of often taking turns repeatedly therein is the update performed for many data record；
The most described update implementation sub-module 611, can be particularly adapted to use affairs for database table successively
In lattice, the execution of many data record is described takes turns repeatedly the often wheel repeatedly update in update more.
In another preferred embodiment of the invention, described update implementation sub-module 611, specifically may include that
Start unit, be suitable to start affairs；
Process unit, is suitable to perform update for many data record in database table；And
End unit, is suitable to end transaction.
In one preferred embodiment of the invention, described result acquisition module 503, can be particularly adapted to according to completing institute
State the time that multi-pass operation is spent, according to described by database performance score=record strip number * weight coefficient/cost time
Corresponding relation, is calculated database performance score, as corresponding database performance testing result:
Wherein, described weight coefficient is to obtain according to the weight coefficient data matching of the terminal sample obtained of sampling.
In another preferred embodiment of the invention, described device can also include: is suitable to according to multiple terminal model
Corresponding database performance measurement time series analysis statistics obtains the analytic statistics module of described weight coefficient；
Described analytic statistics module specifically may include that
Preferable score obtains submodule, is suitable to the performance scores according to preset whole operating system and database manipulation accounts for
The usage frequency of whole operating system, obtains the preferable score of database performance；
Collect submodule, be suitable to collect the terminal sample meeting preset customer volume condition；
Test submodule, is suitable to perform repeatedly to test behaviour to database table in the operating system of collection terminal sample
Make, and call timer record complete described in time that repeatedly test operation is spent, as the data that each terminal models is corresponding
The storehouse performance test time；
Matched sub-block, is suitable to utilize that database performance score=record strip number * weight coefficient/spend is time taking corresponding closes
System, database performance measurement time corresponding according to the preferable score of described database performance, described each terminal sample and described
The repeatedly bar number of the data record that test operation is targeted, coupling obtains the weight coefficient that each terminal models is corresponding；And
Process of fitting treatment submodule, is suitable to be fitted the weight coefficient corresponding from described each terminal sample processing, obtains
Final weight coefficient.
With reference to Fig. 7, it is shown that the testing result display device of a kind of database performance
Structure chart, specifically may include that
Operation executing module 701, is suitable to read data from internal memory, performs database table according to the data read
Multi-pass operation, and by result write disk corresponding for described multi-pass operation；Wherein, described multi-pass operation specifically can include repeatedly
Update, repeatedly inquiry operate and repeatedly update operation；Described operation executing module specifically may include that and is adapted in use at least
One affairs perform the update implementation sub-module 711 for repeatedly update described in database table；
Time logging modle 702, is suitable to record the time of described multi-pass operation；
Result acquisition module 703, is suitable to, according to the time completing described multi-pass operation recorded, obtain corresponding data
Storehouse performance test results；And
Result presentation module 704, the request of the database performance detection triggers on according to user interface, represent
Described database performance testing result.
In implementing, operation executing module 701, time logging modle 702 and result acquisition module 703 may be located at
Various computer systems or server end, these three modules have coordinated the detection of database performance；Result presentation module 704 can
To be positioned in various display, it is used for representing described database performance testing result；Wherein, described computer system or display
May be located on the mobile terminals such as smart mobile phone, panel computer, notebook computer, PDA, it is also possible to be positioned at desktop computer etc. and consolidate
Determine on terminal.
Algorithm and display are not intrinsic to any certain computer, virtual system or miscellaneous equipment relevant provided herein.
Various general-purpose systems can also be used together with based on teaching in this.As described above, construct required by this kind of system
Structure be apparent from.Additionally, the present invention is also not for any certain programmed language.It is understood that, it is possible to use various
Programming language realizes the content of invention described herein, and the description done language-specific above is to disclose this
Bright preferred forms.
In description mentioned herein, illustrate a large amount of detail.It is to be appreciated, however, that the enforcement of the present invention
Example can be put into practice in the case of not having these details.In some instances, it is not shown specifically known method, structure
And technology, in order to do not obscure the understanding of this description.
Similarly, it will be appreciated that one or more in order to simplify that the disclosure helping understands in each inventive aspect, exist
Above in the description of the exemplary embodiment of the present invention, each feature of the present invention is grouped together into single enforcement sometimes
In example, figure or descriptions thereof.But, the method for the disclosure should not be construed to reflect an intention that i.e. required guarantor
The application claims feature more more than the feature being expressly recited in each claim protected.More precisely, as following
Claims reflected as, inventive aspect is all features less than single embodiment disclosed above.Therefore,
The claims following detailed description of the invention are thus expressly incorporated in this detailed description of the invention, the most each claim itself
All as the independent embodiment of the present invention.
Those skilled in the art are appreciated that and can carry out the module in the equipment in embodiment adaptively
Change and they are arranged in one or more equipment different from this embodiment.Can be the module in embodiment or list
Unit or assembly are combined into a module or unit or assembly, and can put them in addition multiple submodule or subelement or
Sub-component.In addition at least some in such feature and/or process or unit excludes each other, can use any
Combine all features disclosed in this specification (including adjoint claim, summary and accompanying drawing) and so disclosed appoint
Where method or all processes of equipment or unit are combined.Unless expressly stated otherwise, this specification (includes adjoint power
Profit requires, summary and accompanying drawing) disclosed in each feature can be carried out generation by providing identical, equivalent or the alternative features of similar purpose
Replace.
Although additionally, it will be appreciated by those of skill in the art that embodiments more described herein include other embodiments
Some feature included by rather than further feature, but the combination of the feature of different embodiment means to be in the present invention's
Within the scope of and form different embodiments.Such as, in the following claims, embodiment required for protection appoint
One of meaning can mode use in any combination.
The all parts embodiment of the present invention can realize with hardware, or to run on one or more processor
Software module realize, or with combinations thereof realize.It will be understood by those of skill in the art that and can use in practice
Microprocessor or digital signal processor (DSP) realize the some or all portions in equipment according to embodiments of the present invention
The some or all functions of part.The present invention is also implemented as the part for performing method as described herein or complete
The equipment in portion or device program (such as, computer program and computer program).Such program realizing the present invention
Can store on a computer-readable medium, or can be to have the form of one or more signal.Such signal is permissible
Download from internet website and obtain, or provide on carrier signal, or provide with any other form.
The present invention will be described rather than limits the invention to it should be noted above-described embodiment, and ability
Field technique personnel can design alternative embodiment without departing from the scope of the appended claims.In the claims,
Any reference marks that should not will be located between bracket is configured to limitations on claims.Word " comprises " and does not excludes the presence of not
Arrange element in the claims or step.Word "a" or "an" before being positioned at element does not excludes the presence of multiple such
Element.The present invention and can come real by means of including the hardware of some different elements by means of properly programmed computer
Existing.If in the unit claim listing equipment for drying, several in these devices can be by same hardware branch
Specifically embody.Word first, second and third use do not indicate that any order.These word explanations can be run after fame
Claim.
Claims (8)
1. a testing result display packing for database performance, described data base includes: data base on mobile terminal, described side
Method includes:
From internal memory, read data, database table is performed multi-pass operation, by described multi-pass operation according to the data read
Corresponding result write disk, and recorded the time of described multi-pass operation；Wherein, described multi-pass operation includes repeatedly inserting
Operation, repeatedly inquiry operate and repeatedly update operation；The execution process of described repeatedly update includes: use affairs to hold
The hand-manipulating of needle takes turns repeatedly update to the one of database table；
According to the time completing described multi-pass operation recorded, obtain corresponding database performance testing result；
According to the request of the database performance detection triggers in user interface, represent described database performance testing result；
Wherein, what described foundation was recorded completes the time of described multi-pass operation, obtains corresponding database performance testing result
Step, including:
According to completing the time that described multi-pass operation is spent, according to database performance score=record strip number * weight coefficient/flower
Time-consuming described corresponding relation, is calculated database performance score, as corresponding database performance testing result:
Wherein, described record strip number is the bar number of the targeted data record of described multi-pass operation, and described weight coefficient is foundation
The weight coefficient data matching of the terminal sample that sampling obtains obtains.
2. the method for claim 1, it is characterised in that described repeatedly update includes taking turns repeatedly update more,
Update of often taking turns repeatedly therein is the update performed for many data record；
One affairs of the most described use perform to take turns repeatedly the step of update for the one of database table specifically, make successively
Perform the described often wheel taken turns repeatedly in update by affairs for many data record in database table repeatedly to insert more
Enter operation.
3. method as claimed in claim 1 or 2, it is characterised in that one affairs of described use perform for database table
The step of described repeatedly update, including:
Affairs start；
Update is performed for many data record in database table；
Affairs terminate.
4. the method for claim 1, it is characterised in that the weight coefficient number of the described terminal sample obtained according to sampling
The step of described weight coefficient is obtained according to matching, including:
Account for the usage frequency of whole operating system according to the performance scores of preset whole operating system and database manipulation, obtain
The preferable score of database performance；
Collect the terminal sample meeting preset customer volume condition；
Database table is performed repeatedly test operation by the operating system of collection terminal sample, and calls timer record
The time that described in completing, repeatedly test operation is spent, as the database performance measurement time that each terminal sample is corresponding；
Utilize the corresponding relation that described database performance score=record strip number * weight coefficient/cost time describes, according to described
Database performance measurement time that the preferable score of database performance, described each terminal sample are corresponding and described repeatedly test operation
The bar number of targeted data record, coupling obtains the weight coefficient that each terminal sample is corresponding；
It is fitted the weight coefficient corresponding from described each terminal sample processing, obtains final weight coefficient.
5. a testing result display device for database performance, described data base includes: data base on mobile terminal, described dress
Put and include:
Operation executing module, is suitable to read data from internal memory, performs repeatedly to grasp to database table according to the data read
Make, and by result write disk corresponding for described multi-pass operation；Wherein, described multi-pass operation includes repeatedly update, repeatedly
Inquiry operates and repeatedly updates operation；Described operation executing module includes: be adapted in use to affairs to perform for database table
The one of lattice takes turns repeatedly the update implementation sub-module of update；
Time logging modle, is suitable to record the time of described multi-pass operation；
Result acquisition module, is suitable to, according to the time completing described multi-pass operation recorded, obtain corresponding database performance
Testing result；And
Result presentation module, the request of the database performance detection triggers on according to user interface, represent described number
According to storehouse performance test results；
Wherein, described result acquisition module, it is particularly adapted to according to completing the time that described multi-pass operation is spent, according to data base
Corresponding relation described by performance scores=record strip number * weight coefficient/cost time, is calculated database performance score,
As corresponding database performance testing result:
Wherein, described weight coefficient is to obtain according to the weight coefficient data matching of the terminal sample obtained of sampling.
6. device as claimed in claim 5, it is characterised in that described repeatedly update includes taking turns repeatedly update more,
Update of often taking turns repeatedly therein is the update performed for many data record；
The most described update implementation sub-module, is particularly adapted to use affairs for data many in database table successively
Record execution is described takes turns repeatedly the often wheel repeatedly update in update more.
7. device as claimed in claim 5, it is characterised in that described update implementation sub-module, including:
Start unit, be suitable to start affairs；
Process unit, is suitable to perform update for many data record in database table；And
End unit, is suitable to end transaction.
8. device as claimed in claim 5, it is characterised in that also include: be suitable to the data corresponding according to multiple terminal model
Storehouse performance test time series analysis statistics obtains the analytic statistics module of described weight coefficient；
Described analytic statistics module includes:
Preferable score obtains submodule, is suitable to the performance scores according to preset whole operating system and database manipulation accounts for whole
The usage frequency of operating system, obtains the preferable score of database performance；
Collect submodule, be suitable to collect the terminal sample meeting preset customer volume condition；
Test submodule, is suitable to perform database table in the operating system of collection terminal sample repeatedly test operation,
And call timer record complete described in time that repeatedly test operation is spent, as data base's property that each terminal models is corresponding
Can the testing time；
Matched sub-block, is suitable to utilize database performance score=record strip number * weight coefficient/spend time taking corresponding relation,
The database performance measurement time corresponding according to the preferable score of described database performance, described each terminal sample and described repeatedly
The bar number of the data record that test operation is targeted, coupling obtains the weight coefficient that each terminal models is corresponding；And
Process of fitting treatment submodule, is suitable to be fitted the weight coefficient corresponding from described each terminal sample processing, obtains final
Weight coefficient.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210472970.2A CN103020132B (en) | 2012-11-20 | 2012-11-20 | The testing result display packing of database performance and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210472970.2A CN103020132B (en) | 2012-11-20 | 2012-11-20 | The testing result display packing of database performance and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103020132A CN103020132A (en) | 2013-04-03 |
| CN103020132B true CN103020132B (en) | 2016-12-21 |
Family
ID=47968736
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201210472970.2A Active CN103020132B (en) | 2012-11-20 | 2012-11-20 | The testing result display packing of database performance and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103020132B (en) |
Families Citing this family (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106407830B (en) * | 2015-07-29 | 2020-01-21 | 阿里巴巴集团控股有限公司 | Cloud-based database detection method and device |
| CN105404581B (en) * | 2015-12-25 | 2019-03-05 | 北京奇虎科技有限公司 | A kind of evaluating method and device of database |
| CN106528388A (en) * | 2016-10-21 | 2017-03-22 | 网易（杭州）网络有限公司 | Database detection method and apparatus |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7403954B2 (en) * | 2005-09-30 | 2008-07-22 | Sap Ag | Systems and methods for repeatable database performance testing |
-
2012
- 2012-11-20 CN CN201210472970.2A patent/CN103020132B/en active Active
Also Published As
| Publication number | Publication date |
|---|---|
| CN103020132A (en) | 2013-04-03 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Alipourfard et al. | {CherryPick}: Adaptively unearthing the best cloud configurations for big data analytics | |
| US10061687B2 (en) | Self-learning and self-validating declarative testing | |
| US8818787B2 (en) | Method and system for predicting performance of software applications on prospective hardware architecture | |
| KR101491878B1 (en) | System and method for providing ranking information of mobile application using information obtained from user terminal | |
| CN102722434B (en) | Performance test method and tool aiming at Linux process scheduling | |
| CN102999604B (en) | The detection method and device of a kind of database performance | |
| CN104462554B (en) | Question and answer page relevant issues recommended method and device | |
| US20200004657A1 (en) | Optimization of power and computational density of a data center | |
| CN105247493A (en) | Identifying impacted tests from statically collected data | |
| CN104025048B (en) | Method and system for estimating installation time of software product in operating environment | |
| Stewart et al. | A Dollar from 15 Cents:{Cross-Platform} Management for Internet Services | |
| CN106095867A (en) | A kind of book recommendation method based on industry analysis and device | |
| CN104778032A (en) | Method and equipment used for carrying out continuous integration | |
| CN103020132B (en) | The testing result display packing of database performance and device | |
| CN107092678B (en) | Method, device and equipment for acquiring application activity degree | |
| CN109461023A (en) | It is lost user and retrieves method and device, electronic equipment, storage medium | |
| Dick et al. | Measurement and Rating of Software-induced Energy Consumption of Desktop PCs and Servers. | |
| EP3317781A1 (en) | Search engine optimization by selective indexing | |
| CN103268282A (en) | Central processing unit (CPU) design method and system based on remote computer hardware experimental system | |
| US9111022B2 (en) | Simulation techniques for predicting in-memory database systems performance | |
| Bin et al. | Using monitors to predict co-running safety-critical hard real-time benchmark behavior | |
| CN103577290A (en) | Test script playback rhythm control method and system | |
| CN110298581A (en) | Determine the method and device of risk indicator value | |
| CN106034150A (en) | Application program dynamic pushing method, device and system | |
| CN109858632A (en) | A kind of method and device of threshold value |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20220801 Address after: Room 801, 8th floor, No. 104, floors 1-19, building 2, yard 6, Jiuxianqiao Road, Chaoyang District, Beijing 100015 Patentee after: BEIJING QIHOO TECHNOLOGY Co.,Ltd. Address before: 100088 room 112, block D, 28 new street, new street, Xicheng District, Beijing (Desheng Park) Patentee before: BEIJING QIHOO TECHNOLOGY Co.,Ltd. Patentee before: Qizhi software (Beijing) Co.,Ltd. |
|
| TR01 | Transfer of patent right |