CN109189786B - Method for periodically generating custom report form for network element management system - Google Patents
Method for periodically generating custom report form for network element management system Download PDFInfo
- Publication number
- CN109189786B CN109189786B CN201810924014.0A CN201810924014A CN109189786B CN 109189786 B CN109189786 B CN 109189786B CN 201810924014 A CN201810924014 A CN 201810924014A CN 109189786 B CN109189786 B CN 109189786B
- Authority
- CN
- China
- Prior art keywords
- report
- network element
- management system
- element management
- database
- 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.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Data Exchanges In Wide-Area Networks (AREA)
Abstract
The invention belongs to the technical field of communication, and discloses a method for periodically generating a self-defined report form by a network element management system, which comprises the steps of classifying data tables in the network element management system according to types; acquiring fields and associated SQL of a data table, forming a report dictionary and storing the report dictionary in a database; the network element management system reads a report dictionary in the database, and a user self-defines a report through the report dictionary; the network element management system generates a report template according to the self-defined report, and the report template is stored in a database; the network element management system reads a report template in the database, a user establishes a report task after specifying a report generation period and starting time through the report template, and the report task is stored in the database; and the network element management system background reads the report task in the database and outputs a report result. The invention solves the problem of higher maintenance cost of the network element management system report in the prior art.
Description
Technical Field
The invention relates to the technical field of communication, in particular to a method for periodically generating a self-defined report form by a network element management system.
Background
With the rapid development of mobile communication, users have more and more refined network element management and higher and more higher requirements on report data, so that new requirements and modifications are frequently provided for report contents, and the development and maintenance costs of a network element management system are increased accordingly. In addition, in order to reduce the investment of maintenance personnel, a table system which has high automation degree and does not need the intervention of maintenance personnel and can automatically generate various daily or weekly reports is urgently needed by a user, and a method which can be flexibly configured and periodically generates reports is urgently needed.
Disclosure of Invention
The embodiment of the application provides a method for periodically generating a self-defined report form by a network element management system, and solves the problem that the maintenance cost of the report form of the network element management system is high in the prior art.
The embodiment of the application provides a method for periodically generating a custom report form by a network element management system, which comprises the following steps:
step S1, classifying the data table in the network element management system according to the type; acquiring fields and associated SQL of a data table, forming a report dictionary and storing the report dictionary in a database;
step S2, the network element management system reads the report dictionary in the database, and the user self-defines the report through the report dictionary; the network element management system generates a report template according to a self-defined report, and the report template is stored in the database;
step S3, the network element management system reads the report template in the database, a user creates a report task after appointing a report generation period and starting time through the report template, and the report task is stored in the database; and the network element management system background reads the report task in the database and outputs a report result.
Preferably, in step S1, the type of the data table includes network element information, a network element upper node, configuration information, and service data.
Preferably, in step S2, the user defining the report through the report dictionary includes: and selecting the fields of the main table, the association table and the data table of the query and the query condition.
Preferably, the query condition includes a time period constraint condition, the time period constraint condition includes a start time and an end time, the start time is the current time minus the report generation period, and the end time is the current time.
Preferably, the master table includes network element upper node and network element information.
Preferably, in step S2, the generating, by the network element management system, a report template according to the self-defined report includes: according to the main table and the association table, modularly assembling a data table according to the association SQL to generate query SQL;
the report template comprises the report field, the query SQL and the query condition.
Preferably, when the data tables of different types are modularly assembled, the data tables are assembled according to the sequence of the network element superior node, the network element information, the network element configuration and the service data.
Preferably, in step S3, the network element management system reads the report task in the database at the background, periodically reads the query SQL in the report template after the report task is started by the user, and sends the query SQL to the database to execute to obtain a report result.
Preferably, in step S3, the user may manage the reporting task at any time, including starting, stopping, and modifying the reporting task.
One or more technical solutions provided in the embodiments of the present application have at least the following technical effects or advantages:
in the embodiment of the application, firstly, the data tables in the network element management system are classified according to types, and the fields and the associated SQL of the data tables are obtained to form a report dictionary; then reading the report dictionary through the network element management system, self-defining the report through the report dictionary by a user, and generating a report template according to the self-defined report by the network element management system; and then the network element management system reads the report template, a user establishes a report task after specifying a report generation period and starting time through the report template, and the network element management system reads the report task at a background and outputs a report result. In conclusion, the method can generate the reports periodically, can automatically generate various self-defined daily reports and periodic reports without the intervention of maintenance personnel after the customization of the user, and can reduce the investment of maintenance personnel and human misoperation. In addition, when a new business data table needs to be added, only a new data table field and data table association SQL need to be added in the report dictionary, and the system does not need to be developed, released and updated for the second time, so that the development cost can be greatly reduced.
Drawings
In order to more clearly illustrate the technical solution in the present embodiment, the drawings needed to be used in the description of the embodiment will be briefly introduced below, and it is obvious that the drawings in the following description are one embodiment of the present invention, and it is obvious for those skilled in the art to obtain other drawings based on the drawings without creative efforts.
Fig. 1 is a flowchart of a report dictionary definition in a method for periodically generating a custom report by a network element management system according to an embodiment of the present invention;
fig. 2 is a flowchart of report template generation in a method for periodically generating a custom report by a network element management system according to an embodiment of the present invention;
fig. 3 is a flowchart of report task work in a method for periodically generating a custom report by a network element management system according to an embodiment of the present invention.
Detailed Description
In order to better understand the technical solution, the technical solution will be described in detail with reference to the drawings and the specific embodiments.
The invention aims to reduce the report maintenance cost of the network element management system, and provides an extensible method which takes tasks as driving, provides user customization and can generate reports periodically.
The technical scheme of the invention provides a method for periodically generating a self-defined report form by a network element management system, which comprises the following steps:
step one, because the report data of the network element management system is from around the network element, the data table can be divided into four types of network element information, network element superior node, configuration information and service data. The network element upper node refers to a logical and physical home object of the network element, such as: subnet, site, area. The configuration information refers to various configuration information on the network element, such as: IP address, equipment number, cell information and frequency point. The service data is various service data generated by the network element during operation, such as: alarm, performance, configuration change. Then, SQL query conditions (namely, associated SQL) of the data table and network element information are associated, and all fields of the data table providing report query are stored in a database to be used as a report dictionary.
Reading the report dictionary through the network element management system, providing a table, a field and a query condition which need to be queried and selected by a user, and specifying a main table initiated by query, wherein the main table comprises network element superior nodes and network element information. After the user selection is completed, the network element management system modularly assembles the table selected by the user according to the sequence of the network element superior node, the network element information, the network element configuration and the service data to generate query SQL, and the query SQL is stored in a database as a report template. And each data table is assembled in a left connection mode because the data integrity of the main table needs to be ensured.
And step three, the user establishes a report task after appointing a report generation period and starting time through a report template, the report task reads query SQL of the report template in each period after the report task is started, and for a data table containing a time field, time period filtering (namely time period constraint conditions) needs to be added in query conditions, namely, the termination time is the current time, and the starting time is the current time-the report generation period. And finally, the network element management system background executes the query SQL, and uploads the query result to an FTP server or sends a mail after saving the query result in a file.
The method can generate reports periodically, and can automatically generate various daily reports and weekly reports without the intervention of maintainers after the user customizes, thereby reducing the investment of maintainers and reducing the human misoperation. When a new business data table needs to be added, only new data table fields and associated SQL need to be added in the report dictionary, secondary development and release updating of the system are not needed, and development cost is greatly reduced.
The following describes a report dictionary definition process of the network element management system in the present invention with reference to fig. 1, which specifically includes the following steps:
step 101: the data table in the network element management system is divided into four types of network element information, network element superior nodes, configuration information and service data. The network element upper node refers to a logical and physical home object of the network element, such as: subnet, site, area. The configuration information refers to various configuration information on the network element, such as: IP address, equipment number, cell information and frequency point. The service data is various service data generated by the network element during operation, such as: alarm, performance, configuration change.
Step 102: and separately storing the fields of each data table and data table association SQL (namely SQL sentences of the data tables and network element information) into a database to form a report dictionary. Wherein, the network element information only needs to store the field.
Taking the example of converting the alarm table in the service data into the report dictionary, firstly, the fields of the alarm table are respectively stored in the data table fields in the report dictionary, such as: alarm name, alarm number, alarm time and alarm position. Then, storing SQL statements related to the alarm table and the network element information into SQL related to the data table, such as: the left join Log _ alarm onLog _ alarm.deviceid is device.id, where Log _ alarm is the table name of the alarm table, and Device is the table name of the network element information, which are associated by the network element ID.
Through the processing of the step 101 and the step 102, the definition of the report dictionary can be completed, and a data basis is provided for the subsequent modular assembly query SQL. If the network element management system needs to add a new service data table, only new data table fields and associated SQL are needed to be added in the report dictionary, and the system does not need to be developed, released and updated for the second time, so that the development cost is greatly reduced.
The following describes the report template generation process in the present invention with reference to fig. 2, which specifically includes the following steps:
step 201: and the network element management system reads the report dictionary from the database.
Step 202: the user can define the required report form through the report form dictionary, including the main table initiating the query, other associated tables, report form fields and query conditions, the query conditions include all report form fields, such as: if the report field has the network element name and the network element status, the query condition may be increased by the network element name being 21NWHD 1022' and the network element status being normal.
Step 203: and the network element management system carries out modular assembly according to the main table and the association table selected by the user and the association SQL defined in the report dictionary to generate the query SQL. When different types of data tables are assembled, the data tables are assembled according to the sequence of network element superior nodes, network element information, network element configuration and service data. And finally, storing the report fields, the query SQL and the query conditions in a database to complete the definition of the report template.
The following describes a report task working mode in the present invention with reference to fig. 3, which specifically includes the following steps:
step 301: and reading the report template from the database by the network element management system.
Step 302: and after the user selects the report template, establishing a report task after the report generation period and the starting time are specified, and storing the report task in the database.
Step 303: the network element management system background reads the report task from the database and caches the report task, after the report task is started by a user, the network element management system background periodically reads the query SQL in the report template, and for the data table containing the time field, the constraint of the time period needs to be added in the query condition, namely the termination time is the current time, and the start time is the current time-the report generation period. And finally, the network element management system background executes the query SQL to obtain a query result, and uploads the FTP server or sends a mail after the query result is stored in a file.
Step 304: the user can manage the report tasks at any time, including starting, stopping and modifying the report tasks.
Through the processing, the user-defined report can be periodically generated.
Finally, it should be noted that the above embodiments are only for illustrating the technical solutions of the present invention and not for limiting, and although the present invention has been described in detail with reference to examples, it should be understood by those skilled in the art that modifications or equivalent substitutions may be made on the technical solutions of the present invention without departing from the spirit and scope of the technical solutions of the present invention, which should be covered by the claims of the present invention.
Claims (6)
1. A method for periodically generating a self-defined report form by a network element management system is characterized by comprising the following steps:
step S1, classifying the data table in the network element management system according to the type; acquiring fields and associated SQL of a data table, forming a report dictionary and storing the report dictionary in a database;
the types of the data table comprise network element information, network element superior nodes, configuration information and service data;
step S2, the network element management system reads the report dictionary in the database, and the user self-defines the report through the report dictionary; the network element management system generates a report template according to a self-defined report, and the report template is stored in the database;
the user self-defining the report through the report dictionary comprises the following steps: selecting fields and query conditions of a main table, an association table and a data table to be queried;
the network element management system generating the report template according to the self-defined report comprises the following steps: according to the main table and the association table, modularly assembling a data table according to the association SQL to generate query SQL;
the report template comprises a report field, the query SQL and the query condition;
step S3, the network element management system reads the report template in the database, a user creates a report task after appointing a report generation period and starting time through the report template, and the report task is stored in the database; and the network element management system background reads the report task in the database and outputs a report result.
2. The method according to claim 1, wherein the query condition includes a time period constraint condition, the time period constraint condition includes a start time and an end time, the start time is the current time minus the report generation period, and the end time is the current time.
3. The method according to claim 1, wherein the master table includes network element upper node and network element information.
4. The method according to claim 1, wherein the assembling of the data tables of different types is performed in order of network element superior node, network element information, network element configuration, and service data.
5. The method according to claim 1, wherein in step S3, the network element management system reads the reporting task in the database from the background, periodically reads the query SQL in the reporting template after the reporting task is started by the user, and sends the query SQL to the database to obtain a reporting result after the query SQL is executed.
6. The method according to claim 1, wherein in step S3, the user can manage the reporting task at any time, including starting, stopping, and modifying the reporting task.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201810924014.0A CN109189786B (en) | 2018-08-14 | 2018-08-14 | Method for periodically generating custom report form for network element management system |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201810924014.0A CN109189786B (en) | 2018-08-14 | 2018-08-14 | Method for periodically generating custom report form for network element management system |
Publications (2)
Publication Number | Publication Date |
---|---|
CN109189786A CN109189786A (en) | 2019-01-11 |
CN109189786B true CN109189786B (en) | 2020-10-13 |
Family
ID=64921703
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201810924014.0A Active CN109189786B (en) | 2018-08-14 | 2018-08-14 | Method for periodically generating custom report form for network element management system |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN109189786B (en) |
Families Citing this family (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN112036143B (en) * | 2020-09-02 | 2023-09-22 | 中国银行股份有限公司 | Method and system for generating sustainable custom report responding to report demand |
Citations (10)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102110142A (en) * | 2011-02-09 | 2011-06-29 | 浪潮集团山东通用软件有限公司 | Method for dynamically expanding personnel transaction in human resource management information system |
CN102156741A (en) * | 2011-04-16 | 2011-08-17 | 武钢集团昆明钢铁股份有限公司 | Custom dynamic report system and implementation method thereof |
CN103886085A (en) * | 2014-03-28 | 2014-06-25 | 浪潮软件集团有限公司 | Universal method for transforming cross report form through columns |
CN104331290A (en) * | 2014-10-31 | 2015-02-04 | 北京思特奇信息技术股份有限公司 | Resource type management and page display method and system |
CN105022769A (en) * | 2015-01-07 | 2015-11-04 | 泰华智慧产业集团股份有限公司 | Data interaction system of urban underground pipeline, and method thereof |
CN105069092A (en) * | 2015-08-05 | 2015-11-18 | 深圳联友科技有限公司 | Report display method, system and mobile terminal |
CN105260476A (en) * | 2015-11-06 | 2016-01-20 | 上海熙菱信息技术有限公司 | Self-defined configuration method and system for reports |
CN107241227A (en) * | 2017-06-29 | 2017-10-10 | 济南浪潮高新科技投资发展有限公司 | A kind of configuration of network data form and generation method |
CN107423272A (en) * | 2017-04-21 | 2017-12-01 | 广东浪潮大数据研究有限公司 | A kind of report form generation method and its device based on excel |
CN107451109A (en) * | 2017-07-05 | 2017-12-08 | 北京京东尚科信息技术有限公司 | Report form generation method and system |
Family Cites Families (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US9749343B2 (en) * | 2014-04-03 | 2017-08-29 | Fireeye, Inc. | System and method of cyber threat structure mapping and application to cyber threat mitigation |
US10832805B2 (en) * | 2015-10-29 | 2020-11-10 | Siemens Healthcare Gmbh | Method and system for generating electronic medical reports |
-
2018
- 2018-08-14 CN CN201810924014.0A patent/CN109189786B/en active Active
Patent Citations (10)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102110142A (en) * | 2011-02-09 | 2011-06-29 | 浪潮集团山东通用软件有限公司 | Method for dynamically expanding personnel transaction in human resource management information system |
CN102156741A (en) * | 2011-04-16 | 2011-08-17 | 武钢集团昆明钢铁股份有限公司 | Custom dynamic report system and implementation method thereof |
CN103886085A (en) * | 2014-03-28 | 2014-06-25 | 浪潮软件集团有限公司 | Universal method for transforming cross report form through columns |
CN104331290A (en) * | 2014-10-31 | 2015-02-04 | 北京思特奇信息技术股份有限公司 | Resource type management and page display method and system |
CN105022769A (en) * | 2015-01-07 | 2015-11-04 | 泰华智慧产业集团股份有限公司 | Data interaction system of urban underground pipeline, and method thereof |
CN105069092A (en) * | 2015-08-05 | 2015-11-18 | 深圳联友科技有限公司 | Report display method, system and mobile terminal |
CN105260476A (en) * | 2015-11-06 | 2016-01-20 | 上海熙菱信息技术有限公司 | Self-defined configuration method and system for reports |
CN107423272A (en) * | 2017-04-21 | 2017-12-01 | 广东浪潮大数据研究有限公司 | A kind of report form generation method and its device based on excel |
CN107241227A (en) * | 2017-06-29 | 2017-10-10 | 济南浪潮高新科技投资发展有限公司 | A kind of configuration of network data form and generation method |
CN107451109A (en) * | 2017-07-05 | 2017-12-08 | 北京京东尚科信息技术有限公司 | Report form generation method and system |
Non-Patent Citations (2)
Title |
---|
"基于异构数据库报表自定义系统的实现";王丽娣 等;《西北煤炭》;20071231;第5卷(第4期);全文 * |
"综合数据查询与自定义报表系统开发探讨";聂文化 等;《建筑论坛》;20150331;全文 * |
Also Published As
Publication number | Publication date |
---|---|
CN109189786A (en) | 2019-01-11 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN107203617B (en) | The online migratory system of mysql and method based on MHA | |
CN113595761A (en) | Micro-service component optimization method of power system information and communication integrated scheduling platform | |
CN107273540A (en) | Distributed search and index updating method, system, server and computer equipment | |
CN108924007B (en) | Big data acquisition and storage system and method of communication operation information | |
CN107179977B (en) | Database Full-automatic monitoring system based on mpm models | |
CN100539597C (en) | Configuring management method and device | |
CN107065813A (en) | A kind of workshop appliance data monitoring system and method | |
CN105260203A (en) | Model-based Hadoop deploy and allocation method | |
CN109521702A (en) | A kind of method and server monitoring dcs operating status | |
CN109189786B (en) | Method for periodically generating custom report form for network element management system | |
CN103051478A (en) | Large-capacity telecommunication network management system as well as setting and application methods thereof | |
CN110399534B (en) | Terminal performance report generation method, device, equipment and storage medium | |
CN116431611A (en) | Automatic data processing module development method based on custom rules | |
CN101572627A (en) | Management method in integrating network and system thereof | |
CN113824587B (en) | Multi-communication protocol equipment management method and system | |
CN110727457B (en) | Component management method and device, storage medium and electronic equipment | |
CN114218724A (en) | Model construction method, device and system for power secondary system and storage medium | |
CN103052105A (en) | Processing method and device for base station alarm | |
CN107122246A (en) | Intelligent numerical simulation job management and feedback method | |
WO2012024917A1 (en) | System, method and interface database for reporting integrated network management data | |
EP3629616A1 (en) | Data interaction method, device and equipment | |
CN102244619B (en) | Equipment management method, gateway and server | |
CN110896358A (en) | Dynamic updating method and device for resource data in NFV | |
CN114253542B (en) | Triggering and running method based on visual trigger and computer storage medium | |
CN102057625A (en) | Manipulation of network management information |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant | ||
TR01 | Transfer of patent right | ||
TR01 | Transfer of patent right |
Effective date of registration: 20201026 Address after: 430205 No.1 tanhu 2nd Road, Canglong Island, Jiangxia Economic Development Zone, Wuhan City, Hubei Province Patentee after: Wuhan Hongxin Technology Development Co.,Ltd. Address before: 430073 Hubei province Wuhan Dongxin East Lake high tech Development Zone, Road No. 5 Patentee before: Wuhan Hongxin Telecommunication Technologies Co.,Ltd. |