Versant SQL (V/SQL) data query is an add-on module for the Versant Object Database for enhanced query performance. V/SQL data query provides a Structured Query Language (SQL) based data query interface to access data that resides in a Versant object database.

How V/SQL Data Query Works

V/SQL data query allows programmers to access objects in a Versant database via SQL statements. V/SQL Data Query Suite uses object to relational transformation rules to help map the objects into a relational view. The tool provides the following principle features:

• Dynamic Mapping: V/SQL data query is able to map the class schema of any Versant database into a "virtual" relational schema.
• Query Performance: V/SQL data query uses navigational access based on the relationships defined in the object schema whenever joins are attempted between tables.
• Standard SQL-92 with no extensions: Instead of extending SQL-92 with object-oriented extensions, V/SQL data query is based on standard SQL-92 to present an ER representation of the class schema. This has the benefit of allowing ODBC compliant tools to access Versant databases.
• Scalable: V/SQL data query uses cursors to access the Versant database allowing efficient use of resources and enabling a quick response to the query. The object cache is maintained by Versant/SQL data query engine and the main memory storage system cache size is configurable.
• Security: V/SQL data query provides full SQL-92 security over and above the user access list security provided by the Versant object database management system.

Availability

The Versant SQL data query add-on module is currently available for the following platforms:

• Windows (32 and 64 bit)
• Solaris Sparc (32 and 64 bit)
• Solaris Intel (64 bit)