Enhanced SQL Support
RaimaDB is one of the very few embedded database systems that supports the INCITS/ISO/IEC 9075-2:2011 [2012] SQL standard. The feature-rich SQL component allows for very rapid and simple deployment of an SQL database system using RaimaDB, while also allowing flexibility to later concurrently use the more optimized core cursor API with the same system. RaimaDB’s SQL PL feature allows for a SQL developer to create more advanced logic within their SQL database system without having to learn a more complicated programming language like C/C++/C#/Java.
SQL PL
The SQL Procedural Language feature of the RaimaDB database system allows for a SQL database developer to access full programming constructs purely in SQL. They can create conditional statements, for and while loops, declare and use variables, all while using only SQL. There is even error handling support for custom error situations. Additionally, these statements are compiled and executed on the server-side, greatly improving the performance of the overall system.
SQL Triggers
SQL triggers are a form of SQL PL that lets the SQL developer create custom events to occur when certain conditions are met in a normal create/insert/update/delete SQL statement. They can be simple things like returning an error if an insert is out of the bounds of a column, or more complicated things, like updating a further table/row if certain conditions are satisfied.
SQL Interfaces
RaimaDB supports multiple different programming languages that interact with the SQL engine. For C#, Raima supports the ADO.NET interface. For Java, Raima supports JDBC. For C/C++, Raima has full ODBC support. RaimaDB is designed so that whatever language the programmer is comfortable with, they can stay within that environment/IDE.
RaimaDB SQL features for embedded systems
- Database schemas in pre-compiled C modules
- SQL stored procedures in pre-compiled C modules
- User defined SQL functions, written in C
- Virtual tables for accessing any kind of source data through SQL (e.g. real-time data fed from sensors)
- Limit the number of rows returned from select, by number or by time
- SQL applications don’t need to compile any SQL at runtime
- Rowid (i.e., database address) primary and foreign keys which will allow direct access to individual rows of a table without having to incur the overhead of an index.
- Updateable query optimization statistics
- Supports forward/backwards static scrollable cursors
RaimaDB SQL features for distributed systems
- Connect to multiple servers
- Query distributed databases (scale-out)
- Database unions: (Results merged, as if one database)
As an embedded database, RaimaDB’s enhanced SQL support permits developers to work as they prefer, and helps businesses meet big data needs related to cloud
Get started with RaimaDB today
Try RaimaDB for free today and see how screaming fast data management can get you to market on schedule and under budget.
