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

What is equivalence partitioning, What is Equivalence Partitioning? Eq...

What is Equivalence Partitioning? Equivalence Partitioning (EP) is the process of methodically decreasing the huge set of possible test cases into a much smaller but still equ

Determine the test cases using boundary value analysis, Q. Consider a progr...

Q. Consider a program which computes the square root of an input integer between 0 and 5000. Determine the equivalence class test cases. Determine the test cases using boundary val

Determine in verify about capability maturity models, Determine in verify a...

Determine in verify about CAPABILITY MATURITY MODELS In this model anapproach for improving Software process is devised. It isn't concerned which life cycle modeis followed for

What is relationship, What is Relationship Entities are associated t...

What is Relationship Entities are associated to each other by relationships. It denotes how two entities are associated. A diamond notation with name of relationship signifi

What is infeasible path, Explain Infeasible Path? Program statement sequ...

Explain Infeasible Path? Program statement sequence that can never be implemented.

Explain iso 9000, Explain ISO 9000 ISO 9000 An international set o...

Explain ISO 9000 ISO 9000 An international set of standards for quality management. Applicable to a range of organisations from manufacturing to service industries.

Explain scalability of information systems, Question: (a) The relations...

Question: (a) The relationship between organisations and information technology is a complex one, and is made up of a number of mediating factors which must be considered prior

Distinguish among verification and validation, Distinguish between verifica...

Distinguish between verification and validation. Verification is the set of activities that ensure that software properly implements a specific function. Validation is a differ

What is function point, What is function point? Function point is the s...

What is function point? Function point is the size of measure it is also used to calculate approximately the software cost. Function point (FP)=Function Count (FC) * Value a

What is 4test, What is 4Test? 4Test is a test scripting language which ...

What is 4Test? 4Test is a test scripting language which is used by SilkTest to compose test scripts to perform automated tests. It's an object-oriented fourth-generation langua

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