An online monitoring system for multi-level power grid marketing indicators

Abstract

The present invention relates to the technical field of online monitoring systems, and in particular to an online monitoring system for multi-level power grid marketing indicators, which adopts the following steps: S10: establishing an external data source: the data sources of marketing management systems at various levels, the data sources of other systems to be connected, and other external data sources are combined to form an external data source library; S20: establishing a data center: the data center is composed of a TP database and an AP database; S30: establishing an OSS data storage library; S40: the TP database in step S20 is composed of a business processing database and a system support database; it adopts a read-write separation data architecture, and the data center provides one-stop data full life cycle services such as data storage, processing, governance, modeling and analysis that integrates TP-type and AP-type data, so as to achieve seamless integration at the data level and sharing and use at the business level.

Description

Technical Field

[0001] The present invention relates to the technical field of online monitoring systems, and in particular to an online monitoring system for multi-level power grid marketing indicators. Background Art

[0002] Today's society has entered the Internet+ era. With the continuous deepening and advancement of marketing monitoring services, the monitoring and management of business expansion, customer service, and power outages are no longer limited to specific links and nodes, but require the realization of full-process monitoring of the business, and more detailed analysis of relevant indicators and details.

[0003] As various businesses are developed, the initially set indicators need to be continuously adjusted and improved as management requirements change. Therefore, the indicator monitoring of each business can no longer use the fixed threshold model, and dynamic update and self-evaluation of indicators must be achieved. At the same time, the current monitoring indicators are scattered and solidified in different links of the business chain, and no indicator library is formed for management, which is not conducive to maintaining and analyzing the correlation between indicators.

[0004] Currently, four levels of monitoring have been implemented, namely, province, city, district, county, and power supply station, but hierarchical management of the same indicator has not been implemented, and there is a lack of systematic monitoring of indicators. In addition, during the SMS sending process, a large number of invalid numbers lead to a waste of SMS fees, so it is also necessary to analyze the results of SMS sending and gradually improve the effectiveness and accuracy of contact information. Summary of the invention

[0005] The purpose of the present invention is to provide an online monitoring system for multi-level power grid marketing indicators in view of the defects and shortcomings of the prior art.

[0006] The online monitoring system for multi-level power grid marketing indicators described in the present invention adopts the following steps:

[0007] S10: Establishing external data sources: The data sources of marketing management systems at all levels, data sources of other systems to be connected, and other external data sources are combined to form an external data source library;

[0008] S20: Establishing a data center: The data center consists of a TP database and an AP database;

[0009] S30: Establish OSS data repository;

[0010] S40: The TP database in step S20 is composed of a business processing database and a system support database;

[0011] S50: The data center in step S20 and the OSS data repository in step S30 form a data lake storage computing layer;

[0012] S60: Establish component service layer, which consists of data analysis model unit, API application programming interface, and data mining unit;

[0013] S70: Establishing an application layer: consisting of a transactional application unit and an analytical application unit;

[0014] S80: The external data source library in step 10 is connected to the AP database in step 20 through CDC and message middleware;

[0015] S90: The TP database in step S20 is connected to the transactional application unit and the analytical application unit in step S70 through an API application programming interface.

[0016] Furthermore, the business processing database in step S40 is composed of an indicator system management database, a real-time monitoring and early warning database, a business analysis database, and a problem collaboration database.

[0017] Furthermore, the system support database in step S40 is composed of basic business data, a rights management database, a user management database, a log management database and a cache database.

[0018] Furthermore, the AP database in step S20 is connected to the business processing database in the TP database through data extraction and data query.

[0019] Furthermore, the AP data in step S20 is connected to the system support database in the TP database through data extraction and data query.

[0020] The beneficial effects of the present invention are as follows: the online monitoring system for multi-level power grid marketing indicators described in the present invention adopts a read-write separation data architecture, and the data center provides one-stop data life cycle services such as data storage, processing, governance, modeling and analysis that integrates TP type and AP type data, thereby achieving seamless integration at the data level and sharing at the business level, and realizing trusted aggregation of global data, on-demand supply of diversified services, comprehensive driving of business development, and comprehensive protection of data security. BRIEF DESCRIPTION OF THE DRAWINGS

[0021] The drawings described herein are used to provide a further understanding of the present invention and constitute a part of the present application, but do not constitute an improper limitation of the present invention. In the drawings:

[0022] Figure 1 is a topological schematic diagram of the present invention;

[0023] Figure 2 is a topological schematic diagram of a data center of the present invention;

[0024] Figure 3It is a topological schematic diagram of the service components in the present invention. DETAILED DESCRIPTION

[0025] The present invention will be described in detail below in conjunction with the accompanying drawings and specific embodiments, wherein the illustrative embodiments and descriptions are only used to explain the present invention but are not intended to limit the present invention.

[0026] like Figure 1-Figure 2 As shown, the online monitoring system for multi-level power grid marketing indicators described in this specific implementation adopts the following steps:

[0027] S10: Establishing external data sources: The data sources of marketing management systems at all levels, data sources of other systems to be connected, and other external data sources are combined to form an external data source library;

[0028] S20: Establishing a data center: The data center consists of a TP database and an AP database;

[0029] S30: Establish OSS data repository;

[0030] S40: The TP database in step S20 is composed of a business processing database and a system support database;

[0031] S50: The data center in step S20 and the OSS data repository in step S30 form a data lake storage computing layer;

[0032] S60: Establish component service layer, which consists of data analysis model unit, API application programming interface, and data mining unit;

[0033] S70: Establishing an application layer: consisting of a transactional application unit and an analytical application unit;

[0034] S80: The external data source library in step 10 is connected to the AP database in step 20 through CDC and message middleware;

[0035] S90: The TP database in step S20 is connected to the transactional application unit and the analytical application unit in step S70 through an API application programming interface.

[0036] Furthermore, the business processing database in step S40 is composed of an indicator system management database, a real-time monitoring and early warning database, a business analysis database, and a problem collaboration database.

[0037] In the present invention, the indicator system management database serves the monitoring indicator management of the entire marketing business domain, mainly including basic indicator information, indicator dimensions, indicator modules, indicator topics, indicator dimension relationships, indicator module relationships, module topic relationships, indicator algorithms, indicator frequencies, etc., and supports business monitoring and early warning reminder management and other related businesses.

[0038] In the present invention, the real-time monitoring and early warning database stores the result information of indicator monitoring, as well as the real-time calculation indicator information and early warning thresholds, to ensure that the monitoring business data is accurate and the performance is reliable.

[0039] In the present invention, the business analysis database is used for marketing global monitoring and analysis services, and performs data modeling and analysis for services with less real-time requirements, as well as services with relatively large data volumes and relatively resource-intensive analysis and statistics, to ensure performance and high availability.

[0040] In the present invention, the problem collaborative database is a database specially established for collaborative interaction with other systems, such as supervising work orders, synchronizing with APP business interactions, etc., to ensure the cleanliness, performance and high availability of data.

[0041] Furthermore, the system support database in step S40 is composed of basic business data, a rights management database, a user management database, a log management database and a cache database.

[0042] In the present invention, the system supports databases: multiple databases are equipped for supporting services to realize different data storage. The basic business database is used for general business data processing, such as processes, distributed tasks, etc. The authority database supports the authority management of the system; the user management database is specifically used to manage users, as well as user-related interface synchronization, such as 4A services; the log database supports system operation and maintenance monitoring, and saves system operation logs and integrated log data.

[0043] Furthermore, the AP database in step S20 is connected to the business processing database in the TP database through data extraction and data query.

[0044] Furthermore, the AP data in step S20 is connected to the system support database in the TP database through data extraction and data query.

[0045] The architecture technology route of the present invention is as follows:

[0046] (1) This system adopts a read-write separation data architecture, and the data center provides one-stop data life cycle services such as data storage, processing, governance, modeling and analysis that integrate TP and AP data, achieving seamless integration at the data level and sharing at the business level, and realizing trusted aggregation of global data, on-demand supply of multiple services, comprehensive driving of business development, and comprehensive protection of data security. The TP library is responsible for the storage service of system transaction data, the AP library is responsible for the storage service of system analysis data, and the OSS service is responsible for the storage of unstructured data.

[0047] (2) The data in the TP database is aggregated into the relational database and Hbase of the AP database in the data center through CDS data extraction technology, achieving quasi-real-time data synchronization at the minute level to ensure timeliness for real-time monitoring.

[0048] (3) The AP library can be expanded horizontally through big data and cluster technology to achieve storage of massive data, targeting association query and statistical analysis functions.

[0049] The service components in this invention are as follows: This system is mainly used to monitor marketing domain business. According to the principle of microservice splitting in the previous section, based on the actual needs of product operation, combined with the business importance and business coupling, the domain-driven design methodology is used to determine the boundaries of each product, analyze and merge, and finally determine the service component library of this system, such as Figure 3 According to the nature of business processing, each component library can be classified as follows:

[0050] (1) General service applications: Basic business component library: Provides basic service support for other service centers, mainly including workflow support services, task scheduling support services, message notification support, system support and other basic service support capabilities.

[0051] (2) Permission management component library: provides permission management services for the system, mainly including menu permissions, role permissions, user permissions, etc.

[0052] (3) User Management Component Library: Provides support services for the system's user management, mainly including user information management, organization management, user information synchronization, etc.

[0053] The monitoring service application in the present invention is stated as follows:

[0054] (1) Indicator system component library: mainly supports the basic business functions of monitoring various indicators, including indicator basic information management, indicator dimension management, indicator statistical frequency management, indicator classification management, etc.

[0055] (2) Business monitoring component library: mainly supports business functions such as customer service monitoring, business expansion monitoring, metering monitoring, and power outage monitoring for full business monitoring in the marketing domain.

[0056] (3) Early warning and reminder component library: mainly supports the early warning management function of indicator monitoring, including early warning management, reminder management, reminder frequency management, reminder message management and other functions.

[0057] Collaborative service applications in the present invention:

[0058] Problem coordination component library: mainly supports the horizontal interaction between the marketing monitoring platform and other systems, including the application of supervision work orders, work order management tracking, work order archiving, etc.

[0059] This invention is designed to coordinate and solve the company's management problems and improve the company's overall operational performance. Based on the principle of "horizontal coordination, vertical integration, smooth operation, and efficient operation", it is designed to coordinate and solve the business. According to the results of comprehensive monitoring and operational analysis, through communication and coordination, dynamic display and other methods, for the changes, problems and risks in the company's operational management found through monitoring and analysis, relevant departments and units are coordinated to eliminate changes, solve problems, prevent risks, and implement them in place.

[0060] The present invention provides comprehensive online processing for eight aspects of online operations, as stated below:

[0061] (1) Abnormal monitoring and collaborative handling:

[0062] Focusing on the goal of solving the company's management problems and improving the company's overall operational performance, we design coordinated solutions based on the principles of "horizontal collaboration, vertical integration, smooth operation and efficient operation".

[0063] Vertically, the marketing business monitoring platform and the grid management platform are connected; horizontally, professional data interfaces such as marketing, production, measurement, infrastructure, and voltage monitoring are connected to achieve visual linkage between professional management departments.

[0064] Based on the results of comprehensive monitoring and operational analysis, through communication and coordination, dynamic display and other means, we coordinate relevant departments and units to eliminate anomalies, solve problems, prevent risks and implement them in place in response to anomalies, problems and risks in the company's operational management discovered through monitoring and analysis.

[0065] (2) Comprehensive decision analysis:

[0066] Based on daily monitoring indicators and according to actual business needs, we build indicator correlations for customer service, business expansion, meter reading and collection, power outages, etc., build a monitoring decision model, identify anomalies in a certain business domain or a certain topic, extract indicator data to monitor the final results, and notify the responsible unit of the abnormal information through SMS, elink, work orders, etc.

[0067] Conduct a comprehensive analysis of customer service performance indicators, combine and count related indicators, and then conduct weighted statistical analysis on all indicators to finally determine the customer service performance indicators of each unit, and issue relevant notifications to abnormal units.

[0068] (3) Business indicator database: Establish a business indicator database with indicator statistics and display as the core, conduct real-time monitoring of key marketing business indicators, and display the operating status of indicators of different business modules.

[0069] (4) Operational Theme Analysis: Operational analysis theme refers to the process in which monitoring personnel monitor various marketing business processes and indicators from the perspective of corporate value goals, business processes, performance appraisals, and corporate benchmarking.

[0070] (5) Full-process monitoring of the business environment: mainly carries out monitoring and analysis functions on the business environment.

[0071] (6) Customer contact file accuracy analysis: Freely filter the optional time period, and count the number accuracy rate, total number of numbers sent, SMS type, number of number errors, marketing system errors, SMS platform errors, operator errors, and other fields within the time range.

[0072] (7) Customer service full process monitoring: Based on the time limits of different business types and stages of customer service tickets and 95598 tickets, monitor the processing of customer service tickets, provide reminder records, and provide real-time statistics and refresh data functions as well as data editing and saving functions. Generate summary data for reminder details and send them to different levels of objects via SMS.

[0073] (8) Full-process monitoring of power outages: Based on power outage events that have not been restored, real-time monitoring of events that have not been restored within the specified time limit is performed, a fault power outage database is generated, and monitoring and processing functions are provided to business personnel.

[0074] The above description is only a preferred embodiment of the present invention, so all equivalent changes or modifications made according to the features and principles described in the scope of the patent application of the present invention are included in the scope of the patent application of the present invention.

Claims

1. An online monitoring system for multi-level power grid marketing indicators, characterized by: Use the following steps: S10: Establish external data sources: The data sources of marketing management systems at all levels, data sources of other systems to be connected, and other external data sources are combined to form an external data source library; S20: Establishing a data center: The data center consists of a TP database and an AP database; The AP database is connected to the business processing database in the TP database through data extraction and data query; Among them, the TP library is responsible for the storage service of system transaction data, the AP library is responsible for the storage service of system analytical data, and the OSS service is responsible for the storage of unstructured data; S30: Establish OSS data repository; S40: The TP database in step S20 is composed of a business processing database and a system support database; The business processing database consists of an indicator system management database, a real-time monitoring and early warning database, a business analysis database and / or a problem collaboration database; The system support database consists of a basic business database, a rights management database, a user management database, a log management database and / or a cache database; S50: The data center in step S20 and the OSS data repository in step S30 form a data lake storage computing layer; S60: Establish a component service layer, which is composed of a data analysis model unit, an API application programming interface and / or a data mining unit; The detection service application is described as follows: indicator system component library: supports the basic business functions of monitoring various indicators, including indicator basic information management, indicator dimension management, indicator statistical frequency management and / or indicator classification management; business monitoring component library: supports customer service monitoring, business expansion monitoring, metering monitoring and / or power outage monitoring; early warning reminder component library: supports the early warning management function of indicator monitoring, including early warning management, reminder management, reminder frequency management and / or reminder message management functions; S70: Establishing an application layer: consisting of a transactional application unit and an analytical application unit; We conduct comprehensive online processing in eight aspects of online operations: (1) Collaborative handling of abnormal monitoring: vertically connect the marketing business monitoring platform and the grid management platform; horizontally connect the professional data interfaces of marketing, production, metering, infrastructure or voltage monitoring to achieve visual linkage between professional management departments; (2) Comprehensive decision analysis: Based on daily monitoring indicators and according to the actual business needs, we build indicator correlation relationships for customer service, business expansion, meter reading or power outages, and build a monitoring decision model. We identify anomalies in a certain business domain or a certain topic, extract indicator data for final result monitoring, and notify the responsible unit of the anomaly information through SMS, elink or work order. We conduct a comprehensive analysis of customer service performance indicators, combine and count the related indicators, and then conduct a weighted statistical analysis of all indicators to finally determine the customer service performance indicators of each unit and notify the abnormal unit. (3) Business indicator library: Establish a business indicator library with indicator statistics and display as the core, conduct real-time monitoring of key indicators of marketing business, and display the operation status of indicators of different business modules; (4) Operational theme analysis: Operational analysis theme refers to the process in which monitoring personnel monitor various marketing business processes and indicators from the perspective of corporate value goals, business processes, performance appraisals, and / or corporate benchmarking; (5) Full-process monitoring of the business environment: mainly focusing on monitoring and analyzing the business environment; (6) Customer contact file accuracy analysis: Freely select a time period to count the number accuracy rate, total number of numbers sent, SMS type, number of number errors, marketing system errors, SMS platform errors, and / or operator error fields within the time period; (7) Customer service full process monitoring: Based on the time limits of different business types and stages of customer service tickets and 95598 tickets, monitor the processing of customer service tickets, provide reminder records, and provide real-time statistics and data refresh functions as well as data editing and saving functions; generate summary data for reminder details and send it to different levels of objects via SMS; (8) Full-process monitoring of power outages: Based on power outage events that have not been restored due to power failures, real-time monitoring of events that have not been restored within the specified time limit is performed, a fault power outage database is generated, and monitoring and processing functions are provided to business personnel; S80: The external data source library in step 10 is connected to the AP database in step 20 through CDC and message middleware; S90: The TP database in step S20 is connected to the transactional application unit and the analytical application unit in step S70 through an API application programming interface.

Images