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-2025 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.

Mentioned in

References in periodicals archive

- Administrators can now create logical data model entities based on stored procedures.

Latest ActiveReports Server Release by GrapeCity Enhances Embedded Ad Hoc Reporting Capabilities

The sp_sp10() stored procedure contains a SQL query SELECT * FROM table10, which selects every filed from the table10 table of the MySQL database.

Performance of database driven network applications from the user perspective

This includes creating stored procedures or functions for code reuse.

Benefits of LXI and scripting

Write the code to create the following stored procedures.

Remote Services, Inc

Any CACHE object method or stored procedure can automatically be exposed as a Web Service, with full SOAP and WSDL support.

CACHE 5 released. (Database Products)

Available by the end of 2003, MySQL Version 5.0 will include features such as stored procedures and triggers.

OPEN SOURCE SOFTWARE RECEIVES RECOGNITION THROUGH LINUX

Intended for experienced programmers familiar with MySQL, this guide describes advanced techniques for designing MySQL databases and applications with chapters on storage engines, benchmark and profile tools, index optimization, stored procedures and functions, cursors, views, and triggers.

Pro MySQL

Virtuoso enables the publishing of Persistent Stored Modules -- SQL Stored Procedures, Java Objects, and .NET Objects -- as SOAP, WSDL, and UDDI compliant Web Services.

OPENLINK'S VIRTUOSO 2.7 SUPPORTS ODBC/JDBC DATABASES