SCADA Articles on SCADA World

SQLTags Historian Makes Storing and Charting Historical Data Fast, Efficient, and Easy

2010-03-19 14:17:35views: 846Inductive Automation

SQLTags Historian Makes Storing and Charting Historical Data Fast, Efficient, and Easy

Logging process data for the purposes of charting and reporting has long been, and continues to be, one of the most popular uses of Inductive Automation's software. For our new release, Ignition by Inductive Automation, we've introduced a feature called SQLTags Historian that makes storing and charting history faster, more efficient, and easier than ever before.

SQLTags Historian builds on the success of our SQLTags realtime tag database system. There are only two steps to using the SQLTags Historian. First, you must configure a connection to a supported database, such as MySQL, SQL Server, or Oracle. Second, you simply select the "Store History for this Tag" option on any of your tags. That's it—SQLTags Historian creates and manages the tables needed to efficiently store history automatically. You're now storing tag history to your database.

Not only is SQLTags Historian easy to set up, but it is very efficient as well. It only stores tag values when they change outside of a deadband. Tags that aren't changing don't take up any storage space in the database. You also can control how frequently a tag is sampled when it is changing through the use of a historical scan class. Scan classes let you choose different logging intervals for sets of tags, or even alter the logging rate dynamically, storing high resolution history only when it is needed. The historian system will also automatically partition your data into multiple tables in the database. This partitioning feature accomplishes two important functions: ensuring consistently high-performance over the long term, and providing an extremely convenient mechanism for data archival and pruning.

One of the best parts about data stored using the SQLTags Historian is that using the data requires no knowledge of the SQL language. Querying history is a matter of specifying a list of tags, a range of time, and a resolution. Even easier, just drag and drop a historian-enabled tag onto an Easy Chart, and the chart will be configured with a SQLTags Historian pen for that tag. Using this drag-and-drop configuration is a great way to rapidly create an advanced, web-launched SCADA system with minimal effort. If you haven't already, download Ignition today and give it a try; you'll be glad you did.


SCADA Articles

Using Free Tools To Detect Attacks On SCADA Networks
2015-05-09 14:28:25views: 1864

ICS/SCADA experts say open-source network security monitoring software is a simple and cheap way to catch hackers targeting plant operations. Operators at Natanz nuclear facility in Iran might well have caught Stuxnet before it spread and sabotaged operations at the plant if they had been watching the wires for anomalous network traffic, a pair of ICS/SCADA experts say.

Hackers gain full control of critical SCADA systems
2015-05-09 14:04:07views: 1964

Russian researchers have found vulnerabilities in industrial control systems that they say grant full control of systems running energy, chemical and transportation systems. The vulnerabilities were discovered by researchers who over the last year probed popular and high-end ICS and SCADA systems used to control everything from home solar panel installations to critical national infrastructure.

SCADA Attacks Double in 2014
2015-05-06 07:17:15views: 1731

Annual threat report from Dell Security shows not only a significant surge in the number of attacks on retail credit card systems, but industrial SCADA systems as well, which are much more likely to go unreported.
For Dell to report an annual surge in point-of-sale (POS) attacks aimed at payment card infrastructures might not be such a surprise to people who pay any attention to the news.

The Industrial Software Revolution Begins Now
2013-10-16 11:33:59views: 2311

Invensys is kicking off the conference “The Industrial Software Revolution Begins Now” and underscoring the ‘revolution’ concept with the release of its Wonderware InTouch 2014 and Wonderware System Platform 2014 software.

Integrating Video into HMI/SCADA
2012-06-29 10:19:55views: 2594

The useful integration of video with industrial control systems has been a reality for a few years, but a burst of applications and installations is on the horizon. Cheaper bandwidth, wide availability of Internet protocol (IP) cameras, and greater familiarity with industrial Ethernet networks seem to be driving user interest.

AdvancedHMI - a different approach to HMI development
2012-06-14 10:46:48views: 1856

AdvancedHMI base package is a free software used to build HMIs that display information residing in a PLC. You will find it to be one of the fastest platforms to build an HMI with. The software takes advantage of the Visual Basic .NET development environment so effort is focused on the core software and not reinventing a development environment.

Web Services and SCADA
2012-06-12 23:06:33views: 1413

Web services can be another method for connectivity to SCADA and MES systems. They can retrieve tomorrow's weather, the price of stocks or commodities, the time of sunrise and sunset, and a slew of other publicly-available resources.

SCADA virtualisation with WinCC Version 7
2011-12-21 12:01:11views: 1353

As automation solutions become increasingly complex, it follows that the effort required to maintain both hardware and software will also increase. PCs must be provided with suitable specification and operating systems to support the applications.

Cloud-Based SCADA Systems: The Benefits and Risks
2011-12-20 22:57:31views: 969

Cloud computing is a hot topic. As people become increasingly reliant on accessing important information through the Internet, the idea of storing or displaying vital real-time data in the cloud has become more commonplace. With tech giants like Apple, Microsoft, and Google pushing forward the cloud computing concept, it seems to be more than just a passing trend.

An alternative to DCS or PLC/SCADA
2011-10-04 13:46:22views: 922

Traditionally, users have had a choice between a DCS or a PLC/SCADA approach when selecting a control system for use in process control applications. A key benefit of traditional DCSs was that the suppliers took a ‘systems approach’ and it was designed for large scale applications.