[hemmerling] Industrial Data & Industrial Data Exchange

Related pages:

• Fieldbuses and Automation Networks.
• FIWARE 1/2.
• FIWARE 2/2 - My first Steps.
• International Data Spaces / Industrial Data Space ( IDS ).
• Manufacturing Execution Systems ( MES ) 2/5 - Software Systems.
• Manufacturing Execution Systems ( MES ) 3/5 - Norms & Design.
• OPC UA and OPC ( OLE for Process Control ).

• The alarm limits are stored in the PLC. So that the PLC can react. The PLC transfers one bit of information, when the signal lefts the range of the alarm limits.
• However for visualisation, the analog values of the alarm limits data must be transfered as digital values from to the HMI device.
• Siemens Industry Online Support "What should you watch out for when using the alarm numbering procedure?", Siemens Industry Online Support "Was ist bei der Anwendung des Meldenummernverfahrens zu beachten?" → “bit alarm procedure” ( German: “Bitmeldeverfahren” ) vs. “alarm numbering procedure” ( German: “Meldenummernverfahren” ).

• EN.Wikipedia "Component Object Model", DE.Wikipedia "Distributed Component Object Model" ( COM ).

• EN.Wikipedia "Distributed Component Object Model", DE.Wikipedia "Distributed Component Object Model" ( DCOM ) - “Network OLE”. Once used by the legacy “OPC DA”.

• EN.Wikipedia "Dynamic Data Exchange", DE.Wikipedia "Dynamic Data Exchange" ( DDE ).
• NetDDE.

• EN.Wikipedia ".NET Remoting", DE.Wikipedia ".NET Remoting".

• EN.Wikipedia "General Packet Radio Service", DE.Wikipedia "General Packet Radio Service".
• EN.Wikipedia "Email", DE.Wikipedia "E-Mail".
• EN.Wikipedia "Short Message Service", DE.Wikipedia "Short Message Service".
• EN.Wikipedia "Simple Network Management Protocol", DE.Wikipedia "Simple Network Management Protocol".

• EN.Wikipedia "Active Directory", DE.Wikipedia "Active Directory".
• EN.Wikipedia "Lightweight Directory Access Protocol", DE.Wikipedia "Lightweight Directory Access Protocol".

• eCl@ss.
• Wiki eClass Wiki.
  • eClass Wiki "IRDI".
• EN.Wikipedia "ECl@ss", DE.Wikipedia "eCl@ss".
• Norms:
  • Data model: ISO 13584-42 / IEC 61360.
  • Release process: ISO 22274.
  • Data transfer: ISO 29002.
• The names used for the primary key, IRDI, might be subject of copyright.
• Every class may have several attributes.
• An item might be member of several classes and may have several attributes of each class.
• eClass membership fees depend on the number of staff members of the company / organisation, only.
• eClass is unique. Some direct competitors:
  1. GS1, GDSN - Just for the food industry only.
     • GS1.
     • GS1 "GDSN-Datenpool".
     • DE.Wikipedia "Globales Daten-Synchronisations-Netzwerk".
  2. ETIM - Just for electronic devices.
     • EN.Wikipedia "ETIM (standard)", DE.Wikipedia "ETIM".
  3. United Nations Standard Products and Services Code ( UNSPSC ) - Just classes, classes don´t have attributes .
     • EN.Wikipedia "UNSPSC", DE.Wikipedia "UNSPSC".

• EN.Wikipedia "Electronic data interchange", DE.Wikipedia "Elektronischer Datenaustausch" ( EDI ).
• EN.Wikipedia "EDIFACT", DE.Wikipedia "EDIFACT".
• PROZEUS - PROZESSEundSTANDARDS, eBusiness Praxis für den Mittelstand.
  • PROZEUS - IT-Dienstleisterpool - List of eBusiness standards .

• EUROMAP - Legacy protocols of the early 1990th.
  • EUROMAP 15.
  • EUROMAP 63.
    • EUROMAP 63 - Data Exchange Interface ( PDF ).

• EN.Wikipedia "FTAM", DE.Wikipedia "File Transfer and Access Management".

• EN.Wikipedia "ISO 10303", DE.Wikipedia "Standard for the exchange of product model data" ( STEP ).

• International Organization of Standardization "ISO 15531-44:2010. Industrial automation systems and integration -- Industrial manufacturing management data -- Part 44: Information modelling for shop floor data acquisition".

• ISO.
  • International Organization of Standardization "ISO 20242-1:2005. Industrial automation systems and integration -- Service interface for testing applications -- Part 1: Overview".
  • International Organization of Standardization "ISO 20242-2:2010. Industrial automation systems and integration -- Service interface for testing applications -- Part 2: Resource management service interface".
  • International Organization of Standardization "ISO 20242-3:2011. Industrial automation systems and integration -- Service interface for testing applications -- Part 3: Virtual device service interface".
  • International Organization of Standardization "ISO 20242-4:2011. Industrial automation systems and integration -- Service interface for testing applications -- Part 4: Device capability profile template".
• Association for Standardisation of Automation and Measuring Systems ( ASAM e. V. ).
• Dr.–Ing. Robert Patzke "ASAM–GDI Generic Device Interface".
  • Wiki ASAM-GDI Wiki.
• EN.Wikipedia "Association for Standardisation of Automation and Measuring Systems", DE.Wikipedia "Association for Standardization of Automation and Measuring Systems".

• Q-DAS "Q-DAS ASCII transfer format".
• Q-DAS "Advanced Quality Data Exchange Format (AQDEF)" - “The AQDEF (Advanced Quality Data Exchange Format) work group was founded to specify a standardized data exchange format, binding requirements for data aquisition and data transfer between measurement system manufacturers and Q-DAS software products”.
• Q-DAS GmbH "Q-DAS ASCII transfer format"

• See Radio-Frequency Identification ( RFID ).

• EN.Wikipedia "Remote procedure call", DE.Wikipedia "Remote Procedure Call".

• See Enterprise Resource Planning ( ERP ) / "Produktionsplanung und Steuerung" ( PPS ).

• EN.Wikipedia "Andon", DE.Wikipedia "Andon (manufacturing)".
• An Andon button is a “call-off order” / “demand” button, in a shopfloor environment.
• Loosely related: Digital Signage.

• EN.Wikipedia "Automated optical inspection", DE.Wikipedia "Automatische optische Inspektion" ( AOI ).
• EN.Wikipedia "Automatic test equipment", DE.Wikipedia "Automatic Test Equipment" ( ATE ).

• Foxboro.
  • Foxboro Data format without text ( = CSV data format ).
  • Foxboro Data format with text ( = CSV data format ).

• Janitza electronics GmbH. Optional communications by Modbus TCP, via an OPC server with Modbus TCP interface → see Fieldbuses and Automation Networks.
  • Wiki Janitza Dashboard.

• pixolus GmbH - “Mobile visuelle Datenerfassung Abtippen war gestern”. “Produkte (1) Verbrauchsablesung durch Mitarbeiter (2) Kundenselbstablesung”.

• Microsoft ActiveSync - for communikation with mobile computers.
  • EN.Wikipedia "ActiveSync", DE.Wikipedia "ActiveSync".
  • EN.Wikipedia "OpenSync (software)", DE.Wikipedia "OpenSync".
• INTERMEC TECHNOLOGIES Gmbh.
  • INTERMEC TECHNOLOGIES Gmbh "Handheld-Computer".
    • INTERMEC TECHNOLOGIES Gmbh "Robuste Mobilcomputer - Die neue CK3-Serie".

• Intermec Technologies Corporation.
  • Intermec Technologies Corporation "CK3B Mobile Computer".
• ProLogis Automatisierung und Identifikation GmbH - “Kennzeichnen, Identifizieren, Automatisieren. Etikettendrucker, Scanner, Mobile Datenerfassung”.
• Zebra Technologies Corporation "105SL Industrial Printers".

• “Scale Listener” - instrumentation device for scales.

• it-production.com - Das Online-Magazin für erfolgreiche Produktion "Universal Machine Connectivity - Auf dem Weg zur einfachen Maschinenanbindung".
• MES D.A.C.H Verband e.V..
  • MES D.A.C.H Verband e.V. "Verbinden heißt UMCM. Universal Machine Connectivity for MES – eine Schnittstelle für alle".
    • MES D.A.C.H Verband e.V. "Technische Details".
      • Typical transfered informations ( in German language ):
        1. Zeitstempel.
        2. Produktionsfortschritt.
        3. Produktionszustand.
        4. Prozesswerte.
        5. Materialinformationen.
      • Data transfer by:
        1. OPC-UA telegrams.
        2. File interface ( e.g. in JSON or XML format ).
  • MES D.A.C.H Verband e.V. "Verbinden heißt UMCM. Universal Machine Connectivity for MES – eine Schnittstelle für alle" - PDF Download.
• MPDV Mikrolab GmbH "UMCM - eine Schnittstelle für alle".
• SYNCOS GmbH "UMCM – Eine MES-Schnittstelle für alle. Von einer einheitlichen Schnittstelle zwischen MES und Maschine profitieren sowohl Maschinenhersteller als auch Anwender".

• It is important that a MES software stores data with timestamps in UTC and not in local time. The problem are daylight savings applied to local time in many countries, including EU: In Spring, you have a gap of one our in your datastream, in Autumn you loose data of 1 hour ( as it is not possible for most MES systems, to store 2 datasets with the same timestamp ).

• Bytes IT Community "to_timestamp fomatting of Dates".
• CodeProject "Bitemporal Database Table Design - The Basics".
• GitHub "jOOQ/jOOQ" - “Add support for Oracle 12c's temporal validity (AS OF PERIOD FOR) #2605” - “An example taken from the documentation”.
• Google Search "valid time temporal".
• Oracle.
  • Oracle "Implementing Temporal Validity" - “Valid time temporal support in Oracle Database enables you to associate a valid time dimension with a table and to have data be visible depending on its time-based validity, as determined by the start and end dates or timestamps of the period for which a given record is considered valid. Examples of time-based validity can include the hire and termination dates of an employee in a Human Resources application, the effective date of coverage for an insurance policy, and the effective date of a change of address for a customer or client”.
  • Oracle Docs "5 Managing and Maintaining Time-Based Information".
  • OOracle® Database SQL Reference "TO_TIMESTAMP ".
• Oracle DBA – Tips and Techniques Oracle DBA – Tips and Techniques. Knowledge Is Power - Share IT! "Oracle 12c New Feature - Temporal Validity".
• Protege Community of Practice (CoP) "ValidTimeTemporalModel".
• SQL Magazine "BiTemporal Design: Time After Time. The time is right to design for better BI queries".
• Stack Overflow "Why do we need a temporal database?".
• Tech on the Net "Oracle/PLSQL: TO_TIMESTAMP Function".
• Timeconsult "What is Temporal Data?".
• EN.Wikipedia "Bitemporal data".
• EN.Wikipedia "Temporal database", EN.Wikipedia "Temporale Datenbank" - “Valid time is the time period during which a fact is true with respect to the real world”.
• EN.Wikipedia "Valid time".

• EN.Wikipedia "Web service", DE.Wikipedia "Webservice".

• See Fieldbuses and Automation Networks.

• See Fieldbuses and Automation Networks.

• See Fieldbuses and Automation Networks.

• See Fieldbuses and Automation Networks.

Inspired by: Cimetrix, Rob Schreck "Implementing GEM and PV2 – what you should know", 2012-05-14.

• See OPC UA and OPC ( OLE for Process Control ).
• I was told by experts that “Data Distribution Services ( DDS )” would be an alternative to OPC UA → See Fieldbuses and Automation Networks.

• SEMI - “The global industry association serving the manufacturing supply chain for the micro- and nano-electronics industries”.
  • SEMI International Standards.
    • SEMI International Standards - Downloads - “Browse 'Equipment Automation Software'”.

• SEMI Interface A Standards ( E120, E125, E132, E134 ).
• EDA does not replace the SEMI SECS/GEM standards or the SEMI GEM 300 standards, since EDA does not provide any features for equipment control or configuration. Instead, equipment suppliers support EDA in addition to other required interfaces.

• SEMI SECS/GEM standards ( E4, E5, E30, and E37 ).
• SEMI GEM 300 standards ( E39, E40, E87, E90, E94, E116, E148, and E157 ).
• The Generic Equipment Model ( GEM ) defines a standard implementation of SECS-II for all semiconductor manufacturing equipment. The GEM standard defines a common set of equipment behavior and communications capabilities that provide the functionality and flexibility to support the manufacturing automation programs of semiconductor device manufacturers.

• CodeForge.com. Free Open Source Codes Forge and Sharing "SECS I, SECS II agreement communication source code" → “Download Source Codes: semi.zip”.

• Cimetrix.
  • Cimetrix "SEMI Interface A Standards Overview" - “Mapping Interface A/EDA to SECS/GEM” #.
  • Cimetrix "SECS-II - SEMI Equipment Communications Standard 2".
  • Cimetrix "SECS/GEM SEMI Standards Overview".
  • Blog Cimetrix SEMI Standards Blog - “SEMI Standards Implementation, Software, & Discussion”.
• Integrated Measurement Association (IMA).
  • |Integrated Measurement Association (IMA) - Standards.
    • Integrated Measurement Association (IMA), James Moyne "Glossary of SEMI Standards: Current and Pending".
• The PEER Group Inc.
  • The PEER Group Inc. "SDR" - “Provides high-technology factories and their equipment suppliers with the connectivity solution required to implement the well established SEMI equipment communication standard (SECS). SDR is fully compliant with current releases of SEMI standards E4 (SECS I), E5 (SECS II) and E37 (HSMS) and is in wide use throughout the semiconductor industry and is considered the standard that other SECS implementations are measured against.”.
  • The PEER Group Inc. "GEM4Tools" - “SECS/GEM is the communications standard for high-technology equipment. OPC is the communications standard for PLC-based equipment. PEER Group brings SECS/GEM and OPC together to deliver fast and easy factory communications for semiconductor, solar, MEMs, LED and other high-technology manufacturing equipment”.
  • The PEER Group Inc. "SECS4Hosts" - “The SECS/GEM protocol is complicated compared with PLC-based factory communications. With SECS4Hosts, you can simplify the development of a host-side SECS or SECS/GEM driver. SECS4Hosts is all about speed. It's simply the fastest way to give your Windows host applications the ability to communicate with any SECS-compliant equipment”.
• EN.Wikipedia "SECS-II" - “The protocol is maintained by the SEMI organization, from which copies of the SEMI E5 standard may be obtained for a fee”.
• Book Richard Zurawski "Integration Technologies for Industrial Automated Systems (Industrial Information Technology)" - Part 4, section 4.5 “SEMI”.

• The data file output format of SIEMENS Gebäudemanagementsystem SICLIMAT X can be one of the data sources of a MES system.

• In the book Kathrin Passig, Johannes Jander "Weniger schlecht programmieren", the chapter “Versionskontrolle als Softwarebausteine” describes the use of a CVS system for data storage and visualisation:
  1. Creat a file 2015-01-01.txt.
  2. Upload it to a Subversion repository with 'svn add 2015-01-01.txt', 'svn commit -m ””'.
  3. Write your data in the file 2015-01-01.txt.
  4. Updates to this file are updated to the Subversion repository by these 2 commands ( i.e. 'svn add 2015-01-01.txt', 'svn commit -m ””' ).
  5. A web server checks out the data frequently by “svn up” and embedds it into a website.

• Microsoft "The Open Data Initiative".
• GitHub "Microsoft/CDM" - “The Common Data Model (CDM) is a standard and extensible collection of schemas (entities, attributes, relationships) that represents business concepts and activities with well-defined semantics, to facilitate data interoperability. Examples of entities include: Account, Contact, Lead, Opportunity, Product, etc.”.
• SAP "The Open Data Initiative".
• Adobe "Open Data Initiative".

• ICANN "ICANN Open Data Initiative".

• Heise "Microsoft, SAP und Adobe kündigen 'Open Data Initiative' an", 2018-09.
• IT-Zoom "Neue Details zur Open-Data-Initiative", 2019-03 - “Ziel der Initiative ist es, die Kompatibilität der Anwendungen und Plattformen der drei Partner durch ein gemeinsames Datenmodell sowie die Speicherung der Informationen in einem gemeinsamen Datenpool zu verbessern. Der einheitliche Datenspeicher ermögliche es Kunden, nahtlos zwischen verschiedenen Entwicklungstools und Applikationen zur Bereitstellung von Diensten zu wählen”.

• ASAM-GDI Forum. Informationsaustausch zum Standard und seiner Anwendung.
• OpenSCADA ( oscada.org ) Forum.