1 / 18

SQL Based Data Access Bodo Bachmann

SQL Based Data Access Bodo Bachmann. Agenda. New Architecture Motivation PI SQL Data Access Server (PI SQL DAS) Roadmap PI JDBC PI SQL DAS 1.0 Cross Platform Demo PI OLEDB 64bit (x64) Details PI System OLEDB Provider 1.0 Functionality Demo Future (Tag based data, Event Frames,...).

agamemnon
Download Presentation

SQL Based Data Access Bodo Bachmann

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. SQL Based Data Access Bodo Bachmann

  2. Agenda • New Architecture • Motivation • PI SQL Data Access Server (PI SQL DAS) • Roadmap • PI JDBC • PI SQL DAS 1.0 • Cross Platform Demo • PI OLEDB 64bit (x64) • Details • PI System OLEDB Provider 1.0 • Functionality • Demo • Future (Tag based data, Event Frames,...)

  3. Data Access - Overview PI Data is available via common standards Data Access RtBaseline Services for Thin Clients OLEDB ODBC OPC • WebServices (i.e. RtBaseline Services) – Provide Data to Web Applications • OLEDB – Data Access via SQL Queries • ODBC – Data Access via SQL Queries • OPC DA/HDA/UA – Data Access to the PI System via OPC Standard

  4. Data Access Via PI OLEDB PI OLEDB provider allows applications (OLE DB consumers) working with PI data through SQL queries: Next Generation – Motivation: renew PI OLEDB Architecture introduce JDBC and other data provider standards support „PI System“ OLE DB/COM Client Application PI Server SQL Engine SQL Queries OLE DB Consumer PI OLEDB Provider

  5. AF in the PI System • Data structured and organized by Assets • Spans multiple PI Systems • Incorporates non time series Data PI Server 1 PI Server 2 AF Vendor Specific Interfaces Vendor Specific Interfaces Generic Interfaces Generic Interfaces Asset-Equipment Centric access to the Data Honeywell Interface Honeywell Interface ABB Interface ABB Interface Delta-V Interface Delta-V Interface Rockwell Interface Rockwell Interface OPC Interface OPC Interface XML Interface XML Interface Modbus Interface Modbus Interface SNMP Interface SNMP Interface Time Series Data Sources Time Series Data Sources Non Time Series Data Sources … … … Honeywell Honeywell ABB ABB Delta-V Delta-V Rockwell Rockwell Other Other SCM RDBMS MES Time Series Data Time Series Data „Meta“-Data

  6. New Architecture PI SQL DAS Network Network • Multi-standard andmulti-platform architectureOne connection allows querying multiple data sources • Standard implementation separated from SQL functionality • Prepared for heterogenious query engine Consumer / Client Consumer / Client Consumer / Client Consumer / Client New SQLStandards ODBC (possible) OLE DB JDBC Third party data source PI Servers AF Database

  7. New Resource Management Consumer / Client Consumer / Client OLE DB JDBC PI SQL DAS PI DAS Network Network • Paging • Protects server from huge data requests • Decreases memory requirements • Caching • Smart memory management • PI SQL DAS Deployment optionsfor example: • 1x PI SQL DAS for Web Farm • 1x PI SQL DAS for Reporting • 1x PI SQL DAS for Clients Third party data source PI Servers AF Database

  8. Roadmap 2008 2011 Use of new Architecture Components PI JDBC PISysODBC PISysJDBC PISysOLEDB PISysOLEDB PI SQL DAS PI SQL DAS PI OLEDB SQLEngine SQLEngine SQLEngine AF Server AF Server / BLS PI Server PI System PI System

  9. PI JDBCArchitecture Details PI SQL DASprotocol Network • PI JDBC • Windows + Linux • requires PI OLEDB • meant to support Java server apps Client Application Multi-Platform(Windows, Linux) PI JDBC WCF RDSA RDSA https WCF C++ PI OLEDB PI Servers

  10. PI JDBC • PI JDBC Details • bridge to PI OLEDB (Type 1 JDBC driver) • based on JDBC 4.0 API (Java Platform SE 6) • same table structure, same SQL functionality as PI OLEDB • Multiplatform • Will work on many Linux Distributions • Testing concentrates on Windows, Novell Suse Linux Enterprise Server and Red Hat Enterprise Linux • best option for JAVA based development • Limitations • PI OLEDB is multithreaded but not designed as backend • additional communication infrastructure overhead • amount of supported OS limited because network component is OS specific

  11. PI JDBC Demo • getSnap JDBC application • Compile in Windows version of Eclipse • Run on Windows and Linux without additional work

  12. PI JDBC Demo • Linux (ubuntu) • DBVisualizerallows to access and explore any jdbc Driver • PI JDBC (Bridge)talking to PI OLEDB

  13. PI OLEDB 64bit • can coexist with 32bit PI OLEDB version on 64bit Windows (x86-x64) • transparent to applications if both versions installed • required for 64bit SQL Server Linked Server • requires 64bit PI SDK • comes as seperate setup kit

  14. PI OLEDB 64bit • check version via architecture column in piproductversion table

  15. PI OLEDB 64bit • Increased performance for large resultsets

  16. PI System OLEDB v1 Architecture Details Network • PISysOLEDB version 1 • Windows based • Linked to AF SDK (bypass object model) • Access via AF Server • Read-only Consumer PISysOLEDB AF SDK SQLEngine AF Server Third party data source PI Servers AF Database

  17. PI System OLEDB v1 Demo

  18. Summary • Upcoming releases • PI JDBC • PI OLEDB 64bit • Release schedule ~ Q2/2009 • PISysOLEDB v1 • Beta scheduled ~ Q2/2009 • Release schedule ~ Q4/2009 • PI SQL DAS v2 based products in development • PISysOLEDB v2 • PISysJDBC

More Related