Birdstep Technology Inc. Raima Division releases RDM Server 8.3 with enhanced SQL support. RDM Server's already comprehensive SQL capabilities are extended with additional support for SQL Triggers and UNIONS as defined in the SQL92 standards.
(PRWEB) November 6, 2009 -- Birdstep Technology Inc. Raima Division (OSE: BIRD), which offers state-of-the-art embedded database technologies, today announced the release of its high availability and high performance, embedded client/server database product RDM Server version 8.3. This release of RDM Server includes key enhancements to the product’s interoperability capabilities.
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 result set 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 proprietary 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 offer the embedded market these new capabilities.”
The new RDM Server 8.3 SDK is available for immediate download at: http://www.raima.com/products/rdm-server/sdk-download/
About The Raima Database Manager Family
Raima released the first version of the Raima embedded database in 1984. Since then the family has grown into two successful embedded database products. RDM Embedded pioneered the embedded market space under the name dbVista. Building on the success of RDM Embedded, Raima released the product in a client/server configuration under the name Velocis, now called RDM Server. Please find free SDK downloads of the RDM Products at http://www.raima.com/downloads/
About Birdstep Technology, Inc
Birdstep Technology, Inc., a wholly owned subsidiary of Birdstep Technology ASA, is a leading provider of high-performance embedded database solutions known as the Raima Database Manager product-line. Since 1984, the company has been focused on solving data management problems in a wide variety of verticals such as Aerospace & Defense, Telecom, Financial, Consumer Electronics, Medical, Industrial Automation, Business Automation and more. With over 20,000 application developers, resulting in over 20,000,000 deployments, Birdstep continues to lead in the worldwide demand for embedded database technology.
###
