CN1482766A - Method for automatic generating of net management report form - Google Patents

Method for automatic generating of net management report form Download PDF

Info

Publication number
CN1482766A
CN1482766A CNA021423156A CN02142315A CN1482766A CN 1482766 A CN1482766 A CN 1482766A CN A021423156 A CNA021423156 A CN A021423156A CN 02142315 A CN02142315 A CN 02142315A CN 1482766 A CN1482766 A CN 1482766A
Authority
CN
China
Prior art keywords
file
task
report
configuration
configuration file
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
Application number
CNA021423156A
Other languages
Chinese (zh)
Other versions
CN100372290C (en
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.)
Huawei Technologies Co Ltd
Original Assignee
Huawei Technologies 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 Huawei Technologies Co Ltd filed Critical Huawei Technologies Co Ltd
Priority to CNB021423156A priority Critical patent/CN100372290C/en
Publication of CN1482766A publication Critical patent/CN1482766A/en
Application granted granted Critical
Publication of CN100372290C publication Critical patent/CN100372290C/en
Anticipated expiration legal-status Critical
Expired - Fee Related legal-status Critical Current

Links

Images

Landscapes

  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The invention relates to a method for reporting network management statistics automatically, wherein the related configuration information of the reporting statistics in the configuration document is first read out, creating the relevant task which is responsible for producing the statistics forms, according to the testing time interval, checking all the tasks, constituting structured query language and executing, storing the executed result in the temporary forms of the data base, reading the data from the temporary forms, and forming document in the filing system. The method according to the invention can substantially reduce the workload for the maintainers.

Description

A kind of method of automatic generation webmaster form
Technical field
The present invention relates to a kind of method of automatic generation webmaster form, belong to data communication technology field.
Background technology
Automatically report generation is a background application, and its effect is regularly to produce alarm data form, bordereau and other statistical report form.By configuration file, the user is the report customization task neatly, as increases new form task, the old form task of deletion or the like.For every form task, the user can be to the form content, the report generation time, form is deposited path etc. and is provided with, pass through configuration file, the user can be provided with the threshold value inspection to each form, when report generation, there is the threshold value situation of crossing the border to take place if the data of finding in the form are used in report generation automatically, then can send Simple Network Management Protocol (Simple Network Management Protocol, hereinafter to be referred as SNMP) middle a kind of trap (hereinafter to be referred as Trap) protocol Data Unit (Protocol Data Unit is hereinafter to be referred as PDU) alarm of stipulating, in form, use red font to highlight this index simultaneously.Automatically generate the file of supertext SGML (Hyper Text Markup Language is hereinafter to be referred as HTML) form, the user can carry out form by any WWW browser and browse, and checks alarm data, business datum and other statisticss.
With regard to prior art, webmaster only offers the various types of bordereaus of user, and must be by user's manual intervention, be that the user must select report form type, statistical condition etc. by network management interface, just can obtain statistics,, also need to particularly point out if the user wishes to preserve form.For the equipment performance statistical information that all will check every day, check a more than statistical report form, the workload of plant maintenance personnel every day will be very big.
Summary of the invention
The objective of the invention is the above-mentioned shortcoming at prior art, propose a kind of method of automatic generation webmaster form, make the user can define the content of required form voluntarily, user friendly plant maintenance and service management reduce user's maintenance workload.
The method of the automatic generation webmaster form that the present invention proposes comprises following each step:
1, reads the relevant configuration information for the treatment of automatic report generation in the configuration file;
2, according to configuration information, create the corresponding task of being responsible for generating form, comprise a call back function in each task, all tasks are formed a task queue;
3, monitor task according to the review time in the above-mentioned configuration file at interval, all tasks in the above-mentioned task queue are checked, if need generate time of form to certain task, just call the call back function of this task;
4, this call back function is constructed complete SQL according to the appointed information in the above-mentioned configuration file, and carries out the good SQL statement of structure, execution result is kept in the temporary table of database;
5, according to the block copy order in the database, data are read from above-mentioned temporary table, in file system, form file.
Configuration file in the said method is configured by the user, and configuration file can be the text of established form.
In the inventive method, each configuration item in the configuration file is:
The configuration item numbering Describe
1 Inspect the task readjustment time interval
2 Automatic report generation task sum
3 The database of report query
4 Report data comes Source Type
5 The SQL statement that automatic report query is relied on
6 Database temporary table table name
7 The report generation time
8 The path of depositing after the report generation
9 The report file name
10 Report heading
11 Report generation mode: sequential system or coverage mode
12 Whether need to carry out the threshold value inspection
13 Threshold value is described, which field checked, on the threshold value/lower limit
Said method also comprises: the file to wherein the 5th step formation is made amendment, increase the report heading of appointment in the configuration file, increase the required various symbols of generation supertext making language document form automatically, change it into supertext markup language file.
Said method also comprises: according to specified threshold value in the configuration file, the specific field that forms file is carried out the threshold value inspection, if the data item above threshold value is arranged, it is set to special marking when revising temporary file, and the alarm packet in the simple structure NMP, send alarm to the network management alarm backstage.
In above-mentioned described the 5th step, the file that forms in the file system, its filename and deposit the path and specify by the configuration item in the configuration file.
The method of the automatic generation webmaster form that the present invention proposes makes the daily craft of user go out the working automation of form, has greatly alleviated the work of maintenance personnel amount.And the present invention has good flexibility, can be configured by configuration file from rise time of form, generation cycle, statement heading, threshold value etc.The present invention simultaneously has extremely strong extensibility, and the user can obtain the form content of own hope by the own task of configuration in configuration file, reaches the purpose of the own report customization of user.Make the daily craft of user go out the working automation of form, greatly alleviated the work of maintenance personnel amount.
Description of drawings
Fig. 1 is the flow chart of the inventive method.
Fig. 2 is the form sample that produces automatically with the inventive method.
Embodiment
The method of the automatic generation webmaster form that the present invention proposes, its flow process at first reads the relevant configuration information in the configuration file as shown in Figure 1.Configuration file is the text of established form, main information wherein has: task identification, database name, SQL (Structured QueryLanguage is hereinafter to be referred as SQL) statement, task execution interval time, generation report file name.Configuration file specifies and sees Table 1:
Each configuration item explanation in table 1 configuration file
The configuration item numbering Describe
1 Inspect the task readjustment time interval
2 Automatic report generation task sum
3 The database of report query
4 Report data comes Source Type
5 The SQL statement that automatic report query is relied on
6 Database temporary table table name
7 The report generation time
8 The path of depositing after the report generation
9 The report file name
10 Report heading
11 Report generation mode: sequential system or coverage mode
12 Whether need to carry out the threshold value inspection
13 Threshold value is described, and which field is checked threshold value must go up/lower limit
By configuration item 1, obtain checking the time interval that whether needs to generate form; By configuration item 2, needing to obtain the form sum of generation; By configuration item 3, the title of the database that need inquire about when obtaining generating form; By configuration item 4, obtaining when generating form is to need to carry out SQL statement, still need carry out the storing process that the user presets in database; By configuration item 5, the SQL statement that will carry out when obtaining generating form or storing process name; By configuration item 6, obtain the table name of temporary table in the database; By configuration item 7, obtain the report generation time; By configuration item 8, obtain the path of depositing after the report generation; By configuration item 9, obtain the file name of the report file that will generate; By configuration item 10, obtain the gauge outfit of form; By configuration item 11, obtain the generating mode of form, the generating mode of form has two kinds, and a kind of is " sequential system ", promptly comprises temporal information in the filename of report file when generating form with a kind of form at every turn, each different; Another kind is " coverage mode ", and promptly for a kind of form, the title of report file is identical when generating form, and new form will cover original form; By configuration item 12, whether needed to carry out the threshold value inspection; By configuration item 13, obtain needing in the form to carry out the field name of threshold value inspection and the threshold limits of this field that the user is provided with.
According to the configuration information that obtains automatic report generation in the above-mentioned configuration file, create the corresponding task of being responsible for generating form, comprise a call back function in each task, all tasks are formed a task queue; Just need to create several tasks if generate several forms; When needing task to generate form, this is called.
Above-mentioned task queue is in charge of by a monitor task, the review time that monitor task is set according to configuration item in the above-mentioned configuration file 1 is checked all tasks in the above-mentioned task queue at interval, if need generate time of form to certain task, just call the call back function of this task.This call back function is according to specifying the complete SQL statement of information structuring (this SQL can be that query statement also can be to carry out storing process) in the above-mentioned configuration file configuration item 5, and carry out and construct good SQL statement, its result will be kept in the temporary table of database, and the table name of this temporary table is configuration item 6 appointments in the configuration file.
The block copy order of using database to provide is poured out data from above-mentioned temporary table with data, form file in file system.The path that this document is deposited is specified by configuration item in the configuration file 8, and filename is specified by configuration item in the configuration file 9.
Above-mentioned file is made amendment, increase the report heading of configuration item 10 appointments in the configuration file, increase the required various symbols of html file form, change it into html format file, and according to the specified threshold value inspection method of configuration item in the configuration file 12,13, specific field is carried out the threshold value inspection, if have above threshold value and get data item, when revising temporary file, it is arranged to special marking, for example: change font color into redness, and the alarm packet in the structure snmp protocol, send alarm to the network management alarm backstage.
Below introduce one embodiment of the present of invention:
Present embodiment is the content of the required configuration file of metering of call daily paper of generation, and the form that produces is as shown in Figure 2 automatically:
Configuration item 1:28800 (second)
Configuration item 2:1 (task)
Configuration item 3: service management database (database name)
Configuration item 4: storing process
Configuration item 5: metering of call daily paper storing process (storing process name)
Configuration item 6: metering of call daily paper statistics table (the interim table name of database)
Configuration item 7: every day 1:00 AM
Configuration item 8: the path of depositing after the report generation
Configuration item 9: metering of call daily paper
Configuration item 10: time started | the number of calls | call phase fair termination number of times | call phase abnormal end number of times | the user success rate % that surfs the Net
Configuration item 11: report generation mode
Configuration item 12: be
Configuration item 13: user's success rate of surfing the Net is lower than 80% and sends alarm
Automatically the report generation module is embodied as background process, when this process initiation, reads automatic report generation configuration file, obtains relevant configuration information.Configuration file is the text of established form, and the parsing of configuration file is finished by the built-in resolver of module.
Automatically the report generation module obtains automatic report generation mission bit stream by resolving configuration file, creates corresponding task by task manager then, and each task is responsible for generating a form.Automatically the report generation task can regularly trigger, and produces complete SQL statement, Query Database, establishment query results temporary table, call at last report form generator with the html format report output under specified path.

Claims (7)

1, a kind of method of automatic generation webmaster form is characterized in that this method comprises following each step:
(1) reads the relevant configuration information for the treatment of automatic report generation in the configuration file;
(2) according to configuration information, create the corresponding task of being responsible for generating form, comprise a call back function in each task, all tasks are formed a task queue;
(3) monitor task according to the review time in the above-mentioned configuration file at interval, all tasks in the above-mentioned task queue are checked, if need generate time of form to certain task, just call the call back function of this task;
(4) this call back function is constructed complete SQL according to the appointed information in the above-mentioned configuration file, and carries out the good SQL statement of structure, execution result is kept in the temporary table of database;
(5) according to the block copy order in the database, data are read from above-mentioned temporary table, in file system, form file.
2, the method for claim 1 is characterized in that configuration file wherein is configured by the user.
3, the method for claim 1 is characterized in that wherein said configuration file is the text of established form.
4, the method for claim 1 is characterized in that each configuration item in the wherein said configuration file is: The configuration item numbering Describe 1 Inspect the task readjustment time interval 2 Automatic report generation task sum 3 The database of report query 4 Report data comes Source Type 5 The SQL statement that automatic report query is relied on
6 Database temporary table table name 7 The report generation time 8 The path of depositing after the report generation 9 The report file name 10 Report heading 11 Report generation mode: sequential system or coverage mode 12 Whether need to carry out the threshold value inspection 13 Threshold value is described, which field checked, on the threshold value/lower limit
5, the method for claim 1, it is characterized in that also comprising: the file to wherein the 5th step formation is made amendment, increase the report heading of appointment in the configuration file, increase the required various symbols of generation supertext making language document form automatically, change it into supertext markup language file.
6, the method for claim 1, it is characterized in that also comprising: according to specified threshold value in the first step configuration file, the specific field that forms file is carried out the threshold value inspection, if the data item above threshold value is arranged, it is set to special marking when revising temporary file, and the alarm packet in the simple structure NMP, send alarm to the network management alarm backstage.
7, the method for claim 1 is characterized in that in wherein said the 5th step, the file that forms in file system, its filename and deposit the path and specified by the configuration item in the configuration file.
CNB021423156A 2002-09-13 2002-09-13 Method for automatic generating of net management report form Expired - Fee Related CN100372290C (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CNB021423156A CN100372290C (en) 2002-09-13 2002-09-13 Method for automatic generating of net management report form

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CNB021423156A CN100372290C (en) 2002-09-13 2002-09-13 Method for automatic generating of net management report form

Publications (2)

Publication Number Publication Date
CN1482766A true CN1482766A (en) 2004-03-17
CN100372290C CN100372290C (en) 2008-02-27

Family

ID=34148003

Family Applications (1)

Application Number Title Priority Date Filing Date
CNB021423156A Expired - Fee Related CN100372290C (en) 2002-09-13 2002-09-13 Method for automatic generating of net management report form

Country Status (1)

Country Link
CN (1) CN100372290C (en)

Cited By (18)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN100388676C (en) * 2004-12-06 2008-05-14 中兴通讯股份有限公司 Method for auto-forming reporting forms of telecommunication equipment performance
CN100395752C (en) * 2005-11-08 2008-06-18 华为技术有限公司 Report data collection system and method
CN101043545B (en) * 2007-03-22 2010-07-07 华为技术有限公司 Method for maintaining communication apparatus
CN101541021B (en) * 2008-03-18 2010-07-21 中国移动通信集团天津有限公司 Method for automatically generating capacity-warning reports
CN101866350A (en) * 2010-05-11 2010-10-20 中兴通讯股份有限公司 Report generation method and device as well as WEB server
CN102411672A (en) * 2011-08-05 2012-04-11 中国科学院光电技术研究所 Method for generating report for rapidly analysis processing test data of photoelectric tracking measurement equipment
CN102422237A (en) * 2009-05-13 2012-04-18 Abb技术有限公司 Alarm management system
CN102023974B (en) * 2009-09-14 2012-08-22 中国移动通信集团公司 Method, device and system for processing message by message queue
WO2012130162A1 (en) * 2011-03-30 2012-10-04 中国银联股份有限公司 System and method for generating information file based on parallel processing
CN102739692A (en) * 2011-03-31 2012-10-17 新奥特(北京)视频技术有限公司 Method and apparatus for uploading reports used in sports event information system
CN102739693A (en) * 2011-03-31 2012-10-17 新奥特(北京)视频技术有限公司 Method and apparatus for distributing statements used in sports event information system
CN103092621A (en) * 2013-03-08 2013-05-08 广州市西美信息科技有限公司 Chart creating method and device
CN103488693A (en) * 2013-09-02 2014-01-01 用友软件股份有限公司 Data processing device and data processing method
CN103699557A (en) * 2013-09-04 2014-04-02 中国四维测绘技术有限公司 Report processing method and report processing system
CN104270340A (en) * 2014-09-01 2015-01-07 北京锐安科技有限公司 Voice signaling data storage method and rapid early warning method
CN106156075A (en) * 2015-03-31 2016-11-23 中国科学院声学研究所 A kind of report generation and the method and device of displaying
WO2019134230A1 (en) * 2018-01-08 2019-07-11 平安科技(深圳)有限公司 Database monitoring method, apparatus, terminal device and storage medium
CN111339128A (en) * 2018-12-18 2020-06-26 北京嘀嘀无限科技发展有限公司 Data acquisition method and device, electronic equipment and storage medium

Family Cites Families (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6178413B1 (en) * 1998-05-20 2001-01-23 Technolines, Llc Database program with automatic creation of user features
US6195653B1 (en) * 1997-10-14 2001-02-27 International Business Machines Corporation System and method for selectively preparing customized reports of query explain data

Cited By (28)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN100388676C (en) * 2004-12-06 2008-05-14 中兴通讯股份有限公司 Method for auto-forming reporting forms of telecommunication equipment performance
CN100395752C (en) * 2005-11-08 2008-06-18 华为技术有限公司 Report data collection system and method
CN101043545B (en) * 2007-03-22 2010-07-07 华为技术有限公司 Method for maintaining communication apparatus
CN101541021B (en) * 2008-03-18 2010-07-21 中国移动通信集团天津有限公司 Method for automatically generating capacity-warning reports
CN102422237B (en) * 2009-05-13 2015-03-11 Abb技术有限公司 Alarm management system
CN102422237A (en) * 2009-05-13 2012-04-18 Abb技术有限公司 Alarm management system
CN102023974B (en) * 2009-09-14 2012-08-22 中国移动通信集团公司 Method, device and system for processing message by message queue
CN101866350A (en) * 2010-05-11 2010-10-20 中兴通讯股份有限公司 Report generation method and device as well as WEB server
WO2011140770A1 (en) * 2010-05-11 2011-11-17 中兴通讯股份有限公司 Report processing method, apparatus and web server
US9531792B2 (en) 2011-03-30 2016-12-27 China Unionpay Co., Ltd. System and method for generating information file based on parallel processing
WO2012130162A1 (en) * 2011-03-30 2012-10-04 中国银联股份有限公司 System and method for generating information file based on parallel processing
CN102737016A (en) * 2011-03-30 2012-10-17 中国银联股份有限公司 A system and a method for generating information files based on parallel processing
CN102737016B (en) * 2011-03-30 2014-07-16 中国银联股份有限公司 A system and a method for generating information files based on parallel processing
CN102739692A (en) * 2011-03-31 2012-10-17 新奥特(北京)视频技术有限公司 Method and apparatus for uploading reports used in sports event information system
CN102739693A (en) * 2011-03-31 2012-10-17 新奥特(北京)视频技术有限公司 Method and apparatus for distributing statements used in sports event information system
CN102411672A (en) * 2011-08-05 2012-04-11 中国科学院光电技术研究所 Method for generating report for rapidly analysis processing test data of photoelectric tracking measurement equipment
CN103092621A (en) * 2013-03-08 2013-05-08 广州市西美信息科技有限公司 Chart creating method and device
CN103092621B (en) * 2013-03-08 2016-08-03 广州市西美信息科技有限公司 The method and device that a kind of chart generates
CN103488693A (en) * 2013-09-02 2014-01-01 用友软件股份有限公司 Data processing device and data processing method
CN103699557A (en) * 2013-09-04 2014-04-02 中国四维测绘技术有限公司 Report processing method and report processing system
CN103699557B (en) * 2013-09-04 2017-10-10 中国四维测绘技术有限公司 report processing method and system
CN104270340A (en) * 2014-09-01 2015-01-07 北京锐安科技有限公司 Voice signaling data storage method and rapid early warning method
CN104270340B (en) * 2014-09-01 2017-10-27 北京锐安科技有限公司 A kind of voice signaling date storage method and the method for quick early warning
CN106156075A (en) * 2015-03-31 2016-11-23 中国科学院声学研究所 A kind of report generation and the method and device of displaying
CN106156075B (en) * 2015-03-31 2019-08-02 中国科学院声学研究所 A kind of method and device of report generation and displaying
WO2019134230A1 (en) * 2018-01-08 2019-07-11 平安科技(深圳)有限公司 Database monitoring method, apparatus, terminal device and storage medium
CN111339128A (en) * 2018-12-18 2020-06-26 北京嘀嘀无限科技发展有限公司 Data acquisition method and device, electronic equipment and storage medium
CN111339128B (en) * 2018-12-18 2023-09-26 北京嘀嘀无限科技发展有限公司 Data acquisition method and device, electronic equipment and storage medium

Also Published As

Publication number Publication date
CN100372290C (en) 2008-02-27

Similar Documents

Publication Publication Date Title
CN1482766A (en) Method for automatic generating of net management report form
DE602004011455T2 (en) Method and system for automatically generating service interfaces for a service-oriented architecture
CN107070890A (en) Flow data processing device and communication network major clique system in a kind of communication network major clique system
US6704726B1 (en) Query processing method
CN100401288C (en) Distributed data source data integration system and method
CN103684828B (en) A kind for the treatment of method and apparatus of telecommunication equipment fault
DE69731614T2 (en) NETWORKING DEVICE AND METHOD FOR MANUFACTURING SUCH A DEVICE
CN111917887A (en) System for realizing data governance under big data environment
DE102015101370A1 (en) Managing big data in process control systems
CN107818024A (en) A kind of request ID transmission methods and system based on spring blockers
CA2518902C (en) System and method for query planning and execution
CN100395987C (en) Method and system for realizing telecommunication network universal performance management
CN107317724A (en) Data collecting system and method based on cloud computing technology
DE102006047499A1 (en) Data extensibility using external database tables
CN101047935A (en) Customer complaint process analysis method
CN107179977B (en) Database Full-automatic monitoring system based on mpm models
CN110175027A (en) A kind of method and apparatus for developing business function
CN104317942A (en) Massive data comparison method and system based on hadoop cloud platform
CN101815012B (en) Method and device for acquiring performance data
CN1394036A (en) Network management system based on strategy
CN1761277A (en) Device for dynamic analyzing call ticket and dynamic analyzing method
DE602004007879T2 (en) Service provisioning system
CN1801145A (en) Method for improving database access efficiency of application system
CN1787448A (en) Method for auto-forming reporting forms of telecommunication equipment performance
CN101192976A (en) Automatic generation method for standard report of value-added service

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
C14 Grant of patent or utility model
GR01 Patent grant
CF01 Termination of patent right due to non-payment of annual fee

Granted publication date: 20080227

Termination date: 20150913

EXPY Termination of patent right or utility model