The Innovator’s (and SQL’s) Dilemma

Let’s look at Christensen’s four marketing issues again:

  1. Availability
  2. Compatibility
  3. Reliability
  4. Economy

How can this be correlated with SQL? First, data availability is determined by the SELECT statement. You query the database to determine if data that meets search criteria exists. Second, data compatibility is determined by the INSERT statement. Data is accepted if it is within the database structure’s definition. Third, data reliability is determined by the UPDATE statement. Data has to change as the database’s state changes to continue to meet the database’s objectives. Finally, data economy is determined by the DELETE statement. Data that is no longer of use can be removed from the database to free up available resources to achieve cost effectiveness.

  1. Select
  2. Insert
  3. Update
  4. Delete

Christensen’s Innovator’s Dilemma tetrad has provided us with another viewpoint on the SQL tetrad.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: