CN113918569A - Visual operation and maintenance management system for power supply network - Google Patents

Visual operation and maintenance management system for power supply network Download PDF

Info

Publication number
CN113918569A
CN113918569A CN202111246213.9A CN202111246213A CN113918569A CN 113918569 A CN113918569 A CN 113918569A CN 202111246213 A CN202111246213 A CN 202111246213A CN 113918569 A CN113918569 A CN 113918569A
Authority
CN
China
Prior art keywords
data
unit
module
management
message
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
CN202111246213.9A
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.)
Shenzhen Power Supply Bureau Co Ltd
Original Assignee
Shenzhen Power Supply Bureau 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 Shenzhen Power Supply Bureau Co Ltd filed Critical Shenzhen Power Supply Bureau Co Ltd
Priority to CN202111246213.9A priority Critical patent/CN113918569A/en
Publication of CN113918569A publication Critical patent/CN113918569A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22Indexing; Data structures therefor; Storage structures
    • G06F16/2282Tablespace storage structures; Management thereof
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/27Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/28Databases characterised by their database models, e.g. relational or object models
    • G06F16/284Relational databases
    • G06F16/285Clustering or classification
    • G06F16/287Visualization; Browsing

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Computing Systems (AREA)
  • Software Systems (AREA)
  • Computational Linguistics (AREA)
  • Information Transfer Between Computers (AREA)

Abstract

The invention discloses a visual operation and maintenance management system for a power supply network, which comprises an operation and maintenance management module, a monitoring module, an intelligent terminal module and a marketing interface module, wherein the monitoring module, the intelligent terminal module and the marketing interface module are connected with the operation and maintenance management module; wherein: the operation and maintenance management module is used for calling the data of the marketing interface module of the power supply network to perform operation and maintenance management processing; the monitoring module is used for analyzing the operation and maintenance management data obtained by the operation and maintenance management module and carrying out visual processing; the intelligent terminal module is used for displaying the operation and maintenance management data of the operation and maintenance management module on the intelligent terminal side after being processed by the visualization module; and the marketing interface module is used for obtaining the power supply network data related to the marketing system. By implementing the invention, the operation and maintenance management content can be visualized, and the efficiency and intuition of the operation and maintenance management are improved.

Description

Visual operation and maintenance management system for power supply network
Technical Field
The invention relates to the technical field of visual operation and maintenance management, in particular to a visual operation and maintenance management system.
Background
The power dispatching data network is used as a basic support system for power grid operation, and provides safe and reliable real-time signals and data for 'secondary' related services such as relay protection, dispatching, automation, communication, monitoring and the like.
The prior art has the following defects and shortcomings: with the continuous expansion of the data network scale, the maintenance and management work of the communication network and the data network equipment is increasingly complex, and the service department puts higher requirements on the operation and maintenance efficiency and quality of the scheduling data network.
Disclosure of Invention
The invention aims to provide a visual operation and maintenance management system for a power supply network, which can realize visualization of operation and maintenance management contents and improve the efficiency and intuition of operation and maintenance management.
In order to solve the technical problem, in one aspect of the present invention, there is provided 1 a visual operation and maintenance management system for a power supply network, which is characterized by comprising an operation and maintenance management module, and a monitoring module, an intelligent terminal module and a marketing interface module which are connected to the operation and maintenance management module; wherein:
the operation and maintenance management module is used for calling data of a marketing interface module of a power supply network to perform operation and maintenance management processing and comprises an access log module and an interface calling module;
the monitoring module is used for analyzing the operation and maintenance management data obtained by the operation and maintenance management module and performing visual processing, and comprises a server module and a visual module;
the intelligent terminal module is used for displaying operation and maintenance management data of the operation and maintenance management module on the intelligent terminal side after being processed by the visualization module, and also comprises a terminal configuration module and a terminal distribution module;
the marketing interface module is used for obtaining power supply network data related to a marketing system and comprises a user file module, an electric bill module, a payment history module, an arrearage inquiry and payment module, a service handling module, an electronic invoice module and a power failure information module.
Preferably, the visualization module further comprises:
the system comprises a visualization capacity management unit, a visualization enabling management unit, a PC visualization display management unit, a mobile terminal visualization display management unit, a large screen terminal visualization display management unit, a large data acceleration analysis capacity unit, a data bus capacity unit and a system foundation management unit.
Preferably, the visualization capability management unit includes at least:
the data source management unit is used for a user to self-define a data source on the visual capability platform and support the relational database as the data source; meanwhile, an accelerated analysis engine is supported to serve as a data source;
the data set management unit is used for supporting importing of a data source, writing sql to form a data view and multiplexing a data set;
the data set dimension definition management unit is used for selecting related columns based on a data set, and defining the related columns as data dimensions, supporting alias setting, supporting multi-level dimension definition and supporting data filter setting;
the data set index definition management unit is used for selecting related columns to be defined as data indexes based on a data set, supporting alias setting and supporting data filter setting;
the data set aggregation expression definition management unit is used for supporting the calculation after aggregation of a plurality of data columns and realizing the dynamic calculation of complex data indexes through an aggregation expression;
the data set enumeration management unit is used for supporting the query of relevant data table fields in a data source in a configuration sql mode and forming the definition of data enumeration by specifying a key column and a value column; and during the chart definition, the names corresponding to the data are displayed on the final interface through the enumeration of the associated dimensions.
Preferably, the visualization enabling management unit further comprises:
the data service unit is used for supporting the definition of data opening permission in the background, including application and data authorization, and allowing the data to be accessed in a secure mode from the outside by defining the data and the access permission;
the widget data service unit is used for realizing the open API access of single-chart multi-dimensional analysis visual data based on the data service of the widget; accessing data in a well-defined visual multidimensional data format to the platform through the third application after authorization;
the data list data service unit is used for providing data services in a data table format, including original data, metadata and the like of the data table, and supporting paging loading services; and after authorization, the third application access platform defines data table data.
Preferably, the PC-side visualization capability display unit further comprises a data billboard basic function unit and a widget basic function unit,
the data billboard basic functional unit further comprises:
the data billboard icon linkage unit is used for automatically refreshing the data and the charts in a linkage manner by the operation of a user on a single chart when the analysis dimensions of the charts of the data billboard of the same data are the same or related;
the data billboard full-screen viewing unit is used for supporting full-screen viewing, and in a full-screen state, the system hides a browser and an irrelevant toolbar and menu of the system interface;
the data billboard main body switching unit is used for switching between at least two data billboard themes;
a multi-expense supporting unit of the data billboard window for supporting the simultaneous opening of a plurality of data billboards
The widget base function unit further includes:
the data export function unit is used for supporting export of a data list for all charts and batch export;
the icon data export unit is used for supporting exporting the graph loaded with the data into a picture;
the abnormal data filtering unit is used for selecting display or non-display of the abnormal data in the chart and preventing the abnormal data from influencing the normal display of the chart;
and the icon conference unit is used for supporting a conference mode of full screen viewing for a single chart, wherein in the conference mode, the chart is adaptively amplified, and switching to the next chart in the data billboard is supported without exiting the full screen mode.
Preferably, the big data accelerated analysis capability unit at least comprises:
the bidirectional synchronization unit of the relational database and the acceleration platform is used for supporting bidirectional synchronization of the relational database and the acceleration platform, and the relational database is mysql, oracle, sqlServer or postgreSQL;
the bidirectional synchronization unit of the nosql database and the acceleration platform is used for supporting bidirectional synchronization of the nosql database and the acceleration platform, and the nosql database is hbase, mongoDb or hive;
the bidirectional synchronization unit of the file type data and acceleration platform is used for supporting bidirectional synchronization of a data file and the acceleration platform, and the data file is in a format of TxtFile and HDFS;
and the message bus message and acceleration platform synchronization unit is used for supporting the synchronization of the data bus data message.
Preferably, the data bus capability unit further comprises a data message management unit and a data message engine unit,
the data message management unit is used for supporting the theme of data message management and enabling consumers of the data message to receive the messages in a multithread parallel mode through multiple designated partitions;
wherein the data message engine unit further comprises:
unified data message management unit: the message processing system is used for encapsulating the change events of adding, modifying and deleting data into a uniform message format;
the data bus kernel engine unit is used for realizing the functions of decoupling data production and consumption, processing redundancy and dynamic expansion based on a distributed and high-throughput message engine;
the data bus message service engine unit is used for processing the reliability of the data message, and the data message can be restored and the sequence is ensured;
a data message SDK unit for providing friendly api and SDK packaging for consumption of data messages.
Preferably, the system base management unit further includes a system management unit and an application management unit, wherein:
the system management unit is used for realizing the system functions of visual platform end user and organization management, authority management, system configuration management, basic service monitoring and operation log management;
the application management unit further includes:
the application version management unit is used for supporting the management of the release package and the upgrade of the mobile client, and comprises version number management, version package resource management and upgrade service management functions;
the application message management unit is used for supporting manual message pushing of a mobile terminal in the rear or dispatching and pushing of the message to a user by a task according to an interface; providing material management, and graphic and text message management.
The implementation of the invention has the following beneficial effects:
the invention provides a visual operation and maintenance management system for a power supply network, which is characterized in that a visual capacity management unit, a visual enabling management unit and a PC (personal computer) end visual capacity display unit are arranged, and the data visualization function effect of terminals such as a large screen and a PC (personal computer) is realized through the visual capacity management unit, the visual enabling management unit and the PC visual display management unit;
in the embodiment of the invention, by arranging the big data accelerated analysis capability unit and the data bus capability unit and providing friendly api and sdk packaging for consumption of data messages, the application end can monitor the data messages and acquire data contents only by simply calling according to sdk, thereby achieving the effect of monitoring daily operation of the application server and the data server during implementation;
in the embodiment of the invention, the visual basic management unit is arranged, and the effects of adjusting and maintaining the server platform during the implementation period and daily maintenance are achieved by providing material management and image-text message management; the embodiment of the invention improves the efficiency and intuition of operation and maintenance management.
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 introduced below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and it is within the scope of the present invention for those skilled in the art to obtain other drawings based on the drawings without inventive exercise.
Fig. 1 is a schematic structural diagram of an embodiment of a visualized operation and maintenance management system for a power supply network provided by the present invention;
FIG. 2 is a schematic structural diagram of the marketing interface module of FIG. 1;
FIG. 3 is a schematic structural diagram of the visualization module of FIG. 1;
FIG. 4 is a schematic structural diagram of the visualization capability management unit in FIG. 3;
FIG. 5 is a schematic diagram of the configuration of the visual energization management unit of FIG. 3;
FIG. 6 is a schematic structural diagram of a visualization capability display unit at the PC side in FIG. 3;
FIG. 7 is a schematic diagram of the big data accelerated analysis capability unit shown in FIG. 3;
FIG. 8 is a block diagram of a data bus capability unit of FIG. 3;
fig. 9 is a schematic structural diagram of the system infrastructure management unit in fig. 3.
Detailed Description
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 only a part of the embodiments of the present invention, and not all of the embodiments. 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.
Fig. 1 is a schematic structural diagram illustrating an embodiment of a visualized operation and maintenance management system for a power supply grid according to the present invention. Referring to fig. 2 to 9 together, in the present embodiment, the system includes: the system comprises an operation and maintenance management module 1, and a monitoring module 2, an intelligent terminal module 3 and a marketing interface module 4 which are connected with the operation and maintenance management module 1.
The operation and maintenance management module 1 is used for calling data of a marketing interface module of a power supply network to perform operation and maintenance management processing, and further comprises: an access log module 10 and an interface calling module 11;
the monitoring module 2 is configured to analyze the operation and maintenance management data obtained by the operation and maintenance management module, and perform visualization processing, and further includes: an application server and data server module 20 and a visualization module 21;
the intelligent terminal module 3 is used for displaying the operation and maintenance management data of the operation and maintenance management module on the intelligent terminal side after being processed by the visualization module, and further comprises: a terminal configuration module 30 and a terminal distribution module 31;
the marketing interface module 4 is used for obtaining power supply network data related to a marketing system, and further comprises a user profile module 40, an electric bill module 41, a payment history module 42, a arrearage inquiry and payment module 43, a service handling module 44, an electronic invoice module 45 and a power failure information module 46.
More specifically, in one example, as shown in fig. 3, the visualization module 21 further includes: the system comprises a visualization capacity management unit 210, a visualization enabling management unit 211, a PC visualization display management unit 212, a mobile terminal visualization display management unit 213, a large screen terminal visualization display management unit 214, a large data acceleration analysis capacity unit 215, a data bus capacity unit 216 and a system foundation management unit 217.
As shown in fig. 4, the visualization capability management unit 210 further includes:
the data source management unit 2100 is configured to allow a user to customize a data source on the visualization capability platform, and support a relational database as the data source, such as mysql, oracle, and the like; meanwhile, an accelerated analysis engine is supported to serve as a data source;
the data collection management unit 2101 is used for supporting importing of a data source and writing sql to form a data view; by multiplexing the data sets, repeated filling of query scripts and new establishment of an aggregation expression during different report designs under the same data set are reduced; the data set is a unified data view, the same mode of a Cube is realized, and a query can be defined in advance to form a multidimensional analysis data set;
a data set dimension definition management unit 2102 configured to select a relevant column based on a data set, and define the relevant column as a data dimension; supporting alias setting and multi-level dimension definition; supporting data filter settings; wherein, the Dimension (Dimension) is the description data, which is a kind of angle for observing data, and refers to the descriptive attribute or characteristic of the object that can specify different values;
a data set index definition management unit 2103, configured to select a related column definition as a data index based on a data set, support alias setting, and support data filter setting; the indexes are also called metrics and are measurement data, and the indexes refer to specific dimension elements which can be measured according to the total number or the ratio;
the data set aggregation expression definition management unit 2104 is configured to support recalculation after aggregation of multiple data columns, for example, sum (columna)/count (columb), and complex dynamic calculation of data indexes can be achieved through aggregation expressions;
the data set enumeration management unit 2105: the method is used for supporting the query of relevant data table fields in a data source in an sql configuration mode and forming the definition of data enumeration by specifying key columns and value columns; during diagram definition, names corresponding to data are displayed on a final interface through enumeration of associated dimensions, and user experience is optimized.
As shown in fig. 5, the visualization enabling management unit 221 further includes:
the data service unit 2110 is used for supporting definition of data opening permission in a background, including application and data authorization, and allowing data to be accessed in a secure mode from the outside by defining the data and the access permission;
the widget data service unit 2111 is used for realizing open API access of single-chart multi-dimensional analysis visual data based on data service of widgets, and the data service comprises dimensions, dimension enumeration, indexes and metadata thereof; after authorization, the third application can access data in a visual multidimensional data format defined by the platform, and the third application only needs to customize and quickly realize a visual display layer as required;
the data list data service unit 2112 is used for providing data services in a data table format, including data table raw data, metadata and the like, and supporting paging loading services; the third application may access the platform-defined data table data after authorization.
As shown in fig. 6, the PC-side visualization capability display unit 212 further includes a data billboard basic function unit 2120 and a widget basic function unit 2121, wherein:
the data billboard base function unit 2120 further includes:
the data billboard icon linkage unit 2122 is used for automatically refreshing the data and the charts in a linkage manner by the operation of a user on a single chart when the analysis dimensions of the charts of the data billboard with the same data are the same or related;
a full screen viewing unit 2123 of the data billboard, which is used for supporting full screen viewing, and in a full screen state, the system hides the browser and irrelevant toolbars and menus of the system interface, so that the user can pay more attention to the subject service analysis; full screen viewing may also be used for conference presentation;
a data billboard main body switching unit 2124 for switching between at least two data billboard themes; the system supports two data billboard themes, one is in a classic white style, and is mainly used for business personnel in an office environment to perform multidimensional analysis on business themes and locate business problems; one is a deep color style and is mainly used for data display in a demonstration mode; the background, foreground color, font and other visual contents of all elements such as system menus, toolbars, charts and the like in the two styles are clearly visible, and the overall matching is harmonious and attractive;
the data billboard window multi-expense supporting unit 2125 is used for supporting simultaneous opening of a plurality of data billboards, so that comparison of a plurality of subject contents is facilitated, and a user can switch the data billboard randomly and batch the current panel or all panels on the right side of the current panel;
the widget base function unit 2121 further includes:
the data export function unit 2126 is used for supporting the data list viewing of all charts, supporting data export and supporting batch export of large-data-volume data lists;
an icon data export unit 2127, configured to support exporting the graph after the data is loaded as a picture; the user can conveniently make an offline report and the like;
an abnormal data filtering unit 2128, configured to select display or non-display of abnormal data in the graph, so as to prevent the abnormal data from affecting normal display of the graph;
an iconic conferencing unit 2129 for supporting a full screen viewing conferencing mode for a single chart, in which the chart is adaptively zoomed in and switching to the next chart in the data slate is supported without exiting full screen mode.
As shown in fig. 7, the big data accelerated analysis capability unit 215 further includes:
the bidirectional synchronization unit 2150 of the relational database and the acceleration platform is used for supporting bidirectional synchronization of the relational database and the acceleration platform, and comprises mysql, oracle, sql server, postgreSql and the like;
the bidirectional synchronization unit 2151 of the nosql database and the acceleration platform is used for supporting bidirectional synchronization of the nosql database and the acceleration platform, and comprises hbase, mongoDb and hive;
the bidirectional synchronization unit 2152 of the file type data and acceleration platform is used for supporting bidirectional synchronization of the data file and the acceleration platform, and comprises formats such as TxtFile and HDFS;
the message bus message and acceleration platform synchronization unit 2153 is configured to support synchronization of data bus messages, and the acceleration analysis platform may subscribe to data from the data bus.
As shown in fig. 8, the data bus capability unit 216 further includes a data message management unit 2160 and a data message engine unit 2161.
The data message management unit 2160 is used for supporting the management of the Topic (Topic) of the data message, and can specify the number of partitions (participation) of the Topic, and by specifying multiple partitions, consumers of the data message can receive the messages in a multithread manner;
wherein the data message engine unit 2161 further comprises:
the unified data message management unit 2164 is used for encapsulating the new, modified and deleted change events of the data into a unified message format, shielding database information and facilitating unified use of a data consumer, wherein the unified message format is provided with Namespace, scheme self-description information and version information, is a self-positioning self-interpretation message protocol format, can automatically sense the change and adjust the version number of the scheme and facilitates the dynamic processing of the change of the data version by the message consumer;
the data bus kernel engine unit 2166 is used for realizing the functions of data production and consumption decoupling, processing redundancy, dynamic expansion and the like based on a distributed and high-throughput message engine; data production and consumption are decoupled: allowing independent extension or modification of production and consumption processes, subject only to passing unified data message format constraints; processing redundancy: the data bus persists data messages until they have been completely processed, avoiding the risk of data loss; and (3) dynamic expansion: through the bus decoupling processing process, the kernel can support the increase of the frequency of message enqueuing and processing;
a data bus message service engine unit 2167 for processing data message reliability, including data message recoverability and sequence assurance; the data message can be recovered: the data bus reduces the coupling degree between processes, and when the process for processing the data message is invalid, the data message can still be processed after the system is recovered; the order of the data messages guarantees: due to the order requirements of data processing; the data bus kernel can support that data can be processed according to a specific sequence;
the data message SDK unit 2168 is used for providing friendly api and SDK package for consumption of data messages, and the application end can realize monitoring of the data messages and acquire data contents only by simple calling according to SDK.
As shown in fig. 9, the system infrastructure management unit 217 further includes a system infrastructure management unit 2170 and an application management unit 2171. Wherein:
the system basic management unit 2170 is used for realizing system functions including visual platform end user and organization management, authority management, system configuration management, basic service monitoring, operation log management and the like;
the application management unit 2171 further includes:
the application version management unit 2172 is configured to support management of a release package and upgrade of a mobile client, and includes functions of version number management, version package resource management, upgrade service management, and the like;
the application message management unit 2173 is configured to support manual pushing of a message to a mobile terminal in the back, or scheduling of a push message to a user by a task according to an interface; providing material management, and graphic and text message management.
In summary, the data visualization function effect of the terminals such as large screen and PC is realized through the visualization capacity management unit, the visualization enabling management unit and the PC visualization display management unit, and through providing friendly api and sdk packaging for consumption of data messages, the application end can monitor the data messages and acquire data contents only through simple calling according to sdk, so that the effect of monitoring the daily operation of the application server and the data server during implementation is achieved, and the effects of tuning the server platform and performing daily maintenance during implementation are achieved by providing material management and image-text message management.
The invention provides a visual operation and maintenance management system, which can support a relational database as a data source, such as mysql, oracle and the like, by customizing the data source on a visual capability platform by a user when in use; meanwhile, an accelerated analysis engine is supported to serve as a data source, a data set is a unified data view, the same mode of a Cube is achieved, a query can be defined in advance to form a multidimensional analysis data set, data set management support is led in the data source, and sql is compiled to form the data view; by multiplexing the data set, repeated filling of query scripts and new establishment of a polymerization expression work during different report designs under the same data set are reduced, and data Dimension (Dimension) is explanatory data which is an angle for observing data and is descriptive attributes or characteristics of objects with different values can be specified; data dimension definition is based on a data set, and related columns are selected and defined as data dimensions; supporting alias setting and multi-level dimension definition; the method comprises the following steps of supporting data filter setting, wherein indexes are also called measurement and are measurement data, and the indexes refer to specific dimension elements which can be measured according to total number or ratio; the data index definition is based on a data set, a related column is selected to be defined as a data index, alias setting is supported, data filter setting is supported, an aggregation expression supports multiple data columns to be aggregated and then calculated, for example, sum (columna)/count (columb), complex dynamic calculation of the data index can be realized through the aggregation expression, a related data table field in a data source is inquired through configuring an sql mode, and a definition of data enumeration is formed through specifying a key column and a value column; during diagram definition, names corresponding to data are displayed on a final interface through enumeration of associated dimensions, user experience is optimized, data opening permission is defined in a background in cooperation with data service management support, application and data authorization is included, data access in an external safety mode is allowed through data and access permission definition, and open API access of single-diagram multi-dimensional analysis visual data, including data service of dimensions, dimension enumeration, indexes and metadata, is achieved through data service based on widgets; after authorization, the third application can access data in a visual multidimensional data format defined by the platform, and the third application only needs to customize and quickly realize a visual display layer as required, provides data services in a data table format, including data table original data, metadata and the like, and supports paging loading services; after authorization, a third application can be accessed to the platform to define that the analysis dimensions of the data table data and the graphs of the data boards of the same data are the same or related, a user operates a single graph to automatically refresh the data and the graphs in a mutual interaction manner, the data boards support full-screen viewing, and in a full-screen state, a system hides a browser and irrelevant toolbars and menus of the system interface, so that the user can pay more attention to the theme business analysis; the full screen viewing can also be used for conference demonstration, the system supports two data billboard themes, one is a classic white style, and the system is mainly used for business personnel in an office environment to perform multi-dimensional analysis on business themes and locate business problems; one is a deep color style and is mainly used for data display in a demonstration mode; the visual contents of backgrounds, foreground colors, fonts and the like of all elements such as system menus, toolbars, charts and the like under two styles are all clearly visible, the overall collocation is harmonious and beautiful, a plurality of data signboards are supported to be opened simultaneously, comparison of a plurality of theme contents is facilitated, a user can switch the data signboards randomly, all panels on the right side of a batch current panel or the current panel are supported, all charts support viewing of a data list and data export, batch export is supported for a data list with large data quantity, and graphs after data loading are exported to be pictures; the method is convenient for users to make off-line reports and the like, can support display or non-display of abnormal data in the chart, prevents the abnormal data from influencing the normal display of the chart, supports a conference mode of full-screen viewing by a single chart, adaptively amplifies the chart in the conference mode, supports switching to the next chart in a data billboard without exiting the full-screen mode, achieves the effect of realizing the data visualization function of terminals such as a large screen and a PC by adopting a visualization capacity management unit, a visualization enabling management unit and a PC visualization display management unit, supports the bidirectional synchronization of a relational database and an acceleration platform, comprises mysql, oracle, sqlServer, postgreSql and the like, supports the bidirectional synchronization of data files and the acceleration platform, comprises formats such as TxtFile, HDFS and the like, supports the synchronization of data bus data messages, and the acceleration analysis platform can subscribe data from a data bus to support the theme (Topic) of management data messages, meanwhile, the number of partitions (parities) of the theme can be designated, consumers of the data message can receive the message in a multithread parallel manner by designating multiple partitions, the management of the theme (Topic) of the data message is supported, the number of partitions (parities) of the theme can be designated, the consumers of the data message can receive the message in a multithread parallel manner by designating multiple partitions, the adding, modifying and deleting change events of the data are encapsulated into a uniform message format, the database information is shielded, the uniform message format is convenient for the uniform use of data consumers, the uniform message format is provided with Namespace and scheme self-description information and version information, the self-positioning self-interpretation message protocol format is a self-positioning self-interpretation message protocol format, the change adjustment version number of the scheme can be automatically sensed, the change of the data version can be dynamically processed by the message side, the adding, modifying and deleting change events of the data are encapsulated into a uniform message format, and the database information is shielded, the data bus kernel engine realizes the functions of data production and consumption decoupling, processing redundancy, dynamic expandability and the like based on a distributed and high-throughput message engine; data production and consumption are decoupled: allowing independent extension or modification of production and consumption processes, subject only to passing unified data message format constraints; processing redundancy: the data bus persists data messages until they have been completely processed, avoiding the risk of data loss; and (3) dynamic expansion: through the bus decoupling processing process, the kernel can support the increase of the frequency of message enqueuing and processing, and the message service engine mainly processes the reliability of data messages, including data message restorability and sequence guarantee; the data message can be recovered: the data bus reduces the coupling degree between processes, and when the process for processing the data message is invalid, the data message can still be processed after the system is recovered; the order of the data messages guarantees: due to the order requirements of data processing; the data bus kernel can support data to be processed according to a specific sequence, friendly api and sdk packaging are provided for consumption of data messages, monitoring of the data messages can be achieved only by simply calling the data messages according to sdk by an application end, data contents are obtained, and therefore the effect of daily operation monitoring of an application server and the data server during implementation is achieved, the effects include system functions of visual platform end user and organization management, authority management, system configuration management, basic service monitoring, operation log management and the like, management of issuing packages and upgrading of a mobile client is supported, functions of version number management, version package resource management, upgrading service management and the like are supported, manual message pushing is supported to the mobile end at the back, or messages are pushed to a user by task scheduling according to an interface; and material management and image-text message management are provided, so that the effects of server platform tuning and daily maintenance during implementation are achieved.
The implementation of the invention has the following beneficial effects:
the invention provides a visual operation and maintenance management system for a power supply network, which is characterized in that a visual capacity management unit, a visual enabling management unit and a PC (personal computer) end visual capacity display unit are arranged, and the data visualization function effect of terminals such as a large screen and a PC (personal computer) is realized through the visual capacity management unit, the visual enabling management unit and the PC visual display management unit;
in the embodiment of the invention, by arranging the big data accelerated analysis capability unit and the data bus capability unit and providing friendly api and sdk packaging for consumption of data messages, the application end can monitor the data messages and acquire data contents only by simply calling according to sdk, thereby achieving the effect of monitoring daily operation of the application server and the data server during implementation;
in the embodiment of the invention, the visual basic management unit is arranged, and the effects of adjusting and optimizing the server platform and performing daily maintenance during the implementation period are achieved by providing material management and image-text message management.
While the invention has been described in connection with what is presently considered to be the most practical and preferred embodiment, it is to be understood that the invention is not to be limited to the disclosed embodiment, but on the contrary, is intended to cover various modifications and equivalent arrangements included within the spirit and scope of the appended claims.

Claims (8)

1. A visual operation and maintenance management system for a power supply network is characterized by comprising an operation and maintenance management module, a monitoring module, an intelligent terminal module and a marketing interface module, wherein the monitoring module, the intelligent terminal module and the marketing interface module are connected with the operation and maintenance management module; wherein:
the operation and maintenance management module is used for calling the data of the marketing interface module of the power supply network to perform operation and maintenance management processing and comprises an access log module and an interface calling module;
the monitoring module is used for analyzing the operation and maintenance management data obtained by the operation and maintenance management module and performing visual processing, and comprises a server module and a visual module;
the intelligent terminal module is used for displaying operation and maintenance management data of the operation and maintenance management module on the intelligent terminal side after being processed by the visualization module, and also comprises a terminal configuration module and a terminal distribution module;
the marketing interface module is used for obtaining power supply network data related to a marketing system and comprises a user file module, an electric bill module, a payment history module, an arrearage inquiry and payment module, a service handling module, an electronic invoice module and a power failure information module.
2. The system of claim 1, wherein the visualization module further comprises:
the system comprises a visualization capacity management unit, a visualization enabling management unit, a PC visualization display management unit, a mobile terminal visualization display management unit, a large screen terminal visualization display management unit, a large data acceleration analysis capacity unit, a data bus capacity unit and a system foundation management unit.
3. The system according to claim 2, characterized in that the visualization capability management unit comprises at least:
the data source management unit is used for a user to self-define a data source on the visual capability platform and support the relational database as the data source; meanwhile, an accelerated analysis engine is supported to serve as a data source;
the data set management unit is used for supporting importing of a data source, writing sql to form a data view and multiplexing a data set;
the data set dimension definition management unit is used for selecting related columns based on a data set, defining the related columns as data dimensions, and supporting alias setting, multi-level dimension definition and data filter setting;
the data set index definition management unit is used for selecting related columns to be defined as data indexes based on a data set, supporting alias setting and supporting data filter setting;
the data set aggregation expression definition management unit is used for supporting the calculation after aggregation of a plurality of data columns and realizing the dynamic calculation of complex data indexes through an aggregation expression;
the data set enumeration management unit is used for supporting the query of relevant data table fields in a data source in a configuration sql mode and forming the definition of data enumeration by specifying a key column and a value column; and during the chart definition, the names corresponding to the data are displayed on the final interface through the enumeration of the associated dimensions.
4. The system of claim 2, wherein the visualization enabling management unit further comprises:
the data service unit is used for supporting the definition of data opening permission in the background, including application and data authorization, and allowing the data to be accessed in a secure mode from the outside by defining the data and the access permission;
the widget data service unit is used for realizing the open API access of single-chart multi-dimensional analysis visual data based on the data service of the widget; accessing data in a well-defined visual multidimensional data format to the platform through the third application after authorization;
the data list data service unit is used for providing data services in a data table format, comprises original data and metadata of the data table and supports paging loading services; and after authorization, the third application access platform defines data table data.
5. The system according to claim 2, wherein the PC-side visualization capability demonstration unit further comprises a data billboard basic function unit and a widget basic function unit,
the data billboard basic functional unit further comprises:
the data billboard icon linkage unit is used for automatically refreshing the data and the charts in a linkage manner by the operation of a user on a single chart when the analysis dimensions of the charts of the data billboard of the same data are the same or related;
the data billboard full-screen viewing unit is used for supporting full-screen viewing, and in a full-screen state, the system hides a browser and an irrelevant toolbar and menu of the system interface;
the data billboard main body switching unit is used for switching between at least two data billboard themes;
a multi-expense supporting unit of the data billboard window for supporting the simultaneous opening of a plurality of data billboards
The widget base function unit further includes:
the data export function unit is used for supporting export of a data list for all charts and batch export;
the icon data export unit is used for supporting exporting the graph loaded with the data into a picture;
the abnormal data filtering unit is used for selecting display or non-display of the abnormal data in the chart and preventing the abnormal data from influencing the normal display of the chart;
and the icon conference unit is used for supporting a conference mode of full screen viewing for a single chart, wherein in the conference mode, the chart is adaptively amplified, and switching to the next chart in the data billboard is supported without exiting the full screen mode.
6. The system according to any one of claims 2 to 5, wherein the big data accelerated analysis capability unit comprises at least:
the bidirectional synchronization unit of the relational database and the acceleration platform is used for supporting bidirectional synchronization of the relational database and the acceleration platform, and the relational database is mysql, oracle, sqlServer or postgreSQL;
the bidirectional synchronization unit of the nosql database and the acceleration platform is used for supporting bidirectional synchronization of the nosql database and the acceleration platform, and the nosql database is hbase, mongoDb or hive;
the bidirectional synchronization unit of the file type data and acceleration platform is used for supporting bidirectional synchronization of a data file and the acceleration platform, and the data file is in a format of TxtFile and HDFS;
and the message bus message and acceleration platform synchronization unit is used for supporting the synchronization of the data bus data message.
7. The system of claim 6, wherein the data bus capability unit further comprises a data message management unit and a data message engine unit,
the data message management unit is used for supporting the theme of data message management and enabling consumers of the data message to receive the messages in a multithread parallel mode through multiple designated partitions;
wherein the data message engine unit further comprises:
unified data message management unit: the message processing system is used for encapsulating the change events of adding, modifying and deleting data into a uniform message format;
the data bus kernel engine unit is used for realizing the functions of decoupling data production and consumption, processing redundancy and dynamic expansion based on a distributed and high-throughput message engine;
the data bus message service engine unit is used for processing the reliability of the data message, and the data message can be restored and the sequence is ensured;
and the data message SDK unit is used for providing api and SDK package for consumption of the data message.
8. The system of claim 7, wherein the system infrastructure management unit further comprises a system management unit and an application management unit, wherein:
the system management unit is used for realizing the system functions of visual platform end user and organization management, authority management, system configuration management, basic service monitoring and operation log management;
the application management unit further includes:
the application version management unit is used for supporting the management of the release package and the upgrade of the mobile client, and comprises version number management, version package resource management and upgrade service management functions;
the application message management unit is used for supporting manual message pushing of a mobile terminal in the rear or dispatching and pushing of the message to a user by a task according to an interface; and provides material management, and graphic message management.
CN202111246213.9A 2021-10-26 2021-10-26 Visual operation and maintenance management system for power supply network Pending CN113918569A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202111246213.9A CN113918569A (en) 2021-10-26 2021-10-26 Visual operation and maintenance management system for power supply network

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202111246213.9A CN113918569A (en) 2021-10-26 2021-10-26 Visual operation and maintenance management system for power supply network

Publications (1)

Publication Number Publication Date
CN113918569A true CN113918569A (en) 2022-01-11

Family

ID=79243027

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202111246213.9A Pending CN113918569A (en) 2021-10-26 2021-10-26 Visual operation and maintenance management system for power supply network

Country Status (1)

Country Link
CN (1) CN113918569A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN116541115A (en) * 2023-05-04 2023-08-04 山东山大华天软件有限公司 Interactive demonstration system and method based on intelligent production line visual case

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN116541115A (en) * 2023-05-04 2023-08-04 山东山大华天软件有限公司 Interactive demonstration system and method based on intelligent production line visual case
CN116541115B (en) * 2023-05-04 2024-02-27 山东山大华天软件有限公司 Interactive demonstration system and method based on intelligent production line visual case

Similar Documents

Publication Publication Date Title
CN106126569B (en) A kind of rapid data method of servicing and system
CN102999364B (en) A kind of method and apparatus monitoring subject classification and dynamic load based on operation of power networks
CN112527373A (en) Visual platform expanding method based on operation integrated management center service
CN113918569A (en) Visual operation and maintenance management system for power supply network
CN107506483A (en) Page loading method, device, electronic equipment and storage medium
CN106843794A (en) A kind of multi-screen display method and system based on Android
CN111078761A (en) Data probing method, device, equipment and storage medium
CN105933175A (en) Real-time monitoring early-warning system
CN106898351B (en) Control method and device for large screen
CN115130442A (en) Report generation method and device, storage medium and computer equipment
CN115936302A (en) Cost sharing method and device, storage medium and computer equipment
CN115222500A (en) Capital monitoring method, device, storage medium and computer equipment
CN115617441A (en) Method and device for binding model and primitive, storage medium and computer equipment
CN114995931A (en) Display method and device of project bulletin board, storage medium and computer equipment
CN113900614B (en) Mobile terminal controlled visual large screen display system
CN113886465A (en) Big data analysis platform for automobile logistics
CN111488087B (en) Control display method, device and system and computer readable storage medium
CN112507017A (en) Data table conversion method and device
CN112947918A (en) Data display method and device
CN113918748A (en) Image visualization system applied to large data of power supply network
CN110083347A (en) The realization system of Visualization Platform
CN117112117B (en) Intelligent control display interaction method and system based on graphic processing
CN113722341B (en) Operation data processing method and related device
CN114462959A (en) Urging method and apparatus for supervising member, terminal device and storage medium
US20230396621A1 (en) Method and system for creating social media content collections

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