SQL Based Data Access
This presentation is the property of its rightful owner.
Sponsored Links
1 / 18

SQL Based Data Access Bodo Bachmann PowerPoint PPT Presentation


  • 144 Views
  • Uploaded on
  • Presentation posted in: General

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,...).

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.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


Sql based data access bodo bachmann

SQL Based Data Access

Bodo Bachmann


Agenda

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,...)


Data access overview

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


Data access via pi oledb

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


Sql based data access bodo bachmann

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


New architecture

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


New resource management

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


Roadmap

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


Pi jdbc architecture details

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


Pi jdbc

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


Pi jdbc demo

PI JDBC Demo

  • getSnap JDBC application

  • Compile in Windows version of Eclipse

  • Run on Windows and Linux without additional work


Pi jdbc demo1

PI JDBC Demo

  • Linux (ubuntu)

  • DBVisualizerallows to access and explore any jdbc Driver

  • PI JDBC (Bridge)talking to PI OLEDB


Pi oledb 64bit

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


Pi oledb 64bit1

PI OLEDB 64bit

  • check version via architecture column in piproductversion table


Pi oledb 64bit2

PI OLEDB 64bit

  • Increased performance for large resultsets


Pi system oledb v1 architecture details

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


Sql based data access bodo bachmann

PI System OLEDB v1 Demo


Summary

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


  • Login