Re: Database design - AGAIN
От | Rudi Starcevic |
---|---|
Тема | Re: Database design - AGAIN |
Дата | |
Msg-id | 20030624221503.M77696@oasis.net.au обсуждение исходный текст |
Ответ на | Re: Database design - AGAIN (Jonathan Gardner <jgardner@jonathangardner.net>) |
Ответы |
Re: Database design - AGAIN
(Michael A Nachbaur <mike@nachbaur.com>)
Re: Database design - AGAIN (Josh Berkus <josh@agliodbs.com>) |
Список | pgsql-sql |
Josh, Jonathan .. Thanks for your replies. You mail was exactly what I was hoping for - your best practise opinion. I do have a grasp of the theory involved with SQL but your input on those 'other' constraints like time, language, longevity etc was just what I was interested in. I'll be using smaller tables with appropriate join tables and PHP. Just for interests sake I'll be using Dia to plan the schema. I prefer to use the UML drawing tools instead of the ER ones. Thank you. Best regards Rudi. > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > On Monday 23 June 2003 22:19, Rudi Starcevic wrote: > > I"m not sure whether to have on larger table or 2 smaller one with a > > join table. > > Theory says you are better off with the join tables. Practical > reality agrees with this. It takes a bit more work to write your > select statements, but the data is better for at least these two reasons: > 1) You won't have a lot of empty columns. > 2) You will be able to add, rename, and remove features pretty easily. > There are more reasons, but they are not immediately obvious to the > untrained DBA. (Words like "data integrity" and "data consistency" > start to mean things when you become trained.) > > With that said, it sounds like you are really intermediate with > database design. If you were a beginner, and if you barely > understood what a table was, (and if you were the guy who would be > using it all the time,) I would probably suggest you use the former > method. It will work pretty well until you want to add more features > or until you start worrying about your database size. At that point, > I would explain how and why to use joins, and how to convert your > data over to the new design. > > - -- > Jonathan Gardner <jgardner@jonathangardner.net> > (was jgardn@alumni.washington.edu) > Live Free, Use Linux! > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.2.1 (GNU/Linux) > > iD8DBQE++HBcWgwF3QvpWNwRAgjPAJ48syjGQahHvU4zi38WVheFbVFC5ACfQw5S > 0qO67ZB2ToO4zFJKoh5GtrU= > =PnFr > -----END PGP SIGNATURE----- > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org
В списке pgsql-sql по дате отправления: