CN103336780A - Real-time monitoring system for equipment information - Google Patents
Real-time monitoring system for equipment information Download PDFInfo
- Publication number
- CN103336780A CN103336780A CN201310206528XA CN201310206528A CN103336780A CN 103336780 A CN103336780 A CN 103336780A CN 201310206528X A CN201310206528X A CN 201310206528XA CN 201310206528 A CN201310206528 A CN 201310206528A CN 103336780 A CN103336780 A CN 103336780A
- Authority
- CN
- China
- Prior art keywords
- module
- database
- equipment
- monitoring system
- web server
- 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.)
- Pending
Links
Images
Landscapes
- Computer And Data Communications (AREA)
Abstract
The invention discloses a real-time monitoring system for equipment information, which is used for conducting real-time remote and mobile monitoring on information of one or more equipment to be monitored. The system comprises terminal equipment, a Web server and a database server which are sequentially connected, wherein the terminal equipment comprises a browser module; the Web server comprises a user authentication module, a background management module, a database module and an equipment management module; a user logs in the Web server through the user authentication module; the background management module comprises an administrator authentication module and an equipment adding module; the equipment adding module has an equipment adding function and a compiling function; variation of the database server is monitored by a trigger; a trigger CLR (Common Language Runtime) sends a context of the trigger to the database module; and the equipment management module judges which equipment the current information variation belongs to according to the information pushed by the database module, checks which terminal pays attention to the equipment to be monitored, and then continues to push the information sent by the database module to a client side.
Description
Technical field
The present invention relates to the data monitoring technology, particularly relate to a kind of facility information real-time monitoring system, it is a kind of general system that facility information is monitored on portable terminal in real time.
Background technology
In the commercial production of reality, it is very important also very practical technology that the real-time information of equipment is showed.In general, the real-time information of equipment shows it is that equipment running status and parameter are carried out the visual process of user with figure, digital mode.Present facility information is showed the desktop application that is based on configuration software mostly, the mode that little web uses, and mobile application is rarer.
For this reason, people imagination, the real-time monitoring of facility information on portable terminal will improve the availability of equipment greatly, security, with and serviceable life, and provide very big facility to the production and operating activities that dependence equipment carries out planning management.Yet, have only indivedual large enterprises to do mobile application at certain special equipment at present, but can't accomplish difference between shielding device, thereby can't large-scale promotion.
Present monitoring of tools is generally all very tight with equipment combination itself.General by programmable logic controller (PLC) (PLC, Programmable Logic Controller) program is passed through OPC (OLE for Process Control with the information of equipment, the OLE that is used for process control), TCP (Transmission Control Protocol, transmission control protocol), UDP agreements such as (User Datagram Protocol, User Datagram Protoco (UDP)) sends in the configuration software (winCC, power control).Then by configuration software establishment terminal presentation program.Different configuration softwares, the PLC of support is of different types.Except configuration software, also has the software fetch equipment information of a large amount of customizations.So present this mode has a lot of problems.
The interface of present most configuration softwares all is the desktop pattern.Because reading and showing all and finish in configuration software of facility information so the monitoring of tools personnel must understand the knowledge of PLC and the knowledge of interface design simultaneously, had relatively high expectations to personnel.And when new equipment increased, the presentation program of a lot of equipment all needed to write again.
Summary of the invention
The technical matters that the present invention mainly solves provides a kind of facility information real-time monitoring system for portable terminal, and it can carry out telemonitoring and mobile monitoring to facility information, and the communication cost is low, requires lower to personnel.
For solving the problems of the technologies described above, the technical scheme that the present invention adopts is: a kind of facility information real-time monitoring system is provided, is used for one or more information of surveillance equipment for the treatment of are monitored in real time; This system comprises terminal device, Web server and the database server that connects successively, and wherein, terminal device includes browser module; Web server comprises user authentication module, Back Administration Module, database module and device management module; The user logins Web server by user authentication module; Back Administration Module comprises that administrator authentication module and equipment add module, and equipment adds module and has equipment interpolation function and compilation facility; The trigger monitoring is used in the change of database server, and trigger CLR sends to database module with the context of trigger; Device management module pushes the message come according to database module judges current message change is to belong to which equipment, and checks which terminal pays close attention to this and treat surveillance equipment, and the information that database module is transmitted continues to be pushed to client then.
In a preferred embodiment of the present invention, described database server comprises monitored target database.
In a preferred embodiment of the present invention, the database module that described Web server is used and monitored target database can be used identical or different database.
In a preferred embodiment of the present invention, the process that described equipment adds module interpolation equipment comprises the steps:
The function that selection equipment adds provides database linkage information and a shared address that comprises its original position, and the mapping relations of the tables of data that will monitor, row name and device parameter;
To copy a trigger DLL to shared address;
In database linkage information, carry out T-SQL, target database is set as allows CLR;
Carry out T-SQL in database linkage information, DLL is compiled into CLR with trigger;
Carry out T-SQL in database linkage information, CLR is deployed to target database with trigger.
In a preferred embodiment of the present invention, described terminal device is one or more of PC, notebook computer, panel computer, personal digital assistant and mobile phone terminal.
In a preferred embodiment of the present invention, described Web server safeguard all terminal devices all connect, and be that terminal device is made the client classification according to the label that connects.
In a preferred embodiment of the present invention, described device management module continues to be pushed to terminal device with the information that database module transmits by websocket.
In a preferred embodiment of the present invention, the two-way communication of setting up websocket between the browser module of described terminal device and the web server connects.
In a preferred embodiment of the present invention, described Web server uses the 5th generation HTML (Hypertext Markup Language) HTML5 and javascript to realize at terminal device.
In a preferred embodiment of the present invention, described browser module will receive the real time data of the equipment that the propelling movement of web server comes, and show in the mode of icon and numerical value; Or show that in the mode of dynamic chart wherein, this dynamic chart adopts third party's widget library to realize.
The invention has the beneficial effects as follows: by adopting websocket and technology, the communication cost reduces greatly between Web server and the browser module.Use the Web program, broken away from configuration software; The real-time device information of browser module pushes in the past rather than poll from database server; The collection and the displaying that have broken away from facility information; Moreover, increasing after the new equipment, facility information is showed does not need to write again code.
Description of drawings
Fig. 1 is the module map of the facility information real-time monitoring system of a preferred embodiment of the present invention;
Fig. 2 is the module map of the Web server of facility information real-time monitoring system shown in Figure 1.
The mark of each parts is as follows in the accompanying drawing: 10, terminal device; 11, browser module; 20, Web server 20; 21, user authentication module; 22, Back Administration Module; 221, administrator authentication module; 222, equipment adds module; 23, database module; 24, device management module; 30, database server.
Embodiment
Below in conjunction with accompanying drawing preferred embodiment of the present invention is described in detail, thereby so that advantages and features of the invention can be easier to be it will be appreciated by those skilled in the art that protection scope of the present invention is made more explicit defining.
The invention provides a kind of facility information real-time monitoring system, be used for one or more information of surveillance equipment for the treatment of are monitored in real time.Described facility information real-time monitoring system is used as a web and is installed on the terminal device, for example one or more of PC, notebook computer, panel computer, personal digital assistant and mobile phone terminal.
See also shown in Figure 1ly, in the present embodiment, the facility information real-time monitoring system comprises successively terminal device 10, Web server 20 and the database server (sqlserver) 30 that connects.Wherein, terminal device 10 includes browser module 11.
In a preferred embodiment, described database server 30 comprises monitored target database.The database module 23 that described Web server 20 is used and monitored target database can be used identical or different database; In view of the problem of efficient, different databases is used in suggestion.
The process that described equipment adds module 222 interpolation equipment comprises the steps:
The user logins Web server 20, the monitoring of online interpolation data;
The function that selection equipment adds provides database linkage information CONN0 (must be keeper's account) and a shared address ADDR1 (the original position ADDR0 that comprises shared address), and the tables of data that will monitor, the mapping relations of row name and device parameter;
To copy a trigger DLL (Dynamic Link Library, dynamic link library) to shared address ADDR1;
In database linkage information CONN0, carry out T-SQL (Transaction-SQL, the enhanced edition of SQL formula design language, it is the main language that allows application and SQL Server link up), target database is set as permission CLR (CommonLanguageRuntime, common language runtime);
Carry out T-SQL in database linkage information CONN0, DLL is compiled into CLR with trigger;
Carry out T-SQL in database linkage information CONN0, CLR is deployed to target database with trigger.So far, a new equipment has been finished with regard to having added.
The trigger monitoring is used in the change of database server 30, and trigger CLR sends to Web server 20 with the context (TriggerContext) of trigger.
The device management module 24 of Web server 20 at first pushes the message of coming according to database server 30 and judges, which equipment current message change belongs to, and checks which terminal paid close attention to this equipment.The device management module 24 of described Web server 20 safeguard all terminal devices 10 all connect, and be that terminal device 10 carries out the client classification according to the label that connects.Then, described device management module 24 continues to be pushed to terminal device 10 with the information that database server 23 transmits by websocket, wherein, websocket is HTML5 (Hypertext Markup Language Version, the 5th generation HTML (Hypertext Markup Language)) a kind of new agreement (protocol), it has realized the full-duplex communication between browser module 11 and the database server 30.
The user uses the browser module 11 on the terminal device 10 to land the web services sites, selects oneself to want the equipment monitored, selects to begin to monitor.
After beginning to monitor, the two-way communication of setting up websocket between the browser module 11 of described terminal device 10 and the Web server 20 connects.The real time data of the equipment that the propelling movement that described browser module 11 will receive Web server 20 is come, and show in the mode of icon and numerical value; Or show that in the mode of dynamic chart wherein, this dynamic chart adopts third party's widget library to realize.
Described terminal device 10 is one or more of PC, notebook computer, panel computer, personal digital assistant and mobile phone terminal.Described Web server 20 uses the 5th generation HTML (Hypertext Markup Language) HTML5 and javascript to realize at terminal device 10, comprises ios so can easily be deployed to, android, all kinds of PC such as windows, the operating system of flat board and mobile phone terminal.Wherein, HTML5 has strengthened the performance performance of Web webpage, secondly, has appended the function that Web such as local data base use; JavaScript is based on object and event-driven and has the browser client script of relative safety.
In above-described embodiment, the user can dynamically add monitoring of tools, and with the real-time information of the mode presentation device of figure and numerical value.The user needn't be restarted the web server, needn't write code, just can increase the supervision of an equipment.
Described facility information real-time monitoring system can be realized telemonitoring and the mobile monitoring of equipment.Illustrate, if the used web server of the present invention is at city A, and the information acquisition database (being database server) for the treatment of surveillance equipment X is at city B, and the user can be from the Web server of city C visit city A, and the database server that adds city B is used for watch-dog.Add finish after, other have the user of authority can be simultaneously from city A, B, ground such as C... come watch-dog X.
Adopt websocket and technology between Web server 20 and the browser module 11, the target of WebSocket standard is to realize and the server end two-way communication that in browser the communication cost reduces greatly.At first, the header file of websocket has only 2Byte, and secondly, the real-time device information of browser module 11 pushes in the past rather than poll from database server 30, has reduced the request cost of the terminal device of client.
Compared to prior art, the facility information real-time monitoring system of above-described embodiment has broken away from configuration software, so the interface can be the web program on the PC, also can be the web on the mobile phone, perhaps App.The maintainability of desktop application is more far short of what is expected than web program, because the web program does not need to install client.
Moreover the present invention has broken away from collection and the displaying of facility information, allows the PLC programmer who much is ignorant of IT also can do the facility information monitoring.
In addition, increase after the new equipment, the user writes fixing database with the equipment real-time information earlier, and facility information writes can be by the program of any configuration software or customized development, and facility information is just showed does not afterwards need to have write code again.
The above only is embodiments of the invention; be not so limit claim of the present invention; every equivalent structure or equivalent flow process conversion that utilizes instructions of the present invention and accompanying drawing content to do; or directly or indirectly be used in other relevant technical fields, all in like manner be included in the scope of patent protection of the present invention.
Claims (10)
1. a facility information real-time monitoring system is used for one or more information of surveillance equipment for the treatment of are monitored in real time; This system comprises terminal device, Web server and the database server that connects successively, and wherein, terminal device includes browser module; Web server comprises user authentication module, Back Administration Module, database module and device management module; The user logins Web server by user authentication module; Back Administration Module comprises that administrator authentication module and equipment add module, and equipment adds module and has equipment interpolation function and compilation facility; The trigger monitoring is used in the change of database server, and trigger CLR sends to database module with the context of trigger; Device management module pushes the message come according to database module judges current message change is to belong to which equipment, and checks which terminal pays close attention to this and treat surveillance equipment, and the information that database module is transmitted continues to be pushed to client then.
2. facility information real-time monitoring system as claimed in claim 1, described database server comprises monitored target database.
3. facility information real-time monitoring system as claimed in claim 2, the database module that described Web server is used and monitored target database can be used identical or different database.
4. facility information real-time monitoring system as claimed in claim 3, described equipment add module and add the process of equipment and comprise the steps:
The function that selection equipment adds provides database linkage information and a shared address that comprises its original position, and the mapping relations of the tables of data that will monitor, row name and device parameter;
To copy a trigger DLL to shared address;
In database linkage information, carry out T-SQL, target database is set as allows CLR;
Carry out T-SQL in database linkage information, DLL is compiled into CLR with trigger;
Carry out T-SQL in database linkage information, CLR is deployed to target database with trigger.
5. facility information real-time monitoring system as claimed in claim 1, described terminal device is one or more of PC, notebook computer, panel computer, personal digital assistant and mobile phone terminal.
6. facility information real-time monitoring system as claimed in claim 1, described Web server safeguard all terminal devices all connect, and be that terminal device is made the client classification according to the label that connects.
7. facility information real-time monitoring system as claimed in claim 1, described device management module continues to be pushed to terminal device with the information that database module transmits by websocket.
8. facility information real-time monitoring system as claimed in claim 1, the two-way communication of setting up websocket between the browser module of described terminal device and the web server connects.
9. facility information real-time monitoring system as claimed in claim 1, described Web server uses the 5th generation HTML (Hypertext Markup Language) HTML5 and javascript to realize at terminal device.
10. facility information real-time monitoring system as claimed in claim 1, described browser module will receive the real time data of the equipment that the propelling movement of web server comes, and show in the mode of icon and numerical value; Or show that in the mode of dynamic chart wherein, this dynamic chart adopts third party's widget library to realize.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310206528XA CN103336780A (en) | 2013-05-30 | 2013-05-30 | Real-time monitoring system for equipment information |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310206528XA CN103336780A (en) | 2013-05-30 | 2013-05-30 | Real-time monitoring system for equipment information |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103336780A true CN103336780A (en) | 2013-10-02 |
Family
ID=49244945
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310206528XA Pending CN103336780A (en) | 2013-05-30 | 2013-05-30 | Real-time monitoring system for equipment information |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103336780A (en) |
Cited By (14)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103634382A (en) * | 2013-11-20 | 2014-03-12 | 安徽科大讯飞信息科技股份有限公司 | System and method for realizing real-time interaction in webpage |
| CN105812406A (en) * | 2014-12-29 | 2016-07-27 | 北京神州泰岳软件股份有限公司 | Information transmission method and device based on WEB simulation terminal system |
| CN105893623A (en) * | 2016-04-29 | 2016-08-24 | 上海交通大学 | Intelligent home system based on B/S structure and data storage and query method thereof |
| CN105915394A (en) * | 2016-06-20 | 2016-08-31 | 河南派亚尼尔自动化设备有限公司 | Visual monitoring platform based on HTML5 and application method |
| CN107024879A (en) * | 2017-04-05 | 2017-08-08 | 大连德嘉工控设备有限公司 | Industry automatic control equipment, method and the router of embedded web monitor server |
| CN107342934A (en) * | 2017-06-19 | 2017-11-10 | 浪潮金融信息技术有限公司 | A kind of mixed mode Mobile solution real-time messages method for pushing and system based on WebSocket |
| CN107566439A (en) * | 2016-09-14 | 2018-01-09 | 彩讯科技股份有限公司 | Equipment state method for real-time monitoring and system based on WebSocket |
| CN108667861A (en) * | 2017-03-28 | 2018-10-16 | 比亚迪股份有限公司 | By browser to the method, system and server of device real-time monitoring |
| CN109451054A (en) * | 2018-12-19 | 2019-03-08 | 京信通信系统（中国）有限公司 | A kind of device management method and equipment |
| CN109460232A (en) * | 2018-09-27 | 2019-03-12 | 深圳新基点智能股份有限公司 | A kind of production and monitoring method of the configuration page |
| CN110704546A (en) * | 2019-09-26 | 2020-01-17 | 惠州西电仲恺人工智能联合创新实验室有限公司 | Electronic billboard system for production management of automobile engine |
| CN111031033A (en) * | 2014-06-13 | 2020-04-17 | 柏思科技有限公司 | Method and system for managing nodes |
| CN111327563A (en) * | 2018-12-13 | 2020-06-23 | 浙江宇视科技有限公司 | Internet of things equipment login management method and device |
| CN112181518A (en) * | 2020-09-25 | 2021-01-05 | 中车青岛四方车辆研究所有限公司 | Train passenger information display system interface design method and system based on BS framework |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101197714A (en) * | 2007-12-13 | 2008-06-11 | 中国移动通信集团湖北有限公司 | Method for centrally capturing mobile data service condition |
| CN102801799A (en) * | 2012-08-03 | 2012-11-28 | 国电南瑞科技股份有限公司 | Real-time monitoring system based on B/S architecture |
-
2013
- 2013-05-30 CN CN201310206528XA patent/CN103336780A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101197714A (en) * | 2007-12-13 | 2008-06-11 | 中国移动通信集团湖北有限公司 | Method for centrally capturing mobile data service condition |
| CN102801799A (en) * | 2012-08-03 | 2012-11-28 | 国电南瑞科技股份有限公司 | Real-time monitoring system based on B/S architecture |
Cited By (18)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103634382A (en) * | 2013-11-20 | 2014-03-12 | 安徽科大讯飞信息科技股份有限公司 | System and method for realizing real-time interaction in webpage |
| CN111031033A (en) * | 2014-06-13 | 2020-04-17 | 柏思科技有限公司 | Method and system for managing nodes |
| CN105812406B (en) * | 2014-12-29 | 2019-05-03 | 北京神州泰岳软件股份有限公司 | Information transferring method and device based on WEB emulation terminal system |
| CN105812406A (en) * | 2014-12-29 | 2016-07-27 | 北京神州泰岳软件股份有限公司 | Information transmission method and device based on WEB simulation terminal system |
| CN105893623A (en) * | 2016-04-29 | 2016-08-24 | 上海交通大学 | Intelligent home system based on B/S structure and data storage and query method thereof |
| CN105915394A (en) * | 2016-06-20 | 2016-08-31 | 河南派亚尼尔自动化设备有限公司 | Visual monitoring platform based on HTML5 and application method |
| CN107566439A (en) * | 2016-09-14 | 2018-01-09 | 彩讯科技股份有限公司 | Equipment state method for real-time monitoring and system based on WebSocket |
| CN108667861B (en) * | 2017-03-28 | 2020-08-07 | 比亚迪股份有限公司 | Method, system and server for monitoring equipment in real time through browser |
| CN108667861A (en) * | 2017-03-28 | 2018-10-16 | 比亚迪股份有限公司 | By browser to the method, system and server of device real-time monitoring |
| CN107024879A (en) * | 2017-04-05 | 2017-08-08 | 大连德嘉工控设备有限公司 | Industry automatic control equipment, method and the router of embedded web monitor server |
| CN107342934A (en) * | 2017-06-19 | 2017-11-10 | 浪潮金融信息技术有限公司 | A kind of mixed mode Mobile solution real-time messages method for pushing and system based on WebSocket |
| CN109460232A (en) * | 2018-09-27 | 2019-03-12 | 深圳新基点智能股份有限公司 | A kind of production and monitoring method of the configuration page |
| CN109460232B (en) * | 2018-09-27 | 2022-09-16 | 深圳新基点智能股份有限公司 | Method for manufacturing and monitoring configuration page |
| CN111327563A (en) * | 2018-12-13 | 2020-06-23 | 浙江宇视科技有限公司 | Internet of things equipment login management method and device |
| CN111327563B (en) * | 2018-12-13 | 2022-06-14 | 浙江宇视科技有限公司 | Internet of things equipment login management method and device |
| CN109451054A (en) * | 2018-12-19 | 2019-03-08 | 京信通信系统（中国）有限公司 | A kind of device management method and equipment |
| CN110704546A (en) * | 2019-09-26 | 2020-01-17 | 惠州西电仲恺人工智能联合创新实验室有限公司 | Electronic billboard system for production management of automobile engine |
| CN112181518A (en) * | 2020-09-25 | 2021-01-05 | 中车青岛四方车辆研究所有限公司 | Train passenger information display system interface design method and system based on BS framework |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103336780A (en) | Real-time monitoring system for equipment information | |
| US8239839B2 (en) | Asynchrony debugging using web services interface | |
| US8788928B2 (en) | System and methodology for development of stream processing applications utilizing spreadsheet interface | |
| US8769502B2 (en) | Template based asynchrony debugging configuration | |
| US20080120393A1 (en) | Web control simulators for mobile devices | |
| CN103092581A (en) | Method and device for setting up Web front-end local development environment | |
| Moshayedi et al. | Raspberry Pi SCADA zonal based system for agricultural plant monitoring | |
| CN103577568A (en) | Cross-platform mobile safety comprehensive information aggregation system and method adopting same | |
| CN109413140B (en) | Remote automatic upgrading method for PACS server | |
| CN106034159A (en) | Serial output system and method of the same | |
| CN103530425A (en) | Android terminal remote data base access code generation system and method based on object dependence mapping | |
| CN101980205A (en) | Universal page generating method | |
| US20130124971A1 (en) | Real time web script refresh using asynchronous polling without full web page reload | |
| US11803786B2 (en) | Enterprise integration platform | |
| US9195704B2 (en) | Automated logging for object-oriented environments | |
| Penberthy | Exam Ref 70-486 Developing ASP. NET MVC 4 Web Applications (MCSD): Developing ASP. NET MVC 4 Web Applications | |
| Tao et al. | Secure gateway of internet of things based on AppWeb and secure sockets layer for intelligent granary management system | |
| Thu et al. | A Method of Automated Mock Data Generation for RESTful API Testing | |
| Siwen et al. | Design and implementation of home automation system | |
| Pathak et al. | Creating Smart IoT Applications | |
| LU100541B1 (en) | An intelligent mobile phone open cross-platform system based on the cloud computing | |
| Patel et al. | Open Source CMS Selection-A Mystery | |
| CN118349719A (en) | Cloud big data acquisition crawler system | |
| Li et al. | Real-time Positioning Measurement using Intelligent Shoes | |
| Bermudez | An Open Source Tool to Test Interoperability |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WD01 | Invention patent application deemed withdrawn after publication | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20131002 |