CN106886557A - Patrol and examine assessment models adaptive approach and system - Google Patents
Patrol and examine assessment models adaptive approach and system Download PDFInfo
- Publication number
- CN106886557A CN106886557A CN201611234797.7A CN201611234797A CN106886557A CN 106886557 A CN106886557 A CN 106886557A CN 201611234797 A CN201611234797 A CN 201611234797A CN 106886557 A CN106886557 A CN 106886557A
- Authority
- CN
- China
- Prior art keywords
- formula
- index
- assessment
- storehouse
- patrolled
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- 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
- G06F16/242—Query formulation
- G06F16/2433—Query languages
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0639—Performance analysis of employees; Performance analysis of enterprise or organisation operations
- G06Q10/06393—Score-carding, benchmarking or key performance indicator [KPI] analysis
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Development Economics (AREA)
- Strategic Management (AREA)
- Entrepreneurship & Innovation (AREA)
- Economics (AREA)
- Educational Administration (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Computational Linguistics (AREA)
- Game Theory and Decision Science (AREA)
- Mathematical Physics (AREA)
- Marketing (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
This application discloses assessment models adaptive approach and system is patrolled and examined, wherein methods described includes：Index storehouse is set up, the index storehouse is patrolled and examined operational indicator comprising two or more；Patrol and examine assessment formula according to one and choose corresponding index from the index storehouse, and according to selected index it is described patrol and examine assessment formula in position and selected index start shipment the condition that can be regarded as and splice and form a SQL SQL statement into the assessment formula；By SQL statement storage in formula storehouse, each SQL statement correspondence one patrols and examines assessment formula；And assessment models will be patrolled and examined and be associated with one or more formula in the formula storehouse and map and store corresponding mapping relations.The present invention can realize patrolling and examining the self adaptation of assessment models, workload and numerous and diverse degree that reduction is developed again.
Description
Technical field
The application is related to the process field of electric numerical data, more particularly to patrols and examines assessment models adaptive approach and system.
Background technology
In existing cruising inspection system, it is related to the index quantified for needs to be calculated.If for the formula for calculating
There are change or new increase formula, it is necessary to developer shows up investigation and analysis demand, and need according to the existing number of system itself
Developed again according to structure.It is big, numerous and diverse that the workload being related to is developed again.
Alternately, some existing cruising inspection systems devise formula configuration interface, are voluntarily configured by user.But because of user's skill
Art ability is uneven, and configuration work difficulty is big, causes inefficient.If the formula of configuration is unreasonable, data are easily caused not
Accurately, arithmetic logic is chaotic, even results in system crash, influences the production of enterprise.
The content of the invention
In order to overcome the deficiencies in the prior art, the technical problem to be solved in the present invention to be to provide one kind and patrol and examine assessment
Model self-adapting method and system, its self adaptation that can realize patrolling and examining assessment models, the workload developed again of reduction and numerous and diverse
Degree, realization is patrolled and examined the assessment of work and ensures that calculating data are accurate.
In order to solve the above technical problems, the present invention patrols and examines assessment models adaptive approach, including：
Index storehouse is set up, the index storehouse is patrolled and examined operational indicator comprising two or more；
Assessment formula is patrolled and examined according to one and choose corresponding index from the index storehouse, and commented in described patrolling and examining according to selected index
Estimate the position in formula and selected index is started shipment the condition that can be regarded as and spliced into assessment formula one structuralized query of formation
Language SQL statement；
By SQL statement storage in formula storehouse, each SQL statement correspondence one patrols and examines assessment formula；And
Assessment models will be patrolled and examined and be associated with one or more formula in the formula storehouse and map and store corresponding
Mapping relations.
Used as the improvement of the method for the invention, methods described also includes：Extracted each other from operational indicator tables of data is patrolled and examined
Each different patrols and examines operational indicator.
Improved as the another kind of the method for the invention, methods described also includes：Increase new patrolling to the index storehouse
Inspection operational indicator.
Used as another improvement of the method for the invention, methods described also includes：Change in the formula storehouse
Or multiple formula.
Used as another improvement of the method for the invention, methods described also includes：Change one or more described mappings
Relation.
In order to solve the above technical problems, the present invention patrols and examines assessment models Adaptable System, including：
Module is set up, for setting up index storehouse, the index storehouse is patrolled and examined operational indicator comprising two or more；
Module is formed, corresponding index is chosen from the index storehouse for patrolling and examining assessment formula according to one, and according to selected finger
It is marked on the position patrolled and examined in assessment formula and selected index is started shipment the condition that can be regarded as and spliced and formed into the assessment formula
One SQL SQL statement；
Memory module, in formula storehouse, each SQL statement correspondence one to patrol and examine assessment by SQL statement storage
Formula；And
Mapping block, mapping is associated for will patrol and examine assessment models with one or more formula in the formula storehouse
And store corresponding mapping relations.
Used as the improvement of system of the present invention, the system also includes：Abstraction module, for from patrolling and examining operational indicator number
Different each each other is extracted according to table patrol and examine operational indicator.
Improved as the another kind of system of the present invention, the system also includes：Increase module, for the index
Storehouse increases new patrols and examines operational indicator.
Used as another improvement of system of the present invention, the system also includes：Formula modified module, for changing
State one or more formula in formula storehouse.
Used as another improvement of system of the present invention, the system also includes：Mapping modified module, for changing one
Individual or multiple mapping relations.
In order to solve the above technical problems, tangible computer computer-readable recording medium of the invention, including for performing of the invention patrolling
Examine the computer program code of assessment models adaptive approach.
In order to solve the above technical problems, the present invention provides a kind of device, including at least one processor；And at least one deposit
Reservoir, containing computer program code, at least one memory and the computer program code are configured to, with institute
At least one processor is stated so that described device performs at least part of step for patrolling and examining assessment models adaptive approach of the invention.
According to the present invention, separate type is combined between index, assessment formula and assessment models, realizes the quick of assessment models
Convenient configuration and self adaptation.For example, if necessary to modification assessment formula, need to only be modified to it, its change nature can reflect
To the assessment models for mapping therewith.Similarly, since assessment models discrete type is stored, if simply assessment models need change, and
The index and assessment formula for using are unchanged, need to only change the mapping relations between assessment models and assessment formula.So as to,
The workload and numerous and diverse degree developed again are greatly reduced, and realizes the self adaptation of assessment models.Furthermore, it is possible to independently of patrolling
The assessment formula for configuring is tested outside check system, it is ensured that the system of operation is not influenceed by wrong formula, from without influence
The production of enterprise, and ensure that the formula to be used is rationally accurate with calculating data.
After the detailed description of embodiment of the present invention is read in conjunction with the figure, other features of the invention and advantage will become more
Plus it is clear.
Brief description of the drawings
Fig. 1 is the flow chart of the embodiment according to the inventive method.
Fig. 2 is the structural representation of the embodiment according to present system.
For clarity, these accompanying drawings are figure that is schematic and simplifying, and they are only gived for understanding institute of the present invention
Necessary details, and omit other details.
Specific embodiment
Embodiments of the present invention and embodiment are described in detail with reference to the accompanying drawings.
By detailed description given below, the scope of application of the invention will be evident that.It will be appreciated, however, that detailed
While thin description and specific example show the preferred embodiment of the present invention, they are given only for illustration purpose.
For the ease of following description, the implication of some terms at this to occurring in this specification is illustrated.
Index, refers to all typings, the most basic original data row of collection in cruising inspection system, is participation in assessment formula
The least factor of calculating.
Assessment formula, is finally to draw the quantized data that user needs according to certain calculation by index and weighted value
The formula of value.For example, in cruising inspection system normalized checking, each single item Index for examination all sets a score value (for example：Wear work board+1
Point), multiple indexs are carried out being calculated final assessment result according to assessment formula.
Index storehouse, be for storing the index that all business in cruising inspection system may be used, comprising index name and/or this
Source of a little indexs etc..
The position of index refers to position of the index where in formula.For example for formula " rotor bank * (power/currents
Amount) ", the position of wherein index " magnitude of current " is exactly the position of denominator in bracket.
The condition of index refers to that whether index can play computing effect in certain circumstances.For example, only calculate rotor bank reaching
Result when reaching 400mA to result at 1000 revs/min or only calculating current amount.If index " rotor bank " is not up to
When 1000 revs/min or the magnitude of current are not up to 400mA, corresponding index is not started shipment can be regarded as use.
Each step of an embodiment of assessment models adaptive approach is patrolled and examined the present invention with reference to flow chart shown in Fig. 1
It is specifically described.
In step S102, operational indicator is patrolled and examined from patrolling and examining operational indicator tables of data and extracting different each other each.It is existing to patrol
In check system, including multiple operational indicator tables of data, each operational indicator tables of data can relate to one or more indexs, and business refers to
Possible indexing section is identical or entirely different between mark tables of data, is extracted from these operational indicator tables of data and not repeated each other
All indexs.
In step S104, index storehouse is set up, for all indexs extracted in storing step S102, comprising these indexs
Source is comprising the corresponding operational indicator data table name of these indexs.Alternately, can not also perform step S102, directly to
The index that all business may be used in index library storage cruising inspection system.According to the service needed of user, also can be to the index storehouse
The new index of addition, farthest to meet the extension of user and increase.
In step S106, assessment formula (comprising the weight used in formula) is patrolled and examined according to what user provided, from index storehouse
Corresponding index is chosen, and starts shipment the bar that can be regarded as in the position patrolled and examined in assessing formula and selected index according to selected index
Part splices and ultimately forms a new SQL SQL statement into the assessment formula, and the SQL statement embodies institute's commentary
Estimate formula, each SQL statement correspondence one patrols and examines assessment formula.
For example, an assessment formula is：Motor performance=(weight (1000)-rotor speed * operation durations) * 100%, wherein
Rotor speed and operation duration are index.The assessment formula is spliced into SQL statement and is, for example,：
Select (1000-equipment. rotating speed * equipment. durations) * 100from equipment
Wherein, equipment is the title of the database table of index storehouse.
In step S108, the SQL statement that will be formed is stored in formula storehouse, in case assessment models are used.Embody assessment public
The SQL of formula is stored behind formula storehouse, and whether developer can test the assessment formula can be just independently of being called outside cruising inspection system
Often operation.Such as it is not normally functioning, the assessment formula can be adjusted, does not interfere with the operation of cruising inspection system.If energy
Normal operation, can be not high according to the accuracy of the advance comparison data of operation result, such as accuracy, and also the assessment formula can be carried out
Adjustment, accuracy during ensuring formally to use.
In step S110, one or more formula that will be patrolled and examined in assessment models and formula storehouse are associated and map and store
Corresponding mapping relations.Each patrol and examine assessment models can formulate in requisition for formula, select formulation from formula storehouse
Formula is used.Relation between model and formula is stored in relation table, model is entered with the formula in formula storehouse
Row relationship maps.
Due to index, assessment formula and assessment models it is discrete from one another store, if assessment formula change, its change
Because the mapping relations between assessment formula and assessment models can reflect corresponding assessment models naturally.If mapping relations are sent out
Changing, does not interfere with assessment formula in itself yet, it is achieved thereby that the rapid and convenient configuration of assessment models and self adaptation, significantly
The workload and numerous and diverse degree developed again are reduced, the production efficiency of enterprise is improve.
According to a kind of implementation method of the inventive method, except combining shown in Fig. 1 and in addition to described each step, methods described
Also include according to actual needs：Increase to the index storehouse and new patrol and examine operational indicator；And/or in the modification formula storehouse one
Individual or multiple formula；And/or change one or more described mapping relations.
Fig. 2 shows the schematic diagram of the embodiment for patrolling and examining assessment models Adaptable System of the invention, the system
Including：Module 202 is set up, for setting up index storehouse, the index storehouse is patrolled and examined operational indicator comprising two or more；Form module
204, corresponding index is chosen from the index storehouse for patrolling and examining assessment formula according to one, and commented in described patrolling and examining according to selected index
Estimate the position in formula and selected index is started shipment the condition that can be regarded as and spliced into assessment formula one structuralized query of formation
Language SQL statement；Memory module 206, in formula storehouse, each SQL statement correspondence one to be patrolled by SQL statement storage
Inspection assessment formula；And mapping block 208, carried out with one or more formula in the formula storehouse for assessment models will to be patrolled and examined
Relationship maps simultaneously store corresponding mapping relations.
A kind of implementation method of system according to the invention, except combine Fig. 2 shown in and described each module in addition to, the system
Can also on demand include one of the following or multiple modules：Abstraction module, for different each other from the extraction of operational indicator tables of data is patrolled and examined
Each patrol and examine operational indicator；Increase module, new operational indicator is patrolled and examined for increasing to the index storehouse；Formula changes mould
Block, for changing one or more formula in the formula storehouse；And mapping modified module, for changing described in one or more
Mapping relations.
As long as appropriate, the inventive method and system can also be applied to other systems outside cruising inspection system.
Multiple difference embodiments described herein or its special characteristic, structure or characteristic can be at one of the invention or many
It is appropriately combined in individual implementation method.In addition, in some cases, if suitably, in flow chart and/or stream treatment description step
Rapid order can be changed, and accurately must not necessarily be performed in the described sequence.In addition, multiple different aspects of the invention can be used
Software, hardware, firmware or its other computer-implemented modules or device for combining and/or performing the function carry out reality
Apply.Software implementation of the invention may include to be stored in computer-readable medium and by holding that one or more processors are performed
Line code.Computer-readable medium may include computer hard disc driver, ROM, RAM, flash memory, pocket computer storage medium such as
CD-ROM, DVD-ROM, flash disc drives and/or such as other devices with USB (USB) interface, and/or appoint
What its appropriate tangible or non-of short duration computer-readable medium or executable code can be preserved thereon and by computing device
Computer storage.The present invention can be used with reference to any appropriate operating system.
Unless explicitly stated otherwise, singulative as used herein " ", " being somebody's turn to do " include plural reference (i.e. with " at least one "
The meaning).It will be further understood that terminology used herein " having ", " including " and/or "comprising" show to exist it is described
Feature, step, operation, element and/or part, but do not preclude the presence or addition of one or more other features, step, behaviour
Work, element, part and/or its combination.Term "and/or" as used in this includes one or more relevant items enumerated
Any and all combination.
Some currently preferred embodiments of the present invention is foregoing described, it should be emphasized, however, that the present invention is not limited to these
Embodiment, and can be the other manner realization in the range of present subject matter.Those skilled in the art can be in the technology of the present invention
The inspiration of design and do not depart from various changes and modifications are made to the present invention on the basis of present invention, these deformations or change
Still fall within protection scope of the present invention.
Claims (10)
1. one kind patrols and examines assessment models adaptive approach, it is characterised in that methods described includes：
Index storehouse is set up, the index storehouse is patrolled and examined operational indicator comprising two or more；
Assessment formula is patrolled and examined according to one and choose corresponding index from the index storehouse, and assessment public affairs are patrolled and examined described according to selected index
Position and selected index in formula are started shipment the condition that can be regarded as and are spliced into assessment formula one SQL of formation
SQL statement；
By SQL statement storage in formula storehouse, each SQL statement correspondence one patrols and examines assessment formula；And
Assessment models will be patrolled and examined and be associated with one or more formula in the formula storehouse and map and store corresponding mapping
Relation.
2. method according to claim 1, it is characterised in that methods described also includes：
Operational indicator is patrolled and examined from patrolling and examining operational indicator tables of data and extracting different each each other.
3. method according to claim 1, it is characterised in that methods described also includes：
Increase to the index storehouse and new patrol and examine operational indicator.
4. method according to claim 1, it is characterised in that methods described also includes：
Change one or more formula in the formula storehouse.
5. according to any described methods of claim 1-4, it is characterised in that methods described also includes：
Change one or more described mapping relations.
6. one kind patrols and examines assessment models Adaptable System, it is characterised in that the system includes：
Module is set up, for setting up index storehouse, the index storehouse is patrolled and examined operational indicator comprising two or more；
Module is formed, corresponding index is chosen from the index storehouse for patrolling and examining assessment formula according to one, and exist according to selected index
The position patrolled and examined in assessment formula and selected index are started shipment the condition that can be regarded as and are spliced into assessment formula formation one
SQL SQL statement；
Memory module, in formula storehouse, each SQL statement correspondence one to patrol and examine assessment formula by SQL statement storage；
And
Mapping block, maps and deposits for will patrol and examine one or more formula in assessment models and the formula storehouse and be associated
Store up corresponding mapping relations.
7. system according to claim 6, it is characterised in that the system also includes：
Abstraction module, for patrolling and examining operational indicator from patrolling and examining operational indicator tables of data and extract different each each other.
8. system according to claim 6, it is characterised in that the system also includes：
Increase module, new operational indicator is patrolled and examined for increasing to the index storehouse.
9. system according to claim 6, it is characterised in that the system also includes：
Formula modified module, for changing one or more formula in the formula storehouse.
10. according to any described systems of claim 6-9, it is characterised in that the system also includes：
Mapping modified module, for changing one or more described mapping relations.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201611234797.7A CN106886557A (en) | 2016-12-28 | 2016-12-28 | Patrol and examine assessment models adaptive approach and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201611234797.7A CN106886557A (en) | 2016-12-28 | 2016-12-28 | Patrol and examine assessment models adaptive approach and system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106886557A true CN106886557A (en) | 2017-06-23 |
Family
ID=59176798
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201611234797.7A Pending CN106886557A (en) | 2016-12-28 | 2016-12-28 | Patrol and examine assessment models adaptive approach and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106886557A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110019385A (en) * | 2017-09-04 | 2019-07-16 | 北京国双科技有限公司 | The querying method and device of parameter |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101582138A (en) * | 2009-06-23 | 2009-11-18 | 用友软件股份有限公司 | Dynamic business processing system and method |
| CN103886189A (en) * | 2014-03-07 | 2014-06-25 | 国家电网公司 | Patrolling result data processing system and method used for unmanned aerial vehicle patrolling |
| CN103927607A (en) * | 2013-01-15 | 2014-07-16 | 杭州新世纪电子科技有限公司 | Data processing method and device |
-
2016
- 2016-12-28 CN CN201611234797.7A patent/CN106886557A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101582138A (en) * | 2009-06-23 | 2009-11-18 | 用友软件股份有限公司 | Dynamic business processing system and method |
| CN103927607A (en) * | 2013-01-15 | 2014-07-16 | 杭州新世纪电子科技有限公司 | Data processing method and device |
| CN103886189A (en) * | 2014-03-07 | 2014-06-25 | 国家电网公司 | Patrolling result data processing system and method used for unmanned aerial vehicle patrolling |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110019385A (en) * | 2017-09-04 | 2019-07-16 | 北京国双科技有限公司 | The querying method and device of parameter |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107844417B (en) | Test case generation method and device | |
| CN103902702B (en) | A kind of data-storage system and storage method | |
| Bozzelli et al. | A systematic literature review on green software metrics | |
| US8577884B2 (en) | Automated analysis and summarization of comments in survey response data | |
| CN103902701B (en) | A kind of data-storage system and storage method | |
| CN103186639B (en) | Data creation method and system | |
| US10747955B2 (en) | Learning device and learning method | |
| JP2014533407A5 (en) | ||
| WO2020082673A1 (en) | Invoice inspection method and apparatus, computing device and storage medium | |
| CN111754110A (en) | Method, device, equipment and medium for evaluating operation index based on artificial intelligence | |
| CN115146865A (en) | Task optimization method based on artificial intelligence and related equipment | |
| CN110032650A (en) | A kind of generation method, device and the electronic equipment of training sample data | |
| CN104636401B (en) | A kind of method and device of SCADA system data rewind | |
| CN102567669A (en) | Automatic testing and evaluation method for database security in classified protection testing and evaluation and system thereof | |
| CN110516034A (en) | Blog management method, device, the network equipment and readable storage medium storing program for executing | |
| AU2017279795A1 (en) | Metadata-driven program code generation for clinical data analysis | |
| CN202736027U (en) | Automatic evaluation system for operation system security in classified protection evaluation | |
| CN102591773A (en) | Automatic evaluation method for operation system security in classified protection evaluation and system thereof | |
| CN104778179A (en) | Data migration test method and system | |
| CN106294128B (en) | A kind of automated testing method and device exporting report data | |
| CN111914010A (en) | Service processing method, device, equipment and storage medium | |
| Wang et al. | Lily results for OAEI 2015. | |
| CN112732567A (en) | Mock data testing method and device based on ip, electronic equipment and storage medium | |
| CN103984634A (en) | Memory unsteady state pressure test method of LINUX server | |
| CN116485220A (en) | Staff performance assessment method and device, electronic equipment and storage 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 | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20170623 |