Regulatory Compliance Leads to Process Improvements (sidebar)

Aug. 1, 2005
Historians vs Databases

Plant historians and relational databases are similar because they both collect and store data. But they were created for completely different purposes, and they behave differently.

The historian captures and stores data about the plant operations for the purpose of measuring plant activity. Those measurements are then used to improve plant operations or report data to regulatory bodies. The relational database collects business data for use in running the company, not just the plant. The relational database is great at answering the question: What customer ordered the largest shipment? The historian, on the other hand, is better at answering the question: What was today’s hourly unit production standard deviation? Ultimately, to make the best use of plant data, companies are finding that it helps to use both the historian and a relational database.

In manufacturing, the historian is a well-accepted tool and typically is preferred over the relational database by plant operators. “One of the reasons we chose to use the historian to track plant operations is because the database can’t keep up with the plant processes,” says Jack Wilkins, senior manager for Proficy Software at GE Fanuc Automation, in Charlottesville, Va. “Plus, the historian has a long history on the manufacturing side. It’s accepted. It’s a known quantity, like the black box flight recorder on an airliner.”

Wilkins notes, however, that the historian has limitations in its ability to analyze data effectively. “We’re beginning to see a greater need to put data in context, and the historian has little ability for context.” GE Fanuc solves this limitation in the historian by bringing in a Microsoft SQL database component.

Over at Lighthammer Software Development Corp., in Exton, Pa., Chief Technology Officer and co-founder Rick Bullotta also sees the need to work with both the historian and a relational database. “Historians do a crummy job with transaction material or genealogy, but they’re great for streaming data.” He notes that databases do poorly in the application space.

Like GE Fanuc, Lighthammer took the approach of bringing the two together, says Bullotta. “We link the historian in the plant tracking or maintenance system to a relational database, and those two different systems appear as a unified system.”

See the story that goes with this sidebar: Regulatory Compliance Leads to Process Improvements

Sponsored Recommendations

Why Go Beyond Traditional HMI/SCADA

Traditional HMI/SCADAs are being reinvented with today's growing dependence on mobile technology. Discover how AVEVA is implementing this software into your everyday devices to...

4 Reasons to move to a subscription model for your HMI/SCADA

Software-as-a-service (SaaS) gives you the technical and financial ability to respond to the changing market and provides efficient control across your entire enterprise—not just...

Is your HMI stuck in the stone age?

What happens when you adopt modern HMI solutions? Learn more about the future of operations control with these six modern HMI must-haves to help you turbocharge operator efficiency...

AVEVA™ System Platform: Smarter, Faster Operations for Enhanced Industrial Performance

AVEVA System Platform (formerly Wonderware) delivers a responsive, modern operations visualization framework designed to enhance performance across all devices with context-aware...