Dictionary: A   B   C   D   E   F   G   H   I   J   K   L   M   N   O   P   Q   R   S   T   U   V   W   X   Y   Z

Stored procedure

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.


Read Also:

  • Storefront

    noun 1. the side of a store facing a street, usually containing display windows. 2. a store or other establishment that has frontage on a street or thoroughfare: After the fire the family took shelter temporarily in an abandoned storefront. adjective 3. of or relating to the frontage of a store, especially the display windows: […]

  • Storehouse

    noun, plural storehouses [stawr-hou-ziz, stohr-] /ˈstɔrˌhaʊ zɪz, ˈstoʊr-/ (Show IPA) 1. a building in which things are stored. 2. any repository or source of abundant supplies, as of facts or knowledge. noun 1. a place where things are stored

  • Storekeeper

    noun 1. a person who owns a store. 2. a person who has charge of or operates a store or stores. 3. U.S. Navy. a petty officer in charge of a supply office afloat or ashore. noun 1. a manager, owner, or keeper of a store

  • Store of value

    noun 1. (economics) the function of money that enables goods and services to be paid for a considerable time after they have been acquired

Disclaimer: Stored procedure definition / meaning should not be considered complete, up to date, and is not intended to be used in place of a visit, consultation, or advice of a legal, medical, or any other professional. All content on this website is for informational purposes only.