 |
SQL Advanced Quering
In typical client/server database application environments, applications attempt to execute user database requests immediately, as soon as a user presses the OK button. The client then waits for the results to return before continuing work. However, some systems might prefer or even require that an application queue user requests for deferred execution. For example, demanding client/server systems might want to queue and defer the execution of low-priority transactions to less taxing off-peak hours. This allows the system to perform more critical work optimally during normal business hours Workflow dependent applications, where the completion of one step in a business process cannot take place before another step completes, are another type of application that can benefit from the deferred execution of user transactions. Oracle8's new advanced queuing feature is a database-centric alternative for applications that would like to defer the execution of database transactions. Oracle applications can use Oracle's PL/SQL-based application programming interface (AP1) to queue transactions for deferred execution, prioritize their execution, set acceptable execution times for transactions, and more. Clients can review deferred transaction results after execution occurs. Meanwhile, queued transactions are automatically protected by Oracle8's backup and recovery mechanisms.
Domain Name Search
|
