A stored procedure is a set of statements/commands which reside in the database. The stored procedure is pre-compiled and keeps the database the effort of parsing and compiling sql statements each time a query is run. Every database has its own stored procedure language, usually a variant of C with a SQL preproceesor. Newer versions of db's support writing stored procedures in Java and Perl too. Before the advent of 3-tier/n-tier architecture it was pretty common for stored procs to execute the business logic( A lot of systems still do it). The biggest advantage is of course speed. Also certain kind of data manipulations are not achieved in SQL. Stored process gives a mechanism to do these manipulations. Stored process is also useful when you require to do Batch updates/exports/house Keeping kind of stuff on the db. The overhead of a JDBC Connection may be important in these cases.

 

Posted Date: 4/20/2013 5:21:51 AM | Location : United States

Ask an Expert

Related Discussions:- What are stored procedures? how is it useful?, Assignment Help, Ask Question on What are stored procedures? how is it useful?, Get Answer, Expert's Help, What are stored procedures? how is it useful? Discussions

Write discussion on What are stored procedures? how is it useful?
Your posts are moderated

Write your message here..

Related Questions

Important Nodes, onstraints: 1 1 1 1 0 1 1 1 onstraints: 1 1 1 1 0 1 1 1

What is aop alliance, AOP Alliance is an open-source project whose goal is ... AOP Alliance is an open-source project whose goal is to promote adoption of AOP and interoperability between different AOP implementations by describing a common set of interfaces

Describe about user security issues and social engineering, Describe about ... Describe about User Security Issues and Social Engineering ? Contrary to popular belief most computer break-ins through external hackers don't happen since of great knowledge

Explain the purpose of the recovery console, Question: a) Give a detai... Question: a) Give a detailed description of your understanding concerning "Managing User Sessions and Open files". b) What is "Overriding Inheritance" and how can it be do

Board coloring, write a java program to board coloring write a java program to board coloring

Areaundercurve, logic for areaunder curver logic for areaunder curver

Program to find prime number from linked list, For this assignment you are ... For this assignment you are provided with a class called LNode which can be used as a list node for a linked list of ints. You are also provided with an abstract class called LList

Write a program to find the area under the curve y = f(x) in, #question.Wri... #question.Write a program to find the area under the curve y = f(x) in java.

I need android kiosk mode, I need Android Kiosk Mode Project Description... I need Android Kiosk Mode Project Description: I need an Android platform developer to develop an app when device start it start into kiosk mode. Only browser window open a c

Write a program to explain do while loop in java, Write a program to explai... Write a program to explain do while loop in Java ? // This is the Hello program in Java class Hello { public static void main (String args[]) { int i = -1; do { if (