PI-ODBC (Server)
The PI-ODBC Server for the PI Data Archive enables the PI database to appear and act like a relational database any ODBC-compliant client application. Structured Query Language (SQL) and Open Database Connectivity (ODBC) are standardized methods for retrieving data from relational databases. ODBC is a standard method for programs to send SQL statements to a database. The database executes the SQL statements and sends the results to the client via ODBC. Most relational database vendors and numerous other database suppliers, including OSI, support ODBC as a way to retrieve data.
Using PI-ODBC Server users can store process information in the PI-Data Archive that is ideal for storing time-oriented data and then use standard ODBC calls to access values. Relational databases contain tables that are generally used for applications not directly related to continuous data collection, such as raw material control, production scheduling, and monitoring product quality versus customer specifications. Typically these applications include summary data of the process because a relational database is not designed to accommodate the raw data. With PI-ODBC, the data resides in the PI-Data Archive and the desired summary data are actually a "virtual table" created on demand when a call is executed. PI-ODBC supports the following summary "tables" , which can be applied to most variables for any time period:
Total (pitotal)
Minimum (pimin)
Maximum (pimax)
Standard deviation (pistd)
Time weighted average (piavg)
Arithmetic average (pimean)
PI-SQL Subsystem
The PI-SQL subsystem prepares and executes SQL statements directed at the PI Server. The primary user of this subsystem is the PI-ODBC Driver.
<%=company%>, 777 Davis Street, San Leandro, CA 94577. Tel: 510-297-5800 Fax: 510-357-8136