THE SQL Server Blog Spot on the Web

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

Buck Woody

Carpe Datum!

The Coming Database Design Wave

Database design has been on my mind as of late – I’ve been teaching it in class, and I have a friend from Twitter that has a couple of questions. In fact, I think I’ll actually do a submission to PASS this year on this topic.


Don’t think it has to do with you? Well, I’m seeing a new “wave” of design options coming at the data professional. Do these ring a bell?


Traditional Logical/Physical Database Design Methodologies

Object-Role Modeling


Entity Framework Code - .NET Classes


If any of these are new to you, get ready….

Published Wednesday, December 16, 2009 6:50 AM by BuckWoody
Filed under: , , ,



Adam Machanic said:

I would argue that:

A) None of these are "new". They're just twists on things we've seen before. Everything in our industry is cyclical and fad-driven--and it seems that people have very short memories.

B) None of these things have anything to do with database design. A proper design should not change depending on whether the application is designed to use EF, ORM2 (why do we need yet ANOTHER ORM acronym?), etc, etc.

December 16, 2009 10:44 AM

Buck Woody said:

Ah - but I disagree. What I'm talking about here is the process and methodolgy, which defines the final product.

Are you familiar with the way the "M" language will affect the databases you'll inherit? Methinks not. If you were, you would be VERY afraid of the disasters headed your way....time to pull our heads out of the sand and find out what those tricksy devs are about to get for Christmas...

December 16, 2009 2:46 PM

KKline said:

Great points, Buck.  I think the biggest problem we face, as the professionals in our field trying to bring everyone up a notch or two in their own professionalism, is apathy.

It seems like there's a minority who are trained in one or more method of design, and who fight with each other constantly.  Meanwhile, the other 80-85% of the world develop and implement apps without doing any real design at all.  Saints preserve us!

December 16, 2009 6:03 PM

Buck Woody said:

That's my point exactly. It's not an "us vs. them" approach - we have to work together with the business to accomplish the goals, or we'll all be out of work. In fact, I hold a "lunch and learn" for my devs on database design so that no matter what tool they use, they end up with the right design, which is what I think Adam's point was.

December 16, 2009 6:28 PM
New Comments to this post are disabled

About BuckWoody

This Blog


Privacy Statement