SQL Access & Reporting

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

How V/SQL Works

V/SQL allows programmers to access objects in a Versant database via SQL statements.  V/SQL 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 is able to map the class schema of any Versant database into a "virtual" relational schema.
• Query Performance: V/SQL 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 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.
• Scaleable: V/SQL 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 engine and the main memory storage system cache size is configurable.
• Security: V/SQL 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 add-on module is currently available for following platforms:

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