US007249356B1
(12) United States Patent
(10) Patent N0.: (45) Date of Patent:
Wilson et al.
(54)
METHODS AND STRUCTURE FOR BATCH PROCESSING EVENT HISTORY PROCESSING AND VIEWING
(56)
U. S. PATENT DOCUMENTS 5,014,208 A *
Wolfson .................... .. 700/99
FOREIGN PATENT DOCUMENTS DE
0434050 A2 *
(US); John Yiu-Chung Wong, Anaheim, CA (US); Jake Phong Doan,
6/1991
(Continued)
Laguna Hills, CA (US); Robert B.
OTHER PUBLICATIONS Simensen et al., “A Frame Work For Batch Plant Information
(73) Assignee: Fisher-Rosemount Systems, Inc.,
Models”, Petri Nets Newsletter, 1996, pp. 1-21.*
Austin, TX (US) Notice:
5/1991
(Continued)
L. Dietz, Austin, TX (US); Marc Webb, Round Rock, TX (US); Roy Faltesek, Round Rock, TX (US);
Havekost, Austin, TX (US)
Jul. 24, 2007
References Cited
(75) Inventors: Grant Wilson, Austin, TX (US); David
MuWa?a Lahham, San Francisco, CA
US 7,249,356 B1
(Continued)
Subject to any disclaimer, the term of this patent is extended or adjusted under 35
Primary ExamineriMeng-Al T. An Assistant Examinerilennifer N. To
(74) Attorney, Agent, or FirmiMarshall, Gerstein & Borun
U.S.C. 154(b) by 0 days.
LLP
(21) Appl. N0.: 09/302,687 (22) Filed: (51)
(2006.01) (2006.01) (2006.01) (2006.01) (2006.01) (2006.01)
US. Cl. ...................... ..
corresponding to the relationships de?ned among procedural elements and equipment in accordance With batch process
ing industry $88.01 standards. The executive program gath ers event information generated by the batch process and derives the relationships among the events in accordance With these industry standard models. Storage and corre
718/101; 718/100; 700/17;
700/87; 700/239; 700/240; 715/500; 715/700; 715/704
(58)
ABSTRACT
A batch event historian gathers, stores and presents data regarding a batch process Where relationships among the various elements of data are automatically derived by an executive program. A persistent store includes structure
Int. Cl.
G06F 9/46 G06F 17/00 G06F 15/00 G06F 3/00 GOSB 11/01 GOSB 19/42
(52)
(57)
Apr. 29, 1999
Field of Classi?cation Search ............ ..
700/7i99,
700/100, 1084118, 121, 2394240; 702/l82il87; 709/100*104; 718/10(L104; 715/700, 500,
sponding retrieval and presentation of such historical data is thereby simpli?ed for a user because the user need not
manually con?gure the historian programs to derive the relationships. Association of any continuous data log With event information is automated thereby obviating the need for manual con?guration by a user to establish such asso
ciations.
715/704
See application ?le for complete search history.
31 Claims, 21 Drawing Sheets
onsc DRNER "‘ 22°
OBJECT AFI
I CDNYINUOUS MA
222
US 7,249,356 B1 Page 2 U.S. PATENT DOCUMENTS 5,157,595 A *
OTHER PUBLICATIONS
10/ 1992 Lovrenich .................... .. 700/7
9/1995 Krummen et al.
5,673,194 A * 5,745,364 A *
9/1997 Cipelletti et al. . 700/115 4/ 1998 Togashi .................... .. 700/121
146-147. Author Unknown; “spgg Reduces Batch Variation”; Online Post
5,774,875 A
6/1998 MedeirOS et a1.
ing; .
5,870,696 5,889,674 5,896,292 5,896,294 5,926,186 5,930,137
A A A A A A
* * * * * *
2/1999 3/1999 4/1999 4/1999 7/1999 7/1999
. 364/468
Author Unknown; “NT-Based Recipe Provides Graphical Editor
5,450,346 A
R?llCiOlph ................. .. Burdlck et a1~ Hosaka et a1~ Chow et a1~ ~~ Itoh et a1~ Togashi
and Simpli?ed Integration”; CONTROL Magazine; Sep. 1997; pp.
702/176 700/121 700/108 700/121 345/619 700/100
Piper, Peggy; “Distributed Control Systems Spread Out”; Online Posting; . Johnson, Dick; “Distributed Control: A View of What’s New”; Online Posting; Control Engineering Online; Sep. 1996;
717/109
Nomikos et al., “Multi-Way Partial Least Squares in Monitoring
707/101 709/101
Batch Processes”, 1995, Chemometrics and Intelligent Laboratory Systems, Vol‘ 30, N0‘ 1, pp‘ 97408
6,041,178 A :
3/2000 Rybarczyk et 3
6,078,924 A 6,289,368 B1*
6/2000 Alnsbury et al' 9/2001 Dentler et al.
6,363,294 Bl :
3/2002 coronfel et a1‘
700/121
Nomikos, “Detection and Diagnosis of Abnormal Batch Operations
673857494 Bl
5/2002 Blahnlk et a1‘ "" "
700/86
Based on Multi-Way Principal Component Analysis”, ISA Trans
6,438,436 131*
8/2002 Hohkibara 6t
..
700/97
actions 1996 V01‘ 35 NO‘ 3 pp‘ 259466
6,522,939 B1:
2/2003 Strauch-et al. ..... ..
700/116
* lg; ,
ga?sorils et :11'1
,
e
6,938,262 B2*
'
ers e1n e
a.
..
8/2005 Bao et al. ................. .. 719/329
FOREIGN PATENT DOCUMENTS 0487419 0 745 916 0 825 506 7114601 8328608 10228312
A2 A1 A2 A1 A1 A1
5/1992 4/1996 2/1998 5/1995 12/1996 11/1998
Kourti et a1‘, “Process Analysis Monitoring and Diagnosis, using
Multivariate Projection Method”, Chemometrics and Intellingent _
Laboratory Systems’ 1995’ V01‘ 28’ N0‘ 1’ pp‘ 3 21'
Rosenof, “Data Logging and Reporting for Effective Batch Con trol”, The Industrial and Process Control Magazine, Jul. 1985, vol. 58, No. 8, pp. 29-32. Search Report under Section 17(5) issued in GB application No. GB 0010257.4 on Dec. 22, 2000.
Examination Report under Section 18(3) issued in GB application No. 00102574 on Sep. 16, 2004.
* cited by examiner
U.S. Patent
Jul. 24, 2007
Sheet 1 0f 21
US 7,249,356 B1
FIG. 1 PRIOR ART DATA POINTS PROCESS EVENTS
101
100
com. DATA COLLECTION
102
PROCESS EVENTS
LOG
API
T
\
‘06
H152
10s
COMPRESSED
"\150
TAGGED
110
me
112
V
"
S
v
v
v
£55m;
MODELING
USER
DYNAMIC
ACCESS ENGINE
Mmmx CONTROL
L114 USER CONFIG.
120
L116
L118
U.S. Patent
Jul. 24, 2007
Sheet 3 0f 21
US 7,249,356 B1
FIG. 3 ESTABLISH CONNECTIONS TO ALL DATA SOURCES
x300
V
INITIALIZE CONNECTION TO DIAGNOSTIC AND MAINTENANCE -\.302 PROCESSES OF DB V
304 ADMINISTRATIVE OR I DIAGNOSTIC MESSAGE '
RECEIVED ?
PROCESS ADMINISTRATIVE OR
-\_ 306
DIAGNOSTIC MESSAGE V
308 MESSAGE AVAILABLE FROM ANY DATA SOURCE ?
PROCESS ALL AVAILABLE
MESSAGES FROM ALL DATA SOURCES
UPDATE STATUS
_\
31°
m 312
U.S. Patent
Jul. 24, 2007
Sheet 4 0f 21
US 7,249,356 B1
FIG. 4
300
T
GET DATA SOURCE CONFIGURATION FROM DB
1.
'\ 400
402
MORE DATA SOURCES TOv PROCESS ?
ESTABLISH CONNECTION BETWEEN EXECUTIVE AND SERVER PROCESS OF NEXT DATA SOURCE
\_ 404
U.S. Patent
Jul. 24, 2007
Sheet 5 0f 21
US 7,249,356 B1
FIG. 5
I
acsls
1
500
5023 PERFORM ARCHNE
ARCHIVE REQUEST ?
PROCESSING PER REQUEST
506
c?) MIT ALL M
504
.
OUTSTANDING
Sgggggg“
RECORDS
?
NO (
DONE
)
‘
U.S. Patent
Jul. 24, 2007
Sheet 6 0f 21
US 7,249,356 B1
FIG. 6
I
310 5
MORE DATA SOURCES TO CHECK ?
602 ANY
MESSAGES FROM THIS DATA SOURCE 7
PROCESS
MESSAGE
’\ 604
U.S. Patent
Jul. 24, 2007
Sheet 7 0f 21
US 7,249,356 B1
FIG. 7
I
a‘? 700
NO
KNOWN MESSAGE TYPE '2
GENERATE A KEY
/\ 702
FROM MESSAGE ‘
LOCATE OBJECT
"\ 704
IN DB USiNG KEY 706
OBJECT LOCATED 712
\
YES
7’
N
CREATE REQUISITE
'
OBJECT(S) FOR
CREATE‘ REOUISITE
UNKNOWN MESSAGE
OBJECT(S)
v
i,
UPDATE smnsncs
UPDATE STATISTICS
FOR UNKNOWN MESSAGES
FOR KNOWN MESSAGES
K
714 V
m 708
N 710
U.S. Patent
Jul. 24, 2007
Sheet 8 0f 21
FIG. 8
US 7,249,356 B1
i
312
800
SUFFICIENT TIME SINCE LAST COMMIT ?
YES
.802
SUFFICIENT MESSAGES SINCE LAST COMMIT ’?
COMMIT EVENTS
'x. 804
TO DB
806 NEW
CONFIGURATION PARAMETERS
UPDATE DB STRUCTURE ANDIOR DATA SOURCES
808
810 DB SIZE CHANGE REQUIRED ? YES
UPDATE DB SIZE
L__-___>
K 812
U.S. Patent
Jul. 24, 2007
Sheet 9 Of 21
US 7,249,356 B1
FIG. 9 ———-——_>
"
DISPLAY NEWLY \- 914
SELECTED‘ BATCH EVENT
DISPLAY ALL > KNOWN BATCHES
.900,
|NF0RMAT|0N
IN BATCH
OVERVIEW
GANTT CHART
mspLAy NEWLY “918
L
SELECTED
DETERMINE
LEVEL OF DETAIL
BATCH To BE
FOR PRESENT
, 902/“
BATCH EVENT
PRESENTED
INFORMATION
TO USER
-
L
-
DISPLAY
904/‘ DEFAULT LEVEL OF DETAIL FOR REOuEsTED BATCH IN GANTT 906 CHART FORM
DISPLAY
A 922
COMPARE TO ANOTHER BATCH ?
SELECTED ADDITIONAL BATCH EVENT INFORMATION
TOGGLE REAL Vs.
OSEILTAQTO
'\ 926 L
PRESENTLY SELECTED
BATCH RELATIVE
SELECTED
'
DETAIL 0F PRESENTED BATCH
T‘ME UNE 7
“ME LINE
USER
D'SPLAY
SELECTION
CONTINUOUS
SELECTED CONTINUOUS
DATA ''
DATA POINT(S) l
L DISPLAY TABULAR DATA ' CORRESPONDING To
c 908-”
t
V RECEIVE
1
"'\ 930
RECEIVE usER ,\
@
REQUEST TO
CHANGE CONTINUOUS
DATA POINT(S) I 934
RETURN TO EVENT INFORMATION DISPLAY 7
932
C’) A
U.S. Patent
Jul. 24, 2007
Sheet 10 0f 21
US 7,249,356 B1
.mz ?dw .=. .-wm_
V..: a?
$2.98
6.8.w..8a.2. . 2.6
_woo.,/\3~52.N89>6q.a.2m8. B .2=85.SE..Eu523m2:3:=¢§28:£=592.8~6.:.,2.8£29.Q.8>5q.28.56, . .280J.>52:8.653.“
52.3“.
..8325$2..>5832d.38w6 285$2.QmE.>3638.25m3.15 8.92Q..3605:.2»8|.w 8.592.Q“3>2.,8.:2,a.m» 8523.3Q>82.65.|w8.23$985q.2.s>6.:qm2»z.58m?3.
__2.s.58=..z._5
EB E _v .. _ 28... . .v .
__. . . ,.w
B.52m5.8ta“232.52mm.382.5m?
_ 6.2; .2woo.
gur2‘7i38.m52u3.:0
2. .2 2..QE
P coo