Re: [SQL] Conceptual Design Question

2008-06-10 Thread Medi Montaseri
Assuming common semantics for a given field then the question of breaking it to many parts is also a function of its size as related to I/O. We know that memory allocation and I/O read/writes are not granular to bytes and are rather blocks of bytes as it travels from VM (virtual memory) all the wa

Re: [SQL] Conceptual Design Question

2008-06-10 Thread Steve Midgley
At 10:52 AM 6/10/2008, [EMAIL PROTECTED] wrote: Date: Tue, 10 Jun 2008 05:05:24 -0700 From: Bryan Emrys <[EMAIL PROTECTED]> To: pgsql-sql@postgresql.org Subject: Conceptual Design Question Message-ID: <[EMAIL PROTECTED]> Hello Everyone, In a text-heavy database, I'm trying to make an initial de

[SQL] Conceptual Design Question

2008-06-10 Thread Bryan Emrys
Hello Everyone, In a text-heavy database, I'm trying to make an initial design decision in the following context. There is a lot of long text that I could break down into three different categories: a. Laws i. Only 1 country per law, many laws ii. Ther