CN112817809A - Equipment monitoring data model and equipment monitoring method - Google Patents
Equipment monitoring data model and equipment monitoring method Download PDFInfo
- Publication number
- CN112817809A CN112817809A CN202011539825.2A CN202011539825A CN112817809A CN 112817809 A CN112817809 A CN 112817809A CN 202011539825 A CN202011539825 A CN 202011539825A CN 112817809 A CN112817809 A CN 112817809A
- Authority
- CN
- China
- Prior art keywords
- equipment
- sub
- template table
- main
- master
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/30—Monitoring
- G06F11/3065—Monitoring arrangements determined by the means or processing involved in reporting the monitored data
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Quality & Reliability (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Testing And Monitoring For Control Systems (AREA)
Abstract
The invention discloses an equipment monitoring data model and an equipment monitoring method, wherein the model comprises the following steps: a master device template table, a slave device template table and a master and slave relationship table; the main equipment template table comprises a main equipment monitoring field, wherein the main equipment monitoring field is used for receiving the running data of the main equipment uploaded by the equipment running system in real time and storing the running data of the main equipment in the main equipment template table in a key + value storage mode; the sub-equipment template table comprises a sub-equipment monitoring field, wherein the sub-equipment monitoring field is used for receiving the running data of the sub-equipment uploaded by the equipment running system in real time and storing the running data of the sub-equipment in the sub-equipment template table in a key + value storage mode; the sub-equipment is operated under the main equipment; the main and sub relation table is used for recording the corresponding relation between the main equipment template table and the sub equipment template table. The method and the device realize flexible storage of a plurality of monitored data in one field, and avoid large modification of a monitoring model.
Description
Technical Field
The invention relates to the technical field of equipment monitoring, in particular to an equipment monitoring data model and an equipment monitoring method.
Background
Most of the existing monitoring systems are fixed in model structure, data are directly obtained from the fixed structure, the meaning of the data stored in one field is unique, and then the data are shown through statistics. The method is not flexible, the modification of the model can be caused by the change of the later-stage service or the modification of the monitoring index, and the modification cost is large.
Disclosure of Invention
The invention aims to provide an equipment monitoring data model and an equipment monitoring method, which can flexibly store a plurality of monitored data in one field and avoid a large amount of modification on the monitoring model.
In order to achieve the above object, the present invention provides an equipment monitoring data model, which includes: a master device template table, a slave device template table and a master and slave relationship table;
the main equipment template table comprises a main equipment monitoring field, wherein the main equipment monitoring field is used for receiving the operation data of the main equipment uploaded by an equipment operation system in real time and storing the operation data of the main equipment in the main equipment template table in a key + value storage mode;
the sub-equipment template table comprises a sub-equipment monitoring field, wherein the sub-equipment monitoring field is used for receiving the running data of the sub-equipment uploaded by the equipment running system in real time and storing the running data of the sub-equipment in the sub-equipment template table in a key + value storage mode; the sub-equipment is operated under the main equipment;
and the main sub-relation table is used for recording the corresponding relation between the main equipment template table and the sub-equipment template table.
Optionally, the system further includes a main dynamic table, where the main dynamic table is provided with the main device monitoring field, and the main dynamic table is configured to dynamically obtain the operation data of the monitored main device through the main device monitoring field, and upload the obtained operation data of the main device to the main device template table for storage based on the main sub-relationship table.
Optionally, the mobile terminal further includes a sub dynamic table, the sub dynamic table is provided with the sub device monitoring field, and the sub dynamic table is configured to dynamically obtain the operation data of the monitored sub device through the sub device monitoring field, and upload the obtained operation data of the sub device to the sub device template table corresponding to the main device template table for storage based on the main sub relationship table.
Optionally, the main device template table and the sub device template table are in a corresponding relationship of n to n, and a main key association is generated between the main device template table and the sub device template table through a sequence number.
Optionally, the master device template table and the slave device template table each include necessary attribute information.
Optionally, the master device template table and the monitored master devices have a correspondence of 1 to n, and the master device template table and the monitored master devices generate master key associations through sequence numbers, wherein n master devices are master devices of the same type;
the sub-device template table and the monitored sub-devices are in a corresponding relation of 1 to n, main key association is generated between the sub-device template table and the monitored sub-devices through sequence numbers, and the n sub-devices are sub-devices of the same type.
Optionally, the master device template table and the slave device template table are respectively provided with a personalized monitoring value related to the operation state of the monitoring device.
Optionally, the master device template table and the slave device template table are both provided with thresholds corresponding to the device operation data obtained by the master device monitoring field and the slave device monitoring field.
The invention also provides an equipment monitoring method based on the equipment monitoring data model, which comprises the following steps:
receiving running data of the main equipment uploaded by an equipment running system in real time through a main equipment monitoring field in the main equipment template table, and storing the running data of the main equipment in the main equipment template table in a key + value storage mode;
receiving the operation data of the sub-equipment uploaded by an equipment operation system in real time through the sub-equipment template table comprising a sub-equipment monitoring field, and storing the operation data of the sub-equipment in the sub-equipment template table in a key + value storage mode;
and counting and displaying the equipment operation data acquired by the main equipment monitoring field and the sub-equipment monitoring field, and simultaneously recording the log data into a database.
Optionally, when a new master device is added, if the type of the new master device is the same as that of the master device, the master device template is directly applied to monitor the new master device;
if the types of the newly added main equipment and the main equipment are different, generating a new main equipment template corresponding to the newly added main equipment so as to monitor the newly added main equipment;
when the sub-equipment is newly added, if the type of the newly added sub-equipment is the same as that of the sub-equipment, directly applying the sub-equipment template to monitor the newly added sub-equipment;
and if the types of the newly added sub-equipment are different from the types of the sub-equipment, generating a new sub-equipment template corresponding to the newly added sub-equipment so as to monitor the newly added sub-equipment.
The invention has the beneficial effects that:
by generating the main equipment template table and the sub-equipment template table, the equipment monitoring field arranged in the template table stores data in a key + value mode, data fields are reduced, redundancy is reduced, meanwhile, the concept of a template is introduced, direct link with equipment is avoided, the space and efficiency of a database are optimized, and low coupling is realized.
Further, the device template table and the devices have the concept of threshold values, the threshold values in the template table are embodied in the setting of the devices of the same type, and the device threshold values are embodied in the setting of instantiated devices, so that the threshold values are personalized.
The apparatus of the present invention has other features and advantages which will be apparent from or are set forth in detail in the accompanying drawings and the following detailed description, which are incorporated herein, and which together serve to explain certain principles of the invention.
Drawings
The above and other objects, features and advantages of the present invention will become more apparent by describing in greater detail exemplary embodiments thereof with reference to the attached drawings, in which the same type of reference numerals are generally used to designate the same type of components.
Fig. 1 shows a schematic monitoring principle of a device monitoring data model according to an embodiment of the present invention.
Detailed Description
The invention will be described in more detail below with reference to the accompanying drawings. While the preferred embodiments of the present invention are shown in the drawings, it should be understood that the present invention may be embodied in various forms and should not be limited to the embodiments set forth herein. Rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the scope of the invention to those skilled in the art.
Fig. 1 shows a schematic monitoring principle of a device monitoring data model according to an embodiment of the present invention.
As shown in fig. 1, an equipment monitoring data model includes: a master device template table, a slave device template table and a master and slave relationship table;
the main equipment template table comprises a main equipment monitoring field, wherein the main equipment monitoring field is used for receiving the running data of the main equipment uploaded by the equipment running system in real time and storing the running data of the main equipment in the main equipment template table in a key + value storage mode;
the sub-equipment template table comprises a sub-equipment monitoring field, wherein the sub-equipment monitoring field is used for receiving the running data of the sub-equipment uploaded by the equipment running system in real time and storing the running data of the sub-equipment in the sub-equipment template table in a key + value storage mode; the sub-equipment is operated under the main equipment;
the main and sub relation table is used for recording the corresponding relation between the main equipment template table and the sub equipment template table.
The main device template table and the sub device template table are in a corresponding relation of n to n, and main key association is generated between the main device template table and the sub device template table through sequence numbers. The master device template table and the slave device monitoring module both include necessary attribute information.
In particular, the device monitoring template table is a high abstraction for all types of devices. The equipment monitoring template table comprises a main equipment template table and a sub-equipment template table, wherein the main equipment template table and the sub-equipment template table are in n-to-n relation, and main key association is generated through a sequence number and has necessary attribute information. The relationship between the main and sub templates is represented by a main and sub relationship table. The master and slave equipment templates are represented by monitoring fields designed universally, and meanwhile, personalized monitoring values can be increased.
The monitored data can be transmitted from the device operating system to the monitoring field in real time. The field is only one, and the storage mode is in a key + value form. The design is flexible in storage of monitoring data, and can receive different types of equipment data to achieve low coupling. The storage form of key + value is the prior art, and is easy to implement by those skilled in the art, and will not be described herein again.
In this embodiment, the system further includes a main dynamic table and a sub dynamic table, the main dynamic table is provided with a main device monitoring field, and the main dynamic table is configured to dynamically obtain the monitored operation data of the main device through the main device monitoring field, and upload the obtained operation data of the main device to the template table of the main device for storage based on the main sub relation table. Similarly, the sub-dynamic table is provided with a sub-device monitoring field, and the sub-dynamic table is used for dynamically acquiring the operation data of the monitored sub-devices through the sub-device monitoring field, and uploading the acquired operation data of the sub-devices to a sub-device template table corresponding to the main device template table for storage based on the main sub-relation table.
In this embodiment, a corresponding relationship of 1 to n is established between the master device template table and the monitored master devices, and master key associations are generated between the master device template table and the monitored master devices through sequence numbers, where n master devices are master devices of the same type;
the sub-device template table and the monitored sub-devices are in a corresponding relation of 1 to n, and the sub-device template table and the monitored sub-devices generate main key association through sequence numbers, wherein the n sub-devices are the same type of sub-devices.
Specifically, the device template table is associated with the correspondingly monitored device quality inspection, and a 1-to-many relationship is designed. The device data is generated by extracting information in a device template table, the relation between the device template table and the device is 1 to n, and the template can not be deleted after the device is started by taking the sequence number as a main key.
In this embodiment, the master device template table and the slave device template table are respectively provided with a personalized monitoring value related to the operation state of the monitoring device.
Specifically, the fields in the main device template table or the sub-device template table can be arbitrarily increased, modified and deleted according to the personalized requirements, so that the flexible monitoring of the operation data of the monitored device is realized.
In this embodiment, the master device template table and the slave device template table are both provided with a master device monitoring field and a threshold corresponding to device operation data obtained by the slave device monitoring field.
Specifically, threshold values can be designed in the main equipment template table and the sub-equipment template table, comparison between the operation data and the threshold value data can be realized through corresponding monitoring fields, and the value of the numerical value is analyzed.
The embodiment of the invention also provides an equipment monitoring method, based on the equipment monitoring data model of the above embodiment, the method comprises the following steps:
receiving the running data of the main equipment uploaded by the equipment running system in real time through a main equipment monitoring field in a main equipment template table, and storing the running data of the main equipment in the main equipment template table in a key + value storage mode;
receiving the operation data of the sub-equipment uploaded by the equipment operation system in real time through the sub-equipment template table comprising the sub-equipment monitoring field, and storing the operation data of the sub-equipment in the sub-equipment template table in a key + value storage mode;
and counting and displaying the equipment operation data acquired by the main equipment monitoring field and the sub-equipment monitoring field, and simultaneously recording the log data into a database.
In this embodiment, when a new master device is added, if the type of the new master device is the same as that of the master device, the master device template is directly applied to monitor the new master device;
if the types of the newly added main equipment are different from the types of the main equipment, generating a new main equipment template corresponding to the newly added main equipment so as to monitor the newly added main equipment;
when the sub-equipment is newly added, if the type of the newly added sub-equipment is the same as that of the sub-equipment, directly applying the sub-equipment template to monitor the newly added sub-equipment;
and if the types of the newly added sub-equipment are different from the types of the sub-equipment, generating a new sub-equipment template corresponding to the newly added sub-equipment so as to monitor the newly added sub-equipment.
Specifically, the newly added equipment can directly apply the former template, so that a plurality of equipment of the same type can be realized, and only one set of template is generated. If a new type of device is enabled, a template needs to be generated according to the type. The data statistics is mainly calculated and displayed through data obtained by monitoring fields in the equipment, and log data can be recorded in a database.
In conclusion, the data are stored on the basis of a key + value mode through the monitoring field, data fields are reduced, redundancy is reduced, the concept of a template is introduced, direct link with equipment is avoided, the space and the efficiency of a database are optimized, and low coupling is realized; the device template and the device have the concept of threshold values, the template threshold values are embodied in the setting of the similar devices, the device threshold values are embodied in the setting of instantiated devices, the threshold values are personalized, the template and the device quality inspection are associated, a relationship of 1 pair of more devices is designed, the access of any type of devices can be realized, secondary development is not needed, and personalized interfaces are supported.
Having described embodiments of the present invention, the foregoing description is intended to be exemplary, not exhaustive, and not limited to the embodiments disclosed. Many modifications and variations will be apparent to those of ordinary skill in the art without departing from the scope and spirit of the described embodiments.
Claims (10)
1. An equipment monitoring data model, comprising: a master device template table, a slave device template table and a master and slave relationship table;
the main equipment template table comprises a main equipment monitoring field, wherein the main equipment monitoring field is used for receiving the operation data of the main equipment uploaded by an equipment operation system in real time and storing the operation data of the main equipment in the main equipment template table in a key + value storage mode;
the sub-equipment template table comprises a sub-equipment monitoring field, wherein the sub-equipment monitoring field is used for receiving the running data of the sub-equipment uploaded by the equipment running system in real time and storing the running data of the sub-equipment in the sub-equipment template table in a key + value storage mode; the sub-equipment is operated under the main equipment;
and the main sub-relation table is used for recording the corresponding relation between the main equipment template table and the sub-equipment template table.
2. The device monitoring data model according to claim 1, further comprising a master dynamic table, wherein the master monitoring field is disposed in the master dynamic table, and the master dynamic table is configured to dynamically obtain the operation data of the monitored master device through the master monitoring field, and upload the obtained operation data of the master device to the master template table for storage based on the master sub-relationship table.
3. The device monitoring data model according to claim 1, further comprising a sub dynamic table, wherein the sub dynamic table is provided with the sub device monitoring field, and the sub dynamic table is configured to dynamically obtain the operation data of the monitored sub devices through the sub device monitoring field, and upload the obtained operation data of the sub devices to the sub device template table corresponding to the main device template table for storage based on the main sub relationship table.
4. The device monitoring data model of claim 1, wherein the master device template table and the slave device template table have an n-to-n correspondence relationship, and a master key association is generated between the master device template table and the slave device template table by a sequence number.
5. The equipment monitoring data model of claim 1, wherein the master equipment template table and the child equipment template table each include necessary attribute information.
6. The device monitoring data model according to claim 1, wherein the correspondence between the master device template table and the monitored master devices is 1 to n, and the master device template table and the monitored master devices generate master key associations through sequence numbers, wherein n master devices are master devices of the same type;
the sub-device template table and the monitored sub-devices are in a corresponding relation of 1 to n, main key association is generated between the sub-device template table and the monitored sub-devices through sequence numbers, and the n sub-devices are sub-devices of the same type.
7. The equipment monitoring data model of claim 1, wherein the master equipment template table and the slave equipment template table each have a personalized monitoring value for monitoring an operational status of the equipment.
8. The equipment monitoring data model according to claim 1, wherein the main equipment template table and the sub-equipment template table are each provided with a threshold corresponding to the equipment operation data obtained by the main equipment monitoring field and the sub-equipment monitoring field.
9. A method for monitoring equipment, based on the equipment monitoring data model of any one of claims 1-9, the method comprising:
receiving running data of the main equipment uploaded by an equipment running system in real time through a main equipment monitoring field in the main equipment template table, and storing the running data of the main equipment in the main equipment template table in a key + value storage mode;
receiving the operation data of the sub-equipment uploaded by an equipment operation system in real time through the sub-equipment template table comprising a sub-equipment monitoring field, and storing the operation data of the sub-equipment in the sub-equipment template table in a key + value storage mode;
and counting and displaying the equipment operation data acquired by the main equipment monitoring field and the sub-equipment monitoring field, and simultaneously recording the log data into a database.
10. The device monitoring method according to claim 9, wherein when a new master device is added, if the type of the new master device is the same as that of the master device, the master device template is directly applied to monitor the new master device;
if the types of the newly added main equipment and the main equipment are different, generating a new main equipment template corresponding to the newly added main equipment so as to monitor the newly added main equipment;
when the sub-equipment is newly added, if the type of the newly added sub-equipment is the same as that of the sub-equipment, directly applying the sub-equipment template to monitor the newly added sub-equipment;
and if the types of the newly added sub-equipment are different from the types of the sub-equipment, generating a new sub-equipment template corresponding to the newly added sub-equipment so as to monitor the newly added sub-equipment.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202011539825.2A CN112817809B (en) | 2020-12-23 | 2020-12-23 | Construction method of equipment monitoring data model and equipment monitoring method |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202011539825.2A CN112817809B (en) | 2020-12-23 | 2020-12-23 | Construction method of equipment monitoring data model and equipment monitoring method |
Publications (2)
Publication Number | Publication Date |
---|---|
CN112817809A true CN112817809A (en) | 2021-05-18 |
CN112817809B CN112817809B (en) | 2023-09-26 |
Family
ID=75853529
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN202011539825.2A Active CN112817809B (en) | 2020-12-23 | 2020-12-23 | Construction method of equipment monitoring data model and equipment monitoring method |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN112817809B (en) |
Citations (9)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JPH09198157A (en) * | 1996-01-22 | 1997-07-31 | Fujitsu Ltd | Slave device control system |
JP2001308870A (en) * | 2000-04-20 | 2001-11-02 | Nec Corp | System and method for specifying management object for monitor unit |
JP2004213654A (en) * | 2002-12-26 | 2004-07-29 | Ricoh Co Ltd | Method, device and system for obtaining and maintaining information of monitoring device |
JP2013077212A (en) * | 2011-09-30 | 2013-04-25 | Nippon Telegr & Teleph Corp <Ntt> | Operational management system and monitoring and setting method thereof |
CN103441572A (en) * | 2013-07-31 | 2013-12-11 | 中国南方电网有限责任公司 | Method for monitoring transformer substation device |
CN105573224A (en) * | 2014-10-08 | 2016-05-11 | 深圳中兴力维技术有限公司 | Monitoring method, monitoring device, and monitoring system based on abstract model |
US20170024272A1 (en) * | 2015-07-22 | 2017-01-26 | Optumsoft, Inc. | Compact binary event log generation |
CN109347689A (en) * | 2018-12-03 | 2019-02-15 | 无锡华云数据技术服务有限公司 | A kind of apparatus monitoring method and system |
CN111831514A (en) * | 2020-07-21 | 2020-10-27 | 深信服科技股份有限公司 | Equipment monitoring method, device, equipment and storage medium |
-
2020
- 2020-12-23 CN CN202011539825.2A patent/CN112817809B/en active Active
Patent Citations (9)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JPH09198157A (en) * | 1996-01-22 | 1997-07-31 | Fujitsu Ltd | Slave device control system |
JP2001308870A (en) * | 2000-04-20 | 2001-11-02 | Nec Corp | System and method for specifying management object for monitor unit |
JP2004213654A (en) * | 2002-12-26 | 2004-07-29 | Ricoh Co Ltd | Method, device and system for obtaining and maintaining information of monitoring device |
JP2013077212A (en) * | 2011-09-30 | 2013-04-25 | Nippon Telegr & Teleph Corp <Ntt> | Operational management system and monitoring and setting method thereof |
CN103441572A (en) * | 2013-07-31 | 2013-12-11 | 中国南方电网有限责任公司 | Method for monitoring transformer substation device |
CN105573224A (en) * | 2014-10-08 | 2016-05-11 | 深圳中兴力维技术有限公司 | Monitoring method, monitoring device, and monitoring system based on abstract model |
US20170024272A1 (en) * | 2015-07-22 | 2017-01-26 | Optumsoft, Inc. | Compact binary event log generation |
CN109347689A (en) * | 2018-12-03 | 2019-02-15 | 无锡华云数据技术服务有限公司 | A kind of apparatus monitoring method and system |
CN111831514A (en) * | 2020-07-21 | 2020-10-27 | 深信服科技股份有限公司 | Equipment monitoring method, device, equipment and storage medium |
Non-Patent Citations (1)
Title |
---|
向观兵等: "一种用于设备运行数据采集的非关系型文本 数据向关系型数据的柔性转化方法", 《2019 中国铸造活动周论文集》, pages 1 - 5 * |
Also Published As
Publication number | Publication date |
---|---|
CN112817809B (en) | 2023-09-26 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN105491038B (en) | A kind of intelligent equipment protocol analytic method | |
CN102967815B (en) | Chip testing method, automated testing equipment and system | |
CN107592238A (en) | Automatic test approach and system, service terminal, the memory of interface | |
CN102118283A (en) | Method and device for testing communication equipment | |
CN107370637B (en) | Vehicle-mounted ECU communication function automatic test system and method | |
CN107341039A (en) | Method, main frame and the system being managed under a kind of virtual environment to USB device | |
CN101262304A (en) | A data stream parsing method based on universal communication data format | |
CN103048984A (en) | Multi-channel ARINC(aeronautical radio incorporated) 700 bus monitoring device and realizing method thereof | |
CN104503429A (en) | Track traffic vehicle static-state test data automatic processing method and apparatus | |
CN111324480A (en) | Large host transaction fault positioning system and method | |
CN110932887A (en) | BMC debugging method, system and device | |
CN110069366A (en) | A kind of reloading method, apparatus and server | |
CN114264897B (en) | Compatibility performance test method and system | |
CN112817809A (en) | Equipment monitoring data model and equipment monitoring method | |
CN106844211A (en) | Software testing method, device and system | |
CN110445752A (en) | A kind of implementation method for supporting a variety of CAN devices and flexibly parse all kinds of CAN messages | |
CN115002011A (en) | Flow bidirectional test method and device, electronic equipment and storage medium | |
CN111538568B (en) | Data processing method based on railway computer interlocking system and interlocking system | |
CN109062639B (en) | Method and system for displaying upgrading information of SCD (substation configuration description) file of transformer substation | |
CN111724489A (en) | General software system of ticket selling and checking machine | |
CN104777808A (en) | Recording method for operating condition debugging of power station as well as record reading methods | |
CN114942623B (en) | Method and device for testing controller, vehicle and computer readable storage medium | |
CN116561014B (en) | Device and method for generating test case of electric power secondary equipment | |
CN116108110B (en) | Kafka message consumption compensation method, system and medium | |
CN107543980A (en) | Electronic product automatic diagnostic device and method |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant |