Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

A Normalization Primer Expand / Collapse
Author
Message
Posted Sunday, January 20, 2002 12:00 AM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Thursday, April 03, 2014 10:06 PM
Points: 6,621, Visits: 1,851
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/bkelley/normalization.asp

K. Brian Kelley, CISA, MCSE, Security+, MVP - SQL Server
Regular Columnist (Security), SQLServerCentral.com
Author of Introduction to SQL Server: Basic Skills for Any SQL Server User
| Professional Development blog | Technical Blog | LinkedIn | Twitter
Post #2297
Posted Wednesday, January 23, 2002 1:30 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 11:24 AM
Points: 32,781, Visits: 14,942
Brian,

nice introductary article. I'd love to see a followup dealing with more complex designs and including child tables.


Steve Jones
steve@dkranch.net







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #26576
Posted Wednesday, January 23, 2002 1:47 PM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Thursday, April 03, 2014 10:06 PM
Points: 6,621, Visits: 1,851
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
bkelley@sqlservercentral.com
http://www.sqlservercentral.com/columnists/bkelley/


K. Brian Kelley, CISA, MCSE, Security+, MVP - SQL Server
Regular Columnist (Security), SQLServerCentral.com
Author of Introduction to SQL Server: Basic Skills for Any SQL Server User
| Professional Development blog | Technical Blog | LinkedIn | Twitter
Post #26577
Posted Wednesday, January 23, 2002 3:06 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, November 05, 2013 9:05 AM
Points: 976, Visits: 59
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
SQL Programmer
Ipreo
Post #26578
Posted Thursday, March 13, 2003 7:15 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, July 29, 2003 12:00 AM
Points: 8, Visits: 1
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".




Post #26579
Posted Thursday, March 13, 2003 7:59 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, January 11, 2013 11:48 AM
Points: 11, Visits: 22
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.




Post #26580
Posted Thursday, March 13, 2003 10:20 AM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Thursday, April 03, 2014 10:06 PM
Points: 6,621, Visits: 1,851
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, CISA, MCSE, Security+, MVP - SQL Server
Regular Columnist (Security), SQLServerCentral.com
Author of Introduction to SQL Server: Basic Skills for Any SQL Server User
| Professional Development blog | Technical Blog | LinkedIn | Twitter
Post #26581
Posted Thursday, March 13, 2003 10:22 AM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Thursday, April 03, 2014 10:06 PM
Points: 6,621, Visits: 1,851
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, CISA, MCSE, Security+, MVP - SQL Server
Regular Columnist (Security), SQLServerCentral.com
Author of Introduction to SQL Server: Basic Skills for Any SQL Server User
| Professional Development blog | Technical Blog | LinkedIn | Twitter
Post #26582
Posted Thursday, March 13, 2003 3:18 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 2:01 AM
Points: 2,693, Visits: 1,173
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


Hope this helps
Phill Carter
--------------------
Colt 45 - the original point and click interface

Australian SQL Server User Groups - My profile
Phills Philosophies
Murrumbeena Cricket Club
Post #26583
Posted Thursday, March 13, 2003 11:08 PM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Thursday, April 03, 2014 10:06 PM
Points: 6,621, Visits: 1,851
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, CISA, MCSE, Security+, MVP - SQL Server
Regular Columnist (Security), SQLServerCentral.com
Author of Introduction to SQL Server: Basic Skills for Any SQL Server User
| Professional Development blog | Technical Blog | LinkedIn | Twitter
Post #26584
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse