stored procedure

Computing Dictionary

stored procedure definition

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.
(2004-03-04)

The Free On-line Dictionary of Computing, © Denis Howe 2010 http://foldoc.org
Cite This Source
Explore Dictionary.com
Previous Definition: storebought
Next Definition: stored program
Words Near: stored procedure
More from Thesaurus.com
Synonyms and Antonyms for stored procedure
More from Reference.com
Search for articles containing stored procedure
Dictionary.com Word FAQs

Dictionary.com presents 366 FAQs, incorporating some of the frequently asked questions from the past with newer queries.

Copyright © 2014 Dictionary.com, LLC. All rights reserved.
  • Please Login or Sign Up to use the Recent Searches feature