stored procedure

(redirected from Stored procedures)

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.
This article is provided by FOLDOC - Free Online Dictionary of Computing (foldoc.org)

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.
Copyright © 1981-2019 by The Computer Language Company Inc. All Rights reserved. THIS DEFINITION IS FOR PERSONAL USE ONLY. All other reproduction is strictly prohibited without permission from the publisher.
References in periodicals archive ?
Besides, Entity Developer, LinqConnect, and dotConnect fully support PostgreSQL 11 stored procedures, which can be used in mapping, etc.
In some cases, SQL queries allow access to server operating system commands using stored procedures. Stored procedures are usually bundled with the database management server.
"Murach's SQL Server 2016 for Developers" also shows how to design a database, how to implement that design, and how to work with database features like views, scripts, stored procedures, functions, triggers, transactions, security, XML data, BLOB data with FILESTREAM storage, and the CLR integration feature.
In the database's final form, investigators for the OTP could use stored procedures to search for calls made and received by different phones over any specified timeframe.
Sakila sample database also serves to highlight the latest features of MySQL such as Views, Stored Procedures, and Triggers" (Sakila, 2013b).
Stored procedures are subroutines in the database which the applications can make call to [15].
"You can compile your stored procedures and run them as native machine code," Leland said.
Agni Link uses a variety of technologies to integrate ERP to CAD, including SQL queries, SQL stored procedures, XML export, and plain text export.