Enhanced SQL Support
The SQL Procedural Language feature of the RDM 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 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.
RDM 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
RDM 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, RDM’s enhanced SQL support permits developers to work as they prefer, and helps businesses meet big data needs related to cloud
Get started with Raima Database Manager today
Try Raima Database Manager for free today and see how screaming fast data management can get you to market on schedule and under budget.