EP2250591A2 - Procédé et dispositif de mémorisation de données appartenant respectivement à un message d'alarme ou d'événement contenant plusieurs attributs - Google Patents

Procédé et dispositif de mémorisation de données appartenant respectivement à un message d'alarme ou d'événement contenant plusieurs attributs

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)
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/fr
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:

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Debugging And Monitoring (AREA)

Abstract

L'invention concerne un procédé et un dispositif correspondant pour la mémorisation de données qui appartiennent respectivement à un message d'alarme ou d'événement contenant plusieurs attributs. L'invention est caractérisée en ce que dans une table établie (T), une première partie ( par exemple, 1, 2 et 3) des attributs appartenant à un message d'alarme ou d'événement (1 à 7) est mémorisée de façon normalisée, directement, et en ce qu'en outre, aussi bien la première partie (par exemple,1, 2 et 3) qu'une seconde partie restante (par exemple, 4, 5, 6, 7) des attributs (1 à 7) est mémorisée en tant qu'ensemble de données à disposition (A).
EP09720438A 2008-03-14 2009-03-12 Procédé et dispositif de mémorisation de données appartenant respectivement à un message d'alarme ou d'événement contenant plusieurs attributs Ceased EP2250591A2 (fr)

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 (fr) 2008-03-14 2009-03-12 Procédé et dispositif de mémorisation de données appartenant respectivement à un message d'alarme ou d'événement contenant plusieurs attributs

Publications (1)

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

Family

ID=40953056

Family Applications (1)

Application Number Title Priority Date Filing Date
EP09720438A Ceased EP2250591A2 (fr) 2008-03-14 2009-03-12 Procédé et dispositif de mémorisation de données appartenant respectivement à un message d'alarme ou d'événement contenant plusieurs attributs

Country Status (5)

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

Families Citing this family (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2014076524A1 (fr) * 2012-11-16 2014-05-22 Data2Text Limited Procédé et appareil conçus pour les descriptions spatiales dans un texte de sortie
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
JP2002505484A (ja) * 1998-02-26 2002-02-19 サン・マイクロシステムズ・インコーポレーテッド データベースにおけるマルチエントリーとマルチテンプレートとの対照のための方法及びシステム
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
DE102008014151A1 (de) 2009-09-17
CN102067118B (zh) 2013-11-20
US20110029582A1 (en) 2011-02-03
WO2009112252A3 (fr) 2009-12-03
CN102067118A (zh) 2011-05-18
WO2009112252A2 (fr) 2009-09-17

Similar Documents

Publication Publication Date Title
DE60306674T2 (de) Verfahren und systeme zur regelung des zugriffs auf ein datenobjekt mittels sperren
EP1110127A1 (fr) Systeme d&#39;information, de commande et/ou d&#39;observation avec interface utilisateur modelisee et procedes de commande et/ou d&#39;observation modelisees
DE1499182B2 (de) Datenspeichersystem
WO2009112252A2 (fr) Procédé et dispositif de mémorisation de données appartenant respectivement à un message d&#39;alarme ou d&#39;événement contenant plusieurs attributs
EP3364257A1 (fr) Procédé de fonctionnement d&#39;un système d&#39;ingénierie pour un système d&#39;automatisation de processus industriel et programme de commande
DE19538448A1 (de) Datenbankmanagementsystem sowie Datenübertragungsverfahren
EP2073136B1 (fr) Système et procédé destinés à la production de données d&#39;évaluation
DE10059103B4 (de) Einheit zur Verwaltung von in einer Datenverarbeitungseinrichtung gespeicherten Daten
WO1999017192A1 (fr) Procede de configuration pour installations informatiques
EP3699704A1 (fr) Système et procédé de vérification des exigences du système des systèmes cyber-physiques
DE112011105475B4 (de) Programmierbare Logiksteuerung
EP0770946B1 (fr) Procédé pour concevoir automatiquement la redondance optimale pour des mesures dans le système de controle des centrales électriques
EP3508928A1 (fr) Procédé de traitement d&#39;alarmes dans un système de commande de processus ainsi que dans un système d&#39;exploitation
EP1950635A1 (fr) Procédé destiné au fonctionnement d&#39;un système d&#39;automatisation
EP2329374A1 (fr) Module de test et procédé destiné à tester un intergiciel de mapping o/r
EP2136303B1 (fr) Procédé de commande d&#39;une actualisation automatique de visualisations de données dans un système informatique
DE10354938A1 (de) Datenverarbeitungssystem mit automatisierbarer Verwaltung und Verfahren zur automatisierten Verwaltung eines Datenverarbeitungssystems
DE10228142B4 (de) System zur Sicherung von Softwarekomponenten und/oder Computerprogrammen
WO2012019614A1 (fr) Procédé de marquage et d&#39;identification d&#39;une structure constitutive d&#39;un produit et produit correspondant
EP2518644A1 (fr) Procédé de commande de la traduction de règles prédéterminées et/ou de données devant être enregistrées d&#39;un flux de données
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 (fr) Procédé de fourniture de données d&#39;un système d&#39;automatisation, procédé de recherche destiné à la détermination de données d&#39;un système d&#39;automatisation, programme informatique, support lisible par ordinateur et dispositif de traitement de données
DE102016215796A1 (de) Zuordnungseinheit und Verfahren zur Zuordnung von Objektdaten zu einem Objektidentifikator
DE2358689A1 (de) Verfahren und anordnung zur entwicklung einer funktionsspezifikation fuer ein rechnersystem

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