COVID-19 Update — We are available to assist you during these trying times. Please contact us for assistance.

Offload Querying/Reporting from the Host to Commodity Systems

Old architecture

Figure 1 — Old Adapter Architecture: Reporting Application with Remote Enscribe Database Access

Situation

A large European steel tubing manufacturer runs its shop floor control applications on an HPE NonStop system. The manufacturer periodically generated reports on Linux systems using a connectivity tool that remotely accessed the NonStop Enscribe database.

Problems

  1. The architecture was susceptible to network failures, timeouts, and/or slowdowns when operating at full capacity.
  2. The manufacturer needed access to its Enscribe data using standard ODBC connectivity for querying, reporting, and OLAP to leverage new analytical tools.
  3. The manufacturer needed to share the OLAP results back with the NonStop applications to optimize shop floor control.

Solution

New architecture

Figure 2 — New Architecture: Replicated and Transformed Oracle Database for Reporting and Analytics

Shop Floor Control Reports and Analysis

In Figure 2, a shop floor application is making changes to an HPE NonStop Enscribe database. HPE Shadowbase picks up these changes from the TMF Audit Trail, replicating and transforming them to the Linux system, and applying them into a replicated Oracle database. This architecture enables local data access for new Linux query and report applications to run query, analysis, OLAP (online analytical processing), and decision support systems.

Shop Floor Control Alerts and Management

Additionally, when a Linux query and report application reads shop metrics that are out-of-band, outside of acceptable or safe parameters, or that need to be optimized, it can update its local database with that information.  HPE Shadowbase will then pick up these changes, transforming the information in-flight into a readable format for the HPE NonStop shop floor application, and deliver that information either directly to the HPE NonStop shop floor application or deliver the changes into a NonStop-based file or table that the application can access. This creates a real-time alerting system for shop floor management and employees to quickly react and fix any potential problems before they become emergencies that would cause greater damage and disruption to manufacturing operations.

Outcomes

HPE Shadowbase Products of Interest


Contact us or your HPE Shadowbase representative, and learn how Shadowbase software will benefit you.

Further Reading

Case Study: Large Manufacturer Uses Data Replication to Offload Online Host Processing and Enable New Business Applications

Related “Asymmetric Capacity Expansion” Case Studies:

  • Print
  • Email link
  • Copy link to clipboard