Case StudiesDatabase ManagementMiningProcess Analysis

Production Data Management System for Diatomaceous Earth Processing

By June 16, 2017 August 8th, 2019 No Comments

Project Drive

A leading diatomaceous earth processing facility was storing its production data in Excel spreadsheets.

The long-term effects of this method lead to large amounts of spreadsheets on their servers, and made it difficult to access necessary information efficiently.

The best remedy for this problem was to move to a web-based solution. This approach provided a centralized database to store the data and an interface for authorized users to enter, edit, and view the data.


Our staff worked with a large diatomaceous earth processing facility to implement a web-based system to store and analyze its production data.

We used the client’s existing paper and Excel-based tools to develop a database schema for the data.

With the database in place, we developed the web-based front end to enter new data and access existing records. In addition to data entry forms, the interface included automated reporting functionality, allowing users to select a date-range and/or specific process areas to view production data.

The system generates nightly reports and sends them to key personnel automatically.

In addition to tabular views of the data, the system includes charts and tables to track downtime and product loss reasons for a range of dates, as well as process OEE.

The system also includes the ability to automatically gather and store data from the process historian.


  • Centralized database of production data
  • Advanced analysis tools for production losses, downtime, and OEE data
  • Automated reports sent out to key personnel on a regular basis
  • Reduced overhead costs
  • Increased data utilization
  • Increased productivity

Project Details

Lovelock, NV
Web-based tools, Technology Migration


  • FactoryTalk Historian
  • SQL Server
  • jQuery
  • Javascript


  • Centralize production data
  • Decrease data management overhead
  • Optimize business processes
  • Understand existing processes
  • Develop web-based system
  • Implement system and train personnel on its operation
  • Increase value of business data by integrating it with process data