CN102436372A - Monitoring table generation system - Google Patents
Monitoring table generation system Download PDFInfo
- Publication number
- CN102436372A CN102436372A CN2011102544764A CN201110254476A CN102436372A CN 102436372 A CN102436372 A CN 102436372A CN 2011102544764 A CN2011102544764 A CN 2011102544764A CN 201110254476 A CN201110254476 A CN 201110254476A CN 102436372 A CN102436372 A CN 102436372A
- Authority
- CN
- China
- Prior art keywords
- rule
- data
- application server
- refresh
- web application
- 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 Transfer Between Computers (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a monitoring table generation system which comprises table configuration files, a table analyzer, a table generator, an Ajax engine, a WEB application server and a browser. The system has the functions of carrying out format design, operand-fetching design, display design and automatic generation and the like on tables, and the implementation of these definition processes of tables are completely defined by users without programming. For better satisfying the demands on dynamic monitoring, the system also provides the functions of dynamic refresh-frequency definition of tables or refresh-frequency definition of different fields of tables, and the like.
Description
Technical field
The present invention relates to a kind of method that form generates of monitoring, belong to field of computer technology.
Background technology
The internet has been deep into people's various fields in life; The in-house network of oneself has been set up or set up in more and more enterprises, organisations and institutions, and the exploitation of many supervisory routines also changes to the B/S framework based on Internet/Intranet from traditional C/S framework.Though the different programs framework has brought each item technology used in performance history and the exploitation and the transformation of all kinds of developing instruments, for most supervisory routine, the generation of monitoring form is an inevitable task in the performance history.For computing system; Form system is data statistics, analysis and the demonstration tool in the grid system; Realize the visual of historical data; Let the user that the operating position of computational resource is understood, planning for the software and hardware in future provides decision-making foundation, the following facility usage trend that calculates of aid forecasting.
In the performance history of the database application of traditional C/S framework; The application development instrument of each manufacturer all provides strong support to the exploitation of form, and the form that can accomplish easily in the database application performance history under the C/S framework generates task.And in the database application exploitation of B/S framework, since the singularity of its program run environment, the present form developing instrument that also is not simple and easy to usefulness.Client application running environment is general browser in addition, can only show static html text, and this has also brought certain degree of difficulty for the exploitation of dynamic table.
Microcomputer information, 2005 26 phases, " based on the dynamic data report generation technology of XML " just adopts XML to define a kind of extraction set of business data, can not carry out the Dynamic Display parameter configuration; " based on stratification project information Design of Management System and the realization of XML " adopted the user interface of XML define system; " based on the displaying subsystem research of the dynamic statement system of WEB " adopts the SVG file that form is showed, and is different with realization mechanism of the present invention.
The dynamic statement that " based on the implementation of dynamic statement under the B/S framework of XML ", " based on the research and the realization of AJAX Technology in Web form ", " based on the design of enterprise's universal dynamic report-building tool of Excel " and " based on the EIP dynamic statement system of ActiveX " are touched upon is static the demonstration; Can not realize that dynamic demonstration can not realize the periodic refreshing function, the inheritability of system is not strong." realizing the method for dynamic statement and the tissue of data thereof " do not adopted the XML descriptive language." a kind of dynamic report generation method and platform " and " ABSTRACTED DYNAMIC REPORT DEFINITION GENERATION FOR USE WITHIN INFORMATION TECHNOLOGY INFRASTRUCTURE " is two pieces of patent documentations; The dynamic statement device of touching upon in the literary composition is taked static the demonstration; Can not realize that dynamic demonstration can not realize the periodic refreshing function, the inheritability of system is not strong.
Summary of the invention
Technology of the present invention is dealt with problems and is: the deficiency that overcomes prior art; A kind of monitoring form generation system based on the XML language is provided; This method can be carried out dynamic interface configurations and generation to the monitoring form of WEB page format, and the automatic refresh function of data is provided.
Technical solution of the present invention is: a kind of monitoring form generation system comprises form configuration file, tabular analysis device, form generation, Ajax engine, WEB application server and browser;
The form configuration file adopts xml formal definition form static information, peek rule, fill rule and refreshes rule, and the form configuration file stores is in the WEB application server;
The tabular analysis device; Generate request according to the form that receives; From the WEB application server, obtain the form configuration file, the xml configuration file is resolved, generate form static information, peek rule, fill rule and refresh rule; To peek rule, fill rule and refresh rule and merge into rule set, and form static information and rule set are sent to grid builder;
Grid builder is used for being responsible for processing form generation work; Acceptance is from the form static information and the rule set of tabular analysis device; Peek rule according in the rule set is inquired about database, obtains result data, according to the fill rule in the rule set; With the assembling of result data and form static information and generate form, and with this form with refresh rule and be sent to the WEB application server;
The WEB application server receives the request of Ajax engine, when receiving form generation request, it is transmitted to the tabular analysis device; Receive the form of grid builder generation and refresh rule, and it is passed to the Ajax engine; When obtaining the cyclic polling instruction from the Ajax engine, send the data query request to database, receive the data query result, and it is transmitted to the Ajax engine;
The Ajax engine receives list data and refreshes rule from the WEB application server, and list data is directly passed to browser; According to the rule that refreshes of form, to the needs data updated, the WEB application server is sent the cyclic polling instruction, and reception needs the Query Result of data updated, and send it to browser, the html page is carried out dynamic refresh;
Browser, the user is accepted to the request that form generates in browser display form interface, sends command adapted thereto to the Ajax engine, and obtains the result that the Ajax engine returns, and it is showed the user.
Described grid builder performing step is following:
The first step is obtained form static information and rule set from the tabular analysis device;
Second step, rule set is carried out rule identification, send the data query request according to the peek rule to database;
In the 3rd step, obtain the data query result from database;
In the 4th step,, the three is assembled into list data according to data query result, form static information and fill rule;
The 5th step, with the list data that is assembled in the 4th step with refresh rule and be sent to application server.
The present invention compared with prior art beneficial effect is: the present invention proposes a kind of monitoring form generation system based on XML.This system has form is carried out format design, peek design, display design and functions such as generation automatically, and the realization of these definition procedures of form is fully by User Defined, the realization of need not programming.In order to satisfy the dynamic monitoring demand better, the dynamic refresh frequency definition of form is provided in addition, perhaps the functions such as refreshing frequency definition of form different field.Specific as follows:
(1) possesses ability with a plurality of system integrations
Therefore dynamic table generation system and database direct correlation, and support the WEB browser, only needing through integrated and the simple database configuration of the page when integrated with the WEB application system, just can extensive integrated and use in the types of applications under the B/S framework.
(2) Data Dynamic refreshes
The invention provides the dynamic refresh function of list data, and can configuration data refresh parameter, be fit to be applied in the system monitoring that data in real time upgrades.
(3) inheritability of reporting format
The present invention is defined as configuration file with static information, peek rule, fill rule and the dynamic refresh principle combinations of form; The form of expression and the content of form are separately considered; Can be so that form customization personnel inherit former table format; The data content is just made an amendment slightly can the brand-new report of newly-built portion, has reduced form customization personnel's workload.
(4) be simple and easy to use
Employing is based on the access mode of WEB, and the user does not need the download client program in use, any other system mend need be installed yet.
Description of drawings
Fig. 1 is a system architecture synoptic diagram of the present invention;
Fig. 2 is a tabular analysis device synoptic diagram of the present invention;
Fig. 3 is a grid builder synoptic diagram of the present invention.
Fig. 4 is data transfer synoptic diagram between Ajax engine of the present invention, WEB application server and the browser.
Embodiment
Monitoring form generation system is with the performance of WEB form, for the user provides form generation and the function that shows.As shown in Figure 1, system of the present invention is divided into form configuration file, tabular analysis device, form generation, Ajax engine, WEB application server and browser six parts.The Ajax engine selects Dojo, WEB server to select Tomcat in the present invention, and browser is selected IE 6.0, is matured product, does not introduce its implementation procedure in detail, among the present invention.Introduce the implementation procedure of form configuration file, tabular analysis device, grid builder below in detail.
One, form configuration file
The form configuration file is made up of four parts: form static information, peek rule and fill rule and dynamic refresh rule.
(1) static information definition
The form static information is the description to whole form static content.Following table is the describing mode of form in html.
The schedule work fragment:
| Operation ID | Job title | Jobs node | Job state |
| 1 | B01X00 | 1 | 2 |
| 2 | C01X00 | 3 | 3 |
| 3 | B01X00 | 5 | 10 |
| ... | ... | ... | ? |
The HTML of schedule work fragment representes as follows:
Top html describes the complete overall picture that reflects the operation form; And the content in the table label meets the requirement of XML segment fully; Be the XML segment of a format specification, we have used the definition mode of form among the html when carrying out the description of form static content.
In the dynamic table system, do not define cell and describe details and font, a definition unit lattice content.Content since second row in schedule work all dynamically generates from database, belongs to static content and has only first row.Therefore, the first row information of form only need be described with html.
It is following that static information in the form xml configuration documentation is described fragment:
(2) peek rule definition
The peek rule is that how having described fetches data from other databases is filled the correlation unit lattice on the form to the description of form peek dynamic content with the definition of fill area.A form can comprise several fill areas, and the corresponding peek rule in each fill area can be formed various complicate list forms like this.The corresponding peek rule of each cell under extreme case.
The peek rule is explained the data how extraction needs from database.The core of peek rule is a query SQL statement, the data how definition needs the data library inquiry.In system, adopt standard sql statement, as:
SELECT?id，name，status?FROM?boinc_job?WHERE?node＝3；
(3) fill rule definition
The fill area will define inquiry rreturn value and filling mapping relations form each field between of peek in the rule.Which cell first the record that fill rule can given query returns is filled into.Fill rule is by < fields>element definition in the xml document, and the child node < field>of < fields>element has been described the fill area of data.
Peek rule and filling mode fragment in the form xml configuration documentation are following:
(4) refresh rule
Through refreshing the rules customization in customization zone, can select that different critical datas are had different monitoring refreshing frequencys, to reach better dynamic monitoring effect.And can be between the data setting color viewing area of monitoring.For example, when this data during greater than certain threshold value, background color is set to green, and during less than certain number, background color is set to redness.Can let the operator that the current state of data is come into plain view like this.
In the xml document, add an element < refresh >, the child node of < refresh>element has been described the rule that refreshes of data.
It is following that refreshing in the form xml configuration documentation customizes fragment:
Above-mentioned refreshing in the rule,＜sql SELECT status FROM boinc_job WHERE id in#; The Ajax engine can be passed in/＞statement.The Ajax engine is selected all id in the list data of receiving, fill this sql statement, as: sql SELECT status FROM boinc_job WHERE id in (1; 2; 3), give the WEB application server with this sql statement asynchronous transmission again, inquire about; Then according to return data, row number are that 4 cell carries out 10 seconds dynamic refreshes once in the his-and-hers watches.When state=3, background colour is green, and when state＞3, background colour be a redness.
Provide the complete example of a form definition XML document below:
Two, tabular analysis device
The tabular analysis device is responsible for resolving the xml configuration file, sends rule to grid builder according to configuration file.
The realization synoptic diagram of tabular analysis device is as shown in Figure 2, and performing step is following:
The first step is obtained the form configuration file from Web Application Server.
Second step; Use DOM resolver resolves form configuration file; Resolve table label, fillin label, sql label, fields label and refresh label; Generate form static information, peek rule, fill rule and dynamic refresh rule, and will peek rule, fill rule and dynamic refresh rule are merged into rule set;
In the 3rd step, form static information and rule set that second step was parsed are sent to grid builder.
Three, grid builder
Grid builder is used for being responsible for handling form generation work, accepts the rule from the tabular analysis device, and database is inquired about, and obtains data, according to regular assembled custom data, generates form.
The realization synoptic diagram of grid builder is as shown in Figure 3, and performing step is following:
The first step is obtained form static information and rule set from the tabular analysis device;
Second step, rule set is carried out rule identification, send the data query request according to the peek rule to database;
In the 3rd step, obtain the data query result from database;
In the 4th step,, the three is assembled into list data according to data query result, form static information and fill rule;
The 5th step, with the list data that is assembled in the 4th step with refresh rule and be sent to application server.
Four, Ajax engine, WEB application server and browser
The Ajax engine is the middle layer between browser and the application server, and the user is operated and server response asynchronization.Data verification on the page and data processing can be undertaken by the Ajax engine, if desired when server reads new list data again by the Ajax engine on behalf of submitting the cyclic polling request to server.
The WEB application server is selected Tomcat.Tomcat is the Web application software container based on Java of an open source code, operation servlet and JSP Web application software, realizes resolving the HTTP request and also generates the response back browser, and service logic is provided for application program.
Browser is to show the html file content, and lets the software of user and these file interactions.Select IE6.0 as browser in this patent, accept the html file that the Ajax engine is delivered, and be shown to the user.
Data transfer synoptic diagram between Ajax engine, WEB application server and the browser is as shown in Figure 4, and performing step is following:
The first step, application server with report data with refresh rule and pass to the Ajax engine;
In second step, the Ajax engine generates the cyclic polling order and sends to application server according to refreshing rule;
In the 3rd step, the Ajax engine is converted into the html page data with report data, and according to the data color that refreshes in the rule definition form, gives browser with page data transmission, is shown as the page;
In the 4th step, application server is received the cyclic polling order, sends the data query request to database;
In the 5th step, application server is received the data query result, and it is passed to the Ajax engine;
In the 6th step, the Ajax engine is received the data query result, and being translated into needs data updated to send to browser;
In the 7th step, browser is received needs data updated, upgrades the page.
The unspecified part of the present invention belongs to general knowledge as well known to those skilled in the art.
Claims (2)
1. a monitoring form generation system is characterized in that: comprise form configuration file, tabular analysis device, form generation, Ajax engine, WEB application server and browser;
The form configuration file adopts xml formal definition form static information, peek rule, fill rule and refreshes rule, and the form configuration file stores is in the WEB application server;
The tabular analysis device; Generate request according to the form that receives; From the WEB application server, obtain the form configuration file, the xml configuration file is resolved, generate form static information, peek rule, fill rule and refresh rule; To peek rule, fill rule and refresh rule and merge into rule set, and form static information and rule set are sent to grid builder;
Grid builder is used for being responsible for processing form generation work; Acceptance is from the form static information and the rule set of tabular analysis device; Peek rule according in the rule set is inquired about database, obtains result data, according to the fill rule in the rule set; With the assembling of result data and form static information and generate form, and with this form with refresh rule and be sent to the WEB application server;
The WEB application server receives the request of Ajax engine, when receiving form generation request, it is transmitted to the tabular analysis device; Receive the form of grid builder generation and refresh rule, and it is passed to the Ajax engine; When obtaining the cyclic polling instruction from the Ajax engine, send the data query request to database, receive the data query result, and it is transmitted to the Ajax engine;
The Ajax engine receives list data and refreshes rule from the WEB application server, and list data is directly passed to browser; According to the rule that refreshes of form, to the needs data updated, the WEB application server is sent the cyclic polling instruction, and reception needs the Query Result of data updated, and send it to browser, the html page is carried out dynamic refresh;
Browser, the user is accepted to the request that form generates in browser display form interface, sends command adapted thereto to the Ajax engine, and obtains the result that the Ajax engine returns, and it is showed the user.
2. a kind of monitoring form generation system according to claim 1, it is characterized in that: described grid builder performing step is following:
The first step is obtained form static information and rule set from the tabular analysis device;
Second step, rule set is carried out rule identification, send the data query request according to the peek rule to database;
In the 3rd step, obtain the data query result from database;
In the 4th step,, the three is assembled into list data according to data query result, form static information and fill rule;
The 5th step, with the list data that is assembled in the 4th step with refresh rule and be sent to application server.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201110254476.4A CN102436372B (en) | 2011-08-31 | 2011-08-31 | Monitoring table generation system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201110254476.4A CN102436372B (en) | 2011-08-31 | 2011-08-31 | Monitoring table generation system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN102436372A true CN102436372A (en) | 2012-05-02 |
| CN102436372B CN102436372B (en) | 2014-07-02 |
Family
ID=45984452
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201110254476.4A Active CN102436372B (en) | 2011-08-31 | 2011-08-31 | Monitoring table generation system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102436372B (en) |
Cited By (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104572694A (en) * | 2013-10-18 | 2015-04-29 | 镇江鼎拓科技信息有限公司 | WEB-mode report generating method based on XML (extensive makeup language) |
| CN104572698A (en) * | 2013-10-18 | 2015-04-29 | 镇江鼎拓科技信息有限公司 | XML-based Web data report generation method under JSP framework |
| CN104778285A (en) * | 2015-05-12 | 2015-07-15 | 成都广达电子股份有限公司 | XML-based WEB service system and working method thereof |
| CN105183489A (en) * | 2015-10-10 | 2015-12-23 | 南京国电南自轨道交通工程有限公司 | Extjs frame based intelligent data analysis system and method |
| CN107277003A (en) * | 2017-06-12 | 2017-10-20 | 郑州云海信息技术有限公司 | A kind of account security management method and system |
| CN107656914A (en) * | 2017-10-16 | 2018-02-02 | 厦门海迈科技股份有限公司 | Form generation method, device, terminal device and the storage medium of configurableization |
| CN109343848A (en) * | 2018-09-18 | 2019-02-15 | 西安葡萄城信息技术有限公司 | A kind of webpage design method and system |
| CN109508447A (en) * | 2017-09-14 | 2019-03-22 | 长沙博为软件技术股份有限公司 | A kind of list data analysis method of the high col width of fixed row |
| CN110569469A (en) * | 2019-09-06 | 2019-12-13 | 四川长虹电器股份有限公司 | Method for dynamically generating HTML (hypertext markup language) form based on data configuration |
| CN110728122A (en) * | 2019-10-12 | 2020-01-24 | 京东数字科技控股有限公司 | Table generation method and device |
Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101216817A (en) * | 2007-12-29 | 2008-07-09 | 中国建设银行股份有限公司 | Heterogeneous report form integration and centralized management device and system |
-
2011
- 2011-08-31 CN CN201110254476.4A patent/CN102436372B/en active Active
Patent Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101216817A (en) * | 2007-12-29 | 2008-07-09 | 中国建设银行股份有限公司 | Heterogeneous report form integration and centralized management device and system |
Non-Patent Citations (2)
| Title |
|---|
| 李艳娥等: "基于AJAX技术的Web报表的研究与实现", 《内蒙古工业大学学报》 * |
| 赵中华等: "基于XML的B/S架构下动态报表的实现方式", 《山东轻工业学院学报》 * |
Cited By (14)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104572698A (en) * | 2013-10-18 | 2015-04-29 | 镇江鼎拓科技信息有限公司 | XML-based Web data report generation method under JSP framework |
| CN104572694A (en) * | 2013-10-18 | 2015-04-29 | 镇江鼎拓科技信息有限公司 | WEB-mode report generating method based on XML (extensive makeup language) |
| CN104778285B (en) * | 2015-05-12 | 2018-08-28 | 成都广达新网科技股份有限公司 | A kind of WEB service system and its working method based on XML |
| CN104778285A (en) * | 2015-05-12 | 2015-07-15 | 成都广达电子股份有限公司 | XML-based WEB service system and working method thereof |
| CN105183489A (en) * | 2015-10-10 | 2015-12-23 | 南京国电南自轨道交通工程有限公司 | Extjs frame based intelligent data analysis system and method |
| CN107277003A (en) * | 2017-06-12 | 2017-10-20 | 郑州云海信息技术有限公司 | A kind of account security management method and system |
| CN109508447A (en) * | 2017-09-14 | 2019-03-22 | 长沙博为软件技术股份有限公司 | A kind of list data analysis method of the high col width of fixed row |
| CN107656914A (en) * | 2017-10-16 | 2018-02-02 | 厦门海迈科技股份有限公司 | Form generation method, device, terminal device and the storage medium of configurableization |
| CN107656914B (en) * | 2017-10-16 | 2020-09-29 | 厦门海迈科技股份有限公司 | Configurable table generation method and device, terminal equipment and storage medium |
| CN109343848A (en) * | 2018-09-18 | 2019-02-15 | 西安葡萄城信息技术有限公司 | A kind of webpage design method and system |
| CN110569469A (en) * | 2019-09-06 | 2019-12-13 | 四川长虹电器股份有限公司 | Method for dynamically generating HTML (hypertext markup language) form based on data configuration |
| CN110569469B (en) * | 2019-09-06 | 2022-02-01 | 四川长虹电器股份有限公司 | Method for dynamically generating HTML (hypertext markup language) form based on data configuration |
| CN110728122A (en) * | 2019-10-12 | 2020-01-24 | 京东数字科技控股有限公司 | Table generation method and device |
| CN110728122B (en) * | 2019-10-12 | 2021-03-30 | 京东数字科技控股有限公司 | Table generation method and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102436372B (en) | 2014-07-02 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102436372B (en) | Monitoring table generation system | |
| Wortmann et al. | Modeling languages in Industry 4.0: an extended systematic mapping study | |
| CN100578495C (en) | Method and system for exposing nested data in a computer-generated document in a transparent manner | |
| Makowski | A structured modeling technology | |
| Ntentos et al. | Assessing architecture conformance to coupling-related patterns and practices in microservices | |
| Gómez-Martínez et al. | Performance assessment of an architecture with adaptative interfaces for people with special needs | |
| Schwarz et al. | Towards an integrated development and sustainability evaluation of energy scenarios assisted by automated information exchange | |
| Saha et al. | Critical factors of website performance: a graph theoretic approach | |
| Hibino et al. | A user support system for manufacturing system design using distributed simulation | |
| Souza et al. | Linked open data publication strategies: Application in networking performance measurement data | |
| Yang et al. | A service-oriented framework for running quantum mechanical simulations of material properties in a grid environment | |
| Michelberger et al. | Determining the link and rate popularity of enterprise process information | |
| Taberko et al. | Ontological Approach for Standards Development Within Industry 4.0 | |
| Birt et al. | Harnessing information technology (IT) for use in production agriculture | |
| Lizcano et al. | Automated end user-centred adaptation of web components through automated description logic-based reasoning | |
| Erazo-Garzon et al. | A Domain-Specific Language and Model-Based Engine for Implementing IoT Dashboard Web Applications | |
| Tan et al. | Internet-based platform for power system simulating and planning | |
| Bivins | Establishing model-to-model interoperability in an engineering workflow | |
| Braun | Microservice-based Reference Architecture for Semantics-aware Measurement Systems | |
| Hussain et al. | Implementation of OGC compliant framework for data integration in Water Distribution System | |
| Watmough | Discovering the hidden semantics in enterprise resource planning data through formal concept analysis | |
| Pavithra et al. | Cloud based result analysis and management system using rest API | |
| Lee et al. | A neutral data interface specification for simulating machine shop operations | |
| Ohuru | A Method for Enhancing Shareability and Reproducibility of Geoprocessing Workflows | |
| Ayuningsih et al. | Development of Information Systems E-People Sarawak at CV. Mobilus Interactive |
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 |