THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Allen White

The Basic Truths about Data

In reviewing database development best practices recently I'm reminded of an attitude I've found prevalent in many development shops, that the database is just "a place to put stuff". As much as I've come to expect this attitude, it continues to upset me. There are two important (at least I think) facts that all developers should remember when it comes to any application development project.

1. The data will ALWAYS last longer than the application itself. Take one look at the legacy systems out there and the effort to correlate that legacy data with current data. Many times the legacy app is there only to provide a retrieval mechanism for that historical data.

2. The "truth" of the business is the data. Each element in each attribute (or column) in each tuple (or row) is indeed a fact about the business. Aggregate these facts and you summarize the business. Throw in some erroneous information and the aggregation becomes meaningless, because it's not based on facts. Even if the data is there to provide a framework for a web application, for example, that web interface represents the business, and therefore has direct meaning for the business.

There is a lot more to establishing best practices than two bullet points, but if the data is good, and it's consistent, then solid, well-founded business decisions can be made.


Published Monday, August 3, 2009 2:30 PM by AllenMWhite



ALZDBA said:

Garbage in ... garbage out ...  what results do they expect ?

So ... even garbage needs to be defined !

Red gate handed out some BALD-D T-shirts a while ago.

BALD-D standing for "Battle Against Lawless Database Design".

And in many cases it's the data warehousing dev team that actually need to re-invent on what directives the OLTP system as been built on.

Happy cleansing ;)

August 3, 2009 2:39 PM

jamiet said:


August 3, 2009 2:55 PM

Grant Fritchey said:

Simple truths seem to be the hardest ones for people to understand. Well said.

August 3, 2009 3:26 PM
New Comments to this post are disabled

About AllenMWhite

Allen White is a consultant and mentor for Upsearch Technology Services in Northeast Ohio. He has worked as a Database Administrator, Architect and Developer for over 30 years, supporting both the Sybase and Microsoft SQL Server platforms over that period.

This Blog


Privacy Statement