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