A Normalization Primer
-
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/bkelley/normalization.asp
K. Brian Kelley
@kbriankelley -
Brian,
nice introductary article. I'd love to see a followup dealing with more complex designs and including child tables.
Steve Jones
-
That is something I plan on doing. This first article was to solve the question of, "What do I give the developers?!?"
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley -
I liked your article too. I always hear database people talk about normalization and denormalization and the various levels of normalization without really understanding what they are talking about. Now I understand this better and will understand when I hear it again. Thanks!
Robert Marda
Robert W. Marda
Billing and OSS Specialist - SQL Programmer
MCL Systems -
I didn't find this to be very well-written. I gave up on it after seeing repeating data conflated with redundancy and seeing 2NF described as "all attributes describing the entire key".
-
Good article but as Steve said it is indroductary. If you've got developers who don't understand normal forms you've got bigger problems on your hand.
-
Hi jrobertsteg,
Can you elaborate more on your concerns and perhaps discuss how you'd present it?
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley -
mdhealy, I'd agree with you, but unfortunately, it's the reality of the situation. I've been in the position where I've said, "I would prefer you build your database this way..." (DBAs didn't have veto) and when asked why I said, "Normalization!" That's when I got the blank stare.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley -
I'd like to see a follow up article from the other side of the fence. De-normalizing the databaase for datawarehousing/reporting.
In my current contract, where we are building a small datamart, I've run up against a lot of resistance to denormalizing the database.
We've been able to alleviate some concerns by keeping the tables somewhat normalized and denormalizing via indexed views, but we still get a lot of weird looks.
Hope this helps
Phill Carter
--------------------
Colt 45 - the original point and click interface
--------------------
Colt 45 - the original point and click interface
-
That's a good idea. I'll have to add it to the list of articles I need to write. Of course, if someone is a hardcore data warehousing DBA (I know you guys are out there) write up an article and submit it to Steve, Andy, or Brian Knight!
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley -
Good article.
Some more things could be elaborated more.
Surrogate key is another issue.
Why we need another key, etc. may be another very usefull
Preethi
G.R. Preethiviraj Kulasingham
Cheers,
Prithiviraj Kulasinghamhttp://preethiviraj.blogspot.com/
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply