CN109189786A - A method of self-defined report is generated for the Element management system period - Google Patents
A method of self-defined report is generated for the Element management system period Download PDFInfo
- Publication number
- CN109189786A CN109189786A CN201810924014.0A CN201810924014A CN109189786A CN 109189786 A CN109189786 A CN 109189786A CN 201810924014 A CN201810924014 A CN 201810924014A CN 109189786 A CN109189786 A CN 109189786A
- Authority
- CN
- China
- Prior art keywords
- report
- management system
- element management
- database
- self
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
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 fields of communication technology, a kind of method for generating self-defined report for the Element management system period are disclosed, including classifying to the tables of data in Element management system according to type;Field, the association SQL for obtaining tables of data, form report dictionary and save into database;Report dictionary in Element management system reading database, user pass through report dictionary self-defined report;Element management system generates report template according to self-defined report, and report template is saved into database;Report template in Element management system reading database, user create report task after specifying report generation period and starting time by report template, and report task is saved into database;Report task in the reading database of Element management system backstage, and output report result.The present invention solves the problems, such as that Element management system report maintenance cost is higher in the prior art.
Description
Technical field
The present invention relates to fields of communication technology, more particularly to one kind to generate self-defined report for the Element management system period
Method.
Background technique
With the rapid development of mobile communication, user also increasingly refines NE management, the requirement to report data
Also higher and higher, thus new demand, which is modified, frequently to be proposed to report content, lead to Element management system exploitation maintenance in this way
Cost can also increase accordingly.In addition, user is the investment for reducing maintenance personnel, also there is an urgent need to high degree of automation, without dimension
Shield personnel intervention, the table system that can automatically generate various daily sheets or weekly return, there is an urgent need to a kind of energy flexible configuration, periods
Property generate report method.
Summary of the invention
The embodiment of the present application is solved by providing a kind of method for generating self-defined report for the Element management system period
Element management system report maintenance cost higher problem in the prior art.
The embodiment of the present application provides a kind of method for generating self-defined report for the Element management system period, including following
Step:
Step S1, classify to the tables of data in Element management system according to type;Obtain field, the association of tables of data
SQL forms report dictionary and saves into database;
Step S2, the described Element management system reads the report dictionary in the database, and user passes through the report
Literary name allusion quotation self-defined report;The Element management system generates report template according to self-defined report, and the report template saves
To in the database;
Step S3, the described Element management system reads the report template in the database, and user passes through the report
Table template creates report task after specifying report generation period and starting time, and the report task is saved to the database
In;Read the report task in the database, and output report result in Element management system backstage.
Preferably, in the step S1, the type of the tables of data includes net element information, network element superior node, with confidence
Breath, business datum.
Preferably, in the step S2, the user includes: selection inquiry by the report dictionary self-defined report
Main table, contingency table, the field of tables of data, querying condition.
Preferably, the querying condition includes period constraint condition, the period constraint condition include initial time,
The time is terminated, the initial time is that current time subtracts the report generation period, and the termination time is current time.
Preferably, the main table includes network element superior node and net element information.
Preferably, in the step S2, it includes: root that the Element management system, which generates report template according to self-defined report,
According to the main table and the contingency table, modularization assembling is carried out to tables of data according to the association SQL, generates query SQL;
The report template includes the report field, the query SQL, the querying condition.
Preferably, to different types of tables of data carry out modularization assembling when, according to network element superior node, net element information,
Network element configuration, the sequence of business datum are assembled.
Preferably, in the step S3, the Element management system backstage is read the report in the database and is appointed
Business, after the report task is most likely initiated by a user, the query SQL in report template described in periodic reading is issued described
Database obtains report result after executing.
Preferably, in the step S3, user can be at any time managed the report task, including starting, stopped, being repaired
Change the report 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 present application, classify first to the tables of data in Element management system according to type, obtain number
According to the field of table, association SQL, report dictionary is formed;Then report dictionary is read by Element management system, user passes through report
Dictionary self-defined report, Element management system generate report template according to self-defined report;Element management system reads report later
Table template, user create report task, Element management system after specifying report generation period and starting time by report template
Read report task, and output report result in backstage.To sum up, report is periodically generated by the method, be able to achieve in user
Maintenance free personnel, which intervene, after customization can automatically generate various customized daily sheets, weekly return, can reduce maintenance personnel's throwing
Enter, and can be reduced human operational error.In addition, when needing to increase new business datum table, it is only necessary to increase in report dictionary
Add new data sheet field be associated with tables of data SQL both can, without to system carry out secondary development and publication update, Neng Gouji
It is big to reduce development cost.
Detailed description of the invention
It, below will be to needed in embodiment description in order to illustrate more clearly of the technical solution in the present embodiment
Attached drawing is briefly described, it should be apparent that, the accompanying drawings in the following description is one embodiment of the present of invention, general for this field
For logical technical staff, without creative efforts, it is also possible to obtain other drawings based on these drawings.
Fig. 1 is in a kind of method for generating self-defined report for the Element management system period provided in an embodiment of the present invention
The flow chart of report dictionary definition;
Fig. 2 is in a kind of method for generating self-defined report for the Element management system period provided in an embodiment of the present invention
The flow chart that report template generates;
Fig. 3 is in a kind of method for generating self-defined report for the Element management system period provided in an embodiment of the present invention
The flow chart of report task work.
Specific embodiment
In order to better understand the above technical scheme, in conjunction with appended figures and specific embodiments to upper
Technical solution is stated to be described in detail.
The purpose of the invention is to reduce Element management system report maintenance cost, provide a kind of expansible with task
For driving, user's customization is provided, the method that report can be generated in the period.
Technical solution of the present invention provide it is a kind of for the Element management system period generate self-defined report method, including with
Lower step:
Step 1: since the report data of Element management system can be divided tables of data around network element
At net element information, network element superior node, configuration information, four seed type of business datum.Wherein, network element superior node refers to that network element is patrolled
Upper and physically ownership object is collected, such as: subnet, site, region.Configuration information refers to various configuration informations on network element, such as: IP
Address, device numbering, cell information, frequency point.Business datum is the various businesses data that network element waits generation at runtime, such as: being accused
Police, performance, configuration change.Then by tables of data and the associated SQL query condition (being associated with SQL) of net element information and data
The field of the be provided with report query of table is all saved in database as report dictionary.
Step 2: reading report dictionary by Element management system, user is provided and selects to need the table inquired, field and look into
The main table that inquiry condition and given query are initiated, main table includes network element superior node and net element information.It selects to complete in user
Afterwards, the table that Element management system selects user by network element superior node, net element information, network element configuration and business datum sequence
Modularization assembling is carried out, query SQL is generated, is saved in database as report template.Due to that need to guarantee that main table data are complete
Property, when assembling, each tables of data was carried out by left even mode.
Step 3: user creates report task, report after specifying report generation period and starting time by report template
Each period reads the query SQL of report template to task after actuation, need to be in inquiry item for the tables of data comprising time field
Increase the filtering (i.e. period constraint condition) of period in part, i.e. the termination time is current time, when initial time=current
The m- report generation period.Last Element management system backstage executes query SQL, uploads FTP clothes after query result is saved file
Business device sends mail.
Report is periodically generated by the method, the Maintenance free personnel after user's customization that are able to achieve intervene can be automatic
Various daily sheets are generated, weekly return reduces maintenance personnel's investment, and can be reduced human operational error.And it is needing to increase
When adding new business datum table, it is only necessary to increase in report dictionary new data sheet field be associated with SQL both can, without right
System carries out secondary development and publication updates, and greatly reduces development cost.
It is illustrated, specifically includes below with reference to report dictionary definition process of the Fig. 1 to Element management system in the present invention
Following steps:
Step 101: the tables of data in Element management system is divided into net element information, network element superior node, configuration information, industry
Business four seed type of data.Wherein, network element superior node refers to the ownership object of network element in logic and physically, and such as: subnet is stood
Location, region.Configuration information refers to various configuration informations on network element, such as: IP address, device numbering, cell information, frequency point.Business
Data are the various businesses data that network element waits generation at runtime, such as: alarm, performance, configuration change.
Step 102: by the field of each tables of data and tables of data association SQL, (i.e. tables of data and net element information is associated
SQL statement) it is retained separately formation report dictionary in database.Wherein, net element information then need to only save field.
For the warning watch in business datum is converted into report dictionary, the field of warning watch is all saved respectively first
Into the data sheet field in report dictionary, such as: alarm name, alarm number, alarm time, warning position.Then it will accuse again
Alert table is saved in tables of data with the associated SQL statement of net element information and is associated in SQL, such as: left join Log_alarm on
Log_alarm.deviceid=Device.id, Log_alarm here are the table names of warning watch, and Device is network element letter
The table name of breath, they are associated by NE ID.
The definition of report dictionary can be completed by the processing of step 101, step 102, looked into for subsequent moduleization assembling
It askes SQL and provides data foundation.It, only need to be in report dictionary if Element management system needs to increase new business datum table
Increase new data sheet field be associated with SQL, without carrying out secondary development to system and publication updates, greatly reduce exploitation
Cost.
It is illustrated below with reference to the process that Fig. 2 generates report template in the present invention, specifically includes the following steps:
Step 201: Element management system reads report dictionary from database.
Step 202: user can be by the customized required report of report dictionary, the main table including initiating inquiry, other
Contingency table, report field and querying condition, querying condition include all report fields, such as: have in report field element name and
Network element state, then querying condition can increase ' element name=21NWHD1022 ' and ' network element state=normal '.
Step 203: the main table and contingency table that Element management system is selected according to user are associated with as defined in report dictionary
SQL carries out modularization assembling, generates query SQL.It need to be by network element superior node, network element when for the assembling of different types of tables of data
The sequence of information, network element configuration and business datum carries out.Report field, query SQL and querying condition are finally saved in number
According to library, the definition of report template is completed.
It is illustrated below with reference to the mode that Fig. 3 works to report task in the present invention, specifically includes the following steps:
Step 301: report template is read from database by Element management system.
Step 302: after user selects report template, report task is created after specifying report generation period and starting time,
It is saved in database.
Step 303: Element management system backstage is read report task from database and is cached, and is opened in report task by user
After dynamic, the query SQL in report template is read in each period timing in Element management system backstage, for the number comprising time field
The constraint of period need to be increased in querying condition according to table, i.e. the termination time is current time, initial time=current time-report
Table generates the period.Last Element management system backstage executes query SQL, obtains query result, and query result is saved file
Ftp server is uploaded afterwards or sends mail.
Step 304: user can at any time be managed report task, including starting, stop, and modify report task.
It can be realized by above processing and periodically generate User-defined report.
It should be noted last that the above specific embodiment is only used to illustrate the technical scheme of the present invention and not to limit it,
Although being described the invention in detail referring to example, those skilled in the art should understand that, it can be to the present invention
Technical solution be modified or replaced equivalently, without departing from the spirit and scope of the technical solution of the present invention, should all cover
In the scope of the claims of the present invention.
Claims (9)
1. a kind of method for generating self-defined report for the Element management system period, which comprises the following steps:
Step S1, classify to the tables of data in Element management system according to type;Field, the association SQL of tables of data are obtained,
It forms report dictionary and saves into database;
Step S2, the described Element management system reads the report dictionary in the database, and user passes through the report word
Allusion quotation self-defined report;The Element management system generates report template according to self-defined report, and the report template is saved to institute
It states in database;
Step S3, the described Element management system reads the report template in the database, and user passes through the report mould
Plate creates report task after specifying report generation period and starting time, and the report task is saved into the database;Net
Read the report task in the database, and output report result in first management system backstage.
2. the method according to claim 1 for generating self-defined report for the Element management system period, which is characterized in that
In the step S1, the type of the tables of data includes net element information, network element superior node, configuration information, business datum.
3. the method according to claim 2 for generating self-defined report for the Element management system period, which is characterized in that
In the step S2, the user passes through the main table that the report dictionary self-defined report includes: selection inquiry, contingency table, number
According to the field of table, querying condition.
4. the method according to claim 3 for generating self-defined report for the Element management system period, which is characterized in that
The querying condition includes period constraint condition, the period constraint condition include initial time, terminate the time, described
Time beginning is that current time subtracts the report generation period, and the termination time is current time.
5. the method according to claim 3 for generating self-defined report for the Element management system period, which is characterized in that
The main table includes network element superior node and net element information.
6. the method according to claim 3 for generating self-defined report for the Element management system period, which is characterized in that
In the step S2, it includes: according to the main table and institute that the Element management system, which generates report template according to self-defined report,
Contingency table is stated, modularization assembling is carried out to tables of data according to the association SQL, generates query SQL;
The report template includes the report field, the query SQL, the querying condition.
7. the method according to claim 6 for generating self-defined report for the Element management system period, which is characterized in that
When carrying out modularization assembling to different types of tables of data, according to network element superior node, net element information, network element configuration, business number
According to sequence assembled.
8. the method according to claim 6 for generating self-defined report for the Element management system period, which is characterized in that
In the step S3, the report task in the database is read on the Element management system backstage, is appointed in the report
After business is most likely initiated by a user, the query SQL in report template described in periodic reading is issued after the database executes and is obtained
Report result.
9. the method according to claim 3 for generating self-defined report for the Element management system period, which is characterized in that
In the step S3, user can be at any time managed the report task, including starting, stopping, the modification report 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 true CN109189786A (en) | 2019-01-11 |
CN109189786B 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) |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN112036143A (en) * | 2020-09-02 | 2020-12-04 | 中国银行股份有限公司 | Method and system for generating sustainable self-defined report responding to report requirement |
Citations (12)
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 |
US20160241580A1 (en) * | 2014-04-03 | 2016-08-18 | Isight Partners, Inc. | System and Method of Cyber Threat Structure Mapping and Application to Cyber Threat Mitigation |
US20170124290A1 (en) * | 2015-10-29 | 2017-05-04 | Ananda Hegde | Method and system for generating electronic medical 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 |
-
2018
- 2018-08-14 CN CN201810924014.0A patent/CN109189786B/en active Active
Patent Citations (12)
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 |
US20160241580A1 (en) * | 2014-04-03 | 2016-08-18 | Isight Partners, Inc. | System and Method of Cyber Threat Structure Mapping and Application to Cyber Threat Mitigation |
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 |
US20170124290A1 (en) * | 2015-10-29 | 2017-05-04 | Ananda Hegde | Method and system for generating electronic medical reports |
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 |
---|
王丽娣 等: ""基于异构数据库报表自定义系统的实现"", 《西北煤炭》 * |
聂文化 等: ""综合数据查询与自定义报表系统开发探讨"", 《建筑论坛》 * |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN112036143A (en) * | 2020-09-02 | 2020-12-04 | 中国银行股份有限公司 | Method and system for generating sustainable self-defined report responding to report requirement |
CN112036143B (en) * | 2020-09-02 | 2023-09-22 | 中国银行股份有限公司 | Method and system for generating sustainable custom report responding to report demand |
Also Published As
Publication number | Publication date |
---|---|
CN109189786B (en) | 2020-10-13 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN106528129B (en) | A kind of Web application interface generation system and method | |
CN106951694B (en) | Adaptive modeling method for online monitoring system of secondary equipment of power system | |
CN103049271B (en) | The method and apparatus of the description document of automatic generation api interface | |
CN108459574A (en) | It is a kind of that system is managed based on the semantic field device information with OPC UA | |
CN101789045B (en) | Realization method of MDA modeling tool orienting to manufacturing field | |
CN102567932A (en) | Method, device and system for managing comprehensive resources | |
CN101141754B (en) | Value-added service analysis system and method thereof | |
CN105915381A (en) | System for realizing monitoring system business logic online modification | |
CN104035754A (en) | XML (Extensible Markup Language)-based custom code generation method and generator | |
CN1968154A (en) | System and method for service expansion using plug | |
CN109213819A (en) | Information resource sharing system | |
CN106250164A (en) | A kind of code generating method based on requirement documents and device | |
CN109582695A (en) | Data general-purpose querying method and inquiry system under a kind of micro services framework | |
CN102495832A (en) | System for automatically generating document in software development process | |
CN104091228A (en) | Systems for resource management, resource registering, resource inquiry and resource semantic corpus management of internet of things | |
CN111666456B (en) | Automatic net rack topology construction method based on multi-source distribution network | |
CN105573774A (en) | Application parameter managing and configuring method | |
CN102857949A (en) | Method and device for planning data consistency guarantees | |
CN112100181A (en) | Data resource management method based on sand table | |
CN105893591A (en) | Intelligent compiling technology of data sharing service | |
CN109189786A (en) | A method of self-defined report is generated for the Element management system period | |
CN112698819A (en) | Method, device and storage medium for designing tree-oriented object programming program | |
CN112883413A (en) | Intelligent management method for IT asset data in power grid enterprise | |
CN101192976A (en) | Automatic generation method for standard report of value-added service | |
CN111626444B (en) | Model maintenance dynamic self-adaption method, device and system based on regulation and control cloud and storage medium |
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 |
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. |
|
TR01 | Transfer of patent right |