|
Query Technology for Database Developers
Dharma SQLengine
Dharma SQLengine, the core component in our advanced query technology, is a high performance optimizing SQL engine that provides the ultimate in power and flexibility. As part of our Dharma/SQL product, it has been designed to plug into any relational or non-relational database architecture and provide a functionally-complete SQL interface compatible with the SQL-92 standard.
The SQLengine component allows development organizations to build more scalable, high performance, open systems by providing the flexibility to access the full power of the database using SQL. Faster development and deployment is the result of giving your developers and users more flexible and easy, standard access to your database.
Tailored for high demanding production environments, the SQLengine includes optimizations found in industry-leading commercial DBMS solutions. Sophisticated query rewrite techniques improve nested query performance. Join-order optimization improves performance of queries joining many tables. The SQLengine extensively caches and buffers information for maximum transaction and query throughput.
The SQLengine component provides innovative optimizations geared towards the needs of your database. In environments where index creation is not possible, Dharma SQLengine dynamically builds indexes to dramatically improve join performance. In environments with built-in navigation elements, the Dharma SQLengine optimizer uses hash joins to take advantage of the proprietary navigation structures.
Dharma SQLengine is known for its reliability and for our continuing product enhancements and available support.
Review the SQLengine Fact Sheet
|
