[prev] [index] [next]

Stored Procedures

Stored procedures
  • procedures/functions that are stored in DB along with data
  • written in a language combining SQL and procedural ideas
  • provide a way to extend operations available in database
  • executed within the DBMS   (close coupling with query engine)
Benefits of using stored procedures:
  • minimal data transfer cost SQL ↔ procedural code
  • user-defined functions can be nicely integrated with SQL
  • procedures are managed like other DBMS data (ACID)
  • procedures and the data they manipulate are held together