|
Development |
Stored Procedures |
Oracle DB2
|
OverviewStored procedures are collections of statements stored in the relational database management system, that are executed repetitively to perform various tasks. They can perform data validation and execute queries, as well as enable transaction management in applications. More importantly, they allow much of the programming logic to be removed from the application and placed in the database, developed and maintained in a single location for consistent results throughout all applications accessing a single database. Most of the major relational database systems provide stored procedures and Omnidex offers a stored procedure interface to work with them. The application can take advantage of the speed of the Omnidex indexes for data retrievals, without sacrificing the excellent data management features available in the RDBMS. When using stored procedures, Omnidex is generally used strictly for qualifying rows, which is what Omnidex is best at. The RDBMS handles all data validation, transaction and updates, while the Omnidex indexes are maintained behind the scenes either in a batch process or through the Omnidex utility ODXAIM. In either case, the indexes are not synchronized, although the latter can be only a slight delay in synchronization. Note that is only an issue in update applications.
|
|
APIs | SQL Reference | Stored Procedures | Third Party Tools | Debugging |
OmniAccess API |
ODBC |
JDBC |
Nested Queries |
SET Operations |
WITH Options |
CURSOR / INSTANCE |
Commands |
Functions |
SQL Server |
Oracle |
MS Access |
Ms Excel |