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

Here’s an example of database refactoring applied at multiple levels: we have an application that manages configuration data for some of our electronic components.

The database for this application contains a table called Parameter, that looks like this:

CREATE TABLE [dbo].[Parameter](

              [ParameterIdentifier] [int] IDENTITY(1,1) NOT NULL,

              [ParameterDescription] [varchar](255) NOT NULL,

              [TIMESTAMP] [timestamp] NOT NULL,

The application doesn’t reference the database tables directly; instead, it was coded to reference views in the database. Here is the auto-generated base view for the Parameter table:

CREATE VIEW [dbo].[vwParameter]

(

ParameterIdentifier

,ParameterDescription ...

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