Submitted by: Submitted by addiazam
Views: 198
Words: 1670
Pages: 7
Category: Business and Industry
Date Submitted: 03/03/2013 03:22 AM
Design of the Ethernet based Process Data Extraction Algorithm and Storage
Technique for Industrial HMI Systems
Muhammad Adnan Azam
Khurram Khan
Engineer - Water Technologies
Siemens Ltd.
Khobar, Saudi Arabia
muhammad.azam@siemens.com
Engineering Manager – Cross Industries Projects
Siemens Pakistan Engineering Co. Ltd.
Karachi, Pakistan
khurram.khan@siemens.com
Abstract— Due to control and monitoring of large number of
process signals in a 365/24/7 process plant, any HMI (Human
Machine Interface) application has its limitation for persistent
long-term storage of the process data and effective analysis.
The data in Siemens HMI application WinCC (Windows
Control Centre) and many other applications is in compressed
and encrypted form and cannot be accessed using standard
SQL Queries. In this paper, high-performance data extraction
algorithm of encrypted process data and its subsequent storage
technique over the network in real time from redundant HMI
(WinCC Servers) is proposed. The results of better response
rates and minimum resource utilization are achieved for the
proposed algorithm and storage technique in comparison to
the existing softwares available for this purpose. The system
developed on the proposed algorithm and storage technique is
deployed and in operation at various Cement Plants and Water
Pumping Stations for more than two years.
Keywords — Ethernet; WinCC; SQL;Algorithm
I.
INTRODUCTION
Importance of process data cannot be nullified in any
plant operation. This data is always required by the
management in earliest possible time with minimum
resource utilization. Siemens WinCC (Windows Control
Centre) uses SQL SERVER for storage of its runtime data.
This process run-time data is in encrypted form and is not
accessible through SQL. For the cyclic retrieval of this data,
queries with the following syntax are suggested in this paper:
“TAG:R,[Process_Tag_Id], ‘Start_Time’ , ‘End_ Time’”
For the...