CN111611301A - KPI (Key Performance indicator) representation method, calculation method and system of wireless communication equipment - Google Patents
KPI (Key Performance indicator) representation method, calculation method and system of wireless communication equipment Download PDFInfo
- Publication number
- CN111611301A CN111611301A CN202010549465.8A CN202010549465A CN111611301A CN 111611301 A CN111611301 A CN 111611301A CN 202010549465 A CN202010549465 A CN 202010549465A CN 111611301 A CN111611301 A CN 111611301A
- Authority
- CN
- China
- Prior art keywords
- index
- original
- kpi
- composite
- calculation formula
- 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
- 238000004364 calculation method Methods 0.000 title claims abstract description 197
- 238000004891 communication Methods 0.000 title claims abstract description 54
- 238000000034 method Methods 0.000 title claims abstract description 17
- 239000002131 composite material Substances 0.000 claims abstract description 180
- 230000011218 segmentation Effects 0.000 claims description 3
- 238000004422 calculation algorithm Methods 0.000 description 2
- 238000010586 diagram Methods 0.000 description 2
- 238000012544 monitoring process Methods 0.000 description 2
- 230000005540 biological transmission Effects 0.000 description 1
- 238000002955 isolation Methods 0.000 description 1
- 230000002045 lasting effect Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000005457 optimization Methods 0.000 description 1
- 238000012545 processing Methods 0.000 description 1
- 238000007619 statistical method Methods 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2462—Approximate or statistical queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0639—Performance analysis of employees; Performance analysis of enterprise or organisation operations
- G06Q10/06393—Score-carding, benchmarking or key performance indicator [KPI] analysis
-
- G06Q50/40—
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04W—WIRELESS COMMUNICATION NETWORKS
- H04W24/00—Supervisory, monitoring or testing arrangements
- H04W24/02—Arrangements for optimising operational condition
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D30/00—Reducing energy consumption in communication networks
- Y02D30/70—Reducing energy consumption in communication networks in wireless communication networks
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Probability & Statistics with Applications (AREA)
- Development Economics (AREA)
- Educational Administration (AREA)
- Economics (AREA)
- Entrepreneurship & Innovation (AREA)
- General Physics & Mathematics (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- Computer Networks & Wireless Communication (AREA)
- Operations Research (AREA)
- Marketing (AREA)
- General Business, Economics & Management (AREA)
- Game Theory and Decision Science (AREA)
- Signal Processing (AREA)
- Quality & Reliability (AREA)
- Fuzzy Systems (AREA)
- Mathematical Physics (AREA)
- Software Systems (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Mobile Radio Communication Systems (AREA)
Abstract
The invention provides a KPI index representation method, a calculation method and a system of wireless communication equipment, wherein the representation method comprises the following steps: acquiring all original indexes, composite indexes and KPI indexes supported by wireless communication equipment; adding all the original indexes, the composite indexes and the KPI indexes into a database, and distributing corresponding IDs for each of the original indexes, the composite indexes and the KPI indexes; and editing a calculation formula field of each composite index and a calculation formula field of each KPI index, wherein the original index contained in the calculation formula field of the composite index is replaced by the original index ID, and the original index and the composite index contained in the calculation formula field of the KPI index are replaced by the original index ID and the composite index ID. The invention simplifies the calculation formula fields of the composite index and the KPI index, saves system resources and improves the calculation efficiency of the index.
Description
Technical Field
The invention belongs to the technical field of communication, and particularly relates to a KPI (Key performance indicator) representation method, a calculation method and a system of wireless communication equipment.
Background
The KPI of the wireless communication equipment is one of key items for examining the quality of the wireless communication equipment by various operators and is also an intuitive reflection on the performance of the wireless communication network. The statistical monitoring of KPI (Key Performance Indicator) indicators is undoubtedly an effective means for detecting the quality of equipment and network Performance. Through the statistical monitoring of daily KPI index, can discern the proruption problem of equipment to and the lasting short board of network performance, thereby carry out targeted optimization promotion, eliminate the problem in the primary stage.
How to quickly and effectively count the KPI of the wireless communication equipment by the wireless communication equipment network management system is a very important task. The existing wireless communication equipment KPI index statistical method generally directly utilizes KPI index calculation formula provided by operator to make statistics. The methods either adopt distributed processing or improve the transmission efficiency of the network, so as to improve the statistical efficiency of the KPI.
Although the technical methods can meet the requirement of quickly counting KPI indexes, the system resources are wasted greatly, and the cost of engineering deployment is increased.
Disclosure of Invention
To overcome the existing problems or at least partially solve the problems, embodiments of the present invention provide a KPI indicator representing method, a calculating method, and a system for a wireless communication device.
According to a first aspect of the embodiments of the present invention, there is provided a KPI indicator representation method for a wireless communication device, including:
acquiring all original indexes, composite indexes and KPI indexes supported by wireless communication equipment;
adding all original indexes, all composite indexes and all KPI indexes into a database, and distributing corresponding IDs for each original index, each composite index and each KPI index;
and editing a calculation formula field of each composite index and a calculation formula field of each KPI, wherein the original index contained in the calculation formula field of the composite index is replaced by the original index ID, the original index contained in the calculation formula field of the KPI is replaced by the original index ID, and the calculation formula field of the composite index contained in the calculation formula field of the KPI is replaced by the composite index ID.
On the basis of the above technical solutions, the embodiments of the present invention may be further improved as follows.
Optionally, the adding all the original indicators, all the composite indicators, and all the KPI indicators into the database, and assigning corresponding IDs to each of the original indicators, each of the composite indicators, and each of the KPI indicators includes:
adding all original indexes into a database, and distributing corresponding ID (identity) for each original index, wherein the IDs of all the original indexes are positioned in a first preset range;
adding all the composite indexes into a database, and distributing corresponding ID (identity) for each composite index, wherein the IDs of all the composite indexes are positioned in a second preset range;
and adding all KPI indexes into a database, and distributing corresponding ID (identity) for each KPI index, wherein the IDs of all KPI indexes are positioned in a third preset range.
Optionally, the editing the calculation formula field of each composite indicator and the calculation formula field of each KPI indicator includes:
editing a calculation formula field of each composite index, replacing an original index name in the calculation formula field with an original index ID, and adding an isolator before the original index ID;
editing a calculation formula field of each KPI, replacing the original field name in the calculation formula field with an original index ID, and adding an isolator before the original index ID; and replacing the composite index name in the field of the calculation formula with a composite index ID, and adding an isolator before the composite index ID.
According to a second aspect of the embodiments of the present invention, there is provided a KPI indicator calculation method for a wireless communication device, including:
reading IDs of all indexes and a calculation formula field of each index, wherein the indexes comprise original indexes, composite indexes and KPI indexes;
analyzing to obtain a corresponding relation between an original index name and an original index value according to an original index data file reported by wireless communication equipment;
finding out a corresponding ID according to the name of the original index, substituting the original index value into a calculation formula field of each composite index, and calculating to obtain a calculation result of each composite index;
and calculating to obtain the calculation result of each KPI according to the calculation formula field of each KPI based on the original index value and the calculation result of the composite index.
Optionally, the reading of the IDs of all the indexes and the calculation formula field of each index includes:
storing the read ID of each index, the calculation formula field of each index and the type data of each index into a parameter list;
correspondingly, storing the corresponding relation between the original index name and the original index value obtained by analysis in a result list;
finding out a corresponding index ID through each index name, and adopting the index ID to replace the index name in the result list to establish a corresponding relation between the index ID and the index value;
traversing the parameter list, replacing the original index value with the original index value to calculate the original index ID after the isolator in the field of the composite index calculation formula for each composite index, calculating the composite index result value, and storing the composite index result value in the result list;
for each KPI, replacing the original index value and the composite index result value with the original index ID and the composite index ID after the separator of the calculation formula field of the KPI is replaced, calculating the KPI result value, and storing the KPI result value into a result list.
Optionally, the method further includes:
storing the read ID of each index, the calculation formula field of each index and the type data of each index into a parameter list in a segmentation mode according to the size sequence of the ID of each index, wherein each ID section corresponds to the type data of one index;
correspondingly, the finding of the corresponding index ID by each index name includes:
according to the type data to which any index name belongs, searching an index ID corresponding to any index name from an ID segment corresponding to the type data, and establishing a corresponding relation between the index ID and an index value;
according to a third aspect of the embodiments of the present invention, there is provided a KPI indicator representation system of a wireless communication device, including:
the acquisition module is used for acquiring all original indexes, composite indexes and KPI indexes supported by the wireless communication equipment;
the distribution module is used for adding all the original indexes, all the composite indexes and all the KPI indexes into a database and distributing corresponding IDs (identity) for each original index, each composite index and each KPI index;
and the editing module is used for editing the calculation formula field of each composite index and the calculation formula field of each KPI, wherein the original index contained in the calculation formula field of the composite index is replaced by the original index ID, the original index contained in the calculation formula field of the KPI is replaced by the original index ID, and the calculation formula field of the composite index contained in the calculation formula field of the KPI is replaced by the composite index ID.
Optionally, the editing module is specifically configured to:
editing a calculation formula field of each composite index, replacing an original index name in the calculation formula field with an original index ID, and adding an isolator before the original index ID;
editing a calculation formula field of each KPI, replacing the original field name in the calculation formula field with an original index ID, and adding an isolator before the original index ID; and replacing the composite index name in the field of the calculation formula with a composite index ID, and adding an isolator before the composite index ID.
According to a fourth aspect of the embodiments of the present invention, there is provided a KPI indicator calculation system of a wireless communication device, including:
the reading module is used for reading the IDs of all the indexes and the calculation formula field of each index, wherein the indexes comprise original indexes, composite indexes and KPI indexes;
the analysis module is used for analyzing the original index data file reported by the wireless communication equipment to obtain the corresponding relation between the original index name and the original index value;
the calculation module is used for finding out the corresponding ID according to the name of the original index, substituting the original index value into the calculation formula field of each composite index, and calculating to obtain the calculation result of each composite index; and calculating to obtain the calculation result of each KPI according to the calculation formula field of each KPI based on the original index value and the calculation result of the composite index.
The embodiment of the invention provides a KPI (Key performance indicator) representation method, a calculation method and a system of wireless communication equipment.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, and it is obvious that the drawings in the following description are some embodiments of the present invention, and those skilled in the art can also obtain other drawings according to the drawings without creative efforts.
Fig. 1 is a flow chart of a KPI indicator representation method for a wireless communication device according to an embodiment of the present invention;
fig. 2 is a flowchart of a KPI indicator calculation method for a wireless communication device according to an embodiment of the present invention;
fig. 3 is a schematic diagram of an overall structure of a KPI indicator representation system of a wireless communication device according to an embodiment of the present invention;
fig. 4 is a schematic diagram of an overall structure of a KPI indicator calculation system of a wireless communication device according to an embodiment of the present invention.
Detailed Description
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, and it is obvious that the drawings in the following description are some embodiments of the present invention, and those skilled in the art can also obtain other drawings according to the drawings without creative efforts.
Referring to fig. 1, a KPI indicator representation method of a wireless communication device according to an embodiment of the present invention is provided, including:
acquiring all original indexes, composite indexes and KPI indexes supported by wireless communication equipment;
adding all original indexes, all composite indexes and all KPI indexes into a database, and distributing corresponding IDs for each original index, each composite index and each KPI index;
and editing a calculation formula field of each composite index and a calculation formula field of each KPI, wherein the original index contained in the calculation formula field of the composite index is replaced by the original index ID, the original index contained in the calculation formula field of the KPI is replaced by the original index ID, and the calculation formula field of the composite index contained in the calculation formula field of the KPI is replaced by the composite index ID.
It can be understood that, aiming at the problem that the traditional KPI index statistics of the wireless communication device is low in efficiency, the embodiment of the present invention can improve the KPI index statistics efficiency of the wireless communication device. In the embodiment of the invention, corresponding IDs are allocated to each original index, composite index and KPI index supported by the wireless communication equipment.
The composite index can be calculated from the original indexes, for example: the cell switching success rate is equal to the cell switching success times/the cell switching times is equal to 100%, the cell switching success rate is a composite index, and the cell switching success times and the cell switching times are original indexes directly reported by equipment. KPI indicators can be calculated from the original indicators and the composite indicators, for example: the average handover success rate of the whole network cell is (base station 1 handover success times/base station 1 handover times + 100% + base station 2 handover success times/base station 2 handover times + 100% + … … + base station n handover success times/base station n handover times + 100%)/n.
Each composite index and each KPI index have corresponding calculation formula fields, and the original index name contained in the calculation formula field of each composite index is represented by an original index ID; similarly, for each KPI, the original index name in the calculation formula field of the KPI is represented by the original index ID, and if the calculation formula field of the composite index exists in the calculation formula field of the KPI, the calculation formula field of the composite index is replaced by the ID of the composite index.
The embodiment of the invention utilizes the combination of the original index and the composite index of the equipment to carry out the statistical calculation of the KPI, thereby reducing the engineering deployment cost and ensuring the service quality of the network management system of the wireless communication equipment.
As an optional embodiment, the adding all the original indicators, all the composite indicators, and all the KPI indicators to the database, and assigning corresponding IDs to each of the original indicators, each of the composite indicators, and each of the KPI indicators includes:
adding all original indexes into a database, and distributing corresponding ID (identity) for each original index, wherein the IDs of all the original indexes are positioned in a first preset range;
adding all the composite indexes into a database, and distributing corresponding ID (identity) for each composite index, wherein the IDs of all the composite indexes are positioned in a second preset range;
and adding all KPI indexes into a database, and distributing corresponding ID (identity) for each KPI index, wherein the IDs of all KPI indexes are positioned in a third preset range.
It can be understood that, when each index is assigned with a corresponding ID, the IDs of different types of indexes are assigned in segments, so that subsequent segment query is facilitated, and query efficiency is improved.
As an optional embodiment, the editing the calculation formula field of each composite indicator and the calculation formula field of each KPI indicator includes:
editing a calculation formula field of each composite index, replacing an original index name in the calculation formula field with an original index ID, and adding an isolator before the original index ID;
editing a calculation formula field of each KPI, replacing the original field name in the calculation formula field with an original index ID, and adding an isolator before the original index ID; and replacing the composite index name in the field of the calculation formula with a composite index ID, and adding an isolator before the composite index ID.
It can be understood that all original indexes of the equipment are added into the database, an ID is distributed to each original index, the ID range is 1-100000, and the field of a calculation formula of the original index is edited to be NULL; adding all composite indexes into a database, distributing an ID (identity) for each composite index, wherein the ID range is 100001-200000, editing a field of a calculation formula of the composite index, changing the name of an original index in the calculation formula into the ID of the original index, and adding a symbol separator "@" in front of the ID of the original index; adding all KPI indexes into a database, allocating ID (identity) for each KPI index, wherein the ID range is 200001-300000, editing a calculation formula field of the KPI index, converting the original index name in the calculation formula into the original index ID, directly replacing a subformula with the composite index ID if the subformula is the calculation formula of the composite index, and adding a sign separator '@' before the ID of the composite index. And storing the related data of each index in a database in a segmented manner according to the size sequence of each index ID so as to facilitate segmented query in subsequent query.
Referring to fig. 2, there is provided a KPI indicator calculation method of a wireless communication device, including:
reading IDs of all indexes and a calculation formula field of each index, wherein the indexes comprise original indexes, composite indexes and KPI indexes;
analyzing to obtain a corresponding relation between an original index name and an original index value according to an original index data file reported by wireless communication equipment;
finding out a corresponding ID according to the name of the original index, substituting the original index value into a calculation formula field of each composite index, and calculating to obtain a calculation result of each composite index;
and calculating to obtain the calculation result of each KPI according to the calculation formula field of each KPI based on the original index value and the calculation result of the composite index.
It can be understood that all indexes are read into the index parameter list according to the index ID sequence, the calculation formula fields of the composite index and the KPI index are analyzed according to the binary tree algorithm rule, when the @' symbol is analyzed, the index ID is shown to be behind the calculation formula fields, the value constants are not the value constants, the calculation formula fields need to be substituted into the corresponding index values for calculation, and the calculation formula attributes of the original indexes are edited to be NULL by default.
After an original index file reported by the wireless communication equipment is received and analyzed to obtain an original index of the wireless communication equipment, the index parameter list is traversed, the original index file and the original index file are preferentially substituted into a composite index calculation formula field according to the sequence to obtain a calculation result of the composite index, and the original index value and the composite index value are substituted into a KPI calculation formula field to obtain a calculation result of the KPI.
And storing the original index value, the calculation result of the composite index and the calculation result of the KPI into a database.
As an optional embodiment, the reading the IDs of all the indexes and the calculation formula field of each index includes:
storing the read ID of each index, the calculation formula field of each index and the type data of each index into a parameter List 1; storing the read ID of each index, the calculation formula field of each index and the type data of each index into a parameter List1 in a segmentation mode according to the size sequence of the ID of each index;
correspondingly, storing the corresponding relation between the original index name and the original index value obtained by analysis in a result List 2;
the correspondence between the index ID and the index value is established by finding the corresponding index ID in the parameter List1 by each index name and replacing the index name in the result List2 with the index ID. Since the indexes in the parameter List1 are stored in segments according to the index IDs, when the corresponding index ID is found in the parameter List1 by each index name, the query can be performed in segments, thereby improving the query efficiency.
And storing the established corresponding relation between the index ID and the index value in a result list according to the ID size sequence of each index.
Traversing the parameter List1, for each composite index, replacing the original index with the original index value to calculate the original index ID after the isolator in the field of the composite index calculation formula, calculating the composite index result value, and storing the composite index result value in the result List 2;
for each KPI, replacing the original index value and the composite index result value with the original index ID and the composite index ID after the separator of the calculation formula field of the KPI, calculating the KPI result value, and storing the KPI result value into a result List List 2;
each of the raw index values, each of the composite index values and each of the KPI index values in the result List2 are stored in the database.
Referring to fig. 3, a KPI indicator representation system of a wireless communication device according to an embodiment of the present invention is provided, including:
an obtaining module 31, configured to obtain all original indicators, composite indicators, and KPI indicators supported by the wireless communication device;
an allocation module 32, configured to add all the original indicators, all the composite indicators, and all the KPI indicators to the database, and allocate corresponding IDs to each of the original indicators, each of the composite indicators, and each of the KPI indicators;
and an editing module 33, configured to edit a calculation formula field of each composite indicator and a calculation formula field of each KPI indicator, where an original indicator included in the calculation formula field of the composite indicator is replaced with an original indicator ID, an original indicator included in the calculation formula field of the KPI indicator is replaced with an original indicator ID, and a composite indicator included in the calculation formula field of the KPI indicator is replaced with a composite indicator ID.
It can be understood that, when the obtaining module 31 obtains all the original indicators, the composite indicators and the KPI indicators supported by the wireless communication device, the allocating module 32 allocates corresponding IDs to each of the original indicators, the composite indicators and the KPI indicators supported by the wireless communication device.
The editing module 33 edits corresponding calculation formula fields for each composite index and each KPI index, wherein the original index name contained in the calculation formula field of each composite index is represented by an original index ID; similarly, for each KPI, the original index name in the calculation formula field of the KPI is represented by the original index ID, and if the calculation formula field of the composite index exists in the calculation formula field of the KPI, the calculation formula field of the composite index is replaced by the ID of the composite index.
The embodiment of the invention utilizes the combination of the original index and the composite index of the equipment to carry out the statistical calculation of the KPI, thereby reducing the engineering deployment cost and ensuring the service quality of the network management system of the wireless communication equipment.
As an optional embodiment, the editing module 33 is specifically configured to:
editing a calculation formula field of each composite index, replacing an original index name in the calculation formula field with an original index ID, and adding an isolator before the original index ID;
editing a calculation formula field of each KPI, replacing the original field name in the calculation formula field with an original index ID, and adding an isolator before the original index ID; and replacing the composite index name in the field of the calculation formula with a composite index ID, and adding an isolator before the composite index ID.
It can be understood that each composite index is obtained by calculating an original index, each KPI is obtained by calculating the original index and the composite index, when editing the calculation formula field of each composite index, the original field name in the calculation formula field is replaced by an original index ID, and an isolation symbol "@" is added before the original index ID; similarly, when editing the calculation formula field of each KPI index, the composite index name in the calculation formula field is replaced with the composite index ID, and an isolator "@" is added before the composite index ID.
Referring to fig. 4, there is provided a KPI indicator calculation system of a wireless communication device, comprising:
a reading module 41, configured to read IDs of all the indexes and a calculation formula field of each index, where the indexes include an original index, a composite index, and a KPI index;
the analysis module 42 is configured to analyze the original index data file reported by the wireless communication device to obtain a corresponding relationship between an original index name and an original index value;
the calculation module 43 is configured to find a corresponding ID according to the name of the original index, and substitute the original index value into the calculation formula field of each composite index to obtain a calculation result of each composite index; and calculating to obtain the calculation result of each KPI according to the calculation formula field of each KPI based on the original index value and the calculation result of the composite index.
It is understood that the reading module 41 reads the ID, the calculation formula field, and the data type of the index for each of the original index, the composite index, and the KPI index. The analysis module 42 receives the original index file reported by the wireless communication device and analyzes the original index file to obtain the original index of the wireless communication device; the calculation module 43 traverses the index parameter list, and substitutes the index parameter list into the composite index calculation formula field in sequence to obtain the calculation result of the composite index, and substitutes the original index value and the composite index value into the KPI calculation formula field to obtain the calculation result of the KPI index.
And storing the original index value, the calculation result of the composite index and the calculation result of the KPI into a database.
The embodiment of the invention segments the IDs of different types of indexes, is convenient for expanding various types of index services at the later stage of a project, and improves the robustness of the network management system software of the wireless communication equipment; original index names in the composite index and KPI index calculation formula are replaced by original index ID, so that the length of the calculation formula is reduced, and the storage space is saved; a sign '@' is added in front of the index ID to distinguish the index ID and the numerical constant in the calculation formula, so that the accuracy of the binary tree algorithm for analyzing the calculation formula is improved; when a sub-formula in the KPI index calculation formula is a calculation formula of a composite index, the composite index ID is adopted to replace the sub-formula, so that the length of the calculation formula is further reduced, and the storage space is saved; all the indexes are sorted according to the ID and then calculated, the composite index can be calculated preferentially, and the KPI is calculated by using the calculation result of the composite index, so that the calculation times of the indexes are reduced, and the calculation efficiency of the KPI is improved.
Finally, it should be noted that: the above examples are only intended to illustrate the technical solution of the present invention, but not to limit it; although the present invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; and such modifications or substitutions do not depart from the spirit and scope of the corresponding technical solutions of the embodiments of the present invention.
Claims (9)
1. A method for representing KPI indicators for a wireless communication device, comprising:
acquiring all original indexes, composite indexes and KPI indexes supported by wireless communication equipment;
adding all original indexes, all composite indexes and all KPI indexes into a database, and distributing corresponding IDs for each original index, each composite index and each KPI index;
and editing a calculation formula field of each composite index and a calculation formula field of each KPI index, wherein the original index contained in the calculation formula field of the composite index is replaced by the original index ID, the original index contained in the calculation formula field of the KPI index is replaced by the original index ID, and the calculation formula field of the composite index contained in the calculation formula field of the KPI index is replaced by the composite index ID.
2. A KPI indicator representation method according to claim 1, wherein said adding all original indicators, all composite indicators and all KPI indicators to a database and assigning a corresponding ID to each original indicator, each composite indicator and each KPI indicator comprises:
adding all original indexes into a database, and distributing corresponding ID (identity) for each original index, wherein the IDs of all the original indexes are positioned in a first preset range;
adding all the composite indexes into a database, and distributing corresponding ID (identity) for each composite index, wherein the IDs of all the composite indexes are positioned in a second preset range;
and adding all KPI indexes into a database, and distributing corresponding ID (identity) for each KPI index, wherein the IDs of all KPI indexes are positioned in a third preset range.
3. A method for representing KPI indicators according to claim 1, wherein said compiling each composite indicator's computational formula field and each KPI indicator's computational formula field comprises:
editing a calculation formula field of each composite index, replacing an original index name in the calculation formula field with an original index ID, and adding an isolator before the original index ID;
editing a calculation formula field of each KPI, replacing the original field name in the calculation formula field with an original index ID, and adding an isolator before the original index ID; and replacing the composite index name in the field of the calculation formula with a composite index ID, and adding an isolator before the composite index ID.
4. A KPI indicator calculation method for a wireless communication device, comprising:
reading IDs of all indexes and a calculation formula field of each index, wherein the indexes comprise original indexes, composite indexes and KPI indexes;
analyzing to obtain a corresponding relation between an original index name and an original index value according to an original index data file reported by wireless communication equipment;
finding out a corresponding ID according to the name of the original index, substituting the original index value into a calculation formula field of each composite index, and calculating to obtain a calculation result of each composite index;
and calculating to obtain the calculation result of each KPI according to the calculation formula field of each KPI based on the original index value and the calculation result of the composite index.
5. A KPI calculation method according to claim 4, wherein reading all the index IDs and each index calculation formula field comprises:
storing the read ID of each index, the calculation formula field of each index and the type data of each index into a parameter list;
correspondingly, storing the corresponding relation between the original index name and the original index value obtained by analysis in a result list;
finding out a corresponding index ID through each index name, and adopting the index ID to replace the index name in the result list to establish a corresponding relation between the index ID and the index value;
traversing the parameter list, replacing the original index value with the original index value to calculate the original index ID after the isolator in the field of the composite index calculation formula for each composite index, calculating the composite index result value, and storing the composite index result value in the result list;
for each KPI, replacing the original index value and the composite index result value with the original index ID and the composite index ID after the separator of the calculation formula field of the KPI is replaced, calculating the KPI result value, and storing the KPI result value into a result list.
6. A KPI indicator calculation method according to claim 5, further comprising:
storing the read ID of each index, the calculation formula field of each index and the type data of each index into a parameter list in a segmentation mode according to the size sequence of the ID of each index, wherein each ID section corresponds to the type data of one index;
correspondingly, the finding of the corresponding index ID by each index name includes:
according to the type data to which any index name belongs, searching an index ID corresponding to any index name from an ID segment corresponding to the type data, and establishing a corresponding relation between the index ID and an index value;
and storing the established corresponding relation between the index ID and the index value in a result list according to the ID size sequence of each index.
7. A KPI indicator representation system for a wireless communication device, comprising:
the acquisition module is used for acquiring all original indexes, composite indexes and KPI indexes supported by the wireless communication equipment;
the distribution module is used for adding all the original indexes, all the composite indexes and all the KPI indexes into a database and distributing corresponding IDs (identity) for each original index, each composite index and each KPI index;
and the editing module is used for editing the calculation formula field of each composite index and the calculation formula field of each KPI, wherein the original index contained in the calculation formula field of the composite index is replaced by the original index ID, the original index contained in the calculation formula field of the KPI is replaced by the original index ID, and the calculation formula field of the composite index contained in the calculation formula field of the KPI is replaced by the composite index ID.
8. A KPI indicator representation system according to claim 6, wherein the editing module is specifically configured to:
editing a calculation formula field of each composite index, replacing an original index name in the calculation formula field with an original index ID, and adding an isolator before the original index ID;
editing a calculation formula field of each KPI, replacing the original field name in the calculation formula field with an original index ID, and adding an isolator before the original index ID; and replacing the composite index name in the field of the calculation formula with a composite index ID, and adding an isolator before the composite index ID.
9. A KPI indicator computing system for a wireless communication device, comprising:
the reading module is used for reading the IDs of all the indexes and the calculation formula field of each index, wherein the indexes comprise original indexes, composite indexes and KPI indexes;
the analysis module is used for analyzing the original index data file reported by the wireless communication equipment to obtain the corresponding relation between the original index name and the original index value;
the calculation module is used for finding out the corresponding ID according to the name of the original index, substituting the original index value into the calculation formula field of each composite index, and calculating to obtain the calculation result of each composite index; and calculating to obtain the calculation result of each KPI according to the calculation formula field of each KPI based on the original index value and the calculation result of the composite index.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202010549465.8A CN111611301B (en) | 2020-06-16 | 2020-06-16 | KPI index representing method, calculating method and system of wireless communication equipment |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202010549465.8A CN111611301B (en) | 2020-06-16 | 2020-06-16 | KPI index representing method, calculating method and system of wireless communication equipment |
Publications (2)
Publication Number | Publication Date |
---|---|
CN111611301A true CN111611301A (en) | 2020-09-01 |
CN111611301B CN111611301B (en) | 2023-12-08 |
Family
ID=72198689
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN202010549465.8A Active CN111611301B (en) | 2020-06-16 | 2020-06-16 | KPI index representing method, calculating method and system of wireless communication equipment |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN111611301B (en) |
Citations (16)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20060200459A1 (en) * | 2005-03-03 | 2006-09-07 | The E-Firm | Tiered access to integrated rating system |
KR100814403B1 (en) * | 2006-10-12 | 2008-03-18 | 삼성전자주식회사 | Formula based network management system supporting queueing mechanism and method of measuring performance parameter |
JP2008140032A (en) * | 2006-11-30 | 2008-06-19 | Hitachi Ltd | Risk analysis method, risk analysis system, and risk analysis program |
CN101345654A (en) * | 2008-08-30 | 2009-01-14 | 华为技术有限公司 | Index computing method and apparatus |
CN102521714A (en) * | 2011-12-29 | 2012-06-27 | 国网信息通信有限公司 | Method and device for constructing KPI (key performance indicator) hierarchical model and energy consumption assessing method and system |
CN103455489A (en) * | 2012-05-28 | 2013-12-18 | 阿里巴巴集团控股有限公司 | Method and system for rapidly constructing key performance indicators (KPIs) of enterprises |
JP2017117209A (en) * | 2015-12-24 | 2017-06-29 | 大和ハウス工業株式会社 | Support system, support method and program |
CN107122431A (en) * | 2017-04-14 | 2017-09-01 | 浙江数链科技有限公司 | A kind of real-time calculating platform and the method for computing data based on real-time calculating platform |
CN107346270A (en) * | 2016-05-05 | 2017-11-14 | 北京京东尚科信息技术有限公司 | Method and system based on the sets cardinal calculated in real time |
CN109034662A (en) * | 2018-08-31 | 2018-12-18 | 东北大学 | A kind of production target Visualized Monitoring System and method based on process flow |
CN109062712A (en) * | 2018-07-20 | 2018-12-21 | 武汉虹信通信技术有限责任公司 | A method of collecting LTE base station equipment index parameter |
CN109086339A (en) * | 2018-07-06 | 2018-12-25 | 深圳市彬讯科技有限公司 | It is a kind of for generating the data processing method and device of index recombination rate |
CN109800225A (en) * | 2018-12-24 | 2019-05-24 | 北京奇艺世纪科技有限公司 | Acquisition methods, device, server and the computer readable storage medium of operational indicator |
CN110019385A (en) * | 2017-09-04 | 2019-07-16 | 北京国双科技有限公司 | The querying method and device of parameter |
CN110134517A (en) * | 2019-05-21 | 2019-08-16 | 山东浪潮通软信息科技有限公司 | A kind of parallel calculating method and device based on Formula Parsing |
CN111104184A (en) * | 2019-12-18 | 2020-05-05 | 青岛海信网络科技股份有限公司 | Method and device for online loading and unloading of comprehensive traffic operation monitoring indexes |
-
2020
- 2020-06-16 CN CN202010549465.8A patent/CN111611301B/en active Active
Patent Citations (16)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20060200459A1 (en) * | 2005-03-03 | 2006-09-07 | The E-Firm | Tiered access to integrated rating system |
KR100814403B1 (en) * | 2006-10-12 | 2008-03-18 | 삼성전자주식회사 | Formula based network management system supporting queueing mechanism and method of measuring performance parameter |
JP2008140032A (en) * | 2006-11-30 | 2008-06-19 | Hitachi Ltd | Risk analysis method, risk analysis system, and risk analysis program |
CN101345654A (en) * | 2008-08-30 | 2009-01-14 | 华为技术有限公司 | Index computing method and apparatus |
CN102521714A (en) * | 2011-12-29 | 2012-06-27 | 国网信息通信有限公司 | Method and device for constructing KPI (key performance indicator) hierarchical model and energy consumption assessing method and system |
CN103455489A (en) * | 2012-05-28 | 2013-12-18 | 阿里巴巴集团控股有限公司 | Method and system for rapidly constructing key performance indicators (KPIs) of enterprises |
JP2017117209A (en) * | 2015-12-24 | 2017-06-29 | 大和ハウス工業株式会社 | Support system, support method and program |
CN107346270A (en) * | 2016-05-05 | 2017-11-14 | 北京京东尚科信息技术有限公司 | Method and system based on the sets cardinal calculated in real time |
CN107122431A (en) * | 2017-04-14 | 2017-09-01 | 浙江数链科技有限公司 | A kind of real-time calculating platform and the method for computing data based on real-time calculating platform |
CN110019385A (en) * | 2017-09-04 | 2019-07-16 | 北京国双科技有限公司 | The querying method and device of parameter |
CN109086339A (en) * | 2018-07-06 | 2018-12-25 | 深圳市彬讯科技有限公司 | It is a kind of for generating the data processing method and device of index recombination rate |
CN109062712A (en) * | 2018-07-20 | 2018-12-21 | 武汉虹信通信技术有限责任公司 | A method of collecting LTE base station equipment index parameter |
CN109034662A (en) * | 2018-08-31 | 2018-12-18 | 东北大学 | A kind of production target Visualized Monitoring System and method based on process flow |
CN109800225A (en) * | 2018-12-24 | 2019-05-24 | 北京奇艺世纪科技有限公司 | Acquisition methods, device, server and the computer readable storage medium of operational indicator |
CN110134517A (en) * | 2019-05-21 | 2019-08-16 | 山东浪潮通软信息科技有限公司 | A kind of parallel calculating method and device based on Formula Parsing |
CN111104184A (en) * | 2019-12-18 | 2020-05-05 | 青岛海信网络科技股份有限公司 | Method and device for online loading and unloading of comprehensive traffic operation monitoring indexes |
Also Published As
Publication number | Publication date |
---|---|
CN111611301B (en) | 2023-12-08 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN101661409B (en) | Extraction method of parallel program communication mode and system | |
CN110674231A (en) | Data lake-oriented user ID integration method and system | |
CN110662212B (en) | Mobile phone terminal identification method based on big data | |
CN116662875A (en) | Interface mapping method and device | |
CN109040744B (en) | Method, device and storage medium for predicting key quality index of video service | |
CN112134719A (en) | Method and system for analyzing base station security log | |
CN111611301B (en) | KPI index representing method, calculating method and system of wireless communication equipment | |
CN113190947A (en) | Feed line group dividing method and device | |
CN111414528B (en) | Method and device for determining equipment identification, storage medium and electronic equipment | |
CN114745275A (en) | Node updating method and device in cloud service environment and computer equipment | |
CN113162801B (en) | Alarm analysis method, device and storage medium | |
CN116390149A (en) | MR information backfilling method and system based on big data | |
CN115660730A (en) | Loss user analysis method and system based on classification algorithm | |
CN102088362B (en) | Collecting method and device of performance data | |
CN107181715B (en) | Service checking method and device | |
CN112232731B (en) | Method and equipment for classifying inventory ABC | |
CN115185663A (en) | Intelligent data processing system based on big data | |
CN111372073B (en) | Video quality evaluation method, device, equipment and medium | |
CN114356712A (en) | Data processing method, device, equipment, readable storage medium and program product | |
CN111488327B (en) | Data standard management method and system | |
CN113239039A (en) | Dynamic data storage method, query method, management method and management system | |
CN112073989A (en) | SDN drainage-based flow auditing method | |
CN106330476B (en) | Method for obtaining guaranteed bandwidth of user side port and network monitoring system | |
CN113949640A (en) | Service data processing method and device | |
CN116955736B (en) | Data constraint condition recommendation method and system in data standard |
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 | ||
TA01 | Transfer of patent application right |
Effective date of registration: 20201026 Address after: 430205 Hubei city of Wuhan province Jiangxia Hidden Dragon Island Tan lake two Road No. 1 Applicant after: Wuhan Hongxin Technology Development Co.,Ltd. Address before: 430073 Hubei province Wuhan Dongxin East Lake high tech Development Zone, Road No. 5 Applicant before: Wuhan Hongxin Telecommunication Technologies Co.,Ltd. |
|
TA01 | Transfer of patent application right | ||
GR01 | Patent grant | ||
GR01 | Patent grant |