With this release, RDM Server’s comprehensive SQL capabilities are extended with additional support for SQL Triggers and UNIONS as defined in the SQL92 standards.
SQL Triggers- In addition to supporting C triggers, RDM Server now also supports SQL Triggers. A SQL trigger is procedural code that is automatically executed in response to an insert, update, or delete event on a database table. The procedural code runs in the same transaction context as it was triggered and is tremendously useful in maintaining the data integrity. Having the power to void a transaction that breaks pre-defined business rules is extremely useful when designing complex database applications. For example, when a new record is added to an employee’s table, new records should also be created in the employee vacation and salary tables. The latter two operations are business rules triggered by the creation of the employee. The salary table may have a pre-defined max salary value which can invalidate the creation of the employee if the manager tries to associate a higher salary for the new employee, violating the corporate rules.
SQL Unions- The SQL UNION clause combines the results of two queries into a single resultset of all matching rows. The two queries must have the same number columns and is useful in data warehouse applications where tables aren’t perfectly normalized. A simple example would be a database having tables ip_traffic_january and ip_traffic_february that have identical structures but are separated due to performance considerations. The union operation will join the results from the two tables into a single resultset as if the application was viewing a single table. However, because the data is stored in two separate tables, inserts will be executed faster by maintaining smaller independent sets of data in associated index structures.
"We’ve always had a commitment to industry standards, and by extending our SQL92 compliancy we’re allowing Raima embedded database users to mix and match propriotory high performant API’s with an even greater degree of compliant SQL API’s, powering today’s complex embedded applications", said Duncan Bates VP of Product Management for the Raima Database Products. "The value of standard SQL has been proven over the last decades in the enterprise and is just as important to embedded applications. We’re happy to offere the embedded market these new capabilities".