Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Notes fields
Ed Prochak (ed.prochak_at_magicinterface.com) wrote:
: what does your lack of disc space have to do with this NOTES table?
: (I suspect nothing).
: If looking to Normalize the tables (you could creat views of the
: denormalized ones later, if you are careful), then you might save some
: space.
I don't see how the notes are not normal.
They aren't really attributes of the tables, and each row of a table may or may not have any notes associated with it. Some tables might have more than one note per row (perhaps not today, but as a likely enhancement in the future, or already "under the table" by having multiple entries in each single item of free form text). Each note could have many attributes associated with it such as the date/format/language/editor/revision of the text (again, perhaps not today but as likely mods later). Furthermore, all the notes will share these common attributes. So why would you say it's not normal to have the notes in their own table?
As for disk space, perhaps the thinking was that you might wish to be able to handle the free form text in a different area of the database, seperately from the rest of the data which probably has more fixed predictable requirements.
$0.04
-- This space not for rent.Received on Tue Apr 19 2005 - 17:32:15 CDT