CN114398244A - Communication system stability evaluation method and device - Google Patents

Communication system stability evaluation method and device Download PDF

Info

Publication number
CN114398244A
CN114398244A CN202111581488.8A CN202111581488A CN114398244A CN 114398244 A CN114398244 A CN 114398244A CN 202111581488 A CN202111581488 A CN 202111581488A CN 114398244 A CN114398244 A CN 114398244A
Authority
CN
China
Prior art keywords
data
preset data
preset
cbss
monitoring index
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202111581488.8A
Other languages
Chinese (zh)
Inventor
周子颖
李张体
杨迪
李瑞玲
高珊珊
季文翀
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
China United Network Communications Group Co Ltd
Original Assignee
China United Network Communications Group Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by China United Network Communications Group Co Ltd filed Critical China United Network Communications Group Co Ltd
Priority to CN202111581488.8A priority Critical patent/CN114398244A/en
Publication of CN114398244A publication Critical patent/CN114398244A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00Error detection; Error correction; Monitoring
    • G06F11/30Monitoring
    • G06F11/34Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment
    • G06F11/3466Performance evaluation by tracing or monitoring
    • G06F11/3495Performance evaluation by tracing or monitoring for systems
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00Error detection; Error correction; Monitoring
    • G06F11/30Monitoring
    • G06F11/34Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment
    • G06F11/3466Performance evaluation by tracing or monitoring
    • G06F11/3476Data logging

Abstract

The invention provides a method and a device for evaluating the stability of a communication system, wherein the method comprises the following steps: receiving a subscription message in Kafka, wherein the Kafka is used for issuing and acquiring operation behavior information of a plurality of data tables in a background database of a centralized service support system cBSS; screening effective data from the subscription message of the Kafka; converting the effective data into first preset data and/or second preset data; and calculating to obtain a corresponding evaluation score according to the first preset data and/or the second preset data so as to evaluate the stability of the cBSS through the evaluation score. The invention can automatically collect the monitoring index of the cBSS of the centralized service support system, and analyze and integrate the monitoring index to obtain the evaluation score reflecting the stability of the cBSS, thereby objectively and rapidly reflecting the operation condition of the cBSS.

Description

Communication system stability evaluation method and device
Technical Field
The present invention relates to the field of communications technologies, and in particular, to a method and an apparatus for evaluating stability of a communication system.
Background
A centralized service Support System (cBSS) is a communication System that centrally manages a core System of a service Support System domain. After the centralized service support system is operated on line, the operation state of the system needs to be monitored, the stability condition of the system operation is obtained, and problems in the system operation are discovered in time.
At present, each monitoring index of the cBSS usually depends on a manual judgment and evaluation mode to find the existing problems, and the manual evaluation result is used as the basis for evaluating the stability of the system.
However, this method is time-consuming and labor-consuming, and requires a plurality of ways to check the system log and the program running status, or to perform comprehensive judgment according to manual experience and other monitoring indexes of the system. Therefore, the whole evaluation process has complicated steps, the evaluation result is easily influenced by subjective factors, the accuracy is not high, and the efficiency is low.
Disclosure of Invention
The invention provides a method and a device for evaluating the stability of a communication system, which are used for automatically acquiring monitoring indexes of a centralized service support system cBSS, analyzing and integrating the monitoring indexes to obtain an evaluation score reflecting the stability of the cBSS, and thus, the running state of the cBSS can be objectively and quickly obtained.
In a first aspect, the present invention provides a method for evaluating stability of a communication system, including:
receiving a subscription message in Kafka, wherein the Kafka is used for issuing and acquiring operation behavior information of a plurality of data tables in a background database of a centralized service support system cBSS;
screening effective data from the subscription message of the Kafka;
converting the effective data into first preset data and/or second preset data;
and calculating to obtain a corresponding evaluation score according to the first preset data and/or the second preset data so as to evaluate the stability of the cBSS through the evaluation score.
Optionally, the screening out valid data from the subscription message of Kafka includes:
receiving subscription information in the Kafka through Storm, filtering the subscription information, and screening out effective data, wherein the subscription information refers to operation behavior information of a plurality of data tables in a background database of the cBSS, and the data tables include: business work list table, conversation detailed list table, the operation behavior information includes: inserting information of the data table and updating information of the data table; the valid data refers to a preset monitoring index for analyzing the stability of the cBSS.
Optionally, the preset monitoring index for analyzing the stability of the cBSS includes: the method comprises the steps of database DBTime, execution time of structured query language SQL sentences, user call ticket pricing process processing time, user call ticket collection process processing time and partition conditions of time periods of call ticket processing processes.
Optionally, before converting the valid data into the first preset data and/or the second preset data, the method further includes:
storing the effective data into a memory database;
and determining a target monitoring index from the memory database, and presenting the target monitoring index in a chart mode.
Optionally, the first preset data refers to a value of a monitoring index of the cBSS in a target time period of each day and a mean value of the monitoring index in the target time period in a preset period obtained through statistics; the second preset data refers to the distribution quantity of the monitoring indexes of the cBSS in each value interval in a preset period.
Optionally, the calculating a corresponding evaluation score according to the first preset data and/or the second preset data includes:
storing the first preset data and/or the second preset data into a memory database;
determining a target monitoring index from the memory database;
and calculating the evaluation score corresponding to the target monitoring index through the first preset data and/or calculating the corresponding evaluation score through the second preset data.
Optionally, a formula for calculating an evaluation score corresponding to the target monitoring index through the first preset data is as follows:
Figure BDA0003426212220000021
in the formula: q is an evaluation score corresponding to the target monitoring index calculated through the first preset data, r is an average value of the target monitoring index in a target time period in a preset period, and c is a value of the target monitoring index in the target time period of the day.
Optionally, a formula for calculating the evaluation score corresponding to the target monitoring index through the second preset data is as follows:
S=normalize(Si+SN)
Si=wi*pi
SN=wN*(1-x0.5)*e-x
in the formula: s is an evaluation score corresponding to the target monitoring index calculated through second preset data, SiIs the basic evaluation score of the ith value interval, i is a natural number more than or equal to 0, SNTo assist in evaluating the score, normaize (S)i+SN) To be Si+SNNormalized to the interval [0,100]Value between, wiIs the weight of the ith value interval, piThe ratio of the number of target monitoring indexes in the ith value interval to the number of target monitoring indexes in the preset period, wNFor auxiliary evaluation of the weight of the score, x is the interval [0,1 ]]A value in between.
Optionally, the method further comprises:
and presenting the evaluation score of the target monitoring index in a chart mode.
In a second aspect, the present invention provides a communication system stability evaluation apparatus, including:
the system comprises a receiving module, a subscription module and a processing module, wherein the receiving module is used for receiving subscription information in Kafka, and the Kafka is used for issuing and acquiring operation behavior information of a plurality of data tables in a background database of a centralized service support system cBSS;
the screening module is used for screening effective data from the subscription message of the Kafka;
the conversion module is used for converting the effective data into first preset data and/or second preset data;
and the evaluation module is used for calculating corresponding evaluation scores according to the first preset data and/or the second preset data so as to evaluate the stability of the cBSS through the evaluation scores.
Optionally, the screening module is specifically configured to:
receiving subscription information in the Kafka through Storm, filtering the subscription information, and screening out effective data, wherein the subscription information refers to operation behavior information of a plurality of data tables in a background database of the cBSS, and the data tables include: business work list table, conversation detailed list table, the operation behavior information includes: inserting information of the data table and updating information of the data table; the valid data refers to a preset monitoring index for analyzing the stability of the cBSS.
Optionally, the preset monitoring index for analyzing the stability of the cBSS includes: the method comprises the steps of database DBTime, execution time of structured query language SQL sentences, user call ticket pricing process processing time, user call ticket collection process processing time and partition conditions of time periods of call ticket processing processes. Optionally, the system further comprises a storage module, configured to store the valid data in a memory database before converting the valid data into first preset data and/or second preset data;
and determining a target monitoring index from the memory database, and presenting the target monitoring index in a chart mode.
Optionally, the first preset data refers to a value of a monitoring index of the cBSS in a target time period of each day and a mean value of the monitoring index in the target time period in a preset period obtained through statistics; the second preset data refers to the distribution quantity of the monitoring indexes of the cBSS in each value interval in a preset period.
Optionally, the evaluation module is specifically configured to:
storing the first preset data and/or the second preset data into a memory database;
determining a target monitoring index from the memory database;
and calculating the evaluation score corresponding to the target monitoring index through the first preset data and/or calculating the corresponding evaluation score through the second preset data.
Optionally, a formula for calculating an evaluation score corresponding to the target monitoring index through the first preset data is as follows:
Figure BDA0003426212220000041
in the formula: q is an evaluation score corresponding to the target monitoring index calculated through the first preset data, r is an average value of the target monitoring index in a target time period in a preset period, and c is a value of the target monitoring index in the target time period of the day.
Optionally, a formula for calculating the evaluation score corresponding to the target monitoring index through the second preset data is as follows:
S=normalize(Si+SN)
Si=wi*pi
SN=wN*(1-x0.5)*e-x
in the formula: s is an evaluation score corresponding to the target monitoring index calculated through second preset data, SiIs the basic evaluation score of the ith value interval, i is a natural number more than or equal to 0, SNTo assist in evaluating the score, normaize (S)i+SN) To be Si+SNNormalized to the interval [0,100]Value between, wiIs the weight of the ith value interval, piThe ratio of the number of target monitoring indexes in the ith value interval to the number of target monitoring indexes in the preset period is calculated,wNfor auxiliary evaluation of the weight of the score, x is the interval [0,1 ]]A value in between.
Optionally, the display device further comprises a display module, configured to: and presenting the evaluation score of the target monitoring index in a chart mode.
In a third aspect, the present invention provides a communication system stability evaluation device, including:
a memory for storing a program;
a processor for executing the program stored by the memory, the processor being configured to perform the method of any of the first aspects when the program is executed.
In a fourth aspect, the present invention provides a computer-readable storage medium comprising: instructions which, when run on a computer, cause the computer to perform the method of any one of the first aspects.
The method and the device for evaluating the stability of the communication system provided by the invention collect the monitoring indexes of the cBSS and store the monitoring indexes in the Kafka; screening effective data from Kafka; converting the effective data into first preset data and/or second preset data; and calculating to obtain a corresponding evaluation score according to the first preset data and/or the second preset data so as to evaluate the stability of the cBSS through the evaluation score. The invention can automatically collect the monitoring index of the cBSS of the centralized service support system, and analyze and integrate the monitoring index to obtain the evaluation score reflecting the stability of the cBSS, thereby objectively and rapidly reflecting the operation condition of the cBSS.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings needed to be used in the description of the embodiments or the prior art will be briefly introduced below, and it is obvious that the drawings in the following description are some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to these drawings without creative efforts.
Fig. 1 is a schematic view of an application scenario of the method for evaluating stability of a communication system according to the present invention;
fig. 2 is a flowchart of a method for evaluating stability of a communication system according to an embodiment of the present invention;
fig. 3 is a flowchart of a method for evaluating stability of a communication system according to a second embodiment of the present invention;
fig. 4 is a schematic structural diagram of a communication system stability evaluation apparatus according to a third embodiment of the present invention;
fig. 5 is a schematic structural diagram of a communication system stability evaluation apparatus according to a fourth embodiment of the present invention;
fig. 6 is a schematic structural diagram of a communication system stability evaluation device according to a fifth embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, but not all, embodiments of the present invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
The terms "first," "second," "third," "fourth," and the like in the description and in the claims, as well as in the drawings, if any, are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used is interchangeable under appropriate circumstances such that the embodiments of the invention described herein are, for example, capable of operation in sequences other than those illustrated or otherwise described herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed, but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.
The technical solution of the present invention will be described in detail below with specific examples. The following several specific embodiments may be combined with each other, and details of the same or similar concepts or processes may not be repeated in some embodiments.
In the following, some terms in the present application are explained to facilitate understanding by those skilled in the art:
1) kafka is a high-throughput distributed publish-subscribe messaging system that can handle all the action flow data in a consumer-scale website. This action (web browsing, searching and other user actions) is a key factor in many social functions on modern networks. These data are typically addressed by handling logs and log aggregations due to throughput requirements. The purpose of Kafka is to unify message processing both online and offline through the parallel loading mechanism of Hadoop, and also to provide real-time consumption through clustering.
2) DB Time is an important index of the parsing performance of an Oracle database in the Time dimension, and the index is decomposed step by step to be positioned on the primary events of wasting resources or resource contention, so that the optimization aim is achieved by reducing the waiting and minimizing the used resources of each request. DB Time (request Time) is DB Wait Time (DB Wait Time) + DB CPU Time (DB CPU service Time).
3) Structured Query Language (SQL), which is a database Query and programming Language for accessing data and querying, updating, and managing relational database systems. SQL statements are one language in which databases are operated.
4) Storm is a free, open-source, distributed, high-fault-tolerance real-time computing system, makes continuous stream computation easy, makes up real-time requirements that Hadoop batch processing cannot meet, and is often used in the fields of real-time analysis, online machine learning, continuous computation, distributed remote invocation, ETL and the like. Therefore, the Storm is used for processing the system data in real time, and the processing is very convenient and fast. And firstly carrying out first-level filtering on the received Kafka message, and further processing the effective message after filtering out the unnecessary message.
Compared with the method for evaluating the stability of the communication system by adopting a manual judgment and evaluation mode to find the problems of the cBSS, the method for evaluating the stability of the communication system has obvious advantages. The existing evaluation method needs to check the system log and the program running state through various modes, or carry out comprehensive judgment by combining other monitoring indexes of the system according to manual experience. Therefore, the whole evaluation process has complicated steps, the evaluation result is easily influenced by subjective factors, the accuracy is not high, and the efficiency is low.
The invention provides a method for evaluating the stability of a communication system, which aims to solve the technical problems in the prior art.
The following describes the technical solutions of the present invention and how to solve the above technical problems with specific embodiments. The following several specific embodiments may be combined with each other, and details of the same or similar concepts or processes may not be repeated in some embodiments. Embodiments of the present invention will be described below with reference to the accompanying drawings.
Fig. 1 is a schematic view of an application scenario of the method for evaluating stability of a communication system according to the present invention, and as shown in fig. 1, firstly, operating data of a centralized service support system cBSS is used as a data source, a monitoring index of the cBSS is obtained according to the operating data, and the monitoring index of the cBSS is stored in Kafka; reading the monitoring indexes in the Kafka by using Storm, filtering and distributing the read monitoring indexes, storing the monitoring indexes into a memory database, and finally, processing and analyzing the target monitoring indexes in the memory database to obtain the evaluation score of the cBSS, wherein the evaluation score is used for evaluating the stability of the cBSS.
Fig. 2 is a flowchart of a method for evaluating stability of a communication system according to an embodiment of the present invention, as shown in fig. 2, the method in this embodiment may include:
and S101, receiving a subscription message in Kafka.
In this embodiment, Kafka is configured to issue operation behavior information of a plurality of data tables in a background database of the bss of the centralized service support system. Kafka is a high-throughput distributed publish-subscribe messaging system that can handle all the action flow data in a consumer-scale website. Easy scale-out while providing high throughput for publishing and subscribing; support multiple subscribers, automatically balance consumers when failing, persist messages to disk, and are thus available for bulk consumption, such as ETL, and real-time applications. Wherein, the monitoring index is as follows: the execution time of the DBTime statement, the execution time of the structured query language SQL statement, the user ticket pricing processing time, the user ticket collection processing time and the ticket processing time partition condition.
S102, screening out effective data from the subscription message of Kafka.
In this embodiment, a Storm may be used to receive a subscription message in Kafka, and filter the subscription message to screen out valid data, where the subscription message refers to operation behavior information of multiple data tables in a background database of the cBSS, and the data tables include: business work list table, conversation detailed list table, the operation behavior information includes: inserting information of the data table and updating information of the data table; the valid data refers to a preset monitoring index for analyzing the stability of the cBSS. And using Storm to process the subscription message read from the Kafka in real time, filtering the subscription message, and filtering out unnecessary monitoring indexes to obtain effective data. Wherein the preset monitoring index for analyzing the stability of the cBSS includes: the method comprises the steps of database DBTime, execution time of structured query language SQL sentences, user call ticket pricing process processing time, user call ticket collection process processing time and partition conditions of time periods of call ticket processing processes.
S103, converting the effective data into first preset data and/or second preset data.
In this embodiment, the valid data is converted into first preset data and/or second preset data in a preset format, where the first preset data is a value of a monitoring index of the cBSS in a target time period of each day, and a statistical average value of the monitoring index in the target time period in a preset period; the second preset data refers to the distribution quantity of the monitoring indexes of the cBSS in each value interval in a preset period. In this embodiment, the form of the first preset data and the second preset data is not limited, and theoretically, the data format may be appropriately adjusted according to the stability evaluation parameter of the cBSS. For example, the peak value of the monitoring index of the cBSS in a preset time period, or the number of times of occurrence of the monitoring index of the cBSS in the target value interval, may also be used.
And S104, calculating corresponding evaluation scores according to the first preset data and/or the second preset data, and evaluating the stability of the cBSS through the evaluation scores.
In this embodiment, the first preset data and/or the second preset data are integrated and analyzed, and a corresponding evaluation score is calculated, so that the stability of the cBSS is evaluated through the evaluation score.
Optionally, storing the first preset data and/or the second preset data in a memory database; determining a target monitoring index from the memory database; and calculating the evaluation score corresponding to the target monitoring index through the first preset data and/or calculating the corresponding evaluation score through the second preset data. The formula for calculating the evaluation score corresponding to the target monitoring index through the first preset data is as follows:
Figure BDA0003426212220000091
in the formula: q is an evaluation score corresponding to the target monitoring index calculated through the first preset data, r is an average value of the target monitoring index in a target time period in a preset period, and c is a value of the target monitoring index in the target time period of the day.
The formula for calculating the evaluation score corresponding to the target monitoring index through the second preset data is as follows:
S=normalize(Si+SN)
Si=wi*pi
SN=wN*(1-x0.5)*e-x
in the formula: sAn evaluation score corresponding to the target monitoring index calculated through the second preset data, SiIs the basic evaluation score of the ith value interval, i is a natural number more than or equal to 0, SNTo assist in evaluating the score, normaize (S)i+SN) To be Si+SNNormalized to the interval [0,100]Value between, wiIs the weight of the ith value interval, piThe ratio of the number of target monitoring indexes in the ith value interval to the number of target monitoring indexes in the preset period, wNFor auxiliary evaluation of the weight of the score, x is the interval [0,1 ]]A value in between.
Optionally, in order to more clearly and intuitively reflect the stability of the communication system, the evaluation score of the target monitoring index may be presented in a graph manner.
Specifically, infiluxdb and grafana architectures can be adopted to realize automatic chart display. Influxdb is an open-source distributed time sequence, time and index database, and granfana is a graphical data display tool of open source, and can customize a data source database, a report, display data and the like.
In the embodiment, by receiving the subscription message in Kafka; screening effective data from the subscription message of the Kafka; converting the effective data into first preset data and/or second preset data; and calculating to obtain a corresponding evaluation score according to the first preset data and/or the second preset data so as to evaluate the stability of the cBSS through the evaluation score. The invention can automatically collect the monitoring index of the cBSS of the centralized service support system, and analyze and integrate the monitoring index to obtain the evaluation score reflecting the stability of the cBSS, thereby objectively and rapidly obtaining the running state of the cBSS.
Fig. 3 is a flowchart of a method for evaluating stability of a communication system according to a second embodiment of the present invention, and as shown in fig. 3, the method in this embodiment may include:
s201, receiving a subscription message in Kafka.
S202, screening out valid data from the subscription message of Kafka.
In this embodiment, the specific implementation processes of step S201 and step S202 refer to the related description in the method shown in fig. 2, and are not described herein again.
And S203, storing the effective data into a memory database.
In this embodiment, a memory database (redis, infiluxdb, or the like) may be used to store valid data, and the data read-write speed of the memory is higher by several orders of magnitude compared to a disk, and the performance of the application can be greatly improved by storing the data in the memory compared with accessing from the disk. The traditional mode of disk data management is abandoned by the memory database, the architecture of all data is redesigned in the memory, and corresponding improvements are made in the aspects of data caching, fast algorithm and parallel operation, so that the data processing speed is much higher than that of the traditional database and is generally more than 10 times higher. Therefore, effective data can be stored better, and the effective data processing efficiency is improved.
And S204, determining a target monitoring index from the memory database, and presenting the target monitoring index in a chart mode.
In this embodiment, the target monitoring index may be selected from the in-memory database first, and the target monitoring index may be presented in a graph manner. For example, the change of the target monitoring index in the preset period is represented in the form of a line graph, so that the obtained graph can be manually analyzed before the evaluation score is calculated, and the operation condition of the cBSS is preliminarily obtained. Specifically, the infiluxdb and the grafana can be used for automatically constructing the monitoring chart, or a monitoring chart interface is established in a html code writing mode, so that the target monitoring index can be displayed. Through the display of the monitoring chart, the system can help the staff judge the system running state through experience, and can also indirectly verify the analysis result of the evaluation score, so that the accuracy of the evaluation result of the communication system is ensured.
And S205, converting the effective data into first preset data and/or second preset data.
And S206, calculating corresponding evaluation scores according to the first preset data and/or the second preset data, and evaluating the stability of the cBSS through the evaluation scores.
In this embodiment, the specific implementation processes of step S205 and step S206 refer to the related description in the method shown in fig. 2, and are not described herein again.
In the embodiment, by receiving the subscription message in Kafka; screening effective data from the subscription message of the Kafka; and storing the effective data into a memory database, determining a target monitoring index from the memory database, and presenting the target monitoring index in a chart mode. In addition, the effective data is converted into first preset data and/or second preset data; and calculating to obtain a corresponding evaluation score according to the first preset data and/or the second preset data so as to evaluate the stability of the cBSS through the evaluation score. The invention can automatically collect the monitoring index of the cBSS of the centralized service support system, present the target monitoring index in a chart mode, and analyze and integrate the monitoring index to obtain the evaluation score reflecting the stability of the cBSS, thereby objectively and rapidly obtaining the running state of the cBSS and ensuring the accuracy of the evaluation result of the communication system.
Fig. 4 is a schematic structural diagram of a communication system stability evaluation apparatus according to a third embodiment of the present invention, and as shown in fig. 4, the apparatus in this embodiment may include:
a receiving module 10, configured to receive a subscription message in Kafka;
the screening module 20 is configured to screen out valid data from the subscription message of Kafka;
the conversion module 30 is configured to convert the valid data into first preset data and/or second preset data;
and the evaluation module 40 is configured to calculate a corresponding evaluation score according to the first preset data and/or the second preset data, so as to evaluate the stability of the cBSS according to the evaluation score.
Optionally, the screening module 20 is specifically configured to:
receiving subscription information in the Kafka through Storm, filtering the subscription information, and screening out effective data, wherein the subscription information refers to operation behavior information of a plurality of data tables in a background database of the cBSS, and the data tables include: business work list table, conversation detailed list table, the operation behavior information includes: inserting information of the data table and updating information of the data table; the valid data refers to a preset monitoring index for analyzing the stability of the cBSS.
Optionally, the preset monitoring index for analyzing the stability of the cBSS includes: the method comprises the steps of database DBTime, execution time of structured query language SQL sentences, user call ticket pricing process processing time, user call ticket collection process processing time and partition conditions of time periods of call ticket processing processes. Optionally, the first preset data refers to a value of a monitoring index of the cBSS in a target time period of each day and a mean value of the monitoring index in the target time period in a preset period obtained through statistics; the second preset data refers to the distribution quantity of the monitoring indexes of the cBSS in each value interval in a preset period.
Optionally, the evaluation module 40 is specifically configured to:
storing the first preset data and/or the second preset data into a memory database;
determining a target monitoring index from the memory database;
and calculating the evaluation score corresponding to the target monitoring index through the first preset data and/or calculating the corresponding evaluation score through the second preset data.
Optionally, a formula for calculating an evaluation score corresponding to the target monitoring index through the first preset data is as follows:
Figure BDA0003426212220000121
in the formula: q is an evaluation score corresponding to the target monitoring index calculated through the first preset data, r is an average value of the target monitoring index in a target time period in a preset period, and c is a value of the target monitoring index in the target time period of the day.
Optionally, a formula for calculating the evaluation score corresponding to the target monitoring index through the second preset data is as follows:
S=normalize(Si+SN)
Si=wi*pi
SN=wN*(1-x0.5)*e-x
in the formula: s is an evaluation score corresponding to the target monitoring index calculated through second preset data, SiIs the basic evaluation score of the ith value interval, i is a natural number more than or equal to 0, SNTo assist in evaluating the score, normaize (S)i+SN) To be Si+SNNormalized to the interval [0,100]Value between, wiIs the weight of the ith value interval, piThe ratio of the number of target monitoring indexes in the ith value interval to the number of target monitoring indexes in the preset period, wNFor auxiliary evaluation of the weight of the score, x is the interval [0,1 ]]A value in between.
Optionally, the display device further comprises a display module, configured to: and presenting the evaluation score of the target monitoring index in a chart mode.
The embodiment may execute the technical solutions in the methods shown in fig. 2 and fig. 3, and the implementation process and the technical effects are similar to those of the methods described above, and are not described herein again.
Fig. 5 is a schematic structural diagram of a communication system stability evaluation apparatus according to a fourth embodiment of the present invention, and as shown in fig. 5, the apparatus in this embodiment may further include, on the basis of the apparatus shown in fig. 4:
the storage module 50 is configured to store the valid data in a memory database before converting the valid data into first preset data and/or second preset data;
and determining a target monitoring index from the memory database, and presenting the target monitoring index in a chart mode.
The embodiment may execute the technical solutions in the methods shown in fig. 2 and fig. 3, and the implementation process and the technical effects are similar to those of the methods described above, and are not described herein again.
Fig. 6 is a schematic structural diagram of a communication system stability evaluation device according to a fifth embodiment of the present invention, and as shown in fig. 6, the communication system stability evaluation device 60 in this embodiment may include:
a processor 61 and a memory 62; wherein:
a memory 62 for storing executable instructions, which may also be a flash (flash memory).
A processor 61 for executing the executable instructions stored in the memory to implement the steps of the method according to the above embodiments. Reference may be made in particular to the description relating to the preceding method embodiment.
Alternatively, the memory 62 may be separate or integrated with the processor 61.
When the memory 62 is a device separate from the processor 61, the electronic terminal 60 may further include:
a bus 63 for connecting the memory 62 and the processor 61.
In addition, embodiments of the present application further provide a computer-readable storage medium, in which computer-executable instructions are stored, and when at least one processor of the user equipment executes the computer-executable instructions, the user equipment performs the above-mentioned various possible methods.
Computer-readable media includes both computer storage media and communication media including any medium that facilitates transfer of a computer program from one place to another. A storage media may be any available media that can be accessed by a general purpose or special purpose computer. An exemplary storage medium is coupled to the processor such the processor can read information from, and write information to, the storage medium. Of course, the storage medium may also be integral to the processor. The processor and the storage medium may reside in an ASIC. Additionally, the ASIC may reside in user equipment. Of course, the processor and the storage medium may reside as discrete components in a communication device.
Those of ordinary skill in the art will understand that: all or a portion of the steps of implementing the above-described method embodiments may be performed by hardware associated with program instructions. The program may be stored in a computer-readable storage medium. When executed, the program performs steps comprising the method embodiments described above; and the aforementioned storage medium includes: various media that can store program codes, such as ROM, RAM, magnetic or optical disks.
Finally, it should be noted that: the above embodiments are only used to illustrate the technical solution of the present invention, and not to limit the same; while the invention has been described in detail and with reference to the foregoing embodiments, it will be understood by those skilled in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some or all of the technical features may be equivalently replaced; and the modifications or the substitutions do not make the essence of the corresponding technical solutions depart from the scope of the technical solutions of the embodiments of the present invention.

Claims (10)

1. A method for evaluating stability of a communication system, comprising:
receiving a subscription message in Kafka, wherein the Kafka is used for issuing and acquiring operation behavior information of a plurality of data tables in a background database of a centralized service support system cBSS;
screening effective data from the subscription message of the Kafka;
converting the effective data into first preset data and/or second preset data;
and calculating to obtain a corresponding evaluation score according to the first preset data and/or the second preset data so as to evaluate the stability of the cBSS through the evaluation score.
2. The method of claim 1, wherein the screening of valid data from the subscription message of Kafka comprises:
receiving subscription information in the Kafka through Storm, filtering the subscription information, and screening out effective data, wherein the subscription information refers to operation behavior information of a plurality of data tables in a background database of the cBSS, and the data tables include: business work list table, conversation detailed list table, the operation behavior information includes: inserting information of the data table and updating information of the data table; the valid data refers to a preset monitoring index for analyzing the stability of the cBSS.
3. The method of claim 2, wherein the preset monitoring criteria for analyzing the stability of the cBSS comprises: the method comprises the steps of database DBTime, execution time of structured query language SQL sentences, user call ticket pricing process processing time, user call ticket collection process processing time and partition conditions of time periods of call ticket processing processes.
4. The method according to claim 1, before converting the valid data into the first preset data and/or the second preset data, further comprising:
storing the effective data into a memory database;
and determining a target monitoring index from the memory database, and presenting the target monitoring index in a chart mode.
5. The method according to claim 1, wherein the first preset data is a value of a monitoring index of the cBSS in a target time period of each day, and a mean value of the monitoring index in the target time period in a preset period obtained through statistics; the second preset data refers to the distribution quantity of the monitoring indexes of the cBSS in each value interval in a preset period.
6. The method according to any one of claims 1 to 5, wherein the calculating a corresponding evaluation score according to the first preset data and/or the second preset data comprises:
storing the first preset data and/or the second preset data into a memory database;
determining a target monitoring index from the memory database;
and calculating the evaluation score corresponding to the target monitoring index through the first preset data and/or calculating the corresponding evaluation score through the second preset data.
7. The method according to claim 6, wherein the formula for calculating the evaluation score corresponding to the target monitoring index through the first preset data is as follows:
Figure FDA0003426212210000021
in the formula: q is an evaluation score corresponding to the target monitoring index calculated through the first preset data, r is an average value of the target monitoring index in a target time period in a preset period, and c is a value of the target monitoring index in the target time period of the day.
8. The method according to claim 6, wherein the formula for calculating the evaluation score corresponding to the target monitoring index through the second preset data is as follows:
S=normalize(Si+SN)
Si=wi*pi
SN=wN*(1-x0.5)*e-x
in the formula: s is an evaluation score corresponding to the target monitoring index calculated through second preset data, SiIs the basic evaluation score of the ith value interval, i is a natural number more than or equal to 0, SNTo assist in evaluating the score, normaize (S)i+SN) To be Si+SNNormalized to the interval [0,100]Value between, wiIs the weight of the ith value interval, piThe ratio of the number of target monitoring indexes in the ith value interval to the number of target monitoring indexes in the preset period, wNFor auxiliary evaluation of the weight of the score, x is the interval [0,1 ]]A value in between.
9. The method of claim 1, further comprising:
and presenting the evaluation score of the target monitoring index in a chart mode.
10. An apparatus for evaluating stability of a communication system, comprising:
the system comprises a receiving module, a subscription module and a processing module, wherein the receiving module is used for receiving subscription information in Kafka, and the Kafka is used for issuing and acquiring operation behavior information of a plurality of data tables in a background database of a centralized service support system cBSS;
the screening module is used for screening effective data from the subscription message of the Kafka;
the conversion module is used for converting the effective data into first preset data and/or second preset data;
and the evaluation module is used for calculating corresponding evaluation scores according to the first preset data and/or the second preset data so as to evaluate the stability of the cBSS through the evaluation scores.
CN202111581488.8A 2021-12-22 2021-12-22 Communication system stability evaluation method and device Pending CN114398244A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202111581488.8A CN114398244A (en) 2021-12-22 2021-12-22 Communication system stability evaluation method and device

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202111581488.8A CN114398244A (en) 2021-12-22 2021-12-22 Communication system stability evaluation method and device

Publications (1)

Publication Number Publication Date
CN114398244A true CN114398244A (en) 2022-04-26

Family

ID=81226836

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202111581488.8A Pending CN114398244A (en) 2021-12-22 2021-12-22 Communication system stability evaluation method and device

Country Status (1)

Country Link
CN (1) CN114398244A (en)

Similar Documents

Publication Publication Date Title
CN109684352B (en) Data analysis system, data analysis method, storage medium, and electronic device
WO2019153487A1 (en) System performance measurement method and device, storage medium and server
CN101635651A (en) Method, system and device for managing network log data
CN105335204A (en) Grey level distribution control method and grey level distribution control device of software program
CN110147470B (en) Cross-machine-room data comparison system and method
CN111881221A (en) Method, device and equipment for customer portrait in logistics service
US20130347127A1 (en) Database management by analyzing usage of database fields
CN110399377A (en) Optimization method, device, electronic equipment and the computer readable storage medium of SQL
CN111382182A (en) Data processing method and device, electronic equipment and storage medium
CN111241059A (en) Database optimization method and device based on database
CN114461644A (en) Data acquisition method and device, electronic equipment and storage medium
CN101778400A (en) Database-based telephone traffic analysis and prediction system and telephone traffic prediction method using same
CN115034512A (en) Process optimization method, system, equipment and computer readable storage medium
US8306953B2 (en) Online management of historical data for efficient reporting and analytics
CN113987086A (en) Data processing method, data processing device, electronic device, and storage medium
CN116089490A (en) Data analysis method, device, terminal and storage medium
CN114398244A (en) Communication system stability evaluation method and device
CN116010380A (en) Data warehouse automatic management method based on visual modeling
CN113722141B (en) Method and device for determining delay reason of data task, electronic equipment and medium
EP4209933A1 (en) Data processing method and apparatus, and electronic device and storage medium
CN114661571A (en) Model evaluation method, model evaluation device, electronic equipment and storage medium
CN114281494A (en) Data full life cycle management method, system, terminal device and storage medium
CN114090686A (en) Account-out acceleration method and device
CN111143328A (en) Agile business intelligent data construction method, system, equipment and storage medium
CN112825165A (en) Project quality management method and device

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