O'Reilly logo

Building the Agile Database: How to Build a Successful Application Using Agile Without Sacrificing Data Management by Larry Burns

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Most people are familiar with stored procedures as a way of implementing data-specific business or application processes, but they serve an important role in data virtualization, as well. Stored procedures can return data to a calling application either as individual values (OUTPUT variables) or as a collection of rows (called a result set, or rowset). Stored procedures that return rowsets are similar in nature to views, with two important differences: they can be parameterized (i.e., they can accept values for one or more input variables), and they can perform complex logic. This allows them to serve as a useful wrapper for views; the amount of data returned to the requestor can be controlled via the input parameter values. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required