Skip navigation
All Places > PI Developers Club > PI SQL Data Access Technologies > PI SQL Data Access technologies
ray

Naming the next OLEDB Provider

Posted by ray Employee Feb 1, 2017

We are working on a new SQL query processing engine for our PI SQL family of products. The main goals are to improve the scalability and performance of our SQL processing. While we are at it, we will update the design of our tables just a bit to simplify some common query patterns. The query engine will be implemented in an updated PI SQL Data Access Server (PI SQL DAS) which means that, over time, the PI ODBC Driver, PI JDBC Driver and PI OLEDB providers will evolve to take advantage of it.

 

The current PI OLEDB Enterprise and PI OLEDB Providers do their own query processing, but the new OLEDB provider will be a lightweight provider that talks to the PI SQL DAS to process queries. The new OLEDB provider will need to coexist with the current providers. So, one of our problems is that we need a new name for the new OLEDB provider. Our favorite so far is "PI SQL Client OLEDB." Can you think of a better name? We'd like your suggestions!

I am pleased to announce the release of several products in the PI SQL Framework which are members of the PI Developer Technologies suite of products:

All of these products provide access to PI System data through SQL queries. Click on these product names to see the Product Release Announcements on the Technical Support website for details. There are just too many enhancements and bug fixes to list them all here. Congratulations to the OSIsoft PI SQL development team on these significant releases!

Details are in my blog post here.