CN107491505A - A kind of common index processing method and system - Google Patents
A kind of common index processing method and system Download PDFInfo
- Publication number
- CN107491505A CN107491505A CN201710641060.5A CN201710641060A CN107491505A CN 107491505 A CN107491505 A CN 107491505A CN 201710641060 A CN201710641060 A CN 201710641060A CN 107491505 A CN107491505 A CN 107491505A
- Authority
- CN
- China
- Prior art keywords
- data
- predefined
- stored
- achievement data
- source
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/258—Data format conversion from or to a database
-
- 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/22—Indexing; Data structures therefor; Storage structures
Abstract
The embodiment of the present invention provides a kind of common index processing method and system.Methods described includes：Multiple source datas for being used to calculate predefined achievement data of each equipment manufacturer are obtained, and defines table according to pre-set level and the source data is stored in the first data Layer；Predefined achievement data is obtained according to the source data, and defines table according to the pre-set level and the predefined achievement data is stored in the second data Layer；Public achievement data is obtained according to the predefined achievement data, and defines table according to the pre-set level and the public achievement data is stored in the 3rd data Layer.Common index processing method provided in an embodiment of the present invention, the multiple source datas of each equipment manufacturer is carried out by hierarchical storage to collect conversion, finally obtain the public achievement data of same type, when reducing index collection processing development amount and updating subsequent treatment algorithm, without re-starting collection statistics to the source data of each equipment manufacturer, make follow-up maintenance simpler.
Description
Technical field
The present embodiments relate to technical field of data processing, and in particular to a kind of common index processing method and system.
Background technology
In communication network optimization and network management, it will usually each index is analyzed, and each index is from more
The source data of multiple different types of data of individual equipment manufacturer.It is therefore desirable to these source datas are converted into being available at analysis
The achievement data of reason, then multiple achievement datas of each equipment manufacturer are normalized, afterwards to normalized achievement data
Analyzed, design corresponding optimized algorithm, so as to realize communication network optimization and Network Management Function.
In the prior art, the every kind of data type of typically each equipment manufacturer develops a set of index collection processing system, from
Source data obtains normalized achievement data, and then optimized algorithm is carried out excellent from the normalized achievement data of each equipment manufacturer acquisition
Change design, but the adjustment of this each optimized algorithm of pattern be required for changing all devices producers corresponding to code, be faced with
Substantial amounts of development amount, and follow-up complex maintenance scene.
The content of the invention
For in the prior art the defects of, the embodiments of the invention provide a kind of common index processing method and system.
In a first aspect, the embodiment of the present invention provides a kind of common index processing method, including：
Multiple source datas for being used to calculate predefined achievement data of each equipment manufacturer are obtained, and are defined according to pre-set level
The source data is stored in the first data Layer by table；
Predefined achievement data is obtained according to the source data, and defines table according to the pre-set level and described will predefine
Achievement data is stored in the second data Layer；
Public achievement data is obtained according to the predefined achievement data, and table is defined by described according to the pre-set level
Public achievement data is stored in the 3rd data Layer.
Second aspect, the embodiment of the present invention provide a kind of common index processing system, including：
First acquisition module, for obtaining multiple source datas for being used to calculate predefined achievement data of each equipment manufacturer,
And define table according to pre-set level and the source data is stored in the first data Layer；
Second acquisition module, for obtaining predefined achievement data according to the source data, and defined according to pre-set level
The predefined achievement data is stored in the second data Layer by table；
3rd acquisition module, for obtaining public achievement data according to the predefined achievement data, and according to default finger
Demarcate adopted table the public achievement data is stored in the 3rd data Layer.
The third aspect, the embodiment of the present invention provide a kind of electronic equipment, including：
Memory and processor, the processor and the memory complete mutual communication by bus；It is described to deposit
Reservoir is stored with can be by the programmed instruction of the computing device, and it is as follows that the processor calls described program instruction to be able to carry out
Method：Multiple source datas for being used to calculate predefined achievement data of each equipment manufacturer are obtained, and table is defined according to pre-set level
The source data is stored in the first data Layer；Predefined achievement data is obtained according to the source data, and according to described pre-
If the predefined achievement data is stored in the second data Layer by index definition table；Obtained according to the predefined achievement data
Public achievement data, and define table according to the pre-set level and the public achievement data is stored in the 3rd data Layer.
Fourth aspect, the embodiment of the present invention provide a kind of storage medium, are stored thereon with computer program, the computer journey
Following method is realized when sequence is executed by processor：Obtain multiple source numbers for being used to calculate predefined achievement data of each equipment manufacturer
According to, and define table according to pre-set level and the source data is stored in the first data Layer；Obtained according to the source data predetermined
Adopted achievement data, and define table according to the pre-set level and the predefined achievement data is stored in the second data Layer；Root
Public achievement data is obtained according to the predefined achievement data, and table is defined by the public index number according to the pre-set level
According to being stored in the 3rd data Layer.
Common index processing method and system provided in an embodiment of the present invention, by the multiple pre- for calculating of each equipment manufacturer
The source data for defining achievement data carries out collecting conversion by hierarchical storage, finally obtains the public index number of same type
According to, subsequent treatment directly can be analyzed from the public achievement data of storage, reduce index collection processing development amount simultaneously
And during renewal subsequent treatment algorithm, without re-starting collection statistics to the source data of each equipment manufacturer, make follow-up maintenance more
Simply.
Brief description of the drawings
In order to illustrate more clearly about the embodiment of the present invention or technical scheme of the prior art, below will be to embodiment or existing
There is the required accompanying drawing used in technology description to be briefly described, it should be apparent that, drawings in the following description are this hairs
Some bright embodiments, for those of ordinary skill in the art, on the premise of not paying creative work, can be with root
Other accompanying drawings are obtained according to these accompanying drawings.
Fig. 1 is common index process flow schematic diagram provided in an embodiment of the present invention；
Fig. 2 is common index processing system structural representation provided in an embodiment of the present invention；
Fig. 3 is the structural representation of electronic equipment provided in an embodiment of the present invention.
Embodiment
To make the purpose, technical scheme and advantage of the embodiment of the present invention clearer, below in conjunction with the embodiment of the present invention
In accompanying drawing, the technical scheme in the embodiment of the present invention is clearly and completely described, it is clear that described embodiment is
Part of the embodiment of the present invention, rather than whole embodiments.Based on the embodiment in the present invention, those of ordinary skill in the art
The every other embodiment obtained under the premise of creative work is not made, belongs to the scope of protection of the invention.
Fig. 1 is common index process flow schematic diagram provided in an embodiment of the present invention, as shown in figure 1, methods described
Including：
Step S11, multiple source datas for being used to calculate predefined achievement data of each equipment manufacturer are obtained, and according to default
The source data is stored in the first data Layer by index definition table；
Specifically, when needing to carry out network management or the network optimization, it usually needs various achievement datas are analyzed,
And these achievement datas include from the initial data of multiple different types of data of each equipment manufacturer, these initial data
Various types, the source data of different-format.Therefore, first have to obtain the multiple for calculating predefined finger of each equipment manufacturer
The source data of data is marked, after obtaining these source datas, it is also necessary to they are stored, unified conversion process is then carried out, obtains
The various achievement datas that can be analyzed, in embodiments of the present invention, source data is stored in the first data Layer first, is
It is easy to subsequent treatment, is pre-designed pre-set level and defines table, table storage source data is defined according to the pre-set level, with index table
The multiple source datas got is stored in the first data Layer by form.
It is used to calculate the source data of telephone traffic, flowed for calculating 4G online for example, obtains the multiple of each mobile phone producer offer
Source data of amount etc., as obtain Huawei mobile phone telephone traffic source data, in emerging mobile phone telephone traffic source data, millet mobile phone telephone traffic source
Data etc., these telephone traffic source datas include the data such as air time, caller place, called place, that is to say, that in this step
Middle acquisition is source data as air time, caller place, called place etc., then according to index definition table by above-mentioned institute
Active data is uniformly stored in the first data Layer, such as these source numbers can be stored in the persistent layer in the first data Layer
According to the general quantity of these source datas is very big, contains the initial data that each equipment manufacturer is used to calculate various indexs, it is mainly made
With being to provide data source for subsequent treatment.
Step S12, predefined achievement data is obtained according to the source data, and table is defined by institute according to the pre-set level
Predefined achievement data is stated to be stored in the second data Layer；
Specifically, the predefined achievement data of each equipment manufacturer is obtained according to the source data stored in the first data Layer, such as
Huawei's mobile phone traffic data, 4G surfing flow data, in the predefined finger such as emerging mobile phone traffic data, 4G surfing flow data
Data are marked, these predefined indexs are most of corresponding with public index, and public index namely finally needs the index analyzed,
Then these are predefined into achievement data and defines table according to above-mentioned pre-set level and be stored in the second data Layer, for example, these are pre-
Define the persistent layer that achievement data is stored in the second data Layer.
For example, the source data for being used to calculate telephone traffic of each equipment manufacturer in the first data Layer can be obtained, China is such as obtained
For source datas such as the air time in mobile phone telephone traffic source data, caller place, called places, Huawei's mobile phone is then calculated
Traffic data；The source datas such as air time, caller place, called place in acquisition in emerging mobile phone telephone traffic source data, so
The traffic data of emerging mobile phone in calculating afterwards；Air time, caller place in acquisition millet mobile phone telephone traffic source data, quilt
Be the source datas such as place, the traffic data of emerging mobile phone in then calculating, then by the traffic data of Huawei's mobile phone, in it is emerging
The traffic data of mobile phone and the traffic data of millet mobile phone define table storage into the second data Layer according to pre-set level.
Step S13, public achievement data is obtained according to the predefined achievement data, and defined according to the pre-set level
The public achievement data is stored in the 3rd data Layer by table.
Specifically, public achievement data is obtained according to the predefined achievement data stored in the second data Layer, in public finger
Mark in data, the public achievement data type of each equipment manufacturer is identical, and implication is identical.Such as according to Huawei's mobile phone traffic data,
In the predefined achievement data such as emerging mobile phone traffic data, millet mobile phone traffic data obtain traffic data, according to Huawei
Mobile phone 4G surfing flows data, on the predefined 4G such as emerging mobile phone 4G surfing flows data, millet mobile phone 4G surfing flow data
The predefined achievement data such as net data on flows obtains 4G surfing flow data, then by traffic data, 4G surfing flow data
Table is defined etc. public achievement data according to pre-set level to be stored in the 3rd data Layer.In actual applications, public achievement data
It can also be to predefining the data after achievement data is normalized, such as Huawei's mobile phone traffic data after normalizing, return
The public achievement datas such as the millet mobile phone traffic data in after one change after emerging mobile phone traffic data, normalization, it is so each
The data format of equipment manufacturer is completely the same and is stored together, and can carry out the analysis of striding equipment producer and the whole network analysis.
Above-mentioned source data, predefined achievement data and public achievement data belong to achievement data, represent a certain of achievement data respectively
Layer form.Such as it is the telephone traffic number of the armamentarium producer after normalization in public achievement data corresponding to traffic figureofmerit
According to the traffic data of each equipment manufacturer in corresponding predefined achievement data, corresponding each equipment manufacturer is used to calculate telephone traffic
The source data of data.
For example, the source data for parameter of each equipment manufacturer works as needs after the conversion storage of three layer data layers
When counting the telephone traffic of certain time, then traffic data is found in the public achievement data stored from the 3rd data Layer,
Then the telephone traffic of certain time is counted.If desired some regional 4G surfing flow data is counted, then directly from the 3rd data
4G surfing flow data are found in the public achievement data stored in layer, then count some regional 4G surfing flow number
According to.
Common index processing method provided in an embodiment of the present invention, multiple by each equipment manufacturer are used to calculate predefined finger
The source data of mark data carries out collecting conversion by hierarchical storage, the public achievement data of same type is finally obtained, after making
Continuous processing can be analyzed directly from the public achievement data of storage, after reducing index collection processing development amount and updating
During continuous Processing Algorithm, without re-starting collection statistics to the source data of each equipment manufacturer, make follow-up maintenance simpler.
It is further, described to obtain the multiple predefined for calculating of each equipment manufacturer on the basis of above-described embodiment
The source data of achievement data, and define table according to pre-set level and the source data is stored in the first data Layer, including：
Gather the original document of each equipment manufacturer；
The original document is parsed, obtains multiple source datas for parameter of each equipment manufacturer and each source
First calculation formula corresponding to data；
The source data and its corresponding first calculation formula are defined into table according to pre-set level and are stored in the first data Layer
In.
Specifically, the original document of each equipment manufacturer is obtained from the equipment side interface of each equipment manufacturer, then using adaptation
Device pattern parses the original document of each equipment manufacturer, obtains multiple source datas for parameter of each equipment manufacturer, with
And the first calculation formula between the corresponding index of these source datas, wherein the first calculation formula can be each equipment manufacturer
Agreement in index data algorithm, algorithm is parsed by the agreement, so that it may obtain each source data and its corresponding index
Between the first calculation formula, then institute's active data and its corresponding first calculation formula are defined table according to pre-set level and deposited
Storage is in the first data Layer.Wherein, the first calculation formula can be constant, i.e. source data can be mapped directly into predefined index
Data, such as the first calculation formula are 100, then can be obtained by with 100 replacement source datas and index number is predefined corresponding to source data
According to.First calculation formula can also simply arithmetic, variable computing, function, such as the first calculation formula is A+B-C ,@
Bsc0id, func (A, B).
For example, obtaining the original document of Huawei mobile phone, original document is parsed, obtained multiple for parameter
The first calculation formula between source data, and the corresponding index of these source datas, then by corresponding to source data and its
First calculation formula defines table according to pre-set level and is stored in the persistent layer of the first data Layer, subsequently to use.
Common index processing method provided in an embodiment of the present invention, source data and its corresponding first calculation formula are all deposited
Storage is in the first data Layer, so, if the index algorithm of equipment manufacturer changes, need to only be calculated corresponding to source data first
Formula is adjusted, and can be realized the renewal of subsequent treatment algorithm in the case where not changing or changing code less, be reduced exploitation
Workload.
It is further, described that predefined achievement data is obtained according to the source data on the basis of the various embodiments described above,
And define table according to the pre-set level and the predefined achievement data is stored in the second data Layer, including：
Obtain the source data in the first data Layer and its corresponding first calculation formula；
According to the source data and its corresponding first calculation formula, predefined achievement data is obtained；
Table is defined according to pre-set level the predefined achievement data is stored in the second data Layer.
Specifically, the source data stored in the first data Layer and its corresponding first calculation formula are obtained, is set according to same
Source data and its corresponding first calculation formula corresponding to standby producer index, calculate predefined achievement data, then according to pre-
If index definition table stores all predefined achievement datas into the persistent layer of the first data Layer.
For example, source data corresponding to Huawei's mobile phone telephone traffic is air time, caller call place, incoming call place etc.
Source data, corresponding first calculation formula of each source data, these source datas and the first calculation formula are stored in the first data Layer
In, the source data related to Huawei mobile phone telephone traffic and the first calculation formula corresponding to them are then got, source data is transported
Calculate combination and obtain Huawei's mobile phone traffic data, Huawei's mobile phone traffic data then is defined into table according to pre-set level is stored in
In the persistent layer of second data Layer.In actual applications, java can be used to demodulate mode and reads each source in the first data Layer
First calculation formula corresponding to data, is handled source data, obtains predefined achievement data.
Common index processing method provided in an embodiment of the present invention, source data in the first data Layer and its corresponding
First calculation formula obtains predefined achievement data, so, only need to be by source data if the index algorithm of equipment manufacturer changes
Corresponding first calculation formula is adjusted, can be in the case where not changing or changing code less, it is possible to is obtained new pre-
Achievement data is defined, realizes the renewal of subsequent treatment algorithm, reduces development amount.
It is further, described to define table according to pre-set level and determine the pre- index on the basis of the various embodiments described above
Adopted data storage in the second data Layer, including：
According to the relation between the predefined achievement data and public achievement data, the second calculation formula is obtained；
Table is defined according to the pre-set level to store the predefined achievement data and its corresponding second calculation formula
In the second data Layer.
Specifically, the predefined achievement data of each equipment manufacturer in the second data Layer is obtained, according to each predefined finger
The relation between data and public achievement data is marked, obtains the second calculation formula, the second calculation formula includes：Arithmetic, letter
Number, variable etc., it is possible to achieve predefined direct mapping between achievement data and public achievement data, other index meters at the same level
The calculating such as calculation, subordinate's index collect, other special formula, the data Layer that wherein index levels corresponding data is stored, such as the
Number of levels corresponding to source data in one data Layer is 1, and rank corresponding to the predefined achievement data in the second data Layer is 2,
Rank corresponding to public achievement data in 3rd data Layer is 3, if also having on public achievement data to public achievement data
Obtained data are handled, then its corresponding rank is 4, and source data is referred to as 1 grade of achievement data at all for this, is predefined
Achievement data is referred to as 2 grades of achievement datas, and public achievement data can also turn into 3 grades of achievement datas.Afterwards, according to default
The predefined achievement data of each equipment manufacturer and its corresponding second calculation formula are stored in the second data Layer by index definition table
In.
For example, public achievement data is the predefined achievement data after normalization, then it is predetermined according to normalization formula storage
Adopted achievement data and normalization calculation formula corresponding to it, as predefined achievement data be respectively Huawei mobile phone telephone traffic A, in it is emerging
Mobile phone telephone traffic B, millet mobile phone telephone traffic C, normalization formula corresponding to them are respectively 40%A, 30%B and 30%C, then will
A and 40%A, B and 30%B and C and 30%C are respectively stored in the second data Layer.
Common index processing method provided in an embodiment of the present invention, predefined achievement data and its corresponding second are calculated
Formula is stored in the second data Layer, and so, public index algorithm changes, only need to be by corresponding to predefined achievement data
Second calculation formula is adjusted, and can realize the renewal of subsequent treatment algorithm in the case where not changing or changing code less,
Reduce development amount.
It is further, described that public finger is obtained according to the predefined achievement data on the basis of the various embodiments described above
Data are marked, and defines table according to the pre-set level and the public achievement data is stored in the 3rd data Layer, including：
Obtain the predefined achievement data in the second data Layer and its corresponding second calculation formula；
According to the predefined achievement data and its corresponding second calculation formula, public achievement data is obtained；
Table is defined according to the pre-set level, and the public achievement data is stored in the 3rd data Layer.
Specifically, obtain and achievement data and its corresponding second calculation formula are predefined in the second data Layer, according to second
Calculation formula is handled predefined achievement data, obtains public achievement data, wherein processing procedure include directly mapping with
Predefined achievement data combinatorial operation etc., can be read by way of java anti-tunes the second calculation formula in the second data Layer come
Calculate public achievement data.Afterwards, define table according to pre-set level and store public achievement data.
In actual applications, in the light of actual conditions pre-set level can be set to define table, it is preferred that pre-set level defines table
Including but not limited to index system coding, index name, index levels, calculation formula etc., for example, table 1 is the embodiment of the present invention
The pre-set level of offer defines table, and table configuration storage marker data information and operation information can be defined by the pre-set level.
The pre-set level of table 1 defines table
Table is defined according to pre-set level defined in table 1 and stores achievement datas at different levels, wherein index levels represent to refer to
Mark the dimension calculated, for distinguishing the achievement data of different pieces of information layer, pointer type be used to distinguish directly mapping achievement data and
Need computing achievement data, it is necessary to computing achievement data can read corresponding to calculation formula calculated, calculating priority can be with
Different achievement datas are configured with different calculating priority, is calculated according to assigned priority order, realizes achievement data formula meter
The nested calculating of calculation, calculation formula are used to configure calculation formula to achievement data, reach the purpose flexibly calculated.According to such
After pre-set level defines the achievement data of table storage different stage, when calculation formula corresponding to some achievement data of a certain rank
During change, its corresponding calculation formula need to be only changed, therefore can increase by configuring different calculation formula, Adjustable calculation formula
Add, change, deleting the operations such as the attribute of achievement data to realize different subsequent treatment optimized algorithms.In actual applications, in order to
It is easy to operation, all achievement data structuring visualizations can also be stored in corresponding achievement data table, it is convenient to
Inquiry, modification, increase, deletion achievement data and its calculation formula are implemented by interface or ad hoc mode, can also conduct
A part for integral platform integrates with other functions.
For example, obtaining the original document of each equipment manufacturer first, parsed from original document for calculating predefined finger
Source data the first calculation formula corresponding with its of data is marked, by these source datas and corresponding first calculation formula according to default
Index definition table is stored in the first data Layer, and then the source data in the first data Layer and the first calculation formula obtain respectively
The predefined achievement data of equipment manufacturer, and the predefined achievement data of each equipment manufacturer corresponding with its second is calculated into public affairs
Formula, define table according to pre-set level and be stored in the second data Layer, finally according to the second calculation formula to predefining achievement data
Handled to obtain public achievement data, defining table according to pre-set level stores public achievement data.
Common index processing method provided in an embodiment of the present invention, according to predefined achievement data and its corresponding second meter
Calculate formula and calculate public achievement data, the form of the predefined achievement data of all devices producer is carried out to unify and be stored in one
Rise, can be real in the case where not changing or changing code less so as to carry out the analysis of striding equipment producer and the whole network analysis
The renewal of existing subsequent treatment algorithm, reduces development amount.
Fig. 2 is common index processing system structural representation provided in an embodiment of the present invention, as shown in Fig. 2 the system
Including：First acquisition module 21, the second acquisition module 22 and the 3rd acquisition module 23, wherein：
First acquisition module 21 is used for the multiple source datas for being used to calculate predefined achievement data for obtaining each equipment manufacturer,
And define table according to pre-set level and the source data is stored in the first data Layer；Second acquisition module 22 is used for according to
Source data obtains predefined achievement data, and defines table according to pre-set level and the predefined achievement data is stored in into the second number
According in layer；3rd acquisition module 23 is used to obtain public achievement data according to the predefined achievement data, and according to default finger
Demarcate adopted table the public achievement data is stored in the 3rd data Layer.
Specifically, the first acquisition module 21 obtains multiple source numbers for being used to calculate predefined achievement data of each equipment manufacturer
According to after obtaining these source datas, it is also necessary to store them, table is defined by source data storage and first according to the pre-set level
In data Layer, the multiple source datas that is got with index sheet form storage, the second acquisition module 22 is deposited according in the first data Layer
The source data of storage obtains the predefined achievement data of each equipment manufacturer, such as Huawei's mobile phone traffic data, 4G surfing flow data,
In the predefined achievement data such as emerging mobile phone traffic data, 4G surfing flow data, these predefined indexs it is most of with it is public
Index is corresponding, and public index namely finally needs the index analyzed, and these then are predefined into achievement data according to above-mentioned
Pre-set level defines table and is stored in the second data Layer, such as these are predefined into achievement data and is stored in the second data Layer
Persistent layer.3rd acquisition module 23 obtains public achievement data according to the predefined achievement data stored in the second data Layer,
In public achievement data, the public achievement data type of each equipment manufacturer is identical, and implication is identical.Such as according to Huawei's mobile phone telephone traffic
Data, in the predefined achievement data such as emerging mobile phone traffic data, millet mobile phone traffic data obtain traffic data, according to
Huawei's mobile phone 4G surfing flows data, in emerging mobile phone 4G surfing flows data, millet mobile phone 4G surfing flow data etc. it is predefined
The predefined achievement data such as 4G surfing flow data obtains 4G surfing flow data, then by traffic data, 4G surfing flows
The public achievement data such as data defines table according to pre-set level and is stored in the 3rd data Layer.System provided in an embodiment of the present invention
System, its function is referring in particular to above method embodiment, and here is omitted.
Common index processing system provided in an embodiment of the present invention, multiple by each equipment manufacturer are used to calculate predefined finger
The source data of mark data carries out collecting conversion by hierarchical storage, the public achievement data of same type is finally obtained, after making
Continuous processing can be analyzed directly from the public achievement data of storage, after reducing index collection processing development amount and updating
During continuous Processing Algorithm, without re-starting collection statistics to the source data of each equipment manufacturer, make follow-up maintenance simpler.
On the basis of above-described embodiment, further, first acquisition module includes, including：
Collecting unit, for gathering the original document of each equipment manufacturer；
Resolution unit, for parsing the original document, obtain multiple source numbers for parameter of each equipment manufacturer
According to and each source data corresponding to the first calculation formula；
First memory cell, for the source data and its corresponding first calculation formula to be defined into table according to pre-set level
It is stored in the first data Layer.
Specifically, collecting unit obtains the original document of each equipment manufacturer from the equipment side interface of each equipment manufacturer, then
Resolution unit parses the original document of each equipment manufacturer using mode adapter, obtains the multiple of each equipment manufacturer and is used to calculate
The first calculation formula between the source data of index, and the corresponding index of these source datas, wherein the first calculation formula
Can be each equipment manufacturer agreement in index data algorithm, algorithm is parsed by the agreement, so that it may obtain each source number
According to and its corresponding index between the first calculation formula, then the first memory cell is by institute's active data and its corresponding first
Calculation formula defines table according to pre-set level and is stored in the first data Layer.Wherein, the first calculation formula can be constant, i.e.
Source data can be mapped directly into predefined achievement data, and such as the first calculation formula is 100, then replaces source data can with 100
Obtain predefining achievement data corresponding to source data.First calculation formula can also simply arithmetic, variable computing, function,
If the first calculation formula is A+B-C ,@bsc0id, func (A, B).System provided in an embodiment of the present invention, its function referring in particular to
Above method embodiment, here is omitted.
Common index processing system provided in an embodiment of the present invention, source data and its corresponding first calculation formula are all deposited
Storage is in the first data Layer, so, if the index algorithm of equipment manufacturer changes, need to only be calculated corresponding to source data first
Formula is adjusted, and can be realized the renewal of subsequent treatment algorithm in the case where not changing or changing code less, be reduced exploitation
Workload.
On the basis of the various embodiments described above, further, second acquisition module includes, including：
Acquiring unit, for obtaining source data and its corresponding first calculation formula in the first data Layer；
Computing unit, for according to the source data and its corresponding first calculation formula, obtaining predefined achievement data；
Second memory cell, for defining table by the pre- index definition data storage in the second data according to pre-set level
In layer.
Specifically, acquiring unit obtains the source data stored in the first data Layer and its corresponding first calculation formula, meter
Unit source data and its corresponding first calculation formula according to corresponding to same equipment manufacturer's index are calculated, calculates predefined index
Data, then the second memory cell define table by all predefined achievement data storages to the first data Layer according to pre-set level
Persistent layer in.System provided in an embodiment of the present invention, its function is referring in particular to above method embodiment, and here is omitted.
Common index processing system provided in an embodiment of the present invention, source data in the first data Layer and its corresponding
First calculation formula obtains predefined achievement data, so, only need to be by source data if the index algorithm of equipment manufacturer changes
Corresponding first calculation formula is adjusted, can be in the case where not changing or changing code less, it is possible to is obtained new pre-
Achievement data is defined, realizes the renewal of subsequent treatment algorithm, reduces development amount.
Fig. 3 is the structural representation of electronic equipment provided in an embodiment of the present invention, as shown in figure 3, the equipment includes：Place
Manage device (processor) 301, memory (memory) 302 and bus 303；
Wherein, processor 301 and memory 302 complete mutual communication by the bus 303；
Processor 301 is used to call programmed instruction in memory 302, is provided with to perform above-mentioned each method embodiment
Method, such as including：Multiple source datas for being used to calculate predefined achievement data of each equipment manufacturer are obtained, and according to default finger
Demarcate adopted table the source data is stored in the first data Layer；Predefined achievement data is obtained according to the source data, and pressed
Table is defined according to the pre-set level the predefined achievement data is stored in the second data Layer；According to the predefined index
The public achievement data of data acquisition, and define table according to the pre-set level and the public achievement data is stored in the 3rd data
In layer.
The embodiment of the present invention discloses a kind of computer program product, and the computer program product is non-transient including being stored in
Computer program on computer-readable recording medium, the computer program include programmed instruction, when described program instructs quilt
When computer performs, computer is able to carry out the method that above-mentioned each method embodiment is provided, such as including：Obtain each instrument factory
Multiple source datas for being used to calculate predefined achievement data of family, and define table according to pre-set level and be stored in the source data
In first data Layer；Predefined achievement data is obtained according to the source data, and table is defined by described according to the pre-set level
Predefined achievement data is stored in the second data Layer；Public achievement data is obtained according to the predefined achievement data, and pressed
Table is defined according to the pre-set level the public achievement data is stored in the 3rd data Layer.
The embodiment of the present invention provides a kind of non-transient computer readable storage medium storing program for executing, the non-transient computer readable storage
Medium storing computer instructs, and the computer instruction makes the computer perform the side that above-mentioned each method embodiment is provided
Method, such as including：Multiple source datas for being used to calculate predefined achievement data of each equipment manufacturer are obtained, and according to pre-set level
The source data is stored in the first data Layer by definition table；Obtained according to the source data and predefine achievement data, and according to
The pre-set level defines table and the predefined achievement data is stored in the second data Layer；According to the predefined index number
According to the public achievement data of acquisition, and define table according to the pre-set level and the public achievement data is stored in the 3rd data Layer
In.
One of ordinary skill in the art will appreciate that：Realizing all or part of step of above method embodiment can pass through
Programmed instruction related hardware is completed, and foregoing program can be stored in a computer read/write memory medium, the program
Upon execution, the step of execution includes above method embodiment；And foregoing storage medium includes：ROM, RAM, magnetic disc or light
Disk etc. is various can be with the medium of store program codes.
The embodiments such as system described above are only schematical, wherein the unit illustrated as separating component
It can be or may not be physically separate, can be as the part that unit is shown or may not be physics list
Member, you can with positioned at a place, or can also be distributed on multiple NEs.It can be selected according to the actual needs
In some or all of module realize the purpose of this embodiment scheme.Those of ordinary skill in the art are not paying creativeness
Work in the case of, you can to understand and implement.
Through the above description of the embodiments, those skilled in the art can be understood that each embodiment can
Realized by the mode of software plus required general hardware platform, naturally it is also possible to pass through hardware.Based on such understanding, on
The part that technical scheme substantially in other words contributes to prior art is stated to embody in the form of software product, should
Computer software product can store in a computer-readable storage medium, such as ROM/RAM, magnetic disc, CD, including some fingers
Make to cause a computer equipment (can be personal computer, server, or network equipment etc.) to perform each implementation
Method described in some parts of example or embodiment.
Finally it should be noted that：Various embodiments above is rather than right only illustrating the technical scheme of embodiments of the invention
It is limited；Although embodiments of the invention are described in detail with reference to foregoing embodiments, the ordinary skill of this area
Personnel should be understood：It can still modify to the technical scheme described in foregoing embodiments, or to which part
Or all technical characteristic carries out equivalent substitution；And these modifications or replacement, do not make the essence disengaging of appropriate technical solution
The scope of each embodiment technical scheme of embodiments of the invention.
Claims (10)
- A kind of 1. common index processing method, it is characterised in that including：Multiple source datas for being used to calculate predefined achievement data of each equipment manufacturer are obtained, and defines table according to pre-set level and incites somebody to action The source data is stored in the first data Layer；Predefined achievement data is obtained according to the source data, and table is defined by the predefined index according to the pre-set level Data storage is in the second data Layer；Public achievement data is obtained according to the predefined achievement data, and define table according to the pre-set level will be described public Achievement data is stored in the 3rd data Layer.
- 2. according to the method for claim 1, it is characterised in that described to obtain the multiple predetermined for calculating of each equipment manufacturer The source data of adopted achievement data, and define table according to pre-set level and the source data is stored in the first data Layer, including：Gather the original document of each equipment manufacturer；The original document is parsed, obtains multiple source datas for parameter of each equipment manufacturer and each source data Corresponding first calculation formula；The source data and its corresponding first calculation formula are defined into table according to pre-set level to be stored in the first data Layer.
- 3. according to the method for claim 2, it is characterised in that described that predefined index number is obtained according to the source data According to, and define table according to the pre-set level and the predefined achievement data is stored in the second data Layer, including：Obtain the source data in the first data Layer and its corresponding first calculation formula；According to the source data and its corresponding first calculation formula, predefined achievement data is obtained；Table is defined according to pre-set level the predefined achievement data is stored in the second data Layer.
- 4. according to the method for claim 3, it is characterised in that described to define table according to pre-set level and determine the pre- index Adopted data storage in the second data Layer, including：According to the relation between the predefined achievement data and public achievement data, the second calculation formula is obtained；Table is defined according to the pre-set level, and the predefined achievement data and its corresponding second calculation formula are stored in In two data Layers.
- 5. according to the method for claim 4, it is characterised in that described that public finger is obtained according to the predefined achievement data Data are marked, and defines table according to the pre-set level and the public achievement data is stored in the 3rd data Layer, including：Obtain the predefined achievement data in the second data Layer and its corresponding second calculation formula；According to the predefined achievement data and its corresponding second calculation formula, public achievement data is obtained；Table is defined according to the pre-set level, and the public achievement data is stored in the 3rd data Layer.
- A kind of 6. common index processing system, it is characterised in that including：First acquisition module, for obtaining multiple source datas for being used to calculate predefined achievement data of each equipment manufacturer, and press Table is defined according to pre-set level the source data is stored in the first data Layer；Second acquisition module, for obtaining predefined achievement data according to the source data, and define table according to pre-set level and incite somebody to action The predefined achievement data is stored in the second data Layer；3rd acquisition module, for obtaining public achievement data according to the predefined achievement data, and determine according to pre-set level The public achievement data is stored in the 3rd data Layer by adopted table.
- 7. system according to claim 6, it is characterised in that first acquisition module includes, including：Collecting unit, for gathering the original document of each equipment manufacturer；Resolution unit, for parsing the original document, obtain each equipment manufacturer multiple source datas for parameter and First calculation formula corresponding to each source data；First memory cell, stored for the source data and its corresponding first calculation formula to be defined into table according to pre-set level In the first data Layer.
- 8. system according to claim 7, it is characterised in that second acquisition module includes, including：Acquiring unit, for obtaining source data and its corresponding first calculation formula in the first data Layer；Computing unit, for according to the source data and its corresponding first calculation formula, obtaining predefined achievement data；Second memory cell, for defining table by the pre- index definition data storage in the second data Layer according to pre-set level In.
- 9. a kind of electronic equipment, it is characterised in that including：Memory and processor, the processor and the memory complete mutual communication by bus；The memory Being stored with can be by the programmed instruction of the computing device, and the processor calls described program instruction to be able to carry out right such as will Seek 1 to 5 any described method.
- 10. a kind of computer-readable recording medium, is stored thereon with computer program, it is characterised in that the computer program The method as described in claim 1 to 5 is any is realized when being executed by processor.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710641060.5A CN107491505B (en) | 2017-07-31 | 2017-07-31 | Universal index processing method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710641060.5A CN107491505B (en) | 2017-07-31 | 2017-07-31 | Universal index processing method and system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107491505A true CN107491505A (en) | 2017-12-19 |
| CN107491505B CN107491505B (en) | 2020-06-16 |
Family
ID=60644016
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710641060.5A Active CN107491505B (en) | 2017-07-31 | 2017-07-31 | Universal index processing method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107491505B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110163492A (en) * | 2019-04-30 | 2019-08-23 | 南京南瑞继保电气有限公司 | Index processing method, device and the storage medium of rail traffic energy management system |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101198134A (en) * | 2007-12-29 | 2008-06-11 | 中国移动通信集团湖北有限公司 | Real time telephone traffic and channel load monitoring method and system used for mobile network |
| CN103532776A (en) * | 2013-09-30 | 2014-01-22 | 广东电网公司电力调度控制中心 | Service flow detection method and system |
| CN105550940A (en) * | 2015-11-25 | 2016-05-04 | 中国南方电网有限责任公司电网技术研究中心 | Power gird equipment standard index data mining and extraction method |
-
2017
- 2017-07-31 CN CN201710641060.5A patent/CN107491505B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101198134A (en) * | 2007-12-29 | 2008-06-11 | 中国移动通信集团湖北有限公司 | Real time telephone traffic and channel load monitoring method and system used for mobile network |
| CN103532776A (en) * | 2013-09-30 | 2014-01-22 | 广东电网公司电力调度控制中心 | Service flow detection method and system |
| CN105550940A (en) * | 2015-11-25 | 2016-05-04 | 中国南方电网有限责任公司电网技术研究中心 | Power gird equipment standard index data mining and extraction method |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110163492A (en) * | 2019-04-30 | 2019-08-23 | 南京南瑞继保电气有限公司 | Index processing method, device and the storage medium of rail traffic energy management system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN107491505B (en) | 2020-06-16 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105989076B (en) | A kind of data statistical approach and device | |
| CN109948641A (en) | Anomaly groups recognition methods and device | |
| CN109284251A (en) | Blog management method, device, computer equipment and storage medium | |
| CN110069519A (en) | Data information management method, apparatus, computer equipment and storage medium | |
| CN107908606A (en) | Method and system based on different aforementioned sources automatic report generation | |
| US20200021690A1 (en) | Toll-free telecommunications management platform | |
| CN103138981B (en) | A kind of social network analysis method and apparatus | |
| CN107886366A (en) | Generation method, sex fill method, terminal and the storage medium of Gender Classification model | |
| CN109344153A (en) | The processing method and terminal device of business datum | |
| US11321155B2 (en) | Automatic resource dependency tracking and structure for maintenance of resource fault propagation | |
| CN106452858B (en) | A kind of method, apparatus and calculating equipment of the identification network user | |
| CN104317942A (en) | Massive data comparison method and system based on hadoop cloud platform | |
| CN111628974A (en) | Differential privacy protection method and device, electronic equipment and storage medium | |
| CN107491505A (en) | A kind of common index processing method and system | |
| WO2012161672A1 (en) | System and method for configuration policy extraction | |
| US9398441B2 (en) | Method and apparatus for identifying re-subscribed user | |
| CN101729929A (en) | System for accessing mass data with intelligent network business libraries, device and method | |
| CN112184402A (en) | Accounting document generation method and device, storage medium and electronic equipment | |
| US20130124484A1 (en) | Persistent flow apparatus to transform metrics packages received from wireless devices into a data store suitable for mobile communication network analysis by visualization | |
| CN109768878A (en) | A kind of network work order calculation method and device based on big data | |
| CN109558403A (en) | Data aggregation method and device, computer installation and computer readable storage medium | |
| CN108399031A (en) | The method and apparatus for determining interface layout mode | |
| CN108551439A (en) | A kind of improved method and device of policy template application | |
| CN101150831A (en) | Network element data processing method and device | |
| CN115134246B (en) | Network performance index monitoring method, device, 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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |