mongo db iot_london_v0.1
DESCRIPTION
Presented by, Timo Klingenmeier, General Manager, inmation GmbH & Co. KG Industry 4.0 and the Internet of Things translate to new opportunities and new challenges for manufacturing corporations. The informed workforce requires access to vast amounts of data. Handling floods of data from the production floor across the organisation and in exchange with selected business partners is not a simple task, but when achieved it turns into a major competitive advantage. MongoDB’s strategic partner inmation has developed a middleware solution which combines intelligent industrial real-time connectivity with unlimited scalability and one uniform storage layer for all kinds of data structures – MongoDB.TRANSCRIPT
![Page 1: Mongo db iot_london_v0.1](https://reader036.vdocuments.us/reader036/viewer/2022062313/5586c002d8b42aab718b45cd/html5/thumbnails/1.jpg)
IoT City Tour
Presentation
Realtime Data – The Source of Corporate Intelligence and Agility
![Page 2: Mongo db iot_london_v0.1](https://reader036.vdocuments.us/reader036/viewer/2022062313/5586c002d8b42aab718b45cd/html5/thumbnails/2.jpg)
IoT City Tour
1. Some thoughts on Industry 4.0
2. Internet of Things vs. Industrial Control
(and practices)
3. The OPC specification in brief
4. Short round-trip through „Industrial Data“
5. Benefits of MongoDB being an universal
data store
30 Minutes to Cover
![Page 3: Mongo db iot_london_v0.1](https://reader036.vdocuments.us/reader036/viewer/2022062313/5586c002d8b42aab718b45cd/html5/thumbnails/3.jpg)
IoT City Tour
The Problem
![Page 4: Mongo db iot_london_v0.1](https://reader036.vdocuments.us/reader036/viewer/2022062313/5586c002d8b42aab718b45cd/html5/thumbnails/4.jpg)
IoT City Tour
The Problem
![Page 5: Mongo db iot_london_v0.1](https://reader036.vdocuments.us/reader036/viewer/2022062313/5586c002d8b42aab718b45cd/html5/thumbnails/5.jpg)
IoT City Tour
“Classic” Industry
![Page 6: Mongo db iot_london_v0.1](https://reader036.vdocuments.us/reader036/viewer/2022062313/5586c002d8b42aab718b45cd/html5/thumbnails/6.jpg)
IoT City Tour
3.x
Industry
MaterialFlows
Source: https://chemicalparks.eu/system/files/attachments/file/14/European_Pipeline_Infrastructure__Networks.pdf
![Page 7: Mongo db iot_london_v0.1](https://reader036.vdocuments.us/reader036/viewer/2022062313/5586c002d8b42aab718b45cd/html5/thumbnails/7.jpg)
IoT City Tour
Goal is the
“Smart Factory”
Further
Computerization of
Traditional Industries
The Internet of Things
Is Technological
Foundation
Industry
4.0Drivers
![Page 8: Mongo db iot_london_v0.1](https://reader036.vdocuments.us/reader036/viewer/2022062313/5586c002d8b42aab718b45cd/html5/thumbnails/8.jpg)
IoT City Tour
4.0Industry
Effects
End of Data Boundaries
for Individual Factories
Data
Interconnectability
Between Sites Without
Geographical
Restrictions
Enourmous
Growth
of Production and
Supplier Networks
![Page 9: Mongo db iot_london_v0.1](https://reader036.vdocuments.us/reader036/viewer/2022062313/5586c002d8b42aab718b45cd/html5/thumbnails/9.jpg)
IoT City Tour
The Internet of Things
![Page 10: Mongo db iot_london_v0.1](https://reader036.vdocuments.us/reader036/viewer/2022062313/5586c002d8b42aab718b45cd/html5/thumbnails/10.jpg)
IoT City Tour
Our Scope
Realtime Data
![Page 11: Mongo db iot_london_v0.1](https://reader036.vdocuments.us/reader036/viewer/2022062313/5586c002d8b42aab718b45cd/html5/thumbnails/11.jpg)
IoT City Tour
system:inmation
![Page 12: Mongo db iot_london_v0.1](https://reader036.vdocuments.us/reader036/viewer/2022062313/5586c002d8b42aab718b45cd/html5/thumbnails/12.jpg)
IoT City Tour
SQL
Text/XML
NoSQL/Schema-flexible/BSON
OPC
Common Data Sources
![Page 13: Mongo db iot_london_v0.1](https://reader036.vdocuments.us/reader036/viewer/2022062313/5586c002d8b42aab718b45cd/html5/thumbnails/13.jpg)
IoT City Tour
1996 20131998 2001 2003 2006 2007 2009
OPC Data Access (DA) specification established
OPC Alarms and Events (A&E) specification established
OPC Historical Data Access (HDA) specification established
OPC Unified Architecture (UA) created
OPC UA 1.0 becomes available
First products based on OPC UA
OPC UA 1.01 becomes available
OPC UA 1.02 becomes available
OPC: OLE for Process Control
Source: www.opcfoundation.org
![Page 14: Mongo db iot_london_v0.1](https://reader036.vdocuments.us/reader036/viewer/2022062313/5586c002d8b42aab718b45cd/html5/thumbnails/14.jpg)
IoT City Tour
Teach yourself…
…and visit www.opcfoundation.org
![Page 15: Mongo db iot_london_v0.1](https://reader036.vdocuments.us/reader036/viewer/2022062313/5586c002d8b42aab718b45cd/html5/thumbnails/15.jpg)
IoT City Tour
Source: www.intel.com
OPC?
![Page 16: Mongo db iot_london_v0.1](https://reader036.vdocuments.us/reader036/viewer/2022062313/5586c002d8b42aab718b45cd/html5/thumbnails/16.jpg)
IoT City Tour
Source: www.arduino.cc
OPC!
![Page 17: Mongo db iot_london_v0.1](https://reader036.vdocuments.us/reader036/viewer/2022062313/5586c002d8b42aab718b45cd/html5/thumbnails/17.jpg)
IoT City Tour
Source: http://www.ccj-online.com/ovation-upgrade-7fa/
Always OPC!
![Page 18: Mongo db iot_london_v0.1](https://reader036.vdocuments.us/reader036/viewer/2022062313/5586c002d8b42aab718b45cd/html5/thumbnails/18.jpg)
IoT City Tour
Advantages
![Page 19: Mongo db iot_london_v0.1](https://reader036.vdocuments.us/reader036/viewer/2022062313/5586c002d8b42aab718b45cd/html5/thumbnails/19.jpg)
IoT City Tour
Simplification
Advantages
No schema pre-definition
Few (sufficient) datatypes
![Page 20: Mongo db iot_london_v0.1](https://reader036.vdocuments.us/reader036/viewer/2022062313/5586c002d8b42aab718b45cd/html5/thumbnails/20.jpg)
IoT City Tour
Data Types:Oracle, PL/SQL
Source: www.techonthenet.com/oracle/datatypes.php
Advantages
![Page 21: Mongo db iot_london_v0.1](https://reader036.vdocuments.us/reader036/viewer/2022062313/5586c002d8b42aab718b45cd/html5/thumbnails/21.jpg)
IoT City Tour
Data Types:SQL Server
Source: www.connectionstrings.com/sql-server-data-types-reference
Advantages
![Page 22: Mongo db iot_london_v0.1](https://reader036.vdocuments.us/reader036/viewer/2022062313/5586c002d8b42aab718b45cd/html5/thumbnails/22.jpg)
IoT City Tour
Data Types:OPC UA
Advantages
![Page 23: Mongo db iot_london_v0.1](https://reader036.vdocuments.us/reader036/viewer/2022062313/5586c002d8b42aab718b45cd/html5/thumbnails/23.jpg)
IoT City Tour
Advantages
Data Types:
![Page 24: Mongo db iot_london_v0.1](https://reader036.vdocuments.us/reader036/viewer/2022062313/5586c002d8b42aab718b45cd/html5/thumbnails/24.jpg)
IoT City Tour
Data Type Flexibility
Advantages
“Intrinsic” variants
“Intrinsic” arrays
![Page 25: Mongo db iot_london_v0.1](https://reader036.vdocuments.us/reader036/viewer/2022062313/5586c002d8b42aab718b45cd/html5/thumbnails/25.jpg)
IoT City Tour
Sample Storage: Each (sub-second
accurate) measurement is stored as a
“Micro-Document”
oObjectId points into another collection which stores the context information for this item (e.g. measurement). cThis is the distinct counter relative to the value updates which were received from the external data source.
vA value submitted by an external (OPC) server, in whatever format. qThe external quality (bit mask).tThe original timestamp taken from the external server.hThe timestamp of the historization process (and machine).
Advantages
![Page 26: Mongo db iot_london_v0.1](https://reader036.vdocuments.us/reader036/viewer/2022062313/5586c002d8b42aab718b45cd/html5/thumbnails/26.jpg)
IoT City Tour
Sample Storage: Different data types can be stored
in the same “value” field:Advantages
![Page 27: Mongo db iot_london_v0.1](https://reader036.vdocuments.us/reader036/viewer/2022062313/5586c002d8b42aab718b45cd/html5/thumbnails/27.jpg)
IoT City Tour
Summary MongoDB is the perfect fit for Industrial Big Data
• It has the performance and the scalability options required to store hi-freq data in huge amounts
• Timestamp accuracy is sufficient
• Schema (-less) flexibility fits the variant data structures, originated in (OPC) source systems
• BSON is not only about storage, but also transport
• Unbeatable value offer (both software and hardware utilization)
• It exposes ‘natural’ data structures which simplify any kind of further analysis
• Choose between private and public cloud storage
![Page 28: Mongo db iot_london_v0.1](https://reader036.vdocuments.us/reader036/viewer/2022062313/5586c002d8b42aab718b45cd/html5/thumbnails/28.jpg)
IoT City Tour
Thank You.