Historians vs. relational databases

An important factor when considering implementation of historian software is recognition of differences between plant-floor data and the business environment. Many companies want to approach a manufacturing data archive in the same way they approach an enterprise archive—with a traditional relational database.

04/01/2005


An important factor when considering implementation of historian software is recognition of differences between plant-floor data and the business environment. Many companies want to approach a manufacturing data archive in the same way they approach an enterprise archive—with a traditional relational database. However, a relational database is rarely the best approach for the manufacturing floor for many reasons.

First, manufacturing operates in real time, requiring very fast data collection for optimal analyses. A plant-wide historian provides 10-20 times faster read/write performance over a relational database and 1-millisecond resolution for true real-time data. Additionally, the plant-wide historian is optimized for 'time series' data, while a relational database is built to manage relationships. For example, relational databases are great at answering a question such as: What customer ordered the largest shipment? A plant-wide historian, on the other hand, excels at answering questions such as: What was today's hourly unit production standard deviation?

With powerful compression algorithms, a plant-wide historian can store years of data easily and securely online, which aids performance and reduces maintenance for lower costs.

As with any major software project, the costs and time to implement a manufacturing data archive can make achievable results and ROI appear to be far in the future. This is absolutely the case with a relational database architecture and the many custom interfaces required for implementation with real-time systems. Relational databases also require companies to manually create and manage custom tables, which can be time intensive.

However, using standard interfaces for a plant-wide historian can decrease implementation time by approximately 50%, reducing overall costs. There is also no management or creation of data 'schemas,' triggers, stored procedures, or views. With this ease of use, you can install and configure a system in hours without specialized services, such as custom coding or scripting for the installation.

Long-term maintenance is also greatly simplified. With a plant-wide historian, no on-line maintenance is required. With a relational database, however, maintenance can be a full-time job, as companies must manage archives and disk space due to poor compression (see graphic). Additionally, tag imports and maintenance must be performed during scheduled downtime, as there is no on-line maintenance.

System Integration, Software
Assuming 500 floating point values/second, a plant-wide historian uses much less disk space and provides faster read/write capabilities. Disk space must be more closely managed with a relational database due to poor compression—even with proprietary, pre-compressed data workarounds. Source: Control Engineering with data from GE Fanuc Automation.

A plant-wide data historian enables companies to collect and analyze tremendous volumes of information generated in plants for improved performance, integrating plant floor and business systems, and reducing the cost of meeting industry regulations. Data collection and analysis can help increase product quality and consistency, for example, by comparing past production runs, analyzing data prior to a downtime event, and plotting ideal production runs against in-process runs. Aggregated data also allows report preparation and information sharing using standard Web-browser tools.

Lastly, the plant-wide historian also serves as the vital link between plant operations and the business, providing business systems with actual data they need to gain a clear, accurate picture of current production status or historical trends. This detailed information can yield numerous benefits, including ability to let customers securely access order status information.


Author Information
Kevin Bernier is director of plant intelligence products, GE Fanuc Automation;




The Engineers' Choice Awards highlight some of the best new control, instrumentation and automation products as chosen by Control Engineering subscribers. Vote now (if qualified)!
The System Integrator Giants program lists the top 100 system integrators among companies listed in CFE Media's Global System Integrator Database.
Each year, a panel of Control Engineering and Plant Engineering editors and industry expert judges select the System Integrator of the Year Award winners in three categories.
This eGuide illustrates solutions, applications and benefits of machine vision systems.
Learn how to increase device reliability in harsh environments and decrease unplanned system downtime.
This eGuide contains a series of articles and videos that considers theoretical and practical; immediate needs and a look into the future.
Maximize ROI with integrated control system approach; Microcontrollers vs. PLCs; Power quality; Accelerate and rewire IIoT; Traits for excellent engineers
HMI effectiveness; Distributed I/O; Engineers' Choice Award finalists; System Integrator advice; Inside Machines
Women in engineering; Engineering Leaders Under 40; PID benefits and drawbacks; Ladder logic; Cloud computing
Programmable logic controllers (PLCs) represent the logic (decision) part of the control loop of sense, decide, and actuate. As we know, PLCs aren’t the only option for making decisions in a control loop, but they are likely why you’re here.
This digital report explains how plant engineers and subject matter experts (SME) need support for time series data and its many challenges.
This article collection contains several articles on how advancements in vision system designs, computing power, algorithms, optics, and communications are making machine vision more cost effective than ever before.

Find and connect with the most suitable service provider for your unique application. Start searching the Global System Integrator Database Now!

Control room technology innovation; Practical approaches to corrosion protection; Pipeline regulator revises quality programs
Cloud, mobility, and remote operations; SCADA and contextual mobility; Custom UPS empowering a secure pipeline
Infrastructure for natural gas expansion; Artificial lift methods; Disruptive technology and fugitive gas emissions
Automation Engineer; Wood Group
System Integrator; Cross Integrated Systems Group
Jose S. Vasquez, Jr.
Fire & Life Safety Engineer; Technip USA Inc.
This course focuses on climate analysis, appropriateness of cooling system selection, and combining cooling systems.
This course will help identify and reveal electrical hazards and identify the solutions to implementing and maintaining a safe work environment.
This course explains how maintaining power and communication systems through emergency power-generation systems is critical.
The Engineers' Choice Awards highlight some of the best new control, instrumentation and automation products as chosen by Control Engineering subscribers. Vote now (if qualified)!
The System Integrator Giants program lists the top 100 system integrators among companies listed in CFE Media's Global System Integrator Database.
Each year, a panel of Control Engineering and Plant Engineering editors and industry expert judges select the System Integrator of the Year Award winners in three categories.
This eGuide illustrates solutions, applications and benefits of machine vision systems.
Learn how to increase device reliability in harsh environments and decrease unplanned system downtime.
This eGuide contains a series of articles and videos that considers theoretical and practical; immediate needs and a look into the future.
Maximize ROI with integrated control system approach; Microcontrollers vs. PLCs; Power quality; Accelerate and rewire IIoT; Traits for excellent engineers
HMI effectiveness; Distributed I/O; Engineers' Choice Award finalists; System Integrator advice; Inside Machines
Women in engineering; Engineering Leaders Under 40; PID benefits and drawbacks; Ladder logic; Cloud computing
Programmable logic controllers (PLCs) represent the logic (decision) part of the control loop of sense, decide, and actuate. As we know, PLCs aren’t the only option for making decisions in a control loop, but they are likely why you’re here.
This digital report explains how plant engineers and subject matter experts (SME) need support for time series data and its many challenges.
This article collection contains several articles on how advancements in vision system designs, computing power, algorithms, optics, and communications are making machine vision more cost effective than ever before.

Find and connect with the most suitable service provider for your unique application. Start searching the Global System Integrator Database Now!

Control room technology innovation; Practical approaches to corrosion protection; Pipeline regulator revises quality programs
Cloud, mobility, and remote operations; SCADA and contextual mobility; Custom UPS empowering a secure pipeline
Infrastructure for natural gas expansion; Artificial lift methods; Disruptive technology and fugitive gas emissions
Automation Engineer; Wood Group
System Integrator; Cross Integrated Systems Group
Jose S. Vasquez, Jr.
Fire & Life Safety Engineer; Technip USA Inc.
This course focuses on climate analysis, appropriateness of cooling system selection, and combining cooling systems.
This course will help identify and reveal electrical hazards and identify the solutions to implementing and maintaining a safe work environment.
This course explains how maintaining power and communication systems through emergency power-generation systems is critical.
The Engineers' Choice Awards highlight some of the best new control, instrumentation and automation products as chosen by Control Engineering subscribers. Vote now (if qualified)!
The System Integrator Giants program lists the top 100 system integrators among companies listed in CFE Media's Global System Integrator Database.
Each year, a panel of Control Engineering and Plant Engineering editors and industry expert judges select the System Integrator of the Year Award winners in three categories.
This eGuide illustrates solutions, applications and benefits of machine vision systems.
Learn how to increase device reliability in harsh environments and decrease unplanned system downtime.
This eGuide contains a series of articles and videos that considers theoretical and practical; immediate needs and a look into the future.
Maximize ROI with integrated control system approach; Microcontrollers vs. PLCs; Power quality; Accelerate and rewire IIoT; Traits for excellent engineers
HMI effectiveness; Distributed I/O; Engineers' Choice Award finalists; System Integrator advice; Inside Machines
Women in engineering; Engineering Leaders Under 40; PID benefits and drawbacks; Ladder logic; Cloud computing
Programmable logic controllers (PLCs) represent the logic (decision) part of the control loop of sense, decide, and actuate. As we know, PLCs aren’t the only option for making decisions in a control loop, but they are likely why you’re here.
This digital report explains how plant engineers and subject matter experts (SME) need support for time series data and its many challenges.
This article collection contains several articles on how advancements in vision system designs, computing power, algorithms, optics, and communications are making machine vision more cost effective than ever before.

Find and connect with the most suitable service provider for your unique application. Start searching the Global System Integrator Database Now!

Control room technology innovation; Practical approaches to corrosion protection; Pipeline regulator revises quality programs
Cloud, mobility, and remote operations; SCADA and contextual mobility; Custom UPS empowering a secure pipeline
Infrastructure for natural gas expansion; Artificial lift methods; Disruptive technology and fugitive gas emissions
Automation Engineer; Wood Group
System Integrator; Cross Integrated Systems Group
Jose S. Vasquez, Jr.
Fire & Life Safety Engineer; Technip USA Inc.
This course focuses on climate analysis, appropriateness of cooling system selection, and combining cooling systems.
This course will help identify and reveal electrical hazards and identify the solutions to implementing and maintaining a safe work environment.
This course explains how maintaining power and communication systems through emergency power-generation systems is critical.
click me