EP2250591A2 - Verfahren und einrichtung zur speicherung von daten, die jeweils zu einer mehrere attribute enthaltenden alarm- oder ereignismeldung gehören - Google Patents

Verfahren und einrichtung zur speicherung von daten, die jeweils zu einer mehrere attribute enthaltenden alarm- oder ereignismeldung gehören

Info

Publication number
EP2250591A2
EP2250591A2 EP09720438A EP09720438A EP2250591A2 EP 2250591 A2 EP2250591 A2 EP 2250591A2 EP 09720438 A EP09720438 A EP 09720438A EP 09720438 A EP09720438 A EP 09720438A EP 2250591 A2 EP2250591 A2 EP 2250591A2
Authority
EP
European Patent Office
Prior art keywords
attributes
alarm
event message
event
record
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.)
Ceased
Application number
EP09720438A
Other languages
German (de)
English (en)
French (fr)
Inventor
Werner Schmidt
Martin Hollender
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
ABB Schweiz AG
Original Assignee
ABB Technology AG
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by ABB Technology AG filed Critical ABB Technology AG
Publication of EP2250591A2 publication Critical patent/EP2250591A2/de
Ceased legal-status Critical Current

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/23—Updating
    • G06F16/2358—Change logging, detection, and notification

Definitions

  • the invention relates to a method and a device for storing data, which in each case belong to an alarm or event message containing multiple attributes.
  • alarms from industrial plants were reported mainly on a panel or by other displays, as well as by printouts, typically using only a simple tabular structure.
  • OPC AE Alarms & Events
  • Today, alarm and event reporting systems according to the OPC AE (Alarms & Events) specification enable notification of manufacturer-specific attributes.
  • OPC AE Alarms & Events
  • modern control and regulation systems or control systems in the context of industrial plants a large number of different alarm and event messages or alarm or event sources are integrated, which typically have different manufacturer-specific attributes.
  • manufacturer-specific detector attributes can be present.
  • As new sources of alarms and event messages are constantly being integrated into control systems, the number of attributes will increase dynamically in the future.
  • PIMS Process Information Management Systems
  • the object of the invention is to provide a method and a device in order to create a possibility for the complete storage of alarm and event data as well as for a quick access to the data.
  • a first part of the attributes associated with an alarm or event message is stored in a fixed table.
  • Typical attributes are for example: name of the acknowledgment user, name of the node on which an event (the event) was generated, changed value before / after, diagnosis code or timestamp.
  • the table which is also referred to as a fixed table, refers to one whose columns must be defined in advance, but which-according to an advantageous embodiment-can also be designed as a dynamic table in which additional columns can be subsequently added.
  • both the first part and also a remaining second part of the attributes are stored as a disposable data record or flat fallback record.
  • This can advantageously be done in the XML language or in the form of BLOBs (Binary Large Objects), e.g. For example, as a database column or as a separate file.
  • BLOBs Binary Large Objects
  • Flat fallback record is a storage location and the entirety of the (relatively) unstructured attributes stored there.
  • Such an inventory record stored in XML for example, is not or hardly suitable for fast queries, but is a complete record that can be used for later analyzes.
  • the normalized first part of the attributes stored in the table is used for display purposes.
  • the first, directly stored part of attributes allows very fast access.
  • Typical attributes that should be available quickly are z. For example, timestamp, tag name, event category, or activation timestamp.
  • the total information stored as a fallback record can be z. B. be made available again by means of XML-processing facilities modern databases or by batch procedures.
  • AE source 1 shows schematically and by way of example several alarm and event sources AE source 1, AE source 2 to AE source n with a plurality of attributes 1 to 7.
  • the attributes 1 to 3 are respectively relevant attributes are to be available for quick access, so z.
  • Alarm or event messages of the AE sources 1 to n are transferred to a table T.
  • the table T has several columns, in the example columns a to c for the direct storage of normalized attributes, and optionally an additional column d or further columns. For storing the information associated with an alarm or event message, one line is provided in each case.
  • the representation of the information stored in the first row of the table T relates, for.
  • attributes of a message of the first AE source 1 are directly stored in the three columns a to c and additionally all attributes, here the attributes 1, 2, 3, 5 and 6 as a fallback record A in column d.
  • the disposal record that is the entirety of the attributes 1, 2, 3, 5 and 6 can instead be stored elsewhere.
  • an asset record might be helpful in a scenario that is:
  • the intended normalization adapts both different attribute names with the same meaning as well as different attribute values with the same meaning.
  • an alignment of different attribute names can mean that both the attribute "user_name” and the attribute "user” are stored in the same column "user”.
  • An example of an equalization of different attribute values with the same meaning would be: in the attribute "Change” Event Sourcei writes “on” and “off 1 , and from event source 2 " + “and” - "Normalization then ensures consistency and writes in both Cases "+” and "-”.
  • the specified table T can be empty, and the alarm and event attributes can only be stored as XML in the disposition data record.
  • the XML capability of modern databases can ensure a high enough processing speed for many applications.
  • a dynamic table T with, for example, the attributes 1, 2, and 3. If now an alarm or event message has an attribute X, which is not present in the table T, it can be provided that the table T is automatically extended by the attribute X and the value is stored there.
  • the associated algorithm would then be:
EP09720438A 2008-03-14 2009-03-12 Verfahren und einrichtung zur speicherung von daten, die jeweils zu einer mehrere attribute enthaltenden alarm- oder ereignismeldung gehören Ceased EP2250591A2 (de)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
DE102008014151A DE102008014151A1 (de) 2008-03-14 2008-03-14 Verfahren und Einrichtung zur Speicherung von Daten, die jeweils zu einer mehrere Attribute enthaltenden Alarm- oder Ereignismeldung gehören
PCT/EP2009/001751 WO2009112252A2 (de) 2008-03-14 2009-03-12 Verfahren und einrichtung zur speicherung von daten, die jeweils zu einer mehrere attribute enthaltenden alarm- oder ereignismeldung gehören

Publications (1)

Publication Number Publication Date
EP2250591A2 true EP2250591A2 (de) 2010-11-17

Family

ID=40953056

Family Applications (1)

Application Number Title Priority Date Filing Date
EP09720438A Ceased EP2250591A2 (de) 2008-03-14 2009-03-12 Verfahren und einrichtung zur speicherung von daten, die jeweils zu einer mehrere attribute enthaltenden alarm- oder ereignismeldung gehören

Country Status (5)

Country Link
US (1) US20110029582A1 (zh)
EP (1) EP2250591A2 (zh)
CN (1) CN102067118B (zh)
DE (1) DE102008014151A1 (zh)
WO (1) WO2009112252A2 (zh)

Families Citing this family (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2014076524A1 (en) * 2012-11-16 2014-05-22 Data2Text Limited Method and apparatus for spatial descriptions in an output text
DE102013001926A1 (de) 2013-02-05 2014-08-07 Abb Ag System und ein Verfahren zur Ereignisprotokollierung in einer technischen Anlage oder einem technischen Prozess
US9092958B2 (en) * 2013-03-15 2015-07-28 Wal-Mart Stores, Inc. Alarm processing systems and methods
CN105740131B (zh) * 2014-12-09 2020-09-25 深圳力维智联技术有限公司 软件用户行为回退处理方法及装置

Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20030105811A1 (en) * 2001-05-02 2003-06-05 Laborde Guy Vachon Networked data stores for measurement data
US20060168013A1 (en) * 2004-11-26 2006-07-27 Invensys Systems, Inc. Message management facility for an industrial process control environment

Family Cites Families (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7082426B2 (en) * 1993-06-18 2006-07-25 Cnet Networks, Inc. Content aggregation method and apparatus for an on-line product catalog
WO1999044157A1 (en) * 1998-02-26 1999-09-02 Sun Microsystems, Inc. Method and system for multi-entry and multi-template matching in a database
US6421571B1 (en) * 2000-02-29 2002-07-16 Bently Nevada Corporation Industrial plant asset management system: apparatus and method
US6965895B2 (en) * 2001-07-16 2005-11-15 Applied Materials, Inc. Method and apparatus for analyzing manufacturing data
US6745175B2 (en) * 2001-08-02 2004-06-01 National Instruments Corporation System and method for a shared memory architecture for high speed logging and trending
US6978260B2 (en) * 2002-04-23 2005-12-20 Hewlett-Packard Development Company, L.P. System and method for storing data
US20040002958A1 (en) * 2002-06-26 2004-01-01 Praveen Seshadri System and method for providing notification(s)
US8041676B2 (en) * 2005-12-02 2011-10-18 International Business Machines Corporation Backup and restore of file system objects of unknown type
US7472108B2 (en) * 2006-05-16 2008-12-30 International Business Machines Corporation Statistics collection using path-value pairs for relational databases

Patent Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20030105811A1 (en) * 2001-05-02 2003-06-05 Laborde Guy Vachon Networked data stores for measurement data
US20060168013A1 (en) * 2004-11-26 2006-07-27 Invensys Systems, Inc. Message management facility for an industrial process control environment

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
YANLEI DIAO ET AL: "Rethinking Data Management for Storage-centric Sensor Networks *", 31 December 2007 (2007-12-31), XP055485410, Retrieved from the Internet <URL:http://web.mit.edu/tibbetts/Public/CIDR_2007_Proceedings/papers/cidr07p03.pdf> [retrieved on 20180618] *

Also Published As

Publication number Publication date
WO2009112252A2 (de) 2009-09-17
US20110029582A1 (en) 2011-02-03
WO2009112252A3 (de) 2009-12-03
CN102067118B (zh) 2013-11-20
DE102008014151A1 (de) 2009-09-17
CN102067118A (zh) 2011-05-18

Similar Documents

Publication Publication Date Title
DE60306674T2 (de) Verfahren und systeme zur regelung des zugriffs auf ein datenobjekt mittels sperren
DE19844013A1 (de) Strukturierter Arbeitsordner
EP1110127A1 (de) Informations-, bedien- und/oder beobachtungssystem mit modellbasierter benutzeroberfläche und verfahren zum modellbasierten bedienen und/oder beobachten
DE10346478A1 (de) Flexibler Softwareupdate für Automatisierungssysteme über Internet
DE1499182B2 (de) Datenspeichersystem
EP2250591A2 (de) Verfahren und einrichtung zur speicherung von daten, die jeweils zu einer mehrere attribute enthaltenden alarm- oder ereignismeldung gehören
EP3364257A1 (de) Verfahren zum betrieb eines engineering-systems für ein industrielles prozessautomatisierungssystem und steuerungsprogramm
DE19538448A1 (de) Datenbankmanagementsystem sowie Datenübertragungsverfahren
EP2073136B1 (de) System und Verfahren zum Erzeugen von Auswertedaten
DE10059103B4 (de) Einheit zur Verwaltung von in einer Datenverarbeitungseinrichtung gespeicherten Daten
EP1027646A1 (de) Konfigurierungsverfahren für datenverarbeitungsanlagen
EP3699704A1 (de) System und verfahren zum überprüfen von systemanforderungen von cyber-physikalischen systemen
EP0770946B1 (de) Verfahren zur automatisierten optimalen Redundanz-Auslegung von Messungen für die Leittechnik in Kraftwerken
EP1950635A1 (de) Verfahren zum Betrieb eines Automatisierungssystems
EP2329374A1 (de) Testmodul und verfahren zum testen einer o/r-abbildungs-middleware
DE102006024233B4 (de) Verfahren und Vorrichtung für ein Fehlertoleranzmanagement einer Softwarekomponente
EP2136303B1 (de) Verfahren zum Steuern einer automatischen Aktualisierung von Datensichten in einem Computersystem
DE10354938A1 (de) Datenverarbeitungssystem mit automatisierbarer Verwaltung und Verfahren zur automatisierten Verwaltung eines Datenverarbeitungssystems
DE10228142B4 (de) System zur Sicherung von Softwarekomponenten und/oder Computerprogrammen
WO2012019614A1 (de) Verfahren zum kennzeichnen und erkennen einer aufbaustruktur eines produkts und entsprechendes produkt
EP2518644A1 (de) Verfahren zur Steuerung der Übersetzung von vorgegebenen Regeln und/oder eingehenden Daten eines Datenstroms
DE102006021048A1 (de) Verfahren, Vorrichtung und System zur konfigurationsabhängigen Steuerung der Informationsbereitstellung
DE112014002696T5 (de) Verfahren und System für effizientes Sortieren in einer relationalen Datenbank
EP4300327A1 (de) Verfahren zum bereitstellen von daten eines automatisierungssystems, suchverfahren zur ermittlung von daten eines automatisierungssystems, computerprogramm, computerlesbares medium und vorrichtung zur datenverarbeitung
DE102016215796A1 (de) Zuordnungseinheit und Verfahren zur Zuordnung von Objektdaten zu einem Objektidentifikator

Legal Events

Date Code Title Description
PUAI Public reference made under article 153(3) epc to a published international application that has entered the european phase

Free format text: ORIGINAL CODE: 0009012

17P Request for examination filed

Effective date: 20100831

AK Designated contracting states

Kind code of ref document: A2

Designated state(s): AT BE BG CH CY CZ DE DK EE ES FI FR GB GR HR HU IE IS IT LI LT LU LV MC MK MT NL NO PL PT RO SE SI SK TR

AX Request for extension of the european patent

Extension state: AL BA RS

RIN1 Information on inventor provided before grant (corrected)

Inventor name: HOLLENDER, MARTIN

Inventor name: SCHMIDT, WERNER

DAX Request for extension of the european patent (deleted)
17Q First examination report despatched

Effective date: 20160714

RAP1 Party data changed (applicant data changed or rights of an application transferred)

Owner name: ABB SCHWEIZ AG

REG Reference to a national code

Ref country code: DE

Ref legal event code: R003

STAA Information on the status of an ep patent application or granted ep patent

Free format text: STATUS: THE APPLICATION HAS BEEN REFUSED

18R Application refused

Effective date: 20181124