Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Brian Kelley » A Normalization Primer
Add to briefcase
11 posts, Page 1 of 2
12»»

A Normalization Primer Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
K. Brian Kelley
Posted Sunday, January 20, 2002 12:00 AM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Today @ 4:47 PM
Points: 6,584, Visits: 1,788
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
Steve Jones - SSC Editor
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: Today @ 4:42 PM
Points: 31,421, Visits: 13,733
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
K. Brian Kelley
Posted Wednesday, January 23, 2002 1:47 PM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Today @ 4:47 PM
Points: 6,584, Visits: 1,788
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
Robert W Marda
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: Friday, February 15, 2013 10:33 AM
Points: 976, Visits: 48
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
jrobertsteg
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
mdhealy
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
K. Brian Kelley
Posted Thursday, March 13, 2003 10:20 AM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Today @ 4:47 PM
Points: 6,584, Visits: 1,788
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
K. Brian Kelley
Posted Thursday, March 13, 2003 10:22 AM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Today @ 4:47 PM
Points: 6,584, Visits: 1,788
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
philcart
Posted Thursday, March 13, 2003 3:18 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, May 17, 2013 5:53 AM
Points: 2,692, Visits: 1,074
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
K. Brian Kelley
Posted Thursday, March 13, 2003 11:08 PM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Today @ 4:47 PM
Points: 6,584, Visits: 1,788
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
11 posts, Page 1 of 2
12»»

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.