CN104571057B - Method for designing warning system database - Google Patents
Method for designing warning system database Download PDFInfo
- Publication number
- CN104571057B CN104571057B CN201510030212.9A CN201510030212A CN104571057B CN 104571057 B CN104571057 B CN 104571057B CN 201510030212 A CN201510030212 A CN 201510030212A CN 104571057 B CN104571057 B CN 104571057B
- Authority
- CN
- China
- Prior art keywords
- information
- alarm
- data
- sensor
- warning
- 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.)
- Expired - Fee Related
Links
Classifications
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/02—Total factory control, e.g. smart factories, flexible manufacturing systems [FMS] or integrated manufacturing systems [IMS]
Landscapes
- Engineering & Computer Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- General Engineering & Computer Science (AREA)
- Manufacturing & Machinery (AREA)
- Quality & Reliability (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Automation & Control Theory (AREA)
Abstract
The invention relates to a method for designing a warning system database, and belongs to the technical field of process control. The database is divided into user management, site management, data storage and warning storage. The user management is personal information of maintaining and managing persons, permission information and operation information of the managing persons; the site management is position information of sites and information of devices in the sites; the data storage comprises device information data analyzed at a sensor terminal; the warning storage comprises arranged warning values and alarming data during device warning. When being received, the sensor data are compared with a warning threshold value in the warning storage in real time; once warning occurs, the database instantly gives out warning to the managing persons through a foreground. After the warning is processed by the managing persons, the managing persons log into the foreground to conduct confirmation, and operation information is directly stored into the database. By means of the method, responsibilities of the managing persons can be clearer, the device quality can be known more visually by inquiring historical data lists and daily statistical tables, the application service life of the devices is forecasted, and the jurisdictional limit of the managing persons can be arranged more reasonably.
Description
Technical field
The present invention relates to the design of relational database, the parsing of cell base station sensing data, and the friendship between the webpage of foreground
Mutually, specifically a kind of method for designing of warning system data base, belongs to process control technology field.
Background technology
With the development of modern industry, the analysis to data is also more and more important.For example, the present invention relates to regard to station
The warning system of point device, we must the temperature of real-time monitoring site apparatus, humidity, voltage, electric current etc., set for analyzing
It is standby whether to be in normal operating conditions.We must store these data, in order to predict when go to repair facility.And institute
The problem of the storage and process of data is related to, we have to use data base.Realtime alarm system is also in modern industry
There are many applications, have the introduction of many articles and patent all about this respect.But do not have about the data base in warning system
It is concrete to introduce.And the operation of data base itself is also simply introduced about the document of data base, it is not bound with actual items to discuss.
Such as Application No. 201110078873.0, entitled " a kind of system and method for industrial undertaking's Realtime Alerts ", invention
In artificial Wei Shukai, the patent of invention of Ye Rui, Ma Zengliang, the patent does not specifically introduce the design of data, does not refer to number yet
According to storage, this is totally unfavorable for comparing with the quality of pre- measurement equipment.
The content of the invention
The present invention will carry out design database with reference to specific warning system, carry out rights management to management personnel, allow pipe
Reason personnel more understand the station state of oneself.Real-time storage, and real-time processing are carried out to the data of sensor acquisition, when there is report
When alert, spontaneous sends warning message to the management personnel that website is specified, and is repaired in order to equipment in time.
The present invention is realized by following concrete technical schemes.
A kind of method for designing of warning system data base, the data base include user management, station field signal, data storage and
Alarm storage part, wherein user management is personal information and the authority information of maintenance management personnel；Station field signal is website
The information of equipment in positional information and website；Data storage mainly has the facility information data that sensor side is parsed；Alarm storage
The alarm data mainly having when warning value and the equipment alarm of setting, the method for designing step are as follows：
A, user management：Customer management information is stored with four relation tables, is respectively：Department information table, user profile
Table, equipment authority list and menu authority list, department information table include department's id information and department name information；User message table bag
Information is included for ID, department ID, user's login name, user's modification logging, user mobile phone number, subscriber mailbox information, equipment power
Limit table is associated with user message table, and mainly regulation maintenance management personnel are responsible for the equipment in which region, and equipment authority list includes
Information be equipment permission ID, region ID and equipment id information；Menu authority list is associated with user message table, mainly regulation dimension
Repair after management personnel log in front page layout, the operable authority of institute, including information：Menu permission ID, pad name；
B, station field signal：Come admin site information, region letter using zone information table, site information table and facility information table
Breath table is higher level's table of site information table, and zone information table includes information：Region ID, zone name；Site information table includes letter
Cease and be：Site ID, region ID, site name；Facility information table is associated with site information table, mainly stores setting under each website
Standby information, has including information：Device id, Site ID, device name, device type；
C, data storage：Mainly the data of recording equipment sensor acquisition, are stored with three tables：Sensor is arranged
Table, real time data table and historical data table, sensor arrange table and associate with the facility information table of station field signal part, mainly divide
The conversion formula of the observed data title and correlation of each sensor of clear equipment, the result of sensor measurement is magnitude of voltage or electricity
Flow valuve, is now changed with formula, and sensor setting table includes information：Sensor arranges ID, device id, sensor name
Title, sensing data type, conversion formula；Real time data table arranges table with sensor and associates, main real-time update sensor
Data, including information：Real time data ID, sensor arrange ID, sensor real time data；Historical data table and real time data table are closed
Connection, the data of main storage sensor, historical data table include information：Historical data ID, real time data ID, sensor historic number
According to；
D, alarm storage：Essential record warning information, is stored using three tables：Alarm arrange table, Real-time Alarm table and
History alarm table, alarm arrange table and associate with the real time data table of data storage section, are mainly used to arrange alarm threshold, and it wraps
Include information：Alarm arranges ID, real time data ID, lower alarm threshold value and upper alarm threshold value；Real-time Alarm table also with real time data table
Association, the process state of the warning information and alarm equipment of real-time update equipment, Real-time Alarm table include information：Real-time Alarm
ID, real time data ID, alarm time started, acknowledged alarm time, alarm end time, acknowledged alarm people and warning value；History
The process state of the warning information and alarm equipment of warning watch essential record equipment, history alarm table include information：History alarm
ID, Real-time Alarm ID, alarm time started, acknowledged alarm time, alarm end time, acknowledged alarm people and warning value；
E, the User operation log table for having auxiliary user management part in addition, it and user message table and facility information table are closed
Connection, essential record maintenance management human users' schedule, it includes information：When User operation log ID, ID, user log in
Between, user's logout time；The historical data day statistical table that assistance data storage part needs, essential record gathered data one day
Meansigma methodss, historical data day statistical table include information：Historical data day statistics ID, real time data ID and sensor historic data are flat
Average；
The real time data table of above-mentioned data storage section constantly updates the real time data of site sensor, and by closing
The sensor setting table of connection is compared with the alarm threshold in the alarm setting table of alarm storage part, by alarm letter if alarm
Breath storage is in Real-time Alarm table, and notifies to alert the maintenance management personnel in region, after alarm equipment is handled well, will alarm
Information Store is in history alarm table, and updates Real-time Alarm table, and maintenance management personnel log in foreground and confirm that equipment is fixed, and handle
Operation information is stored in User operation log table；
While real time data table is updated, store the data in historical data table, write an operation in data base,
Morning counts on time the data day of historical data table daily, and stores the data in day statistical table.
The present invention clearly illustrates the design and realization of a warning system data base, is that the design of record alert database is carried
An example is supplied.User operation log table is provided in data base, and this can only be that management personnel log in alarm system in person
System foreground ability typing information, can distribute the effect that task serves supervision again well.Equipment authority list and menu authority
Table can allow management personnel to be easier to understand the management region and responsibility of oneself.Statistical table can be used to compare and set historical data day
In the life-span of standby fine or not and pre- measurement equipment, the moon, statistics can set up view on the basis of this table in addition.
The invention has the beneficial effects as follows allow management personnel's responsibility to be more apparent from by User operation log, historical data table and
The quality of equipment, the shelf life of pre- measurement equipment, it is also possible to more reasonably pacify can be more intuitively known in the inquiry of day statistical table
The compass of competency of row management personnel.
Description of the drawings
Fig. 1 is the structural representation of data base of the present invention.
Specific embodiment
The invention will be further described with reference to the accompanying drawings and examples, but not limited to this.
Embodiment：
As shown in figure 1, a kind of method for designing of warning system data base, the data base includes that user manages to the embodiment of the present invention
Reason, station field signal, data storage and alarm storage part, wherein user management is the personal information and authority of maintenance management personnel
Information；Station field signal is the information of equipment in the positional information and website of website；Data storage mainly has sensor side parsing
Facility information data；Alarm storage mainly has alarm data during warning value and the equipment alarm of setting, the method for designing step
It is as follows：
A, user management：Customer management information is stored with four relation tables, is respectively：Department information table, user profile
Table, equipment authority list and menu authority list, department information table include department's id information and department name information；User message table bag
Information is included for ID, department ID, user's login name, user's modification logging, user mobile phone number, subscriber mailbox information, equipment power
Limit table is associated with user message table, and mainly regulation maintenance management personnel are responsible for the equipment in which region, and equipment authority list includes
Information be equipment permission ID, region ID and equipment id information；Menu authority list is associated with user message table, mainly regulation dimension
Repair after management personnel log in front page layout, the operable authority of institute, including information：Menu permission ID, pad name；
B, station field signal：Come admin site information, region letter using zone information table, site information table and facility information table
Breath table is higher level's table of site information table, and zone information table includes information：Region ID, zone name；Site information table includes letter
Cease and be：Site ID, region ID, site name；Facility information table is associated with site information table, mainly stores setting under each website
Standby information, has including information：Device id, Site ID, device name, device type；
C, data storage：Mainly the data of recording equipment sensor acquisition, are stored with three tables：Sensor is arranged
Table, real time data table and historical data table, sensor arrange table and associate with the facility information table of station field signal part, mainly divide
The conversion formula of the observed data title and correlation of each sensor of clear equipment, the result of sensor measurement is magnitude of voltage or electricity
Flow valuve, is now changed with formula, and sensor setting table includes information：Sensor arranges ID, device id, sensor name
Title, sensing data type, conversion formula；Real time data table arranges table with sensor and associates, main real-time update sensor
Data, including information：Real time data ID, sensor arrange ID, sensor real time data；Historical data table and real time data table are closed
Connection, the data of main storage sensor, historical data table include information：Historical data ID, real time data ID, sensor historic number
According to；
D, alarm storage：Essential record warning information, is stored using three tables：Alarm arrange table, Real-time Alarm table and
History alarm table, alarm arrange table and associate with the real time data table of data storage section, are mainly used to arrange alarm threshold, and it wraps
Include information：Alarm arranges ID, real time data ID, lower alarm threshold value and upper alarm threshold value；Real-time Alarm table also with real time data table
Association, the process state of the warning information and alarm equipment of real-time update equipment, Real-time Alarm table include information：Real-time Alarm
ID, real time data ID, alarm time started, acknowledged alarm time, alarm end time, acknowledged alarm people and warning value；History
The process state of the warning information and alarm equipment of warning watch essential record equipment, history alarm table include information：History alarm
ID, Real-time Alarm ID, alarm time started, acknowledged alarm time, alarm end time, acknowledged alarm people and warning value；
E, the User operation log table for having auxiliary user management part in addition, it and user message table and facility information table are closed
Connection, essential record maintenance management human users' schedule, it includes information：When User operation log ID, ID, user log in
Between, user's logout time；The historical data day statistical table that assistance data storage part needs, essential record gathered data one day
Meansigma methodss, historical data day statistical table include information：Historical data day statistics ID, real time data ID and sensor historic data are flat
Average；
The real time data table of above-mentioned data storage section constantly updates the real time data of site sensor, and by closing
The sensor setting table of connection is compared with the alarm threshold in the alarm setting table of alarm storage part, by alarm letter if alarm
Breath storage is in Real-time Alarm table, and notifies to alert the maintenance management personnel in region, after alarm equipment is handled well, will alarm
Information Store is in history alarm table, and updates Real-time Alarm table, and maintenance management personnel log in foreground and confirm that equipment is fixed, and handle
Operation information is stored in User operation log table；
While real time data table is updated, store the data in historical data table, write an operation in data base,
Morning counts on time the data day of historical data table daily, and stores the data in day statistical table.
Claims (1)
1. a kind of method for designing of warning system data base, the data base include user management, station field signal, data storage and announcement
Alert storage part, wherein user management is personal information and the authority information of maintenance management personnel；Station field signal is the position of website
Confidence ceases the information with equipment in website；Data storage mainly has the facility information data that sensor side is parsed；Alarm storage master
The alarm data when warning value of setting to be had and equipment alarm, the method for designing step are as follows：
A, user management：Customer management information is stored with four relation tables, is respectively：Department information table, user message table, set
Standby authority list and menu authority list, department information table include department's id information and department name information；User message table includes letter
Cease for ID, department ID, user's login name, user's modification logging, user mobile phone number, subscriber mailbox information, equipment authority list
Associate with user message table, mainly regulation maintenance management personnel are responsible for the equipment in which region, the letter that equipment authority list includes
Breath is equipment permission ID, region ID and equipment id information；Menu authority list is associated with user message table, mainly regulation maintenance pipe
After reason personnel log in front page layout, the operable authority of institute, including information：Menu permission ID, pad name；
B, station field signal：Come admin site information, zone information table using zone information table, site information table and facility information table
It is higher level's table of site information table, zone information table includes information：Region ID, zone name；Site information table includes that information is：
Site ID, region ID, site name；Facility information table is associated with site information table, mainly stores the equipment letter under each website
Breath, has including information：Device id, Site ID, device name, device type；
C, data storage：Mainly the data of recording equipment sensor acquisition, are stored with three tables：Sensor arranges table, reality
When tables of data and historical data table, sensor arranges table and associates with the facility information table of station field signal part, mainly distinguish and set
The conversion formula of the observed data title and correlation of each standby sensor, the result of sensor measurement is magnitude of voltage or electric current
Value, is now changed with formula, and sensor setting table includes information：Sensor arrange ID, device id, sensor name,
Sensing data type, conversion formula；Real time data table arranges table with sensor and associates, the number of main real-time update sensor
According to including information：Real time data ID, sensor arrange ID, sensor real time data；Historical data table and real time data table are closed
Connection, the data of main storage sensor, historical data table include information：Historical data ID, real time data ID, sensor historic number
According to；
D, alarm storage：Essential record warning information, is stored using three tables：Alarm arranges table, Real-time Alarm table and history
Warning watch, alarm arrange table and associate with the real time data table of data storage section, are mainly used to arrange alarm threshold, and it includes letter
Breath：Alarm arranges ID, real time data ID, lower alarm threshold value and upper alarm threshold value；Real-time Alarm table is also associated with real time data table,
The process state of the warning information and alarm equipment of real-time update equipment, Real-time Alarm table include information：Real-time Alarm ID, in real time
Data ID, alarm time started, acknowledged alarm time, alarm end time, acknowledged alarm people and warning value；History alarm table master
The process state of the warning information and alarm equipment of recording equipment, history alarm table is wanted to include information：History alarm ID, in real time announcement
Alert ID, alarm time started, acknowledged alarm time, alarm end time, acknowledged alarm people and warning value；
E, the User operation log table for having auxiliary user management part in addition, it is associated with user message table with facility information table,
Essential record maintenance management human users' schedule, it includes information：User operation log ID, ID, user's landing time, use
Family logout time；The historical data day statistical table that assistance data storage part needs, essential record gathered data one day it is average
Value, historical data day statistical table include information：Historical data day statistics ID, real time data ID and sensor historic data are average
Value；
The real time data table of above-mentioned data storage section constantly updates the real time data of site sensor, and by association
Sensor setting table is compared with the alarm threshold in the alarm setting table of alarm storage part, if alarm is deposited warning information
Store up in Real-time Alarm table, and notify to alert the maintenance management personnel in region, after alarm equipment is handled well, by warning information
Store in history alarm table, and update Real-time Alarm table, maintenance management personnel log in foreground and confirm that equipment is fixed, and operation
Information Store is in User operation log table；
While real time data table is updated, store the data in historical data table, write an operation in data base, daily
Morning data day statistics on time to historical data table, and store the data in day statistical table.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510030212.9A CN104571057B (en) | 2015-01-21 | 2015-01-21 | Method for designing warning system database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510030212.9A CN104571057B (en) | 2015-01-21 | 2015-01-21 | Method for designing warning system database |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN104571057A CN104571057A (en) | 2015-04-29 |
| CN104571057B true CN104571057B (en) | 2017-03-22 |
Family
ID=53087385
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510030212.9A Expired - Fee Related CN104571057B (en) | 2015-01-21 | 2015-01-21 | Method for designing warning system database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104571057B (en) |
Families Citing this family (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105354743A (en) * | 2015-12-07 | 2016-02-24 | 中国建设银行股份有限公司 | Data processing method and device |
| CN109714387A (en) * | 2018-11-16 | 2019-05-03 | 国电南瑞南京控制系统有限公司 | A kind of operation management system alarm method for subscribing subscribes to terminal, issue terminal and system |
| CN110333699A (en) * | 2019-05-05 | 2019-10-15 | 深圳市万睿智能科技有限公司 | A kind of equipment centralized management system |
| CN114448935B (en) * | 2022-01-05 | 2024-01-05 | 中盈优创资讯科技有限公司 | Automatic pushing processing method and device for IP address availability alarm |
| CN115190171A (en) * | 2022-06-02 | 2022-10-14 | 河北秦淮数据有限公司 | Alarm data processing method and device, electronic equipment and storage medium |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1506896A (en) * | 2002-11-29 | 2004-06-23 | �����е����ɷݹ�˾ | Alarm management method and equipment thereof |
| CN201371835Y (en) * | 2009-03-12 | 2009-12-30 | 上海科泰信息技术有限公司 | Railway transportation centralized alarm management system |
| CN102200769A (en) * | 2011-03-30 | 2011-09-28 | 北京三博中自科技有限公司 | Real-time alarm system for industrial enterprise and method thereof |
| CN102750145A (en) * | 2012-06-05 | 2012-10-24 | 怯肇乾 | Network system software system framework and implementation method thereof |
| CN102833099A (en) * | 2012-08-15 | 2012-12-19 | 曙光信息产业(北京)有限公司 | Extensible alarm emergency processing system and control method thereof |
| CN102841923A (en) * | 2012-07-09 | 2012-12-26 | 中国联合网络通信集团有限公司 | Information processing platform and information processing method |
| CN103873288A (en) * | 2012-12-18 | 2014-06-18 | 中国电信股份有限公司 | System and method for positioning failures of communication network equipment based on alarm information |
Family Cites Families (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP1412873B1 (en) * | 2001-06-22 | 2018-08-15 | Schneider Electric Software, LLC | Internationalization of objects executable in a supervisory process control and manufacturing information system |
| US7671733B2 (en) * | 2006-03-17 | 2010-03-02 | Koninklijke Philips Electronics N.V. | Method and system for medical alarm monitoring, reporting and normalization |
| US8854177B2 (en) * | 2010-12-02 | 2014-10-07 | Viscount Security Systems Inc. | System, method and database for managing permissions to use physical devices and logical assets |
-
2015
- 2015-01-21 CN CN201510030212.9A patent/CN104571057B/en not_active Expired - Fee Related
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1506896A (en) * | 2002-11-29 | 2004-06-23 | �����е����ɷݹ�˾ | Alarm management method and equipment thereof |
| CN201371835Y (en) * | 2009-03-12 | 2009-12-30 | 上海科泰信息技术有限公司 | Railway transportation centralized alarm management system |
| CN102200769A (en) * | 2011-03-30 | 2011-09-28 | 北京三博中自科技有限公司 | Real-time alarm system for industrial enterprise and method thereof |
| CN102750145A (en) * | 2012-06-05 | 2012-10-24 | 怯肇乾 | Network system software system framework and implementation method thereof |
| CN102841923A (en) * | 2012-07-09 | 2012-12-26 | 中国联合网络通信集团有限公司 | Information processing platform and information processing method |
| CN102833099A (en) * | 2012-08-15 | 2012-12-19 | 曙光信息产业(北京)有限公司 | Extensible alarm emergency processing system and control method thereof |
| CN103873288A (en) * | 2012-12-18 | 2014-06-18 | 中国电信股份有限公司 | System and method for positioning failures of communication network equipment based on alarm information |
Also Published As
| Publication number | Publication date |
|---|---|
| CN104571057A (en) | 2015-04-29 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104571057B (en) | Method for designing warning system database | |
| CN103065228B (en) | Have a power failure monitoring assessment method for early warning and equipment | |
| CN104678868B (en) | A kind of business and equipment O＆M monitoring system | |
| WO2007019451A3 (en) | Method and system for monitoring for and reporting of lien distress events | |
| KR101135985B1 (en) | Power monitoring system | |
| KR102131969B1 (en) | System and method for protecting the lonely death using services based Information and Communication Technology | |
| CN103345203A (en) | Methods for collaboratively assisting a control room operator | |
| US20140136258A1 (en) | Pt2776 | |
| JP2018036985A (en) | Work management system | |
| CN108475943A (en) | A kind of power supply and distribution management service system | |
| KR20180010441A (en) | System and method for preventing fall | |
| CN105354303A (en) | Power grid alarm data processing method and apparatus based on BI (Business Intelligence) multi-dimensional analysis theory | |
| JP2011065486A (en) | Noticing program and noticing system | |
| JP2016170566A (en) | Management device, remote health management system, and program | |
| CN211236077U (en) | Data contrast type electric power overload early warning device | |
| US20090276712A1 (en) | Safety awareness system | |
| JP2017160036A (en) | Maintenance management system | |
| JP2019046292A (en) | Electricity usage monitoring system and electricity usage monitoring method | |
| CN105253059A (en) | Electric vehicle safety early warning system and early warning method thereof | |
| JP7097043B2 (en) | Watching system | |
| JP2006285640A (en) | Caution information notification system | |
| JP2007102418A (en) | Safety operation system | |
| JP6131738B2 (en) | Information provision system, hygiene management system, and program | |
| JP2012242870A (en) | Call name list creation system | |
| AU2018317485B2 (en) | Passive care control method and associated systems |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| CF01 | Termination of patent right due to non-payment of annual fee | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20170322 Termination date: 20200121 |