News CNCnetPDM About us Support  
         

DATA PROCESSING | INTERNET OF THINGS

Even having all required information in a single data repository again was good progress the next challenges were to put all data into relationship, build the desired reports and deliver them to the users with no or minimal effort.

Goal:

  • Aggregate, concentrate and summarize large amount of acquired data

In addition it was necessary to keep an eye on potential performance and resource issues caused by the high amount of data received from the shop floor. The fact that every machine delivers 6 records per minute creates an amount of almost half a million records for 50 machines per day! This definitely is ‘Big Data’ which, without any form of aggregation would quickly have led to serious problems.

Again Oracle’s Manufacturing Operations Center (MOC) provided the right tools to get this job done. In configurable intervals MOC reads all data from the so called ‘raw data’ and ‘staging’ tables and aggregates it into several layers of summary tables each with another purpose for example machine-states, output quantities, downtime or scrap reasons, operational or quality data. After processing the raw data MOC makes room for new data by cleaning up the initial table. To further increase performance, data in the summary tables is made available to the reporting components via so called ‘materialized views’.

Functions:

  • Reading and validating of raw data followed by building summary tables and materialized views
  • Automatic cleanup of raw data after processing
  • Reprocessing of incorrect input data

Benefits:

  • Reduced hardware costs by compression of data
  • Ensured performance by aggregating raw data into summary tables and materialized views
  • Enabled reprocessing of invalid or forgotten input data

 

Privacy notice

This website uses cookies. By continuing to use it you agree to our privacy policy. 

https://www.inventcom.net/success-stories/internet-of-things/data-processing
Success Stories | Internet of Things | Overview
The Internet of Things (IoT) becomes reality for one of the top 500 fastest growing manufacturing companies in the US.... [read more]
Overview
Success Stories | Internet of Things | Machine States
The initial requirement of the customer sounded pretty simple: ‘We’d just like to know whether our manufacturing equipment is producing or not’. When standing... [read more]
Machine States
Success Stories | Internet of Things | Output Quantity
For any kind of measurement it’s imperative for manufacturers to know the amount of parts produced by the equipment. Now that the customer knew about the state of the... [read more]
Output Quantity
Success Stories | Internet of Things | Operational Data
Of course automatic reporting of machine-states and part counter values by the manufacturing devices was great progress but the customer now needed to see this data in context... [read more]
Operational Data
Success Stories | Internet of Things | Quality Data
To be able to create reports about the produced quality additional data from the shop floor was needed. Although it would have been perfect to get this data directly from the... [read more]
Quality Data
Success Stories | Internet of Things | Scheduling
To perform any target to actual comparison and output Key-Performance-Indicators (KPI) such as Overall Equipment Effectivity (OEE) it was necessary to integrate scheduling data... [read more]
Scheduling
Success Stories | Internet of Things | Dashboards Overview
The customer's solution Oracle’s Manufacturing Operations Center (MOC) uses the concept of providing web- and role-based dashboards for different employees to gain the... [read more]
Dashboards Overview
Success Stories | Internet of Things | Production Supervisor
This dashboard acts like an electronic whiteboard that automatically fetches data from the customers shop floor devices and provides real-time information about equipment status... [read more]
Production Supervisor
Success Stories | Internet of Things | Overall Equipment Effectiveness OEE
The standard of Oracle’s Manufacturing Operations Center (MOC) ships with a dashboard called ‘Plant Manager’ which includes several reports that output Overall... [read more]
Overall Equipment Effectiveness OEE
Success Stories | Internet of Things | Production Loss Analysis
This dashboard outputs information about production loss distribution (B), effective production capacity (C) and production loss (D) for machines in a department of a plant... [read more]
Production Loss Analysis
Success Stories | Internet of Things | Equipment Downtime Analysis
This dashboard shows downtime reasons machines in one or all departments of a plant within a selected period (A). The pie chart (B) below the selection area outputs the... [read more]
Equipment Downtime Analysis
Success Stories | Internet of Things | Production Slippage Trend
This dashboard, accessible from the equipment downtime analysis report outputs, in addition to total production value (A), production slippage hours (B) and a performance to... [read more]
Production Slippage Trend
Success Stories | Internet of Things | Equipment Idle Time Reasons
By using this dashboard the reasons for idle times of machines within a selected period (A) can be analyzed. Right to the pie chart (B) with percentage distribution of... [read more]
Equipment Idle Time Reasons
Success Stories | Internet of Things | Equipment Efficiency Analysis
For selected equipment in one or all departments of a plant (A) this dashboard outputs an analysis about the efficiency of the manufacturing resources within a period of time. In... [read more]
Equipment Efficiency Analysis
Success Stories | Internet of Things | Equipment Scrap Analysis
This dashboard shows an analysis about bad quality produced by manufacturing equipment in one or all departments of a plant (A) within a selected period. Right to a pie chart (B)... [read more]
Equipment Scrap Analysis
Success Stories | Internet of Things | Batch Performance
This dashboard provides analytics tools for work orders executed within a selected period in all or single plants and product categories (A). The graph (B) on the left side below... [read more]
Batch Performance
Success Stories | Internet of Things | Production Performance
This dashboard enables comparison of scheduled with actual equipment usage. Output can be limited to one or all departments in a plant within a selected period (A). The... [read more]
Production Performance
Modified: 2015-11-22