Oracle Data Platform for Manufacturing

Manufacturing plant data consolidation

 

Optimize efficiency and lower risk with consolidated, real-time data

Today’s manufacturers must understand how efficiently all their lines are running across multiple plants—they need to know immediately when a problem occurs, not five or ten minutes after the fact. However, this is also one of their biggest challenges because their ability to do this relies on real-time access to data from multiple remote locations that may have limited or sporadic internet connectivity. To solve this problem, we need to push machine learning (ML) and data acquisition to the network edge.

Simplify decision-making at the edge

We can configure Oracle Data Platform to solve this challenge by including Oracle Roving Edge Devices (REDs). Each RED is designed to capture, store, run, manage, and gain insight from data, giving manufacturers the ability to automate the decision-making process and management of manufacturing equipment at the edge. Oracle Data Platform for manufacturing also includes anomaly detection capabilities, which can be used to address manufacturing line disruptions and provide maintenance-related insights to improve mitigation and remediation.

The following architecture demonstrates how Oracle Data Platform supports plant data consolidation by deploying advanced analytics and machine learning at the edge to identify anomalies, perform smart data collection, and provide real-time operational information.

plant data consolidation diagram, description below

This image shows how Oracle Data Platform for manufacturing can be used to consolidate plant data. The platform includes the following five pillars:

  1. 1. Data Sources, Discovery
  2. 2. Ingest, Transform
  3. 3. Persist, Curate, Create
  4. 4. Analyze, Learn, Predict
  5. 5. Measure, Act

The Data Sources, Discovery pillar includes two categories of data.

  1. 1. Business records data comprises warehouse management and inventory optimization data, ERP (Oracle E-Business Suite, Fusion SaaS, NetSuite) data, and MES planning and scheduling data.
  2. 2. Technical input data includes sensor, camera, and device (IoT) data and data from PLM, SCADA, and manufacturing applications.

The Ingest, Transform pillar comprises four capabilities.

  1. 1. Batch ingestion uses Oracle Data Integrator and OCI Data Integration.
  2. 2. Streaming ingest uses Kafka Connect.
  3. 3. Custom integration uses Oracle WebLogic Server on VMs.
  4. 4. RED sync transfer uses a local daemon.

Batch ingestion connects unidirectionally to the serving data store.

Streaming ingest and custom integration connect unidirectionally to the outbound transfer area.

Additionally, RED sync transfer unidirectionally connects to the inbound transfer area.

The Persist, Curate, Create pillar comprises four capabilities.

  1. 1. The serving data store uses MySQL and Oracle DB server.
  2. 2. Batch processing/Spark processing uses OCI GoldenGate Stream Analytics.
  3. 3. The outbound transfer area uses OCI Object Storage.
  4. 4. The inbound transfer area uses OCI Object Storage.

These capabilities are connected within the pillar. Batch/Spark processing is unidirectionally connected to the serving data store.

The outbound transfer area is unidirectionally connected to batch/Spark processing.

Three capabilities connect into the Analyze, Learn, Predict pillar:

The serving data store connects unidirectionally to the analytics and visualization capability and bidirectionally to the anomaly detection capability. The outbound transfer area connects unidirectionally to the anomaly detection and RED sync transfer capabilities.

The inbound transfer area connects unidirectionally to the anomaly detection capability.

The Analyze, Learn, Predict pillar comprises three capabilities.

  1. 1. Analytics and visualization uses Oracle Analytics Server.
  2. 2. Anomaly detection uses a model trained centrally and deployed locally as PMML.
  3. 3. RED sync transfer uses a local daemon.

The anomaly detection capability is unidirectionally connected to the analytics and visualization capability within the pillar.

Three capabilities are connected to the Measure, Act pillar. The analytics and visualization capability is unidirectionally connected to local dashboards and reports and also local predictions. The anomaly detection capability is unidirectionally connected to local predictions, and the RED sync transfer capability is unidirectionally connected to an additional use case.

The Measure, Act pillar captures how the consolidated plant data can be used. These potential uses are divided into four groups.

  1. The first group includes local dashboards and reports.
  2. The second group includes local predictions.
  3. The third group includes applications.
  4. The fourth group contains an additional use case, which is operational efficiency and performance.

The three central pillars—Ingest, Transform; Persist, Curate, Create; and Analyze, Learn, Predict—are supported by Oracle Roving Edge Device(s).



There are four main ways to inject data into an architecture to enable manufacturers to easily understand operational efficiency and performance.

  • A custom integration from Oracle Integration Repository lets us integrate data—both structured and unstructured—from various sources, allowing for interactions with devices, custom APIs, and so on. The data can be ingested from any application development type (for example, standalone Java or Python code, Oracle WebLogic Server–based applications, or Kubernetes-based applications). Data will be stored in object storage for further refinement, for outbound transfer, or to feed AI models.
  • The RED data sync is an efficient and simple way to transfer ML models from a central location (for example, your object storage repository of trained models in Oracle Cloud Infrastructure (OCI)) to the edge. In this use case, the edge definition would have the RED colocated with other machinery within the plant itself. New versions of models are stored in “standalone” Predictive Model Markup Language (PMML) format. The local daemon will perform an update when a new model is discovered and automatically push it to the RED. The RED data sync is also a great way to transfer all the data collected by different REDs throughout the day (for example, relevant anomalies, signals, and so on) to your central location, most likely to object storage on OCI. This data will then be used for operational reporting and ML model training. The volume of data involved in these RED data sync processes will determine your requirements for edge-to-data center telco or satellite bandwidth.
  • Batch ingestion uses Oracle Data Integrator, a comprehensive data integration solution that covers all data integration requirements from high-volume, high performance batch loads to event-driven, trickle-feed integration processes and SOA-enabled data services. While real-time needs are evolving, the most common extract from ERP, planning, warehouse management, and transportation management systems is a batch ingestion using an extract, transform, and load or extract, load, and transform process. These extracts could be frequent, as often as every 10 or 15 minutes, but they are still bulk in nature as transactions are extracted and processed in groups rather than individually. OCI offers different services to handle batch ingestion; these include the native OCI Data Integration service or Oracle Data Integrator running on an OCI Compute instance. Depending on the volumes and data types, data could be loaded into object storage or loaded directly into a structured relational database for persistent storage.
  • Analyzing data in real-time from multiple sources can help provide manufacturing companies with valuable insights into their operational efficiency and overall performance. Oracle Data Platform uses streaming ingestion to ingest data streams from several ISA-95 Level 2 systems, such as supervisory control and data acquisition (SCADA) systems, programmable logic controls, and batch automation systems. Streaming data (events) will be ingested and some basic transformations/aggregations will occur before the data is stored in object storage. Streaming analytics can be used to identify correlating events, and identified patterns can be fed back (manually) for a data science examination of the raw data. While traditional analytics tools extract information from data at rest, streaming analytics assesses the value of data in motion, i.e., in real time.

Data persistence and processing is built on three components.

  • In the serving data store, data will be managed by Oracle Database Server or MySQL for data processing. The serving data store provides a persistent relational tier often used to serve data directly to end users via SQL-based tools. It also functions as the serving layer for specialized analytics.
  • All data retrieved from data sources in its raw form (as a native file or extract) is captured and loaded into object storage to be used in current or future ML model training. Cloud object storage is the most common data persistence layer for our data platform, and it serves as both the inbound transfer area and the outbound transfer area. It can be used for both structured and unstructured data.
  • With object storage as the primary data persistence tier, OCI GoldenGate Stream Analytics is the primary processing engine. Batch processing involves several activities, including basic noise treatment, missing data management, and filtering based on defined outbound datasets. Results are written back to various layers of object storage or to a persistent relational repository based on the processing needed and the data types used.

The ability to analyze, learn, and predict is built on two technologies.

  • Analytics and visualization services deliver descriptive analytics (describes current trends with histograms and charts), predictive analytics (predicts future events, identifies trends, and determines the probabilities of uncertain outcomes), and prescriptive analytics (proposes suitable actions, leading to optimal decision-making). Oracle Analytics Server provides the functionality to deliver descriptive analytics related to operational reporting and prescriptive analytics. Additionally, ML models can be embedded directly into the Oracle Analytics Server data flow. Oracle Analytics Server is designed to run on-premises and provides dashboards, reporting, alerting, self-service data preparation, and end user–driven machine learning algorithms. Oracle Data Platform for manufacturing is completely open and flexible, so, if desired, you could use third-party tools for this instead.
  • Alongside the use of advanced analytics, ML models are developed, trained, and deployed to support anomaly detection. OCI Anomaly Detection is an AI service that makes it easier for developers to build business-specific anomaly detection models that flag critical incidents, speeding up detection and resolution. These models will be trained at the central location and deployed in PMML format to be executed locally as Java or Python code.

Automate decision-making to increase profitability

Oracle Data Platform lets manufacturers get the greatest value from all their available data while simplifying and streamlining data access and storage. The ability to push data collection and ML scoring to the edge through Oracle Roving Edge Devices helps manufacturers make better business decisions that are informed by accurate data that’s always available when they need it, allowing them to increase efficiency and production while lowering costs.

Related resources

Inizia a utilizzare Oracle Modern Data Platform

Prova oltre 20 servizi cloud sempre gratuiti, con una prova di 30 giorni per altri servizi aggiuntivi.

Oracle offre un livello gratuito (Free Tier) senza limiti di tempo per 20 servizi come database autonomo, computazione basata su Arm e storage, oltre a 300 dollari in crediti gratuiti per provare servizi cloud aggiuntivi. Scopri i dettagli e attiva subito il tuo account gratuito.

  • Cosa è incluso in Oracle Cloud Free Tier?

    • 2 database autonomi, di 20 GB ciascuno
    • VM di computazione AMD e basate su Arm
    • 200 GB di storage a blocchi totale
    • 10 GB di storage degli oggetti
    • 10 TB di trasferimento dati in uscita al mese
    • Oltre 10 servizi sempre gratuiti
    • 300 dollari di crediti gratuiti per 30 giorni e per molti più servizi

Scopri le linee guida

Prova una vasta gamma di servizi OCI attraverso tutorial e laboratori interattivi. Che tu sia uno sviluppatore, un amministratore o un analista, possiamo aiutarti a chiarire come funziona OCI. Molti laboratori sono disponibili in Oracle Cloud Free Tier o su un ambiente gratuito fornito da Oracle.

  • Introduzione ai principali servizi di OCI

    I laboratori di questo workshop trattano i servizi di base Oracle Cloud Infrastructure (OCI), tra cui le reti cloud virtuali (VCN) e i servizi di computazione e storage.

    Inizia ora il laboratorio sui servizi chiave di OCI
  • Avvio rapido al database autonomo

    Questo workshop spiega i passaggi necessari per iniziare a utilizzare Oracle Autonomous Database.

    Scopri il laboratorio di avvio rapido al database autonomo
  • Creare un'applicazione da un foglio di calcolo

    Questo laboratorio spiega come caricare un foglio di calcolo in una tabella Oracle Database e come poi creare un'applicazione basata su questa nuova tabella.

    Scopri questo laboratorio
  • Distribuisci un'applicazione HA su OCI

    In questo laboratorio potrai distribuire dei server Web su due istanze di computazione in Oracle Cloud Infrastructure (OCI), configurate in modalità ad alta disponibilità tramite un load balancer.

    Inizia ora il laboratorio sull'applicazione HA

Scopri più di 150 progetti basati su best practice

Scopri come i nostri architetti e altri clienti implementano una vasta gamma di carichi di lavoro, dalle app enterprise all'HPC, dai microservizi ai data lake. Comprendi a fondo le best practice, impara dagli architetti dei nostri clienti nella serie Built & Deployed e distribuisci diversi carichi di lavoro con la nostra funzionalità "click to deploy" o in autonomia dal nostro repository GitHub.

Le architetture più utilizzate

  • Apache Tomcat con MySQL Database Service
  • Oracle Weblogic su Kubernetes con Jenkins
  • Ambienti di Machine Learning (ML) e intelligenza artificiale
  • Tomcat su Arm con Oracle Autonomous Database
  • Analisi dei log con lo stack ELK
  • HPC con OpenFOAM

Scopri quanto puoi risparmiare su OCI

Le tariffe di Oracle Cloud sono semplici e a prezzi bassi equiparati a livello globale e supportano una vasta gamma di casi d'uso. Per stimare un tasso ridotto, prova lo strumento di stima dei costi e configura i servizi in base alle tue esigenze.

Prova la differenza:

  • 1/4 dei costi della larghezza di banda in uscita
  • 3 volte maggiore il rapporto qualità-prezzo relativo alla computazione
  • Stesso prezzo basso in ogni region
  • Prezzi bassi senza obblighi a lungo termine

Contattaci

Vuoi saperne di più su Oracle Cloud Infrastructure? I nostri esperti possono darti una mano.

  • Possono rispondere a domande quali:

    • Quali carichi di lavoro funzionano meglio su OCI?
    • Come posso ottenere il massimo dagli investimenti complessivi Oracle?
    • Come si posiziona OCI rispetto ad altri fornitori di cloud computing?
    • In che modo OCI può supportare gli obiettivi di IaaS e PaaS?