What are the benefits of using stored procedures, Software Engineering

Assignment Help:

What are the benefits of using Stored Procedures?

- They help in reducing network traffic and latency which in turn boosts application performance.

- They assist in promoting code reuse.

- They provide better security to data.

- It's possible to encapsulate the logic using stored procedures. This allows to change stored procedure code without affecting clients.

- It's possible to reuse stored procedure execution plans that are cached in SQL Server's memory. This decreases server overhead.

 


Related Discussions:- What are the benefits of using stored procedures

Iterative enhancement model, Iterative Enhancement Model Iterative Enha...

Iterative Enhancement Model Iterative Enhancement Model: This model has the similar phases as the waterfall model, but with fewer restrictions. Normally the phases happen in th

Applicability with reference to software reliability models, Q. Applicabili...

Q. Applicability with reference to software reliability models? Applicability : It is another important characteristic of a model. The model must be judged by its degree of a

Allocate operations to the entity life history diagram, QUESTION 1 (a) ...

QUESTION 1 (a) Suggest how the atomicity of EV1 "Request for estimate" could be improved (b) Document any five events listed above (Tip: state the actor, system agent, input

What are the elements of analysis model, What are the elements of Analysis ...

What are the elements of Analysis model? i. Data Dictionary ii. Data Flow Diagram iii. Entity Relationship Diagram iv. State Transition Diagram v. Process specifica

Illustrate the symbols of a data flow diagram, Symbols of a data flow diagr...

Symbols of a data flow diagram  1. Data Flow Signifies the connectivity between various processes 2. Process   Performs some processing of input data 3. Ex

Define software testing, Define software testing? Software testing is a...

Define software testing? Software testing is a critical element of software quality assurance and shows the ultimate review of specification, design, and coding.

Explain concept with respect to software development, Question: (a) ...

Question: (a) (i) Using examples from the case study or otherwise, explain the following concepts: • Encapsulation • Specialization • Polymorphism (ii) Discuss the a

What is software verification, What is software verification? Ans) In ge...

What is software verification? Ans) In general the demonstration of consistency, completeness, and correctness of the software at every stage and between every stage of the deve

Compare rmi and corba from a middleware perspective, QUESTION - RMI (a...

QUESTION - RMI (a) Figure illustrates an RMI communication.                                      Describe the role of each component in the RMI. (b) Explain the ter

Three generic phases of software engineering, What are the three generic ph...

What are the three generic phases of software engineering a) Definition, b) development, c) support

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd