STORED PROCEDURE
\stˈɔːd pɹəsˈiːd͡ʒə], \stˈɔːd pɹəsˈiːdʒə], \s_t_ˈɔː_d p_ɹ_ə_s_ˈiː_dʒ_ə]\
Sort: Oldest first
-
A subroutine stored in a database and executedby the database management system. The subroutine may bewritten in the same language in which the database is queriedand may be precompiled to improve performance.Typically a stored procedure encapsulates some businessprocess. Performing this on the database server avoids thenetwork overhead of transferring input data to the client forprocessing. This would be particularly significant ifprocessing lots of data and returning a small result set likea total or maximum. Stored procedures also provide consistentimplementation of the business logic to clients written indifferent languages and running in different environments.Some financial systems allow databases access through storedprocedures alone, this restricts actions on the data to asmall number of auditable queries.Sybase SQL Server (Adaptive Server Enterprise) was the firstcommercially successful RDBMS to support stored procedures.
By Denis Howe
Word of the day
basidiomycota
- comprises fungi bearing the spores on basidium: Gasteromycetes (puffballs); Tiliomycetes (comprising orders Ustilaginales (smuts) and Uredinales (rusts)); Hymenomycetes (mushrooms; toadstools; agarics; bracket fungi); in some classification systems considered a division of kingdom comprises fungi bearing spores on a basidium; includes Gasteromycetes (puffballs) Tiliomycetes comprising the orders Ustilaginales (smuts) and Uredinales (rusts) Hymenomycetes (mushrooms, toadstools, agarics bracket fungi).
Nearby Words
- store-room
- store-ship
- stored
- stored messenger rna
- stored mrna
- stored procedure
- stored-up
- storefront
- storehouse
- storekeeper
- storer