pi module database ken coates, jon peterson osi software, inc
TRANSCRIPT
![Page 1: PI Module Database Ken Coates, Jon Peterson OSI Software, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e985503460f94b9b433/html5/thumbnails/1.jpg)
PI Module Database Ken Coates, Jon Peterson
OSI Software, Inc.
![Page 2: PI Module Database Ken Coates, Jon Peterson OSI Software, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e985503460f94b9b433/html5/thumbnails/2.jpg)
Introduction
PI Server Databases
Programmatic InterfacesActiveX.
OSI and ActiveX based interfaces.
Tools for applicationsOSI Products. Controls, applications
ISV and system integrators
User’s applications
![Page 3: PI Module Database Ken Coates, Jon Peterson OSI Software, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e985503460f94b9b433/html5/thumbnails/3.jpg)
Introduction, continued
PI Module DatabaseAdd structure to the PI Data Archive
“Display Time” data source resolution
PI Batch DatabaseModel and store batch data
Map batch data to PI Data Archive
Support ISA S88 and beyond
![Page 4: PI Module Database Ken Coates, Jon Peterson OSI Software, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e985503460f94b9b433/html5/thumbnails/4.jpg)
Purpose
Batch IndustryDemands on equipment modeling
Numerous, similar equipment entities
Produce a wide range of products
Moveable, configurable equipment
![Page 5: PI Module Database Ken Coates, Jon Peterson OSI Software, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e985503460f94b9b433/html5/thumbnails/5.jpg)
Purpose
All industries can benefitAdd Structure to the PI Data Archive
Add organization through PI Point grouping
Controllers
Arrays. For example profile points
Complete hierarchical model
![Page 6: PI Module Database Ken Coates, Jon Peterson OSI Software, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e985503460f94b9b433/html5/thumbnails/6.jpg)
OSI Brewing
Demonstrate the Module DatabasePre-beta PI 3.3
Top-down design approachStart with the big picture
Drill down into the details
![Page 7: PI Module Database Ken Coates, Jon Peterson OSI Software, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e985503460f94b9b433/html5/thumbnails/7.jpg)
Enterprise: OSI Brewing, Inc.
Site: Cleveland
Area: Production
Line: Phil’s Pilsner
Line: Mark’s Stout
![Page 8: PI Module Database Ken Coates, Jon Peterson OSI Software, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e985503460f94b9b433/html5/thumbnails/8.jpg)
PI SDK Object Model
Server
PIModuleDB
PIHeadings
PIModulePIModules
PIHeading
PIProperties
PIAliases
PIProperty
PIAlias
PIHeading
![Page 9: PI Module Database Ken Coates, Jon Peterson OSI Software, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e985503460f94b9b433/html5/thumbnails/9.jpg)
PIHeadings
Used to implement consistent naming convention
Does not enforce a particular hierarchy
Does enforce order
![Page 10: PI Module Database Ken Coates, Jon Peterson OSI Software, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e985503460f94b9b433/html5/thumbnails/10.jpg)
PIModules
PIModule is the fundamental equipment element
Comprised of:Name
PIHeading: Module's hierarchy
PIAliases: Collection of Data sources
PIProperties: User/Application specific configuration data
PIModules: More equipment collections
![Page 11: PI Module Database Ken Coates, Jon Peterson OSI Software, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e985503460f94b9b433/html5/thumbnails/11.jpg)
PIModule
FCML101
F9CCFA79-B356-11d3-BA4B-F0C04F428C95
ControllerFlow controller, ML-101
PIAliases PIProperties
Version 24PIAdmin 22-Sep-19993-Oct-1999
![Page 12: PI Module Database Ken Coates, Jon Peterson OSI Software, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e985503460f94b9b433/html5/thumbnails/12.jpg)
PIAliases
PIAlias maps a common name to a PI Point
Used to associate data with modules or equipment
All PIModules have a collection of PIAliases
![Page 13: PI Module Database Ken Coates, Jon Peterson OSI Software, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e985503460f94b9b433/html5/thumbnails/13.jpg)
PIAliasesFCML101
PIAliases
Alias Data Source
Value LCMS101.pv
Setpoint LCMS101.sp
Output LCMS101.out
![Page 14: PI Module Database Ken Coates, Jon Peterson OSI Software, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e985503460f94b9b433/html5/thumbnails/14.jpg)
PIProperties
Set of Name-Value pairsStored in a VARIANT; therefore can hold nearly anything
User or application definable propertiesNon-time series data associated with module
![Page 15: PI Module Database Ken Coates, Jon Peterson OSI Software, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e985503460f94b9b433/html5/thumbnails/15.jpg)
PIPropertiesFCML101
PIProperties
Name Value
Instrument Engineer John Doe
Last Tuned 22-Nov-1996
Type PID
![Page 16: PI Module Database Ken Coates, Jon Peterson OSI Software, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e985503460f94b9b433/html5/thumbnails/16.jpg)
Demonstration
Configuration ToolMicrosoft Management Console Based
Consistent configuration interface
![Page 17: PI Module Database Ken Coates, Jon Peterson OSI Software, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e985503460f94b9b433/html5/thumbnails/17.jpg)
MMC Snap-inMMC
Programming Interface
PIModuleDbSQL Server
WMI
Snap-In Toolkit
PI-SDK basedControls
IIS
PIModuleDb Snap-in
Active DirectoryActive Directory
WMI
Snap-in
![Page 18: PI Module Database Ken Coates, Jon Peterson OSI Software, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e985503460f94b9b433/html5/thumbnails/18.jpg)
Enterprise: OSI Brewing, Inc.
Site: Cleveland
Area: Production
Line: Phil’s Pilsner
Line: Mark’s Stout
Unit: Brew Kettle
Unit: Brew Kettle
![Page 19: PI Module Database Ken Coates, Jon Peterson OSI Software, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e985503460f94b9b433/html5/thumbnails/19.jpg)
Unit: Brew Kettle
![Page 20: PI Module Database Ken Coates, Jon Peterson OSI Software, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e985503460f94b9b433/html5/thumbnails/20.jpg)
Table View of Brew Kettle
Brew Kettle PIAliases
Alias Data Source Feed Valve Position LCMS101.fvp Feed Flow LCMS101.flow Level Control Valve Position LCMS101.lvp Level LCMS101.level Steam Outlet Valve Position TCMS101.ovp Steam Flow TCMS101.flow Steam Inlet Valve Position TCMS101.ivp Thermocouple 1 TCMS101.tc1 Thermocouple 2 TCMS101.tc2
![Page 21: PI Module Database Ken Coates, Jon Peterson OSI Software, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e985503460f94b9b433/html5/thumbnails/21.jpg)
Brew Kettle “Sub-Modules”
The PIModules used to add collections of modules.
PIModule: “Controllers”Temperature Controller
Level Controller
![Page 22: PI Module Database Ken Coates, Jon Peterson OSI Software, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e985503460f94b9b433/html5/thumbnails/22.jpg)
Brew Kettle Demonstration
Add the brew kettle to hierarchy
Add the controllers to the brew kettle
![Page 23: PI Module Database Ken Coates, Jon Peterson OSI Software, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e985503460f94b9b433/html5/thumbnails/23.jpg)
Unit: Brew Kettle
![Page 24: PI Module Database Ken Coates, Jon Peterson OSI Software, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e985503460f94b9b433/html5/thumbnails/24.jpg)
Brew Kettle, Phil’s Stout Line
Nearly identical to Brew Kettle on Mark’s Stout Line
References different data sources
Demonstration: Display time resolution of data sources
![Page 25: PI Module Database Ken Coates, Jon Peterson OSI Software, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e985503460f94b9b433/html5/thumbnails/25.jpg)
Historize Equipment Changes
Just like Process DataTime stamp and Value
Keep track of modificationsNew Instruments and New Units
Changing Product InformationUpdated Specifications
New Products / Raw Materials
Database Driven Applications
![Page 26: PI Module Database Ken Coates, Jon Peterson OSI Software, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e985503460f94b9b433/html5/thumbnails/26.jpg)
Adding a New Instrument
Brew KettleEffectiveDate:
01-Jan-00
Brew KettleEffectiveDate:01-Mar-00
Time (values)
Aliases
Thermocouple 1
Thermocouple 2
Aliases
Thermocouple 1
Thermocouple 2
Thermocouple 3
Thermocouple 4
![Page 27: PI Module Database Ken Coates, Jon Peterson OSI Software, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e985503460f94b9b433/html5/thumbnails/27.jpg)
Enhanced Brew Kettle
![Page 28: PI Module Database Ken Coates, Jon Peterson OSI Software, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e985503460f94b9b433/html5/thumbnails/28.jpg)
Demonstration
Excel spreadsheet report Correctly resolving equipment in place for report period
![Page 29: PI Module Database Ken Coates, Jon Peterson OSI Software, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e985503460f94b9b433/html5/thumbnails/29.jpg)
PIModuleDB Summary
Easier access to PI Data Archive
Model to fit users requirementsFor example, production requirements vs. maintenance requirements
Model supports changes through time
Module definable attributesPIProperties collection
![Page 30: PI Module Database Ken Coates, Jon Peterson OSI Software, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e985503460f94b9b433/html5/thumbnails/30.jpg)
Features For Release 2
Module TemplatesRe-use of common module configurations
Also hierarchical
InheritanceChanges to Module template propagated through derived modules
PI Alias DefinitionsTemplate of alias definition with default point attributes
![Page 31: PI Module Database Ken Coates, Jon Peterson OSI Software, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e985503460f94b9b433/html5/thumbnails/31.jpg)
Release Schedule
Leveraging foundation of PI SDK 1Harry SmithBill Vaughan
Leveraging foundation of PI 3.xRichard BeesonRulik Perla
Four Developers (4 fold increase!)Configuration tools and controls
Richard MayPrabal Acharyya
ActiveX and Server ComponentsKen CoatesJon Peterson
![Page 32: PI Module Database Ken Coates, Jon Peterson OSI Software, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e985503460f94b9b433/html5/thumbnails/32.jpg)
Release Schedule
Beta Second Quarter 2000General beta with beta controls and configuration tools
Release Third Quarter 2000PI 3.3
PI SDK 1.1
![Page 33: PI Module Database Ken Coates, Jon Peterson OSI Software, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e985503460f94b9b433/html5/thumbnails/33.jpg)
Unit
Server
PIModuleDB PIBatchDB
PIHeadings
PISubBatchDefs
PITransferRecordDB
PIBatchList
PIModules
PIProducts
PIPeople
PITransferRecordList PITransferRecord
PISubBatchDefinition
PIHeading
PIModule
PIModules
PIAliases PIAlias
PIProperties PIProperty
PIProperties
PIProduct
PIPerson
Same as PIModule except for Unit
PIUnitBatchList
PIUnitBatchRules
PIHeading
PIBatch
PIUnitBatches
PIProperties PIProperty
PIProperties
PIUnitBatch
PISubBatch
PIUnitBatch
PISubBatches
PISubBatches
PISubBatchDefinition
SubBatchLinkage
Hierarchy
Hierarchy
Hierarchy
PI Module Database
PIModuleTemplates
PIProductTemplates
PIPeopleTemplates
Hierarchy
![Page 34: PI Module Database Ken Coates, Jon Peterson OSI Software, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e985503460f94b9b433/html5/thumbnails/34.jpg)
Empty Title/Bullets
![Page 35: PI Module Database Ken Coates, Jon Peterson OSI Software, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e985503460f94b9b433/html5/thumbnails/35.jpg)
Empty Title/BigGraphic
![Page 36: PI Module Database Ken Coates, Jon Peterson OSI Software, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e985503460f94b9b433/html5/thumbnails/36.jpg)
Empty Title/Small Graphic