Stored Procedures

1
Stored Procedures
IS2080 Data Management

• Dr. Meg Murray
• mcmurray_at_kennesaw.edu

2
Extending SQL

• SQL has limitations
• Stored Procedures allow Database developers to
  add program like code and logic to SQL
• A stored procedure is a program that is stored
  within the database and is compiled when used
• In Oracle, it can be written in PL/SQL or Java
• In SQL Server, it can be written in TRANSACT-SQL
• Stored Procedures are not supported in MS-Access

3
(No Transcript)
4
Stored Procedures

• We wont be learning how to create Stored
  Procedures in this class (covered in the advanced
  database course)
• However, you should be aware that in enterprise
  database systems, most SQL commands are contained
  in Stored Procedures

5
Stored Procedure Advantages

• Greater security as store procedures are always
  stored on the database server
• Decreased network traffic
• SQL can be optimized by the DBMS compiler
• Code sharing results in
• Less work
• Standardized processing
• Specialization among developers

6
Stored Procedure Tutorial

• http//adbc.kennesaw.edu