servers analytics clients data access -...
TRANSCRIPT
![Page 1: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/1.jpg)
![Page 2: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/2.jpg)
2 © Copyright 2011 OSIsoft, LLC.
Presented by
PI System Product Roadmap
Ray Verhoeff, Ray Hall, Mark Hughes
![Page 3: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/3.jpg)
3 © Copyright 2011 OSIsoft, LLC.
Achievements since Users Conference 2010
• Servers
• Analytics
• Clients
• Data Access
![Page 4: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/4.jpg)
4 © Copyright 2011 OSIsoft, LLC.
PI 64-Bit Products • Servers:
– PI Server 2010 – PI Notifications 2010 R2(*) – PI ACE 2010 R2 – OSIsoft Utilities Gateway
• Data Access – PI SDK – PI OLE DB 3.3 – PI OLE DB Enterprise 2010 – PI Web Services 2010
• Clients – PI WebParts 2010 R2 – PI DataLink for Excel Services 2010
![Page 5: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/5.jpg)
5 © Copyright 2011 OSIsoft, LLC.
Data Access Services
SQL-Based OPC Web Services SDKs
Real-time Interfaces
IT Data
Custom Data APIs / SDKs
Relational Data OLEDB / ODBC
SQL SERVER /
ORACLE
Batch Data BATCH EXECUTION
SYSTEMS
Real-Time Data DCS / PLC / SCADA / OPC
HISTORIANS /
INTERFACES
High Availability (option)
Windows Security PI Data Archive
PI Notifications PI Analytics
PI Asset Framework
Health Monitoring
PI Server 2010
![Page 6: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/6.jpg)
6 © Copyright 2011 OSIsoft, LLC.
PI Server 2010 in 2010
• AF Link Subsystem
• AF Scaling and Performance
• AF Builder
![Page 7: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/7.jpg)
7 © Copyright 2011 OSIsoft, LLC.
Migrating PI Module DB to PI Asset Framework (AF)
Module
Database AF Element
Database
AF Link
Subsystem
ISV/Internal Apps
PI ACE
`
`
BatchView
MDB based
Applications
Custom via Data Access
`
PI WebParts
AF based
Applications
PI ProcessBook
![Page 8: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/8.jpg)
8 © Copyright 2011 OSIsoft, LLC.
Trends of AF Server Performance
0
500
1000
1500
MDB AF 2.0 AF 2.1 AF 2010
Objects read per second
0
200
400
600
MDB AF 2.0 AF 2.1 AF 2010
Objects Added per Second
8
0
100
200
MDB AF 2.0 AF 2.1 AF 2010
seconds (40,000 element database)
0.20.2
02000400060008000
10000
MDB AF 2.0 AF2.1 AF 2010
Th
ou
sa
nd
s
Supported Number of Objects
40k
Total Objects Read Performance
Insert Rate Search Time
![Page 9: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/9.jpg)
9 © Copyright 2011 OSIsoft, LLC.
PI Analytics
• PI Notifications 2010 R2
• PI ACE 2010 R2
• PI for StreamInsight
![Page 10: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/10.jpg)
10 © Copyright 2011 OSIsoft, LLC.
PI Notifications 2010 R2
• Message formatting (pretty slick!)
• Option to control tag usage
• 64-bit!
Go see: PI Notifications – Customizing Content and Delivering Information
![Page 11: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/11.jpg)
11 © Copyright 2011 OSIsoft, LLC.
PI ACE 2010 R2
• PI ACE Schedulers running on multiple machines
• Higher scale. Faster startup.
• Visual Studio 2005, 2008 & 2010
• Both 32- and 64-bit!
Go see: Creating Calculations to Solve Business Problems - PI ACE 2010 R2
![Page 12: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/12.jpg)
12 © Copyright 2011 OSIsoft, LLC.
PI System and Microsoft StreamInsight
Query
Logic
Event sources Event targets
PI Server
StreamInsight Application at Runtime
.NET
C#
LINQ StreamInsight Application
Development
Input
Adapters
Output
Adapters StreamInsight Engine
Query
Logic
Query
Logic
PI Interface (future)
PI Server
PI for StreamInsight
Stock ticker, news feeds
Trading stations
Pagers, Mobile
![Page 13: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/13.jpg)
13 © Copyright 2011 OSIsoft, LLC.
Go see…
• PI for StreamInsight – Applying Microsoft StreamInsight to Real World Problems
![Page 14: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/14.jpg)
14 © Copyright 2011 OSIsoft, LLC.
PI Clients
• PI WebParts 2010
• PI DataLink 2010
Go see: PI ProcessBook – What’s Here, What’s Coming
![Page 15: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/15.jpg)
15 © Copyright 2011 OSIsoft, LLC.
PI WebParts 2010 (& R2)
• Support for AF Data Reference types
– All time series data
• Formula
• Table Lookup
• Custom
Go see: Asset Based Visualization with PI WebParts
Putting it All Together: Assemble Your PI Reports & Displays into Status Dashboards
![Page 16: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/16.jpg)
16 © Copyright 2011 OSIsoft, LLC.
PI DataLink 2010
• Support for Microsoft Office 2010
• Fully internationalized – 8 languages
• PI DataLink Server 2010 – Support for SharePoint 2010
– 64-bit!
![Page 17: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/17.jpg)
17 © Copyright 2011 OSIsoft, LLC.
Localization in 2010
• PI ActiveView
• PI ProcessBook
• PI WebParts
• PI DataLink
• French
• German
• Russian
• Spanish
• Korean
• Japanese
• Brazilian Portuguese
• Simplified Chinese
Saluton
![Page 18: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/18.jpg)
18 © Copyright 2011 OSIsoft, LLC.
PI Data Access
• PI OLE DB Enterprise 2010
• PI JDBC 2010
• PI Web Services 2010
Data Access Services
SQL-Based OPC Web Services SDKs
![Page 19: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/19.jpg)
19 © Copyright 2011 OSIsoft, LLC.
PI OLE DB Enterprise 2010 (& R2)
• Access to AF structures
• Data access to AF Attribute data
– Snapshots, compressed, interpolated
– With Unit of Measure conversions
![Page 20: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/20.jpg)
20 © Copyright 2011 OSIsoft, LLC.
PI JDBC 2010 (& R2)
• Access to AF
• Compliant with JDBC 4.0 API
• Bulk insert
• JNDI Directory Service support
– JDBC 2.0 Optional Package
![Page 21: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/21.jpg)
21 © Copyright 2011 OSIsoft, LLC.
• Access to PI System data using standard web service technologies
PI Web Services
Microsoft Web Server (IIS)
PI Web Services
Web Service Client application Web Service
Client application Web Service Client application Web Service
Client application
Intranet Extranet Internet
![Page 22: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/22.jpg)
22 © Copyright 2011 OSIsoft, LLC.
PI Web Services 2010 (& R2)
• Support for PI System time series data: – Both PI tag & AF Attribute paths – Snapshots, compressed, interpolated, plot, summaries – Performance Equations
• Basic PI tag search
![Page 23: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/23.jpg)
23 © Copyright 2011 OSIsoft, LLC.
PI Interfaces
• 43 Interface Releases in 2010!
• First AMI Interface Released!
• Modbus Serial and Modbus Ethernet Interfaces Completely Rewritten
• Improvement in message logging
![Page 24: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/24.jpg)
24 © Copyright 2011 OSIsoft, LLC.
New Developments in PI Interfaces
– Siemens Spectrum Power TG Interface (Windows) – Silver Spring Network Interface (AMI) – ESC StackVision Interface Read/Write – ESC StackVision Read-Only – Modbus Serial Interface – Modbus Ethernet Interface – Siemens Simatic Batch Interface – REpowerEvent List Plug-In for OPC DA Interface – Simca Batch OnLine Interface (64-Bit) – GE iBatch Interface
![Page 25: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/25.jpg)
25 © Copyright 2011 OSIsoft, LLC.
Go See…
• Unlock your Data with PI Data Access
• Using PI System Data and Events in Your Enterprise and Line of Business Systems
• Business Intelligence with the PI System & PowerPivot
• Gaining Actionable Insight from PI Data Using the Microsoft BI Platform
![Page 26: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/26.jpg)
26 © Copyright 2011 OSIsoft, LLC.
Our current development efforts
![Page 27: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/27.jpg)
27 © Copyright 2011 OSIsoft, LLC.
2011 Development Efforts What is OSIsoft working on in 2011 to help you?
The fastest,
easiest way to
visualize PI data
Also significant work in Asset-PI, Security, Interfaces, Data Access
![Page 28: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/28.jpg)
28 © Copyright 2011 OSIsoft, LLC.
A tour through the PI System
IT Data
Custom Data APIs / SDKs
Relational Data OLEDB / ODBC SQL SERVER /
ORACLE
Batch Data Batch Execution
Systems
Real-Time Data DCS / PLC / SCADA / OPC
HISTORIANS / INTERFACES
PI Server(s)
AF Server(s)
Interface 1
Interface N
SQL
Interfaces Servers Analytics Data Access Visualization
PI Analytics
PI Notifications
PI SDK
AF SDK
OLEDB
Web Services
PI DataLink
PI WebParts
PI ProcessBook
Interface 2
![Page 29: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/29.jpg)
29 © Copyright 2011 OSIsoft, LLC.
PI System – Interfaces
Custom Data APIs / SDKs
Relational Data OLEDB / ODBC SQL SERVER /
ORACLE
Real-Time Data DCS / PLC / SCADA / OPC
HISTORIANS / INTERFACES
Interface 1
Interface N
Interfaces
PI DataLink
Interface 2
IT Data
Batch Data Batch Execution
Systems
![Page 30: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/30.jpg)
30 © Copyright 2011 OSIsoft, LLC.
Interfaces • OSIsoft commitment:
– 440 interfaces
– 22 developers in 6 locations
– Over 160 effort-years of expertise
• Interface Development – IEC 61850
– OPC .NET
– Web Services
– IPMI
– Modular Mining
– SAFER Weather Station
– Thermotron 8800 Controller
• Batch Interfaces – Performix xBatch
– Werum PAS-X
– Foxboro Batch
• AMI Interface Development – Trilliant Unity
– MultiSpeak
– Eschelon
![Page 31: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/31.jpg)
31 © Copyright 2011 OSIsoft, LLC.
PI System – Servers
PI Server(s)
AF Server(s)
SQL
Servers
![Page 32: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/32.jpg)
32 © Copyright 2011 OSIsoft, LLC.
Security • Goal
– Your trusted source of real time data
• How – Continually improve the PI Infrastructure – Dedicated Cyber Security Manager
• Work Underway – Engagement with Idaho National Labs – Security Reviews with Microsoft – Designed-In on new efforts
Go see: I Want to be Secure, Best Practices for Securing Your PI System
![Page 33: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/33.jpg)
33 © Copyright 2011 OSIsoft, LLC.
Some of the World Largest Databases
130M items
20TB
inventory, items
42TB
(2006)
+65K videos/day
45TB
US demographics
250TB
70K calls/sec
2.85TRow
1.9 trillion call records
323TB
2,800TB
online/on tape
220TB
6,000TB
proprietary
? not available
?
http://www.focus.com/fyi/operations/10-largest-databases-in-the-world/
10 9 8 7 6
5 4 3 2 1
2007 Article:
![Page 34: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/34.jpg)
34 © Copyright 2011 OSIsoft, LLC.
Customers want to use more of the PI System
Synchro Phasors 4,800 data streams at 60Hz
3 years online
Unique events: 27 Trillion
Estimated data size: 270TB
Automated Metering 150M data streams, 15 min
7 years online
Unique events: 16 Trillion
Estimated data size: 200TB 270TB 200TB
![Page 35: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/35.jpg)
35 © Copyright 2011 OSIsoft, LLC.
PI System – Analytics Analytics
PI Analytics
PI Notifications
![Page 36: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/36.jpg)
36 © Copyright 2011 OSIsoft, LLC.
Analytics Product Suite
Go see: Creating Calculations to Solve Business Problems - PI ACE 2010 R2 Go see: PI for StreamInsight – Applying Microsoft StreamInsight to Real World Problems
PI Analytics
Configuration Programming
Performance Equations AF Configured Analytics
PI Advanced Computing Engine (PI ACE)
Totalizers Microsoft StreamInsight & PI for StreamInsight Statistical Quality Control
PI AF formula data reference PI AF custom data reference
![Page 37: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/37.jpg)
37 © Copyright 2011 OSIsoft, LLC.
AF Configured Analytics - Philosophy • Rich Configuration in AF
– Merge of PE and Formula DR syntax – Configuring rollup calculations
• OSIsoft takes care of – Scheduling – Dependencies – Writing results to PI
• Very Large Scale – Improvements in data access – OSIsoft managed scale-out
![Page 38: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/38.jpg)
38 © Copyright 2011 OSIsoft, LLC.
Analytics – Simple Configuration
• Equation defined on an attribute or a template
![Page 39: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/39.jpg)
39 © Copyright 2011 OSIsoft, LLC.
PI System – Data Access Data Access
PI SDK
AF SDK
OLEDB
Web Services
![Page 40: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/40.jpg)
40 © Copyright 2011 OSIsoft, LLC.
Data Access – AF SDK
• Rich Data Access – Full featured
– Bulk operations
– Calculations
– Updates
• .NET exposure
• PI Points
![Page 41: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/41.jpg)
41 © Copyright 2011 OSIsoft, LLC.
Data Access • PI Web Services
– Data by exception – Event Frames
• PI OLEDB Enterprise & PI JDBC – Event Frames
• PI SDK – Buffering of new data and edits – Fanning to all members of an HA Collective – Windows Security
Go see: Unlock your Data with PI Data Access Go see: What's New with High Availability in the PI System
![Page 42: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/42.jpg)
42 © Copyright 2011 OSIsoft, LLC.
PI System – Visualization Visualization
PI DataLink
PI WebParts
PI ProcessBook
![Page 43: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/43.jpg)
43 © Copyright 2011 OSIsoft, LLC.
PI DataLink
• AF attribute paths
• PI tag paths
• Search
• Units of Measure
• 64-bit Excel Support
Go see: Asset Centric PI DataLink - PI DataLink meets PI AF
![Page 44: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/44.jpg)
44 © Copyright 2011 OSIsoft, LLC.
Visualization
• The fastest, easiest way to visualize PI System data!
Go see: Introducing the Fastest, Easiest Way to Visualize Your PI System Data
Stay and see: Turning Insight Into Action
![Page 45: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/45.jpg)
45 © Copyright 2011 OSIsoft, LLC.
PI System – Event Frames
Custom Data APIs / SDKs
Relational Data OLEDB / ODBC SQL SERVER /
ORACLE
Real-Time Data DCS / PLC / SCADA / OPC
HISTORIANS / INTERFACES
PI Server(s)
AF Server(s)
Interface 1
Interface N
SQL
Interfaces Servers Analytics Data Access Visualization
PI Analytics
PI Notifications
PI SDK
AF SDK
OLEDB
Web Services
PI DataLink
PI WebParts
PI ProcessBook
Interface 2
IT Data
Batch Data Batch Execution
Systems
![Page 46: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/46.jpg)
46 © Copyright 2011 OSIsoft, LLC.
What can you do with Event Frames?
• Any event in your process – Such as a downtime or incident
• Automatically identify important events – Based upon patterns in your PI data
• Search these events • Visualize and analyze them
– To improve your process
• Imagine: – A simple downtime tracking tool – Configuration, no programming
Go see: PI Event Frames - Infrastructure to Find Data Relevant to Your Events
![Page 47: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/47.jpg)
47 © Copyright 2011 OSIsoft, LLC.
Event Frames – Infrastructure changes
• Interfaces
– Batch Interfaces
• Servers
– Events Frames stored in AF Server
– Batch to EF transition
• Analytics
– Generating Event Frame on patterns
• Data Access
– AF SDK
– PI Web Services
– PI OLEDB Enterprise & PI JDBC
• Clients
– PI DataLink
– PI WebParts
– PI ProcessBook
– New Visualization
Targeted by 2012 Users Conference
![Page 48: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/48.jpg)
48 © Copyright 2011 OSIsoft, LLC.
Custom Data APIs / SDKs
Relational Data OLEDB / ODBC SQL SERVER /
ORACLE
Real-Time Data DCS / PLC / SCADA / OPC
HISTORIANS / INTERFACES
PI Server(s)
AF Server(s)
Interface 1
Interface N
SQL
Interfaces Servers Analytics Data Access Visualization
PI Analytics
PI Notifications
PI SDK
AF SDK
OLEDB
Web Services
PI DataLink
PI WebParts
PI ProcessBook
Interface 2
IT Data
PI System – Summary
Batch Data Batch Execution
Systems
![Page 49: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/49.jpg)
49 © Copyright 2011 OSIsoft, LLC.
PI System – Summary Interfaces Servers Analytics Data Access Visualization
![Page 50: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/50.jpg)
50 © Copyright 2011 OSIsoft, LLC.
PI System – Summary Interfaces Servers Analytics Data Access Visualization
![Page 51: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/51.jpg)
51 © Copyright 2011 OSIsoft, LLC.
PI System – Summary Interfaces Servers Analytics Data Access Visualization
![Page 52: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/52.jpg)
52 © Copyright 2011 OSIsoft, LLC.
PI System – Summary Interfaces Servers Analytics Data Access Visualization
![Page 53: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/53.jpg)
53 © Copyright 2011 OSIsoft, LLC.
PI System – Summary Interfaces Servers Analytics Data Access Visualization
![Page 54: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/54.jpg)
54 © Copyright 2011 OSIsoft, LLC.
PI System – Summary Interfaces Servers Analytics Data Access Visualization
Event Frames
![Page 55: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/55.jpg)
55 © Copyright 2011 OSIsoft, LLC.
PI System Future Development
![Page 56: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/56.jpg)
56 © Copyright 2011 OSIsoft, LLC.
“A committee is a cul-de-sac down which ideas are lured and then quietly strangled.” Sir Barnett Cocks (1907-1989)
![Page 57: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/57.jpg)
57 © Copyright 2011 OSIsoft, LLC.
“Prediction is very difficult, especially about the future.” Niels Bohr (1885-1962)
![Page 58: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/58.jpg)
58 © Copyright 2011 OSIsoft, LLC.
“Doubt is not a pleasant condition, but certainty is absurd.” Voltaire (1694 - 1778)
![Page 59: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/59.jpg)
59 © Copyright 2011 OSIsoft, LLC.
“The future, according to some scientists, will be exactly like the past, only far more expensive.” John Sledak (1937-2000)
![Page 60: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/60.jpg)
60 © Copyright 2011 OSIsoft, LLC.
“When you can't solve the problem, manage it.” Robert H. Schuller (1926-)
![Page 61: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/61.jpg)
61 © Copyright 2011 OSIsoft, LLC.
“O Marvelous! what new configuration will come next? I am bewildered with multiplicity.” William Williams (1883-1963)
![Page 62: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/62.jpg)
62 © Copyright 2011 OSIsoft, LLC.
“If there are no stupid questions, then what kind of questions do stupid people ask? Do they get smart just in time to ask questions?” Scott Adams (1957-)
![Page 63: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/63.jpg)
63 © Copyright 2011 OSIsoft, LLC.
“Everything that is beautiful and noble is the product of reason and calculation.” Charles Baudelaire (1821-1867)
![Page 64: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/64.jpg)
64 © Copyright 2011 OSIsoft, LLC.
“I do not fear computers. I fear the lack of them.” Isaac Asimov (1920-1992)
![Page 65: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/65.jpg)
65 © Copyright 2011 OSIsoft, LLC.
“The future is here. It's just not widely distributed yet.” William Gibson (1948-)
![Page 66: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/66.jpg)
66 © Copyright 2011 OSIsoft, LLC.
“Make sure you have finished speaking before your audience has finished listening.” Dorothy Sarnoff (1914-2008)
![Page 67: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/67.jpg)
67 © Copyright 2011 OSIsoft, LLC.
“Go ahead, show my e-mail address up there.” Richard Beeson
![Page 68: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/68.jpg)
68 © Copyright 2011 OSIsoft, LLC.
Teresa Dixon, Business Lead [email protected] Richard Beeson, Lead Architect [email protected] Mark Hughes [email protected]
![Page 69: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/69.jpg)
Thank you
© Copyright 2011 OSIsoft, LLC.
![Page 70: Servers Analytics Clients Data Access - OSIsoftcdn.osisoft.com/corp/en/media/presentations/2011/Users...+65K videos/day 45 TB US demographics 250 TB 70K calls/sec 2.85 TRow 1.9 trillion](https://reader031.vdocuments.us/reader031/viewer/2022022700/5bb99ca709d3f2d4678bd947/html5/thumbnails/70.jpg)
70 © Copyright 2011 OSIsoft, LLC.