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

Aan de slag met Oracle Modern Data Platform

Probeer meer dan 20 'Altijd gratis'-cloudservices uit, met een proefversie van 30 dagen voor nog meer

Oracle biedt een Free Tier zonder tijdslimiet voor meer dan 20 services zoals Autonomous Database, Arm Compute en Storage, evenals USD 300 aan gratis tegoed om extra cloudservices uit te proberen. Lees de informatie en meld u vandaag nog aan voor uw gratis account.

  • Wat is inbegrepen in Oracle Cloud Free Tier?

    • 2 Autonomous Databases van elk 20 GB
    • Compute VM's van AMD en Arm
    • 200 GB totale blokopslag
    • 10 GB objectopslag
    • 10 TB uitgaande dataoverdracht per maand
    • Meer dan 10 extra 'Altijd gratis'-services
    • $ 300 aan gratis tegoed voor 30 dagen voor nog meer

Leer met stapsgewijze begeleiding

Ervaar een breed scala aan OCI-services via zelfstudies en praktijklabs. Of u nu een ontwikkelaar, beheerder of analist bent, wij kunnen u laten zien hoe OCI werkt. Veel labs draaien op de Oracle Cloud Free Tier of een door Oracle geleverde gratis labomgeving.

  • Aan de slag met OCI Core Services

    De labs in deze workshop bevatten een inleiding tot de kernservices van Oracle Cloud Infrastructure (OCI), waaronder virtuele cloudnetwerken (VCN) en compute- en opslagservices.

    Start nu het lab voor OCI-kernservices
  • Snel aan de slag met Autonomous Database

    In deze workshop doorloopt u de stappen om aan de slag te gaan met Oracle Autonomous Database.

    Start nu het lab Snel aan de slag met Autonomous Database
  • Een app bouwen vanuit een spreadsheet

    Dit lab begeleidt u bij het uploaden van een spreadsheet naar een Oracle Database tabel en het maken van een applicatie op basis van deze nieuwe tabel.

    Start deze training nu
  • Een HA-applicatie implementeren op OCI

    In dit lab implementeert u webservers op twee compute-instances in Oracle Cloud Infrastructure (OCI), geconfigureerd in de modus voor hoge beschikbaarheid met behulp van een lastverdeler.

    Start nu het lab voor HA-applicaties

Ontdek meer dan 150 best practices

Bekijk hoe onze architecten en andere klanten een breed scala aan workloads implementeren, van bedrijfsapps tot HPC, van microservices tot data lakes. Begrijp de best practices, hoor over andere architecten van klanten in onze reeks 'Built & Deployed' en implementeer veel workloads met onze 'click-to-deploy'-functie, of doe dit zelf vanuit onze GitHub-repository.

Populaire architecturen

  • Apache Tomcat met MySQL Database Service
  • Oracle Weblogic op Kubernetes met Jenkins
  • Machine learning (ML)- en AI-omgevingen
  • Tomcat op Arm met Oracle Autonomous Database
  • Loganalyse met ELK-stack
  • HPC met OpenFOAM

Bekijk hoeveel u kunt besparen op OCI

De prijsbepaling voor Oracle Cloud is eenvoudig, met wereldwijd consistente lage prijzen, met ondersteuning voor een breed scala aan gebruiksdoelen. Ga naar de kostencalculator voor een schatting van uw lage tarief en kies en configureer de services die u nodig hebt.

Ervaar het verschil:

  • Een kwart van de kosten voor uitgaande bandbreedte
  • Drie keer betere Compute prijs-prestatieverhouding
  • Zelfde lage prijs in elke regio
  • Lage prijzen zonder langetermijnverplichtingen

Neem contact op met de verkooporganisatie

Wilt u meer weten over Oracle Cloud Infrastructure? Laat een van onze experts u helpen.

  • Ze kunnen vragen beantwoorden zoals:

    • Welke workloads draaien het beste op OCI?
    • Hoe profiteer ik optimaal van Oracle investeringen?
    • Wat zijn de voordelen van OCI ten opzichte van andere cloudcomputing-providers?
    • Hoe kan OCI uw IaaS- en PaaS-doelen ondersteunen?