Subscribe and listen to AW’s podcast!
Subscribe and listen to the Automation World Gets Your Questions Answered podcast!
Listen Here

Historians Make a Comeback

There was a time when people thought data historians would go by the wayside, asserts Jack Wilkins, global product manager within the Proficy System Group of automation vendor GE Fanuc Intelligent Platforms (, Charlottesville, Va. “But because of their ability to retain high-fidelity data in a very compressed format, we’re seeing a resurgence in historian use. We’re [also] seeing historians being a repository and providing real-time data manipulation.”

Better cost effectiveness of historians also drives more use of them now, states Elliot Middleton, industrial intelligence product manager for software vendor Wonderware (, Lake Forest, Calif. “They are used in smaller as well as much larger applications, because the cost of instrumentation is going down and the requirements of instrumentation are going up.” He mentions historians embedded in distributed-control or other types of systems as a use he is seeing now.

Historians were developed to perform operational trending, Middleton says. On the plant floor, data may come from programmable logic controllers or supervisory-control-and-data-acquisition (SCADA) systems. “Then those data were used locally by SCADA to make deterministic decisions, or sent to higher-level system for analytics,” Wilkins adds.

What kinds of data do historians manage? “You name it,” Wilkins replies. “Lots of different data types. That is generally true for all historian manufacturers.”

Traditionally, those data are deposited into historians through the pull model. “The historian has to know where to get data. Then it then extracts and historizes (chronicles) it,” Middleton explains. But through the newer push model, there is time integration between SCADA systems and the historian, he states. “The primary system knows the historian needs the data, configures that historian and then pushes the data into it.” Wilkins notes that transfer time from data collectors, such as data-acquisition devices, can be milliseconds.

Data retrieval may depend on the end-user preference or the technology’s vendor. For example, while he says that multiple data-retrieval technologies may be used, Wilkins believes that Microsoft Corp.’s Excel is popular. “We find that manufacturing engineers have comfort with that.” He notes, though, that he sees more migration to Excel Services, which are a part of Microsoft Office SharePoint technology and, “actually, more to Web-based analyses.”

But Wonderware “significantly leverages” the Microsoft structured-query-language (SQL) server, which is a relational database management system, Middleton explains. “We expose our data as if it’s in an SQL database—but the data are stored in proprietary files, as most vendors do—for performance and scalability.”

However, there’s a “lot of overhead in storing data in an SQL server,” Middleton remarks. That’s where filtering and compression of data find use. Filtering removes random noise, not the original signal; compression simply removes space. That compression functionality of data historians is important, Wilkins stresses, because higher consumption of repository space “will ultimately lead to performance issues.” For most historians, he believes that the compression ratio “would be 100-to-1 or better. But that depends on historian configuration.”

Visualize data

One functionality historians may leverage is graphical visualization of data, something Wilkins says historians may provide as a basic administrative tool. “But for more in-depth analyses, users may have to use vendor-specific portals or Microsoft Excel.” Middleton, who believes it’s important to balance responsiveness with fidelity, adds that “what may be important is being able to overlay time periods.”

And yet another functionality that will ensure historians won’t go by the wayside? What Wilkins calls a next-level capability, consisting of mathematical operations that manipulate data and convert them into actionable information. Adding that “there is no singular use for historians,” he stresses that whatever their use, the key is “to deliver high-fidelity, easily accessible data at high rates of speed.” 

C. Kenna Amos,, is an Automation World Contributing Editor.
Discover New Content
Access Automation World's free educational content library!
Unlock Learning Here
Discover New Content
What It Takes To Protect Against Cyber-Attacks
Learn what dozens of end-users and system integrators have to say about how best to protect your operations against cyber-attacks.
Download Now
What It Takes To Protect Against Cyber-Attacks