Object Middleware for CMS

---

Our first implementation of these software layers are in a specific CMS project, the Grid Enabled Analysis Environment (GAE).  As part of this project, we convert large amounts of SQL data into ROOT trees.  We would like to provide the isolation layers mentioned above for this project, and we target our client code into a heterogeneous environment (Redhat 6.2, 7.1, Solaris, Win32, etc.).

The ODBC layer mentioned above is comprised of two layers, namely:

• 1. ODBC Driver Manager:  On Linux, Sun we use software from either unixODBC, or iODBC.  On Win32, the driver manager comes pre-installed.

• 2. Specific Database ODBC Drivers:  We target initially Oracle and SqlServer.  On Win32, both these driver are supplied by the respective database vendors.  On *nix, these packages are supplied for SqlServer by FreeTDS and for Oracle by an open source project archived at Fermilab.

Sample source code for the GAE SQL to ROOT converter can be found here.  The software is packaged along with a Grid-optimized remote procedure call layer called CLARENS.  CLARENS also performs Grid authorization, ensuring that rpc requests come from appropriate clients.  SQL2Root was designed to be a CLARENS plugin.

<Previous

Next>