PI Batch Database - PowerPoint PPT Presentation

andrew
pi batch database l.
Skip this Video
Loading SlideShow in 5 Seconds..
PI Batch Database PowerPoint Presentation
Download Presentation
PI Batch Database

play fullscreen
1 / 36
Download Presentation
PI Batch Database
266 Views
Download Presentation

PI Batch Database

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. PI Batch Database Jon Peterson OSI Software, Inc.

  2. Introduction • PI Server Databases • Programmatic Interfaces • ActiveX. • OSI and ActiveX based interfaces. • Tools for applications • OSI Products. Controls, applications • ISV and system integrators • User’s applications

  3. Introduction, continued • PI Batch Database • Model and store batch data • Map batch data to PI Data Archive • Support ISA S88 and beyond • PI Module Database • Add structure to the PI Data Archive • “Display Time” data source resolution

  4. Purpose • Batch Industry • Demands on equipment modeling • Numerous, similar equipment entities • Produce a wide range of products • Moveable, configurable equipment

  5. Purpose • All industries can benefit • Add Structure to the PI Data Archive • Add organization through PI Point grouping • Complete hierarchical model

  6. OSI Brewing • Review of PI Module Database • Use model of two Brew Kettles

  7. Enterprise: OSI Brewing, Inc. Site: Cleveland Area: Production Line: Phil’s Pilsner Line: Mark’s Stout Unit: Brew Kettle Unit: Brew Kettle

  8. PIModule • 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

  9. PIUnit • A PIUnit is a specialized PIModule • A PIModule set to be a PIUnit can historize batch objects

  10. PIUnit Reactor1 F9CCFA79-B356-11d3-BA4B-F0C04F428C95UnitReactor 1IsPIUnit = TRUE Version 3PIAdmin 23-Jan-199911-Oct-1999 PIAliases PIProperties

  11. PIModuleDB Summary • Easier access to PI Data Archive • Model to fit users requirements • For example, production requirements vs. maintenance requirements • Model supports changes through time • Module definable attributes • PIProperties collection

  12. PI Batch Database • Model and store batch data • Map batch data to PI Data Archive • Support ISA S88 and beyond

  13. PI Batch Database • Design based on previous experience • ISA S88:1. The material that is being produced or that has been produced by a single execution of a batch process.2. An Entity that represents the production of a materiel at any point in the process. • Requires two unique data objects • PIBatch • PIUnitBatch

  14. PI Batch Database Server PIBatchDB PITransferRecordDB PITransferRecordList PITransferRecord PISubBatchDefs PISubBatchDef PIBatchList PIBatch PIUnitBatches PIUnitBatch PIBatchDB PIUnitBatchList PIUnitBatch

  15. PIBatch • Encapsulates first definition: “the product being produced” • “Batch” of beer • Has a start and end time; but not all times significant • Associated data may be difficult to store in PI Data Archive

  16. PIBatch Properties • Batch ID • Product • Recipe • Unique ID • PIUnitBatches • PIProperties • Start Time • End Time

  17. PIBatch Properties • Product • String or reference to the PIProducts collection in the PI Module Database • PIUnitBatches • Collection of PIUnitBatch objects; references to physical batch processing • PIProperties • Name-Value pairs; used to store application/user specific data

  18. PIUnitBatch • Encapsulates 2nd definition: “production of material at any point in the process” • Definite time of activity • Associated data stored in the PI Data Archive • Created via interface on a PIModule set to be a PIUnit

  19. PIUnitBatch Properties • Batch ID • Product • Procedure Name • PIUnit • Unique ID • PIBatch • PISubBatches • Start Time • End Time

  20. Creating a PIUnitBatch • A PIModule, with its IsPIUnit property set to TRUE supports following method:Function AddPIUnitBatch(bstrBatchID As String, varProduct, pStartTime As PITime, [pEndTime As PITime]) As PIUnitBatch • Demonstrate creating a PIUnitBatch

  21. PISubBatch • Encapsulates identifiable portions of a PIUnitBatch • Operations, phases, steps… • Sub-batch hierarchy is preserved • Sub-batch definitions are site configurable • Not restricted to Operation,phase and step of S88

  22. PISubBatch Properties • Name • Sub-batch definition • Recipe • Unique ID • PIUnitBatch • PIProperties • Start Time • End Time

  23. PISubBatchDefinitions • Defines available sub-batch definitions or types. • For example, Operation, Phase • Defines hierarchy of sub-batches • For example, A phase must be part of an operation • Does not define specific instance of a sub-batch

  24. Creating Sub-batches • Always part of a PIUnitBatch • PISubBatches property of PIUnitBatchFunction Add(Name As String, pDef As PISubBatchDefinition, pStartTime As PITime, [pEndTime As PITime]) As PISubBatch • Demonstrate creating sub-batches

  25. PITransferRecord • Material tracking • Genealogy

  26. PITransferRecord Properties • Source (PIBatch or PIUnitBatch) • Destination(PIBatch or PIUnitBatch) • Start Time • End Time • Quantity • Engineering Units • Unique ID

  27. Creating Transfer Records • Method of the PITransferRecordDb Function Add(pSource As Unknown, pDestination As Unknown, pStartTime As PITime, [pEndTime As PITime], [Quantity], [EngineeringUnits]) As PITransferRecord

  28. Release Schedule • Leveraging foundation of PI SDK 1 • Harry Smith • Bill Vaughan • Leveraging foundation of PI 3.x • Richard Beeson • Rulik Perla • Four Developers (4 fold increase!) • Configuration tools and controls • Richard May • Prabal Acharyya • ActiveX and Server Components • Ken Coates • Jon Peterson

  29. Release Schedule • Beta Second Quarter 2000 • General beta with beta controls and configuration tools • Release Third Quarter 2000 • PI 3.3 • PI SDK 1.1

  30. PI Module Database Server PIModuleDB PIBatchDB PIHeadings PIHeading PITransferRecordDB PIModules PIModule PITransferRecordList PITransferRecord PIHeading PISubBatchDefs PISubBatchDefinition PIAliases PIAlias PIBatchList PIBatch PIProperties PIProperty PIProperties PIProperty PIProperties Hierarchy PIProperties PIModules Hierarchy PIUnitBatches Unit PIUnitBatchRules PIUnitBatch SubBatchLinkage PIUnitBatch PIUnitBatchList PISubBatches PISubBatch PISubBatchDefinition PISubBatches PIProducts PIProduct Same as PIModule except for PIHeading and Unit Hierarchy PIPeople PIPerson

  31. Empty Title/Bullets

  32. Empty Title/BigGraphic

  33. Empty Title/Small Graphic

  34. Enterprise: OSI Brewing, Inc. Site: Cleveland Area: Production Line: Phil’s Pilsner Line: Mark’s Stout Unit: Brew Kettle Unit: Brew Kettle

  35. Unit: Brew Kettle

  36. Unit: Brew Kettle