Simba SQL Engine is a component of SimbaEngine SDK. It provides SQL processing in data drivers and data providers for non-SQL data stores
built with SimbaEngine SDK. Simba SQL Engine can also be used in custom solutions where SQL parsing or execution is required.
SimbaEngine SDK supports a wide variety of implementations to meet your project and system requirements. Have questions about which deployment is best for you? Ask Simba's data connectivity experts.
Simba SQL Engine is a complete, compatible, high-performance and easy-to-use solution for SQL processing on non-SQL data stores. Everything you need to prepare and execute SQL queries is included with a clean and logical interface. With compliance to the SQL-92 standard, it is carefully designed to support common reporting and BI tools, but it can be extended to implement any SQL function or feature.
- SQL Support for Non-SQL Data Stores – Use Simba SQL Engine to enable SQL queries to non-SQL data sources – such as web services, object-oriented, network, real time (e.g. SCADA) and ISAM databases – or use it in a custom solution and call it from your own code. Simba SQL Engine makes object-oriented, hierarchical or other non-tabular data available to common desktop tools such as Excel. Simba SQL Engine allows you to embed SQL parsing or execution into your product.
- Scalar Functions – Support is provided for over 60 scalar and aggregate functions.
- 32- and 64-bit Support – Simba SQL Engine natively supports both 32-bit and 64-bit platforms, including Windows, Linux, UNIX.
- ODBC 3.52 Support – Simba SQL Engine provides comprehensive support for ODBC 3.52 data types.
- Unicode Support – Simba SQL Engine supports ANSI and Unicode UTF-8, -16 and -32 for both data and metadata. This allows your customers to access their data in virtually any language, resulting in the widest interoperability.
- Collaborative Query Execution – Simba SQL Engine's innovative Collaborative Query Execution feature allows your data store to execute the parts of the query for which it is designed and dynamically leave the rest of the query to be executed by the Simba engine. Because Simba SQL Engine does not redundantly execute the same parts of the query as your data store, your SimbaEngine SDK data driver or data provider delivers the full performance of your data store.
- Pass-Down Processing – Table filters, joins and aggregations can be passed down to your data store for execution if your data store is optimized for those functions.
- Stored Procedures – Simba SQL Engine supports Stored Procedures.
The Simba SQL Engine parser conforms to the SQL-92 specification, but it can be extended to implement any SQL function or feature. When Simba SQL Engine prepares a SQL statement, it validates the tables and columns referenced in the statement against the metadata from the underlying data store. Then it creates an intermediate version of the query called the Algebraic Expression Tree (AETree).
The AE-Tree is eventually transformed into an Execution Tree for query execution. By carefully moving or modifying nodes, the AE-Tree can be updated to change the way the query is executed without changing the result. The underlying data store can modify the AE-Tree, so that when the query is executed, Simba SQL Engine delegates some or all of the processing to the underlying data store. We call this Collaborative Query Execution. This ensures the utmost performance and intregrity of any specialized processing and optimizations within your data store. If the entire query can be delegated, Simba SQL Engine will only retrieve the result set. This is particularly important for analytical databases with built-in, high-performance aggregation processing that end users expect to see even through ODBC.
Download a free 30-day evaluation of SimbaEngine ODBC SDK.
