Design of Ethernet Based Process Data Extraction Algo

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...