CN1482766A - Method for automatic generating of net management report form - Google Patents
Method for automatic generating of net management report form Download PDFInfo
- 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
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
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 |
10 | |
11 | Report generation mode: sequential system or |
12 | Whether need to carry out the |
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 |
10 | |
11 | Report generation mode: sequential system or |
12 | Whether need to carry out the |
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.
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)
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)
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 |
-
2002
- 2002-09-13 CN CNB021423156A patent/CN100372290C/en not_active Expired - Fee Related
Cited By (28)
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 |