stored procedure


Also found in: Acronyms, Wikipedia.

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 ?
Administrators can now create logical data model entities based on stored procedures.
The sp_sp10() stored procedure contains a SQL query SELECT * FROM table10, which selects every filed from the table10 table of the MySQL database.
3 that adds controls and analytics for all stored procedures on the database, providing a fine-grained snapshot into all procedures and immediate notification of any content changes.
1's integrated debugger can be used to develop and analyze stored procedures, functions and triggers in applications written for EnterpriseDB, Oracle and PostgreSQL databases.
0 will include features such as stored procedures and triggers.
Key innovations included the industry's first model-driven database access capabilities for a business rules system which acts as an alternative to stored procedures and SQL coding.
Virtuoso enables the publishing of Persistent Stored Modules -- SQL Stored Procedures, Java Objects, and .
Since many developers are using Java as an alternative to PL/SQL, SQL Navigator's Java support provides the ability for users to build Java stored procedures and execute Java commands.
Permission Control - Determines who has access to stored procedures and alerts when there is a possible threat of database users gaining unauthorized permissions on Windows NT files and resources.
The compatibility of the ANTs-based Genero db was exceptional, achieving 100 percent compatibility with all the application code and even the stored procedures, which are usually impossible to migrate," said Bryn Jenkins, chief operating officer of Four J's Development Tools, Inc.
In addition, EnterpriseDB's mature support for advanced enterprise database features like triggers and stored procedures and its blazing-fast performance make EnterpriseDB Advanced Server a perfect fit for us.
Providing complete and secure data management capabilities through formulated queries, stored procedures, and custom SQL statements.