SitePoint Sponsor |
|
User Tag List
Results 1 to 13 of 13
-
Jun 12, 2002, 08:39 #1
- Join Date
- Jan 2002
- Location
- London
- Posts
- 3,509
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Database design & normalization resources
Here are some excellent articles on database design & normalisation - most are written with Access in mind, but 99% of the principles and techniques apply to every database under the sun, so they are well worth a read no matter which DB you use!
Understanding Relational Database Design
<snip/>
How the Table Analyzer Wizard Works
Database Normalization Basics
GeekGirls.com Database Tutorials
Some tip-style pages:
<snip/>
Database Design and Modeling Fundamentals
Does anyone else know of any quality articles/resources on these topics? Also, could one of the moderators could mark this thread "Important"? Cheers!
M@rco
EDIT: Added tips pages
EDIT: Removed the mailing list links, which are now sadly deceased.
EDIT:
SitePoint article:
Concepts of Database Design and Management
Wikipedia:
Database normalization
MittineagueLast edited by Mittineague; Dec 18, 2010 at 14:42. Reason: pre-new-sticky cleanup
-
Jun 16, 2002, 16:15 #2
- Join Date
- Aug 2001
- Location
- Livonia, MI, USA
- Posts
- 513
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
The best resource I've found for learning these topics is Part 5 (entitled "Relational Database Design") of Kevin Yank's book Building a Database-Driven Web Site Using PHP and MySQL.
<snip/>
-BryanLast edited by Mittineague; Dec 18, 2010 at 14:35. Reason: pre-new-sticky cleanup
-
Jul 6, 2002, 05:36 #3
- Join Date
- Jul 2002
- Location
- Toronto, Canada
- Posts
- 39,347
- Mentioned
- 63 Post(s)
- Tagged
- 3 Thread(s)
normalization
there's a great normalization resource which covers data modelling and the relational model here --
http://www.utexas.edu/its/archive/wi...ng/rm/rm7.htmlLast edited by ScallioXTX; Sep 16, 2010 at 15:14. Reason: updated link
-
Jul 7, 2002, 14:01 #4
- Join Date
- Sep 2000
- Location
- Ontario, Canada
- Posts
- 320
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
I just found some good articles about normalization posted on the DevShed forums:
<snip/>Last edited by Mittineague; Nov 9, 2010 at 23:27. Reason: pre-new-sticky cleanup
-
Jul 12, 2002, 08:34 #5
- Join Date
- Feb 2002
- Location
- Gatwick, UK
- Posts
- 1,206
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
I swear by Data Modelling Essentials ( which means it's never been opened
- j/king )
But if someone knows the url for the e-book then that's a fairly good resource.
Flawless---=| If you're going to buy a pet - get a Shetland Giraffe |=---
-
Mar 13, 2003, 15:47 #6
- Join Date
- Jan 2003
- Posts
- 38
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
It is sometimes interesting to browse comp.databases.theory
And for those who want the heavy stuff: http://www.dbdebunk.com/. This site focuses heavily on the fundamentals of relational data theory. It has good information for those interested in the serious side of database design, and also for those possibly even interested in developing database management systems themselves (one of my future dreams).
(WARNING: might cause you to rethink much of what you think you know about databases)
-
Jul 2, 2003, 07:24 #7
- Join Date
- Feb 2003
- Location
- Groningen, Netherlands
- Posts
- 21
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
OOP and datamodeling: http://www.agiledata.org/
-
Jan 8, 2006, 14:11 #8
- Join Date
- Jan 2006
- Posts
- 4
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
See about database design www.configure-all.com
There is also about MySQL security
-
Feb 16, 2006, 04:02 #9
- Join Date
- Jan 2006
- Posts
- 8
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Lots of database design and normalization articles here:
http://www.databasedev.co.uk/general.html
-
Nov 16, 2007, 15:21 #10
- Join Date
- Jan 2007
- Posts
- 2
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Didn't see this in the thread, but I found it in another thread. Amazing list of data model samples for many different applications
http://www.databaseanswers.org/data_models/index.htm
-
May 18, 2008, 03:55 #11
- Join Date
- Apr 2008
- Location
- Morristown, NJ
- Posts
- 30
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
I know this thread is a bit dated, but I do have a very pertinent article on this subject, and good database design never goes out of style:
http://www.barrywise.com/2008/01/dat...gn-techniques/
-
Sep 4, 2008, 16:25 #12
I'm a believer in normalizing to 3NF then turn around and denormilize for performance. Don't get to caught up in the "rules".
http://blog.makezine.com/archive/200...normalize.html
Sort of shares my belief.Last edited by ScallioXTX; Sep 16, 2010 at 15:27. Reason: updated URL
-
Sep 4, 2008, 17:04 #13
- Join Date
- Jul 2002
- Location
- Toronto, Canada
- Posts
- 39,347
- Mentioned
- 63 Post(s)
- Tagged
- 3 Thread(s)
nice link, weathersquare
i should like to suggest that the correct strategy is as follows:normalize to 3NF and then stop
don't denormalize right away -- that'd be silly
wait until you hit a few million rows
this strategy is completely supported by that article:Only when you find there are performance problems do you need to think about optimizing. Usually this can be accomplished through smarter querying. When it cannot, you derive a denormalized data set from the normalized source.
Bookmarks