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

Loading in 2 Seconds...

play fullscreen
1 / 36

PI Batch Database - PowerPoint PPT Presentation


  • 256 Views
  • Uploaded on

PI Batch Database. Jon Peterson OSI Software, Inc . 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. Introduction, continued.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'PI Batch Database' - andrew


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
pi batch database

PI Batch Database

Jon Peterson

OSI Software, Inc.

introduction
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
introduction continued
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
purpose
Purpose
  • Batch Industry
    • Demands on equipment modeling
      • Numerous, similar equipment entities
      • Produce a wide range of products
      • Moveable, configurable equipment
purpose5
Purpose
  • All industries can benefit
    • Add Structure to the PI Data Archive
    • Add organization through PI Point grouping
  • Complete hierarchical model
osi brewing
OSI Brewing
  • Review of PI Module Database
    • Use model of two Brew Kettles
enterprise osi brewing inc
Enterprise: OSI Brewing, Inc.

Site: Cleveland

Area: Production

Line: Phil’s Pilsner

Line: Mark’s Stout

Unit: Brew Kettle

Unit: Brew Kettle

pimodule
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
piunit
PIUnit
  • A PIUnit is a specialized PIModule
  • A PIModule set to be a PIUnit can historize batch objects
piunit10
PIUnit

Reactor1

F9CCFA79-B356-11d3-BA4B-F0C04F428C95UnitReactor 1IsPIUnit = TRUE

Version 3PIAdmin 23-Jan-199911-Oct-1999

PIAliases

PIProperties

pimoduledb summary
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
pi batch database12
PI Batch Database
  • Model and store batch data
  • Map batch data to PI Data Archive
  • Support ISA S88 and beyond
pi batch database13
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
pi batch database14
PI Batch Database

Server

PIBatchDB

PITransferRecordDB

PITransferRecordList

PITransferRecord

PISubBatchDefs

PISubBatchDef

PIBatchList

PIBatch

PIUnitBatches

PIUnitBatch

PIBatchDB

PIUnitBatchList

PIUnitBatch

pibatch
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
pibatch properties
PIBatch Properties
  • Batch ID
  • Product
  • Recipe
  • Unique ID
  • PIUnitBatches
  • PIProperties
  • Start Time
  • End Time
pibatch properties17
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
piunitbatch
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
piunitbatch properties
PIUnitBatch Properties
  • Batch ID
  • Product
  • Procedure Name
  • PIUnit
  • Unique ID
  • PIBatch
  • PISubBatches
  • Start Time
  • End Time
creating a piunitbatch
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
pisubbatch
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
pisubbatch properties
PISubBatch Properties
  • Name
  • Sub-batch definition
  • Recipe
  • Unique ID
  • PIUnitBatch
  • PIProperties
  • Start Time
  • End Time
pisubbatchdefinitions
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
creating sub batches
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
pitransferrecord
PITransferRecord
  • Material tracking
    • Genealogy
pitransferrecord properties
PITransferRecord Properties
  • Source (PIBatch or PIUnitBatch)
  • Destination(PIBatch or PIUnitBatch)
  • Start Time
  • End Time
  • Quantity
  • Engineering Units
  • Unique ID
creating transfer records
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

release schedule
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
release schedule29
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
slide30

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

enterprise osi brewing inc34
Enterprise: OSI Brewing, Inc.

Site: Cleveland

Area: Production

Line: Phil’s Pilsner

Line: Mark’s Stout

Unit: Brew Kettle

Unit: Brew Kettle