CN102289373A - Method for dynamically configuring index evaluation system - Google Patents
Method for dynamically configuring index evaluation system Download PDFInfo
- Publication number
- CN102289373A CN102289373A CN201110213363XA CN201110213363A CN102289373A CN 102289373 A CN102289373 A CN 102289373A CN 201110213363X A CN201110213363X A CN 201110213363XA CN 201110213363 A CN201110213363 A CN 201110213363A CN 102289373 A CN102289373 A CN 102289373A
- Authority
- CN
- China
- Prior art keywords
- index
- data
- new set
- evaluation system
- image data
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Images
Abstract
The invention provides a method for dynamically configuring an index evaluation system. The method is characterized in that: a basic information table, a common library, a background application program unit and a scheduling program unit are provided. The method comprises the following steps of: 10, configuring an acquisition unit; 20, configuring an index unit, and self-defining an index calculation formula; 30, starting an acquisition program, acquiring acquisition data and storing the acquisition data in an acquisition table; 40, starting an index calculation program, realizing index calculation and storing index data in an index table; and 50, sending the index data to a customer. The method has the advantages that: the index evaluation system realizes the flexible configuration and calculation of an index, can define other indexes which are components of the index, supports self-definition of the calculation formula and the like, and solves the inflexibility of an index relation. The index evaluation system can be used by a user mastering skills; and as long as some pieces of basic data are set, the complete configuration of the user is realized by dragging and selection, and the index evaluation system can be used after definition without participation of a developer, so that the development cost of the system is saved.
Description
[technical field]
The present invention relates to a kind of realization index evaluation system dynamic configuration method.
[background technology]
Index is the key element that quality professional or service is measured, and it is relevant with business, subservice, service or sub-services, and the crucial index of quality is general need to be obtained after the combination calculation processing by Key Performance Indicator is carried out.Assess QoS by the crucial index of quality.Index system refers to the organism that several indexs that connect each other are formed.Be used for the Key Performance Indicator of evaluation quality, the crucial index of quality becomes increasingly complex, and be to estimate the quality of service, often relates to hundreds and thousands of even more index and result of calculation thereof.
At specific application scenarios customized development, the construction cycle is long mostly for existing index system, and need suitable understanding all be arranged to technology and business, can't adapt to complicated, the fast-changing market environment of competition now.Concrete manifestation is as follows: 1, the ineffective activity of index relation, the correlation rule of this class index must with the specific transactions scene relating, after business change or upgrading, the relation between index need add or remodify again.2, the limitation of index calculating, this class index is calculated and is excessively depended on fixed index incidence relation, if application scenarios changes or the index formula changes, then computation process needs the technician to develop again.3, the limitation of New Set definition, index definition need concern that customized development index computation process can't satisfy fast-changing market environment again according to index.Therefore, when business scenario or demand change, just must entrust the original system developer to develop again, test, reach the standard grade, whole flow process is more loaded down with trivial details, the cycle is long, and has increased the development cost of this system, has caused the inconvenience in the use.
[summary of the invention]
The technical problem to be solved in the present invention is to provide a kind of realization index evaluation system dynamic configuration method, has solved the ineffective activity of index configuration, the limitation of index calculating and the limitation of New Set definition.
The present invention is achieved in that a kind of realization index evaluation system dynamic configuration method, and described method provides Basic Information Table, public library, background application unit, scheduler program unit;
Described public library provides the method or the function of function for described index evaluation system, and described function comprises: sign of operation, arithmetic, character string are handled, data gather, the date handles;
Described Basic Information Table is preserved information such as Information Monitoring, index parameter, is the predefined sets of data storehouse of index appraisement system table, and the content in the described information table is for the background application cell call;
Information Monitoring in the described background application cell call Basic Information Table and index parameter generate corresponding acquisition tables, capture program and index table, index calculation procedure respectively, and finish capture program, the registration of index calculation procedure in scheduler program;
Capture program scheduling, the scheduling of index calculation procedure are realized in described scheduler program unit, and coordinate the execution sequence between said procedure;
Described method concrete steps are as follows:
Step 10, set up a configurable collecting unit in described index evaluation system, the user disposes this collecting unit, and the index evaluation system is kept at the Information Monitoring of configuration in the Basic Information Table after finishing; At least one group of Information Monitoring of index evaluation system configurations; Described Information Monitoring comprises: gather table name, acquisition parameter, collection period, pre-service time delay, key word; Described one group of Information Monitoring comprises at least one acquisition parameter;
Step 20, set up a configurable index unit in described index evaluation system, the user disposes the index unit, and the index evaluation system is kept at index parameter in the Basic Information Table after finishing; Described index parameter comprises: index table name, self-defined computing formula, key word, indicator-specific statistics cycle; The computing formula of described index is that image data is carried out generating achievement data after the computing, and its operation rule calls from described public library; Described image data is to obtain data according to acquisition parameter from external system; The described indicator-specific statistics cycle is greater than collection period;
Step 30, described background application unit extract respectively organizes Information Monitoring in the described Basic Information Table, generates the acquisition tables and a corresponding capture program of a corresponding sky respectively, and described each capture program is registered in described scheduler program unit; Described each collection table name of opening in this group Information Monitoring corresponding with it of the title of acquisition tables is consistent, and the key word in this group Information Monitoring corresponding with it of the key word of described each acquisition tables is consistent;
Described scheduler program unit starts each capture program simultaneously, obtain image data from external system after, each capture program is kept at image data in the acquisition tables of corresponding described sky with it, after finishing, notice scheduler program unit;
Step 40, described background application unit extract the index parameter in the Basic Information Table, generate the index table and a corresponding index calculation procedure of a corresponding sky, and described index calculation procedure is registered in described scheduler program unit; Index table name in the title of the described index table index parameter corresponding with it is consistent, and the key word in the key word of the described index table index parameter corresponding with it is consistent;
The operation rule that described index calculation procedure calls in the described public library is converted to query statement with the index computing formula, described query statement is specially: with the acquisition tables table name of the image data correspondence that relates in the computing formula as the table name among the FROM clause, described computing formula is as the field of SQL statement, and its each acquisition tables key word is as the Correlation Criteria between corresponding acquisition tables;
After the notice that capture program sends is received in described scheduler program unit, start the index calculation procedure, the index calculation procedure judges whether the image data that relates in the corresponding index computing formula is complete, if it is complete, the index calculation procedure is created the temporary table of each corresponding acquisition tables, and from each acquisition tables, the image data of this indicator-specific statistics in the cycle extracted in the corresponding temporary table according to the indicator-specific statistics cycle, and the acquisition tables table name in the query statement of index computing formula is replaced with the table name of corresponding temporary table, carry out inquiry, after confirming successful inquiring, the achievement data that inquiry is generated is saved in the corresponding index table of index calculation procedure; Achievement data in the described index table can also call when the index unit generates the New Set data by disposing once more for follow-up index evaluation system;
Step 50, index evaluation system are submitted to the user with the data in the described index table.
Further, described index evaluation system comprises that also the user disposes the index flow process once more, and the achievement data that calls image data and generated generates New Set, and this user disposes index flow process concrete steps once more and draws together:
Step 60, user generate the New Set parameter by disposing described index unit once more, the index evaluation system is kept at the New Set parameter in the Basic Information Table, and described New Set parameter comprises: New Set table name, self-defined new computing formula, new key, New Set measurement period; Described self-defined new computing formula is image data and the achievement data that generated to be carried out computing generate the New Set data;
Step 70, described background application unit extract the New Set parameter in the Basic Information Table, generate the New Set table of a New Set calculation procedure and a sky; The query statement of described new computing formula is specially: with the acquisition tables table name of image data that relates in the new computing formula and the achievement data correspondence that has generated and index table table name as the table name among the FROM clause, described new computing formula is as the field of SQL statement, and the key word of its acquisition tables key word and index table is as the Correlation Criteria between acquisition tables and index table;
After described New Set calculation procedure starts, the New Set calculation procedure judges whether the image data that relates in the new computing formula and the achievement data that has generated be complete, if it is complete, the New Set calculation procedure is created the corresponding acquisition tables and the temporary table of index table respectively, and from the acquisition tables that relates to and index table, image data in this New Set measurement period and achievement data are extracted in the corresponding respectively temporary table according to the New Set measurement period, and the table name of acquisition tables table name in the query statement of new computing formula and index table replaces with the table name of corresponding temporary table, carry out inquiry, after confirming successful inquiring, the New Set data that inquiry is generated are saved in the corresponding New Set table of New Set calculation procedure; When can also disposing the index unit once more for follow-up index evaluation system, described New Set data call;
Step 80, index evaluation system are submitted to the user with the New Set data in the described New Set table.
Further, described index evaluation system configurations index unit disposes one group of index parameter at least.
Further, the unit of scheduler program described in the step 30 starts each capture program simultaneously, after obtaining image data from external system, the process that each capture program is kept at image data in the acquisition tables of corresponding described sky with it is specially: capture program judges according to the collection period that disposes in this group Information Monitoring whether the data in this collection period are all obtained, if obtained total data, capture program is kept at image data in the acquisition tables of this group Information Monitoring correspondence; If do not obtain total data, but arrived the pre-service time delay that disposes in this group Information Monitoring, capture program also is kept at image data in the acquisition tables of this group Information Monitoring correspondence.
The present invention has following advantage: this index evaluation system has realized the flexible configuration and the calculating of index, and the definable index which other index is made of, and supports self-defined computing formula etc., has solved the ineffective activity of index relation.Based on the index computing formula of definition, system generates computation process automatically, generates another index according to original index or the index calculated, has solved the limitation that index is calculated.Based on original index, the index of having calculated, computing formula commonly used and processing logic, system provides the ability of User Defined New Set.The user only need grasp business and can use, as long as some master datas are set, by dilatory, select promptly to have realized that the user's is configurable fully, can use after the definition, do not need the developer to participate in, solved the limitation of New Set definition, saved the development cost of system.
[description of drawings]
The present invention is further illustrated in conjunction with the embodiments with reference to the accompanying drawings.
Fig. 1 is the structural representation of embodiment one.
Fig. 2 is the structural representation of embodiment two.
[embodiment]
See also Fig. 1 to shown in Figure 2, embodiments of the invention are described in detail.
A kind of realization index evaluation system dynamic configuration method, described method provides Basic Information Table, public library, background application unit, scheduler program unit;
Described public library provides the method or the function of function for described index evaluation system, and described function comprises: sign of operation, arithmetic, character string are handled, data gather, the date handles;
Described Basic Information Table is preserved information such as Information Monitoring, index parameter, is the predefined sets of data storehouse of index appraisement system table, and the content in the described information table is for the background application cell call;
Information Monitoring in the described background application cell call Basic Information Table and index parameter generate corresponding acquisition tables, capture program and index table, index calculation procedure respectively, and finish capture program, the registration of index calculation procedure in scheduler program;
Capture program scheduling, the scheduling of index calculation procedure are realized in described scheduler program unit, and coordinate the execution sequence between said procedure;
Described method concrete steps are as follows:
Step 10, set up a configurable collecting unit in described index evaluation system, the user disposes this collecting unit, and the index evaluation system is kept at the Information Monitoring of configuration in the Basic Information Table after finishing; At least one group of Information Monitoring of index evaluation system configurations; Described Information Monitoring comprises: gather table name, acquisition parameter, collection period, pre-service time delay, key word; Described one group of Information Monitoring comprises at least one acquisition parameter;
Step 20, set up a configurable index unit in described index evaluation system, the user disposes the index unit, and the index evaluation system is kept at index parameter in the Basic Information Table after finishing; Described index parameter comprises: index table name, self-defined computing formula, key word, indicator-specific statistics cycle; The computing formula of described index is that image data is carried out generating achievement data after the computing, and its operation rule calls from described public library; Described image data is to obtain data according to acquisition parameter from external system; The described indicator-specific statistics cycle is greater than collection period;
Step 30, described background application unit extract respectively organizes Information Monitoring in the described Basic Information Table, generates the acquisition tables and a corresponding capture program of a corresponding sky respectively, and described each capture program is registered in described scheduler program unit; Described each collection table name of opening in this group Information Monitoring corresponding with it of the title of acquisition tables is consistent, and the key word in this group Information Monitoring corresponding with it of the key word of described each acquisition tables is consistent;
Described scheduler program unit starts each capture program simultaneously, obtain image data from external system after, each capture program is kept at image data in the acquisition tables of corresponding described sky with it, after finishing, notice scheduler program unit;
Step 40, described background application unit extract the index parameter in the Basic Information Table, generate the index table and a corresponding index calculation procedure of a corresponding sky, and described index calculation procedure is registered in described scheduler program unit; Index table name in the title of the described index table index parameter corresponding with it is consistent, and the key word in the key word of the described index table index parameter corresponding with it is consistent;
The operation rule that described index calculation procedure calls in the described public library is converted to query statement with the index computing formula, described query statement is specially: with the acquisition tables table name of the image data correspondence that relates in the computing formula as the table name among the FROM clause, described computing formula is as the field of SQL statement, and its each acquisition tables key word is as the Correlation Criteria between corresponding acquisition tables;
After the notice that capture program sends is received in described scheduler program unit, start the index calculation procedure, the index calculation procedure judges whether the image data that relates in the corresponding index computing formula is complete, if it is complete, the index calculation procedure is created the temporary table of each corresponding acquisition tables, and from each acquisition tables, the image data of this indicator-specific statistics in the cycle extracted in the corresponding temporary table according to the indicator-specific statistics cycle, and the acquisition tables table name in the query statement of index computing formula is replaced with the table name of corresponding temporary table, carry out inquiry, after confirming successful inquiring, the achievement data that inquiry is generated is saved in the corresponding index table of index calculation procedure; Achievement data in the described index table can also call when the index unit generates the New Set data by disposing once more for follow-up index evaluation system;
Step 50, index evaluation system are submitted to the user with the data in the described index table.
Further, described index evaluation system comprises that also the user disposes the index flow process once more, and the achievement data that calls image data and generated generates New Set, and this user disposes index flow process concrete steps once more and comprises:
Step 60, user generate the New Set parameter by disposing described index unit once more, the index evaluation system is kept at the New Set parameter in the Basic Information Table, and described New Set parameter comprises: New Set table name, self-defined new computing formula, new key, New Set measurement period; Described self-defined new computing formula is image data and the achievement data that generated to be carried out computing generate the New Set data;
Step 70, described background application unit extract the New Set parameter in the Basic Information Table, generate the New Set table of a New Set calculation procedure and a sky; The query statement of described new computing formula is specially: with the acquisition tables table name of image data that relates in the new computing formula and the achievement data correspondence that has generated and index table table name as the table name among the FROM clause, described new computing formula is as the field of SQL statement, and the key word of its acquisition tables key word and index table is as the Correlation Criteria between acquisition tables and index table;
After described New Set calculation procedure starts, the New Set calculation procedure judges whether the image data that relates in the new computing formula and the achievement data that has generated be complete, if it is complete, the New Set calculation procedure is created the corresponding acquisition tables and the temporary table of index table respectively, and from the acquisition tables that relates to and index table, image data in this New Set measurement period and achievement data are extracted in the corresponding respectively temporary table according to the New Set measurement period, and the table name of acquisition tables table name in the query statement of new computing formula and index table replaces with the table name of corresponding temporary table, carry out inquiry, after confirming successful inquiring, the New Set data that inquiry is generated are saved in the corresponding New Set table of New Set calculation procedure; When can also disposing the index unit once more for follow-up index evaluation system, described New Set data call;
Step 80, index evaluation system are submitted to the user with the New Set data in the described New Set table.
Below in conjunction with specific embodiment whole operation process of the present invention is elaborated:
Embodiment one:
See also Fig. 1: at first, the collecting unit configuration Information Monitoring in described index evaluation system, the user disposes two groups of Information Monitorings:
First group of Information Monitoring is:
Gather table name: MSC performance collection table (mobile switching centre's performance collection table);
Acquisition parameter: calling service channel assignment request number of times, called service channel assignment request number of times, page response number of times, paging request number of times;
Collection period: 15 minutes;
Pre-service time delay: 1800 seconds;
Key word: local network sign;
Second group of Information Monitoring is:
Gather table name: BSC performance collection table (base station controller acquisition tables);
Acquisition parameter: calling service channel allocation number of success, calling service channel assignment request number of times;
Collection period: 30 minutes;
Pre-service time delay: 2700 seconds;
Key word: local network sign;
The index evaluation system is kept at the Information Monitoring of configuration in the Basic Information Table after finishing.
Secondly, the index unit in described index evaluation system, the user disposes two groups of index parameters:
First group of index parameter is:
The index table name: exchange load and resource are used table;
First computing formula: caller ratio=EXPRPKG.DIV (SUM (calling service channel assignment request number of times), SUM ((calling service channel assignment request number of times+called service channel assignment request number)), 0) * 100; Described " caller ratio " is first achievement data;
Key word: local network sign;
The indicator-specific statistics cycle: 60 minutes;
Second group of index parameter is:
Index table name: wireless performance tables of data;
Second computing formula: calling service channel allocation success ratio=EXPRPKG.DIV (SUM (calling service channel allocation number of success), SUM (calling service channel assignment request number of times), 0) * 100; Described " calling service channel allocation success ratio " is second achievement data;
Key word: local network sign;
The indicator-specific statistics cycle: 60 minutes;
The index evaluation system is kept at index parameter in the Basic Information Table after finishing; Data Source in described first computing formula and described second computing formula is an image data, and described image data is to obtain data according to acquisition parameter from external system; Wherein, EXPRPKG is the expression formula bag, and promptly operation rule calls from described public library.
Once more, described background application unit extracts first group of Information Monitoring in the described Basic Information Table, generate first acquisition tables " MSC performance collection table " and first capture program of a sky, the key word of described first acquisition tables " MSC performance collection table " is " a local network sign "; Described background application unit extracts second group of Information Monitoring in the described Basic Information Table, generate second acquisition tables " BSC performance collection table " and second capture program of a sky, the key word of described second acquisition tables " BSC performance collection table " is " a local network sign "; Described first capture program and second capture program are registered in described scheduler program unit.
Described scheduler program unit starts first capture program and second capture program simultaneously, obtain image data from external system, first capture program judges whether the data in the collection period that is provided with in first group of Information Monitoring are all obtained, if all obtain, image data is kept in first acquisition tables " MSC performance collection table ", if do not obtain total data, judge whether to reach the collection pre-service time delay " 1800 seconds " that is provided with in first group of Information Monitoring, if reach, capture program also is kept at image data first acquisition tables " MSC performance collection table "; Second capture program is kept at image data in second acquisition tables " BSC performance collection table " after judging according to the method identical with first capture program, after finishing, and notice scheduler program unit.Preserve " calling service channel assignment request number of times " data, " called service channel assignment request number of times " data, " page response number of times " data, " paging request number of times " data in described first acquisition tables " MSC performance collection table ".Preserve " calling service channel allocation number of success " data, " calling service channel assignment request number of times " data in described second acquisition tables " BSC performance collection table ".
Then, described background application unit extracts first group of index parameter in the Basic Information Table, generate the first index table " exchange load and resource are used table " and the first index calculation procedure of a corresponding sky, the key word of described " exchange load and resource are used table " is " a local network sign "; Described background application unit extracts second group of index parameter in the described Basic Information Table, generate the second index table " wireless performance tables of data " and the second index calculation procedure of a sky, the key word of the described second index table " wireless performance tables of data " is " a local network sign "; The described first index calculation procedure and the second index calculation procedure are registered in described scheduler program unit.
The query statement of described first computing formula is: SELECT EXPRPKG.DIV (SUM (calling service channel assignment request number of times), SUM ((calling service channel assignment request number of times+called service channel assignment request number of times)), 0) * 100 FROM MSC performance collection tables; Owing to only relate to an acquisition tables in first computing formula, therefore do not need key word with acquisition tables as Correlation Criteria.
The query statement of described second computing formula is: SELECT EXPRPKG.DIV (SUM (calling service channel allocation number of success), SUM (calling service channel assignment request number of times), 0) * 100 FROM BSC performance collection tables.
The notice that capture program sends is received in described scheduler program unit, starts the first index calculation procedure and the second index calculation procedure simultaneously.The first index calculation procedure judges whether the image data that first computing formula relates to is complete, if it is complete, the first index calculation procedure is created " MSC performance collection table temporary table ", according to 60 minutes indicator-specific statistics cycles that is provided with in first index parameter, " MSC performance collection table temporary table " arrived in data extract in this measurement period in " MSC performance collection table " and " BSC performance collection table ", and the query statement of first computing formula is revised as: SELECT EXPRPKG.DIV (SUM (calling service channel assignment request number of times), SUM ((calling service channel assignment request number of times+called service channel assignment request number of times)), 0) * 100 FROM MSC performance collection table temporary tables;
The second index calculation procedure judges whether the image data that second computing formula relates to is complete, if it is complete, the second index calculation procedure is created " BSC performance collection table temporary table ", according to 60 minutes indicator-specific statistics cycles that is provided with in first index parameter, data extract in this measurement period in " BSC performance collection table " is arrived in corresponding " BSC performance collection table temporary table ", and the query statement of second computing formula is revised as: SELECT EXPRPKG.DIV (SUM (calling service channel allocation number of success), SUM (calling service channel assignment request number of times), 0) * 100 FROM BSC performance collection table temporary tables;
Carry out inquiry, after confirming successful inquiring, first achievement data " caller ratio " that inquiry is generated is saved in the first index table " exchange load and resource are used table "; Second achievement data " calling service channel allocation success ratio " that inquiry is generated is saved in the second index table " wireless performance tables of data ".
At last, described index evaluation system is submitted to the user with the data in first achievement data " caller ratio " and second achievement data " calling service channel allocation success ratio ".
Embodiment two:
See also Fig. 2, in the present embodiment, the user calls first achievement data " caller ratio " in the first index table " exchange load and resource are used table " that has generated among first acquisition tables among the embodiment one " BSC performance collection table " and the embodiment one, generate the 3rd achievement data, concrete steps are as follows:
At first, the index evaluation system disposes the index unit once more and generates the 3rd index parameter, and the index evaluation system is kept at the 3rd index parameter in the Basic Information Table;
The 3rd index parameter is:
Index table name: mobile network system performance index table;
The 3rd computing formula is: wireless system percent of call completed=(1-caller ratio/100) * SUM (page response number of times) * SUM (paging request number of times)/100); Described " caller ratio " data (generating in embodiment one) are called from the first index table " exchange load and resource are used table ", and the data of described page response number of times and paging request number of times are called from first acquisition tables " BSC performance collection table " (generating among embodiment one); Described " wireless system percent of call completed " is the 3rd achievement data;
Key word: local network sign;
The indicator-specific statistics cycle: 60 minutes;
Secondly, described background application unit generates the 3rd index table " mobile network system performance index table " of the 3rd an index calculation procedure and a sky; The query statement of described the 3rd computing formula is: SELECT (1-caller ratio/100) * SUM (page response number of times) * SUM (paging request number of times) FROM exchange load and resource are used table, BSC performance collection table WHERE exchange load and resource are used table. local network sign=BSC performance collection table. and the local network sign, wherein the WHERE statement associates " the BSC performance collection table " and " exchange load and resource are used table " that relates in the 3rd computing formula by key word " local network sign ".
After described the 3rd index calculation procedure starts, the 3rd index calculation procedure judges whether the image data and the achievement data that relate in the 3rd computing formula be complete, if it is complete, the 3rd index calculation procedure is created corresponding " BSC performance collection table temporary table " and " exchange load and resource are used the table temporary table ", according to the indicator-specific statistics cycle that is provided with in the 3rd index parameter be 60 minutes, image data in this measurement period and achievement data are extracted in the corresponding respectively temporary table, and replacing with in the query statement of the 3rd computing formula: SELECT (1-caller ratio/100) * SUM (page response number of times) * SUM (paging request number of times) FROM exchange load and resource are used the table temporary table, and BSC performance collection table temporary table WHERE exchange load and resource are used the table temporary table. local network sign=BSC performance collection table temporary table. and the local network sign.Carry out inquiry, after confirming successful inquiring, the 3rd achievement data " wireless system percent of call completed " that inquiry is generated is saved in " mobile network system performance index table "; Described the 3rd achievement data " wireless system percent of call completed " calls in the time of can also disposing the index unit once more for follow-up index evaluation system;
At last, the index evaluation system is submitted to the user with the 3rd achievement data " wireless system percent of call completed " in described " mobile network system performance index table ".
The above, only for preferred embodiment of the present invention, so can not limit scope of the invention process according to this, i.e. the equivalence of doing according to claim of the present invention and description changes and modification, all should still belong in the scope that the present invention contains.
Claims (4)
1. realize index evaluation system dynamic configuration method for one kind, it is characterized in that: described method provides Basic Information Table, public library, background application unit, scheduler program unit;
Described Basic Information Table is preserved information such as Information Monitoring, index parameter, is the predefined sets of data storehouse of index appraisement system table, and the content in the described information table is for the background application cell call;
Described public library provides the method or the function of function for described index evaluation system, and described function comprises: sign of operation, arithmetic, character string are handled, data gather, the date handles;
Information Monitoring in the described background application cell call Basic Information Table and index parameter generate corresponding acquisition tables, capture program and index table, index calculation procedure respectively, and finish capture program, the registration of index calculation procedure in scheduler program;
Capture program scheduling, the scheduling of index calculation procedure are realized in described scheduler program unit, and coordinate the execution sequence between said procedure;
Described method concrete steps are as follows:
Step 10, set up a configurable collecting unit in described index evaluation system, the user disposes this collecting unit, and the index evaluation system is kept at the Information Monitoring of configuration in the Basic Information Table after finishing; At least one group of Information Monitoring of index evaluation system configurations; Described Information Monitoring comprises: gather table name, acquisition parameter, collection period, pre-service time delay, key word; Described one group of Information Monitoring comprises at least one acquisition parameter;
Step 20, set up a configurable index unit in described index evaluation system, the user disposes the index unit, and the index evaluation system is kept at index parameter in the Basic Information Table after finishing; Described index parameter comprises: index table name, self-defined computing formula, key word, indicator-specific statistics cycle; The computing formula of described index is that image data is carried out generating achievement data after the computing, and its operation rule calls from described public library; Described image data is to obtain data according to acquisition parameter from external system; The described indicator-specific statistics cycle is greater than collection period;
Step 30, described background application unit extract respectively organizes Information Monitoring in the described Basic Information Table, generates the acquisition tables and a corresponding capture program of a corresponding sky respectively, and described each capture program is registered in described scheduler program unit; Described each collection table name of opening in this group Information Monitoring corresponding with it of the title of acquisition tables is consistent, and the key word in this group Information Monitoring corresponding with it of the key word of described each acquisition tables is consistent;
Described scheduler program unit starts each capture program simultaneously, obtain image data from external system after, each capture program is kept at image data in the acquisition tables of corresponding described sky with it, after finishing, notice scheduler program unit;
Step 40, described background application unit extract the index parameter in the Basic Information Table, generate the index table and a corresponding index calculation procedure of a corresponding sky, and described index calculation procedure is registered in described scheduler program; Index table name in the title of the described index table index parameter corresponding with it is consistent, and the key word in the key word of the described index table index parameter corresponding with it is consistent;
The operation rule that described index calculation procedure calls in the described public library is converted to query statement with the index computing formula, described query statement is specially: with the acquisition tables table name of the image data correspondence that relates in the computing formula as the table name among the FROM clause, described computing formula is as the field of SQL statement, and its each acquisition tables key word is as the Correlation Criteria between corresponding acquisition tables;
After the notice that capture program sends is received in described scheduler program unit, start the index calculation procedure, the index calculation procedure judges whether the image data that relates in the corresponding index computing formula is complete, if it is complete, the index calculation procedure is created the temporary table of each corresponding acquisition tables, and from each acquisition tables, the image data of this indicator-specific statistics in the cycle extracted in the corresponding temporary table according to the indicator-specific statistics cycle, and the acquisition tables table name in the query statement of index computing formula is replaced with the table name of corresponding temporary table, carry out inquiry, after confirming successful inquiring, the achievement data that inquiry is generated is saved in the corresponding index table of index calculation procedure; Achievement data in the described index table can also call when the index unit generates the New Set data by disposing once more for follow-up index evaluation system;
Step 50, index evaluation system are submitted to the user with the data in the described index table.
2. a kind of realization index evaluation system dynamic configuration method according to claim 1, it is characterized in that: comprise that also the user disposes the index flow process once more, the achievement data that calls image data and generated generates New Set, and this user disposes index flow process concrete steps once more and comprises:
Step 60, user generate the New Set parameter by disposing described index unit once more, the index evaluation system is kept at the New Set parameter in the Basic Information Table, and described New Set parameter comprises: New Set table name, self-defined new computing formula, new key, New Set measurement period; Described self-defined new computing formula is image data and the achievement data that generated to be carried out computing generate the New Set data;
Step 70, described background application unit extract the New Set parameter in the Basic Information Table, generate the New Set table of a New Set calculation procedure and a sky; The query statement of described new computing formula is specially: with the acquisition tables table name of image data that relates in the new computing formula and the achievement data correspondence that has generated and index table table name as the table name among the FROM clause, described new computing formula is as the field of SQL statement, and the key word of its acquisition tables key word and index table is as the Correlation Criteria between acquisition tables and index table;
After described New Set calculation procedure starts, the New Set calculation procedure judges whether the image data that relates in the new computing formula and the achievement data that has generated be complete, if it is complete, the New Set calculation procedure is created the corresponding acquisition tables and the temporary table of index table respectively, and from the acquisition tables that relates to and index table, image data in this New Set measurement period and achievement data are extracted in the corresponding respectively temporary table according to the New Set measurement period, and the table name of acquisition tables table name in the query statement of new computing formula and index table replaces with the table name of corresponding temporary table, carry out inquiry, after confirming successful inquiring, the New Set data that inquiry is generated are saved in the corresponding New Set table of New Set calculation procedure; When can also disposing the index unit once more for follow-up index evaluation system, described New Set data call;
Step 80, index evaluation system are submitted to the user with the New Set data in the described New Set table.
3. a kind of realization index evaluation system dynamic configuration method according to claim 1 and 2 is characterized in that: described index evaluation system configurations index unit, dispose one group of index parameter at least.
4. a kind of realization index evaluation system dynamic configuration method according to claim 1 and 2, it is characterized in that: the unit of scheduler program described in the step 30 starts each capture program simultaneously, after obtaining image data from external system, the process that each capture program is kept at image data in the acquisition tables of corresponding described sky with it is specially: capture program judges according to the collection period that disposes in this group Information Monitoring whether the data in this collection period are all obtained, if obtained total data, capture program is kept at image data in the acquisition tables of this group Information Monitoring correspondence; If do not obtain total data, but arrived the pre-service time delay that disposes in this group Information Monitoring, capture program also is kept at image data in the acquisition tables of this group Information Monitoring correspondence.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 201110213363 CN102289373B (en) | 2011-07-28 | 2011-07-28 | Method for dynamically configuring index evaluation system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 201110213363 CN102289373B (en) | 2011-07-28 | 2011-07-28 | Method for dynamically configuring index evaluation system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN102289373A true CN102289373A (en) | 2011-12-21 |
| CN102289373B CN102289373B (en) | 2013-08-21 |
Family
ID=45335826
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN 201110213363 Active CN102289373B (en) | 2011-07-28 | 2011-07-28 | Method for dynamically configuring index evaluation system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102289373B (en) |
Cited By (22)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102831548A (en) * | 2012-08-13 | 2012-12-19 | 中国民航大学 | Automatic assessment system of skill of control tower administrator |
| CN103020280A (en) * | 2012-12-27 | 2013-04-03 | 北京讯鸟软件有限公司 | Method for expanding SQL (Structured Query Language) query statement through multi-dimension KPI (Key Performance Index) function |
| CN103093043A (en) * | 2013-01-09 | 2013-05-08 | 中国电力科学研究院 | Design method for formula computing tools in power information system and design system thereof |
| CN103455489A (en) * | 2012-05-28 | 2013-12-18 | 阿里巴巴集团控股有限公司 | Method and system for rapidly constructing key performance indicators (KPIs) of enterprises |
| CN103995899A (en) * | 2014-06-10 | 2014-08-20 | 浪潮通用软件有限公司 | Analysis system for KPI |
| CN104184623A (en) * | 2014-09-10 | 2014-12-03 | 深圳市优网科技有限公司 | Communication index generating method and device |
| CN104391998A (en) * | 2014-12-15 | 2015-03-04 | 北京国双科技有限公司 | SSAS (SQL server analysis services) based customized index processing method and device |
| CN104536982A (en) * | 2014-12-08 | 2015-04-22 | 北京用友政务软件有限公司 | Data processing method and data processing device |
| CN104933299A (en) * | 2015-06-03 | 2015-09-23 | 浪潮软件集团有限公司 | Data processing method and device |
| CN106250390A (en) * | 2016-07-15 | 2016-12-21 | 中国银联股份有限公司 | A kind of substep automatically generates the method and device of sql like language |
| CN106293891A (en) * | 2015-06-12 | 2017-01-04 | 交通银行股份有限公司 | Multidimensional investment target measure of supervision |
| CN106686619A (en) * | 2015-11-06 | 2017-05-17 | 大唐移动通信设备有限公司 | Performance assessment method and device |
| CN107730021A (en) * | 2016-08-10 | 2018-02-23 | 中国移动通信集团湖北有限公司 | A kind of operational indicator optimization method and device |
| CN107808336A (en) * | 2017-11-02 | 2018-03-16 | 中国银行股份有限公司 | The computational methods and device of a kind of financial index |
| CN108268639A (en) * | 2018-01-18 | 2018-07-10 | 成都嗨翻屋文化传播有限公司 | A kind of index calculating method under big data environment |
| CN108734414A (en) * | 2018-06-05 | 2018-11-02 | 山东省海洋资源与环境研究院 | A kind of marine environmental monitoring data normalization storage and the system of analysis and appraisal |
| CN108805376A (en) * | 2017-05-02 | 2018-11-13 | 北京京东尚科信息技术有限公司 | A kind of statistical method, device, electronic equipment and storage medium |
| CN110795440A (en) * | 2019-09-05 | 2020-02-14 | 连连银通电子支付有限公司 | Method and device for updating index |
| CN110851766A (en) * | 2019-11-08 | 2020-02-28 | 山东浪潮通软信息科技有限公司 | Evaluation method for flexibly configuring analysis system |
| CN112862334A (en) * | 2021-02-20 | 2021-05-28 | 平安国际智慧城市科技股份有限公司 | Index system construction method and device based on syntax analysis tree and computer equipment |
| CN112950086A (en) * | 2021-04-12 | 2021-06-11 | 中国民航管理干部学院 | Dynamic construction method and system for performance assessment index system of civil aviation enterprise and public institution |
| CN113836882A (en) * | 2021-11-24 | 2021-12-24 | 深圳小库科技有限公司 | Method and device for generating economic index statistical table, computing equipment and storage medium |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101840534A (en) * | 2010-01-22 | 2010-09-22 | 同济大学 | Integrated supply chain performance index evaluation method |
| CN101931237A (en) * | 2010-09-06 | 2010-12-29 | 余杭供电局 | Method for appraising voltage reactive configuring and running status of high-voltage electric distribution network |
-
2011
- 2011-07-28 CN CN 201110213363 patent/CN102289373B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101840534A (en) * | 2010-01-22 | 2010-09-22 | 同济大学 | Integrated supply chain performance index evaluation method |
| CN101931237A (en) * | 2010-09-06 | 2010-12-29 | 余杭供电局 | Method for appraising voltage reactive configuring and running status of high-voltage electric distribution network |
Cited By (32)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103455489A (en) * | 2012-05-28 | 2013-12-18 | 阿里巴巴集团控股有限公司 | Method and system for rapidly constructing key performance indicators (KPIs) of enterprises |
| CN103455489B (en) * | 2012-05-28 | 2017-03-01 | 阿里巴巴集团控股有限公司 | A kind of method and system of rapid build enterprise critical sales index |
| CN102831548A (en) * | 2012-08-13 | 2012-12-19 | 中国民航大学 | Automatic assessment system of skill of control tower administrator |
| CN103020280A (en) * | 2012-12-27 | 2013-04-03 | 北京讯鸟软件有限公司 | Method for expanding SQL (Structured Query Language) query statement through multi-dimension KPI (Key Performance Index) function |
| CN103020280B (en) * | 2012-12-27 | 2016-03-16 | 北京讯鸟软件有限公司 | A kind of method SQL query statement expanded by various dimensions KPI function |
| CN103093043B (en) * | 2013-01-09 | 2015-08-05 | 中国电力科学研究院 | The method for designing of formulae discovery instrument and design system thereof in power information system |
| CN103093043A (en) * | 2013-01-09 | 2013-05-08 | 中国电力科学研究院 | Design method for formula computing tools in power information system and design system thereof |
| CN103995899A (en) * | 2014-06-10 | 2014-08-20 | 浪潮通用软件有限公司 | Analysis system for KPI |
| CN104184623A (en) * | 2014-09-10 | 2014-12-03 | 深圳市优网科技有限公司 | Communication index generating method and device |
| CN104536982A (en) * | 2014-12-08 | 2015-04-22 | 北京用友政务软件有限公司 | Data processing method and data processing device |
| CN104391998A (en) * | 2014-12-15 | 2015-03-04 | 北京国双科技有限公司 | SSAS (SQL server analysis services) based customized index processing method and device |
| CN104391998B (en) * | 2014-12-15 | 2018-09-18 | 北京国双科技有限公司 | Customization index processing method and processing device based on analytical database |
| CN104933299A (en) * | 2015-06-03 | 2015-09-23 | 浪潮软件集团有限公司 | Data processing method and device |
| CN106293891A (en) * | 2015-06-12 | 2017-01-04 | 交通银行股份有限公司 | Multidimensional investment target measure of supervision |
| CN106293891B (en) * | 2015-06-12 | 2020-08-04 | 交通银行股份有限公司 | Multidimensional investment index monitoring method |
| CN106686619A (en) * | 2015-11-06 | 2017-05-17 | 大唐移动通信设备有限公司 | Performance assessment method and device |
| CN106686619B (en) * | 2015-11-06 | 2020-02-07 | 大唐移动通信设备有限公司 | Performance evaluation method and equipment |
| CN106250390A (en) * | 2016-07-15 | 2016-12-21 | 中国银联股份有限公司 | A kind of substep automatically generates the method and device of sql like language |
| CN106250390B (en) * | 2016-07-15 | 2019-12-13 | 中国银联股份有限公司 | Method and device for automatically generating SQL step by step |
| CN107730021A (en) * | 2016-08-10 | 2018-02-23 | 中国移动通信集团湖北有限公司 | A kind of operational indicator optimization method and device |
| CN108805376A (en) * | 2017-05-02 | 2018-11-13 | 北京京东尚科信息技术有限公司 | A kind of statistical method, device, electronic equipment and storage medium |
| CN107808336A (en) * | 2017-11-02 | 2018-03-16 | 中国银行股份有限公司 | The computational methods and device of a kind of financial index |
| CN107808336B (en) * | 2017-11-02 | 2022-02-25 | 中国银行股份有限公司 | Financial index calculation method and device |
| CN108268639A (en) * | 2018-01-18 | 2018-07-10 | 成都嗨翻屋文化传播有限公司 | A kind of index calculating method under big data environment |
| CN108268639B (en) * | 2018-01-18 | 2022-02-11 | 成都嗨翻屋科技有限公司 | Index calculation method under big data environment |
| CN108734414A (en) * | 2018-06-05 | 2018-11-02 | 山东省海洋资源与环境研究院 | A kind of marine environmental monitoring data normalization storage and the system of analysis and appraisal |
| CN110795440A (en) * | 2019-09-05 | 2020-02-14 | 连连银通电子支付有限公司 | Method and device for updating index |
| CN110851766A (en) * | 2019-11-08 | 2020-02-28 | 山东浪潮通软信息科技有限公司 | Evaluation method for flexibly configuring analysis system |
| CN112862334A (en) * | 2021-02-20 | 2021-05-28 | 平安国际智慧城市科技股份有限公司 | Index system construction method and device based on syntax analysis tree and computer equipment |
| CN112950086A (en) * | 2021-04-12 | 2021-06-11 | 中国民航管理干部学院 | Dynamic construction method and system for performance assessment index system of civil aviation enterprise and public institution |
| CN112950086B (en) * | 2021-04-12 | 2024-03-08 | 中国民航管理干部学院 | Dynamic construction method and system of performance assessment index system of civil aviation enterprise and public institution |
| CN113836882A (en) * | 2021-11-24 | 2021-12-24 | 深圳小库科技有限公司 | Method and device for generating economic index statistical table, computing equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102289373B (en) | 2013-08-21 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102289373B (en) | Method for dynamically configuring index evaluation system | |
| CN107818133B (en) | Residential area network capacity analysis method and system based on big data | |
| CN103312851B (en) | Intelligent cellphone application interaction interface program usability testing method | |
| CN109885496B (en) | Test log management method and system | |
| CN104468259A (en) | Method for automatically testing communication service expense | |
| CN102769709B (en) | A kind of for providing the method and apparatus of service contact information to user | |
| CN102821402A (en) | Wireless network optimization testing method based on smart phone of common user | |
| CN103246606B (en) | The performance test methods of ESB platform and system | |
| CN102104885A (en) | Network element performance counting method and system | |
| CN111209060A (en) | Capability development platform processing method and device | |
| CN104883705A (en) | Problem positioning method for data service complaints and device thereof | |
| CN110659189B (en) | Application program generation method and device, cloud server and readable storage medium | |
| CN101227349B (en) | Device and method for automatically testing system change | |
| CN113037510A (en) | Charging method, charging device and computer readable storage medium | |
| CN102821403A (en) | Wireless network optimization test system based on intelligent mobile phone of ordinary user | |
| CN115858672A (en) | Power terminal management method and device, electronic equipment and storage medium | |
| CN107346323B (en) | Label recommendation method and label recommendation device | |
| CN101577839B (en) | Method and system for processing links between network elements of intelligent network platform | |
| CN109714378A (en) | The recommended method and system of application program | |
| CN104426708A (en) | Method and system for executing security detection service | |
| CN103514123B (en) | The recognition methods of a kind of USB equipment connection port and system | |
| CN102821405A (en) | Wireless network optimization testing terminal based on smart phone of common user | |
| CN111740871A (en) | Data acquisition method and device | |
| CN112714457B (en) | Coverage quality evaluation method, device, equipment and computer readable storage medium | |
| CN102821404A (en) | Radio network optimization testing device based on common user smart phone |
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 | ||
| CP01 | Change in the name or title of a patent holder | ||
| CP01 | Change in the name or title of a patent holder |
Address after: 350000 No. 22 water head road Doumen, Jinan District, Fuzhou, Fujian Patentee after: China Electric fufu Mdt InfoTech Ltd Address before: 350000 No. 22 water head road Doumen, Jinan District, Fuzhou, Fujian Patentee before: Fujian Fushitong Information Software Co.,Ltd. |