stored procedure

(redirected from Sproc)

stored procedure

(database)
A subroutine stored in a database and executed by the database management system. The subroutine may be written in the same language in which the database is queried and may be precompiled to improve performance.

Typically a stored procedure encapsulates some business process. Performing this on the database server avoids the network overhead of transferring input data to the client for processing. This would be particularly significant if processing lots of data and returning a small result set like a total or maximum. Stored procedures also provide consistent implementation of the business logic to clients written in different languages and running in different environments.

Some financial systems allow databases access through stored procedures alone, this restricts actions on the data to a small number of auditable queries.

Sybase SQL Server (Adaptive Server Enterprise) was the first commercially successful RDBMS to support stored procedures.

stored procedure

In a database management system (DBMS), it is an SQL program that is stored in the database which is executed by calling it directly from the client or from a database trigger. When the SQL procedure is stored in the database, it does not have to be replicated in each client. This saves programming effort especially when different client user interfaces and development systems are used. Triggers and stored procedures are built into DBMSs used in client/server environments.
References in periodicals archive ?
Decon-Cycle, Decon Sproc 200 Plus from TricorBraun won and industrial packaging award for its HDPE container that separates a concentrate from water, allowing the two to mix when ready.
Sproc, SC, USN, Material Officer and Quality Assurance Division Officer, USNS Saturn (T-AFS 10), April 2007 to November 2008.
SGI MPI in IRIX 6.5 uses the default space/time scheduling and does not allow users to specify gang-scheduling (a mechanism that turns on gang-scheduling using schedctl() for an SPROC job does not work for this new SGI MPI version) [Salo 1998].
We use the IRIX SPROC library because performance of IRIX Pthreads is not competitive with SPROC.
The Sales/Disbursing Officer, ENS Brent Sproc, teamed up with SHC Ron Magee, SH1 Nicholas, SH1 Charles, and PS1 McLeod to transfer the remaining Ship's Store inventory, and shut down sales and disbursing operations.
ENS Sproc turned in the last of his cash early on and then turned his attention to the details of the remaining paperwork required to settle Saipan's account with Defense Finance and Accounting Service (DFAS).