# Data Validation and Reconciliation

﻿
Data Validation and Reconciliation

Industrial process data validation and reconciliation or short data validation and reconciliation (DVR) is a technology which is using process information and mathematical methods in order to automatically correct measurements in industrial processes. The use of DVR allows for extracting accurate and reliable information about the state of industry processes from raw measurement data and produces a single consistent set of data representing the most likely process operation.

## Models, data and measurement errors

Industrial processes, for example chemical or thermodynamic processes in chemical plants, refineries, oil or gas production sites, or power plants, are often represented by two fundamental means:

1. Models that express the general structure of the processes,
2. Data that reflects the state of the processes at a given point in time.

Models can have different levels of detail, for example one can incorporate simple mass or compound conservation balances, or more advanced thermodynamic models including energy conservation laws. Mathematically the model can be expressed by a nonlinear system of equations $F(y)=0\,$ in the variables $y=(y_1,\ldots,y_n)$, which incorporates all the above-mentioned system constraints (for example the mass or heat balances around a unit). A variable could be the temperature or the pressure at a certain place in the plant.

### Error types

Data originates typically from measurements taken at different places throughout the industrial site, for example temperature, pressure, volumetric flow rate measurements etc. To understand the basic principles of DVR, it is important to first recognize that plant measurements are never 100% correct, i.e. raw measurement $y\,$ is not a solution of the nonlinear system $F(y)=0\,\!$. When using measurements without correction to generate plant balances, it is common to have incoherencies. Measurement errors can be categorized into two basic types:

1. random errors due to intrinsic sensor accuracy and
2. systematic errors (or gross errors) due to sensor calibration or faulty data transmission.

Random errors means that the measurement $y\,\!$ is a normally distributed random variable with mean $y^*\,\!$, where $y^*\,\!$ is the true value that is typically not known. A systematic error on the other hand is characterized by a measurement $y\,\!$ which is a normally distributed random variable with mean $\bar{y}\,\!$, which is not equal to the true value $y^*\,$.

Other sources of error when calculating plant balances, are small instabilities in plant operations. Not all measurements and samples are taken at the same time, causing discrepancies between measurements. Using time averages for plant data partly reduces this problem but lab analyses cannot be averaged.

### Necessity of removing measurement errors

ISA-95 is the international standard for the integration of enterprise and control systems . It asserts that:

Data reconciliation is a serious issue for enterprise-control integration. The data have to be valid to be useful for the enterprise system. The data must often be determined from physical measurements that have associated error factors. This must usually be converted into exact values for the enterprise system. This conversion may require manual, or intelligent reconciliation of the converted values [...]. Systems must be set up to ensure that accurate data are sent to production and from production. Inadvertent operator or clerical errors may result in too much production, too little production, the wrong production, incorrect inventory, or missing inventory.

## History

DVR has become more and more important due to industrial processes that are becoming more and more complex. DVR started in the early 1960s with applications aiming at closing material balances in production processes where raw measurements were available for all variables . At the same time the problem of gross error identification and elimination has been presented . In the late 1960s and 1970s unmeasured variables were taken into account in the data reconciliation process ,. During the 1980s the area of DVR became more mature by considering general nonlinear equation systems coming from thermodynamic models,. In 1992 Liebman et al. introduced the concept of dynamic DVR.

## Data reconciliation

Data reconciliation is a technique that targets at correcting measurement errors that are due to measurement noise, i.e. random errors. From a statistical point of view the main assumption is that no systematic errors exist in the set of measurements, since they may bias the reconciliation results and reduce the robustness of the reconciliation.

Given n measurements yi, data reconciliation can mathematically be expressed as an optimization problem of the following form: \begin{align} \min_{x,y^*} & \sum_{i=1}^n\left(\frac{y_i^*-y_i}{\sigma_i}\right)^2 \\ \mbox{subject to } & F(x,y^*)=0 \\ & y_{\min}\le y^*\le y_{\max}\\ & x_{\min}\le x\le x_{\max}, \end{align}\,\!

where $y_i^*\,\!$ is the reconciled value of the i-th measurement ( $i=1,\ldots,n\,\!$), $y_i\,\!$ is the measured value of the i-th measurement ( $i=1,\ldots,n\,\!$), $x_j\,\!$ is the j-th unmeasured variable ( $j=1,\ldots,m\,\!$), and $\sigma_i\,\!$ is the standard deviation of the i-th measurement ( $i=1,\ldots,n\,\!$), $F(x,y^*)=0\,\!$ are the $p\,\!$ process equality constraints and $x_{\min}, x_{\max}, y_{\min}, y_{\max}\,\!$ are the bounds on the measured and unmeasured variables.

The term $\left(\frac{y_i^*-y_i}{\sigma_i}\right)^2\,\!$ is called the penalty of measurement i. The objective function is the sum of the penalties, which will be denoted in the following by $f(y^*)=\sum_{i=1}^n\left(\frac{y_i^*-y_i}{\sigma_i}\right)^2$.

In other words, one wants to minimize the overall correction (measured in the least squares term) that is needed in order to satisfy the system constraints. Additionally, each least squares term is weighted by the standard deviation of the corresponding measurement.

### Redundancy

Data reconciliation is strongly relying on the concept of redundancy. Redundancy is a source of information that is used to correct the measurements as little as possible in order to satisfy the process constraints. Redundancy can be due to sensor redundancy, where sensors are duplicated in order to have more than one measurement of the same quantity. Redundancy can also arise from topological redundancy, where a single variable can be estimated in several independent ways, from separate sets of measurements./ Topological redundancy is intimately linked with the degree of freedom ( $dof\,\!$) of a mathematical system , i.e. the minimum number of pieces of information (i.e. measurements) that are required in order to calculate all of the system variables. For instance, in the example above the flow conservation requires that $a=b+c\,$, and it is clear that one needs to know the value of two of the 3 variables in order to calculate the third one. Therefore the degree of freedom in that case is equal to 2.

When speaking about topological redundancy we have to distinguish between measured and unmeasured variables. In the following let us denote by $x\,\!$ the unmeasured variables and $y\,\!$ the measured variables. Then the system of the process constraints becomes $F(x,y)=0\,\!$, which is a nonlinear system in $y\,\!$ and $x\,\!$. If the system $F(x,y)=0\,\!$ is calculable with the $n\,$ measurements given, then the level of topological redundancy is defined as $red= n - dof\,\!$, i.e. the number of additional measurements that are at hand on top of those measurements which are required in order to just calculate the system. Another way of viewing the level of redundancy is to use the definition of $dof\,$, which is the difference between the number of variables (measured and unmeasured) and the number of equations. Then one gets \begin{align} red= n - dof = n-(n+m-p) = p-m, \end{align}

i.e. the redundancy is the difference between the number of equations $p\,$ and the number of unmeasured variables $m\,$. The level of total redundancy is the sum of sensor redundancy and topological redundancy. We speak of positive redundancy if the system is calculable and the total redundancy is positive. One can see that the level of topological redundancy merely depends on the number of equations (the more equations the higher the redundancy) and the number of unmeasured variables (the more unmeasured variables, the lower the redundancy) and not on the number of measured variables. However, it is possible that the system $F(x,y)=0\,\!$ is not calculable, even though $p-m\ge 0\,\!$, as illustrated in the following example.

#### Example of calculable and non-calculable systems

Let us consider a small system with 4 streams and 2 units. We incorporate only flow conservation constraints and obtain $a+b=c\,\!$ and $c=d\,\!$. If we have measurements for $c\,\!$ and $d\,\!$, but not for $a\,\!$ and $b\,\!$, then the system cannot be calculated (knowing $c\,\!$ does not give information about $a\,\!$ and $b\,\!$). On the other hand, if $a\,\!$ and $c\,\!$ are known, but not $b\,\!$ and $d\,\!$, then the system can be calculated.

### Benefits

Redundancy can be used as a source of information to cross-check and correct the measurements $y\,\!$ and increase their accuracy and precision: on the one hand they reconciled Further, the data reconciliation problem presented above also includes unmeasured variables $x\,\!$. Based on information redundancy, estimates for these unmeasured variables can be calculated along with their accuracies. In industrial processes these unmeasured variables that data reconciliation provides are referred to as soft sensors or virtual sensors, where hardware sensors are not installed.

## Data Validation

Data validation denotes all validation and verification actions before and after the reconciliation step.

### Data Filtering

Data filtering denotes the process of treating measured data such that the values become meaningful and lie within the range of expected values. Data filtering is necessary before the reconciliation process in order to increase robustness of the reconciliation step. There are several ways of data filtering, for example taking the average of several measured values over a well-defined time period.

### Result Validation

Result validation is the set of validation or verification actions taken after the reconciliation process and it takes into account measured and unmeasured variables as well as reconciled values. Result validation covers, but is not limited to, penalty analysis for determining the reliability of the reconciliation, or bound checks to ensure that the reconciled values lie in a certain range, e.g. the temperature has to be within some reasonable bounds.

### Gross Error Detection

Result validation may include statistical tests to validate the reliability of the reconciled values, by checking whether gross errors exist in the set of measured values. These tests can be for example

• the chi square test (global test)
• the individual test.

If no gross errors exist in the set of measured values, then each penalty term in the objective function is a random variable that is normally distributed with mean equal to 0 and variance equal to 1. By consequence, the objective function is a random variable which follows a chi-square distribution, since it is the sum of the square of normally distributed random variables. Comparing the value of the objective function $f(y^*)\,\!$ with a given percentile $P_{\alpha}\,$ of the probability density function of a chi-square distribution (e.g. the 95th percentile for a 95% confidence) gives an indication of whether a gross error exists: If $f(y^*)\le P_{95}$, then no gross errors exist with 95% probability. The chi square test gives only a rough indication about the existence of gross errors, and it is easy to conduct: one only has to compare the value of the objective function with the critical value of the chi square distribution.

The individual test compares each penalty term in the objective function with the critical values of the normal distribution. If the i-th penalty term is outside the 95% confidence interval of the normal distribution, then there is reason to believe that this measurement has a gross error.

## Advanced Data Validation and Reconciliation

Advanced data validation and reconciliation (DVR) is an integrated approach of combining data reconciliation and data validation techniques, which is characterized by

• complex models incorporating besides mass balances also thermodynamics, momentum balances, equilibria constraints, hydrodynamics etc.
• gross error remediation techniques to ensure meaningfulness of the reconciled values,
• robust algorithms for solving the reconciliation problem.

### Thermodynamic models

Simple models include mass balances only. When adding thermodynamic constraints such as heat balances to the model, its scope and the level of redundancy increases. Indeed, as we have seen above, the level of redundancy is defined as pm, where p is the number of equations. Including energy balances means adding equations to the system, which results in a higher level of redundancy (provided that enough measurements are available, or equivalently, not too many variables are unmeasured).

### Gross Error Remediation  The workflow of an advanced data validation and reconciliation process.

Gross errors are measurement systematic errors that may bias the reconciliation results. Therefore it is important to identify and eliminate these gross errors from the reconciliation process. After the reconciliation statistical tests can be applied that indicate whether or not a gross error does exist somewhere in the set of measurements. These techniques of gross error remediation are based on two concepts:

• gross error elimination
• gross error relaxation.

Gross error elimination determines one measurement that is biased by a systematic error and discards this measurement from the data set. The determination of the measurement to be discarded is based on different kinds of penalty terms that express how much the measured values deviate from the reconciled values. Once the gross errors are detected they are discarded from the measurements and the reconciliation can be done without these faulty measurements that spoil the reconciliation process. If needed, the elimination is repeated until no gross error exists in the set of measurements.

Gross error relaxation targets at relaxing the estimate for the uncertainty of suspicious measurements so that the reconciled value is in the 95% confidence interval. Relaxation typically finds application when it is not possible to determine which measurement around one unit is responsible for the gross error (equivalence of gross errors). Then measurement uncertainties of the measurements involved are increased.

It is important to note that the remediation of gross errors reduces the quality of the reconciliation, either the redundancy decreases (elimination) or the uncertainty of the measured. Therefore it can only be applied when the initial level of redundancy is high enough to ensure that the data reconciliation can still be done (see Section 2,).

### Workflow

Advanced DVR solutions offer an integration of the techniques mentioned above:

1. data acquisition from data historian, data base or manual inputs
2. data validation and filtering of raw measurements
3. data reconciliation of filtered measurements
4. result verification
• range check
• gross error remediation (and go back to step 3)
5. result storage (raw measurements together with reconciled values)

The result of an advanced DVR procedure is a coherent set of validated and reconciled process data.

## Applications

DVR finds application mainly in industry sectors where either measurements are not accurate or even non-existing, like for example in the upstream sector where flow meters are difficult or expensive to position (see ); or where accurate data is of high importance, for example for security reasons in nuclear power plants (see ). Another field of application is performance and process monitoring (see ) in oil refining or in the chemical industry.

As DVR enables to calculate estimates even for unmeasured variables in a reliable way, the German Engineering Society (VDI Gesellschaft Energie und Umwelt) has accepted the technology of DVR as a means to replace expensive sensors in the nuclear power industry (see VDI norm 2048,).

## DVR Software

Wikimedia Foundation. 2010.

### Look at other dictionaries:

• Clinical data management — encompasses the entry, verification, validation and quality control of data gathered during the conduct of a clinical trial. Contents 1 Role of the Clinical Data Manager in a Clinical Trial 2 Standard Operating Procedures 3 The Data Management… …   Wikipedia

• Law, Crime, and Law Enforcement — ▪ 2006 Introduction Trials of former heads of state, U.S. Supreme Court rulings on eminent domain and the death penalty, and high profile cases against former executives of large corporations were leading legal and criminal issues in 2005.… …   Universalium

• Electronic data processing — Bold textElectronic data processing (EDP) can refer to the use of automated methods to process commercial data. Typically, this uses relatively simple, repetitive activities to process large volumes of similar information. For example: stock… …   Wikipedia

• Mass balance — A mass balance (also called a material balance) is an application of conservation of mass to the analysis of physical systems. By accounting for material entering and leaving a system, mass flows can be identified which might have been unknown,… …   Wikipedia

• Extract, transform, load — Extract, transform and load (ETL) is a process in database usage and especially in data warehousing that involves: Extracting data from outside sources Transforming it to fit operational needs (which can include quality levels) Loading it into… …   Wikipedia

• Billing Mediation Platform — A billing mediation platform is a system used to convert datatypes of a certain type to other datatypes, usually for billing purposes. They are used mostly by telephone companies, who typically need to process UDRs (Usage Detail Records). In call …   Wikipedia

• Systems Applications Products audit — is when a computer system from SAP undegoes an audit to check its security and data integrity. SAP is the acronym for Systems, Applications, Products. It is a system that provides users with a soft real time business application. It contains a… …   Wikipedia

• Iran — /i ran , i rahn , uy ran /, n. a republic in SW Asia. 67,540,002; ab. 635,000 sq. mi. (1,644,650 sq. km). Cap.: Teheran. Formerly (until 1935), Persia. * * * Iran Introduction Iran Background: Known as Persia until 1935, Iran became an Islamic… …   Universalium

• Financial tester — The financial testers are the software testers who concern themselves with the way data flows through a transactional system, this data should have a start point and have a method by which to track the data through its different states (offers,… …   Wikipedia

• Biological warfare — For the use of biological agents by terrorists, see bioterrorism. Weapons of mass destruction …   Wikipedia