Eliminating volumes of code that would otherwise be needed to transform object models to relational models saves hours of development time and dramatically reduces maintenance costs. The SQL parser converts SQL statements into the most efficient Versant execution form. Join optimizations are made based on join order and cardinality of tables. Index optimizations include support for dynamic indexes, multi-attribute indexes, and sort elimination. Customers can develop and deploy a Versant Object Database Management System using the tools they already own without extensive retraining.
Organizations can choose the technologies and tools that best meet the needs of the users.
These graphical tools provide easy, familiar access to the objects contained in a Versant database. This support includes outer joins, union operations, ODBC-compatible scalar functions, and extended data types. It can also maintain a corresponding relational schema for the purpose of using SQL and ODBC tools. These are only two examples of the many transformations that are performed. The use of database cursors to access Versant databases is an efficient use of system resources that improves query performance.