Received: from localhost (maia-2.hub.org [200.46.204.187])
	by postgresql.org (Postfix) with ESMTP id 2FA469F96E9
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Sun, 19 Aug 2007 17:13:14 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024)
	with ESMTP id 52537-08 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Sun, 19 Aug 2007 17:13:08 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5
Received: from rv-out-0910.google.com (rv-out-0910.google.com
 [209.85.198.184])
	by postgresql.org (Postfix) with ESMTP id A3E4B9F96E3
	for <pgsql-performance@postgresql.org>;
	Sun, 19 Aug 2007 17:13:10 -0300 (ADT)
Received: by rv-out-0910.google.com with SMTP id l15so815958rvb
	for <pgsql-performance@postgresql.org>;
	Sun, 19 Aug 2007 13:13:08 -0700 (PDT)
DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta;
	h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references;
	b=AXa+MRpvpEGwOfV5jdYTVPtJflH3RL/t8SxpvMsVpO3KE2dhnDsisNG742LQH5gcHWtw4HVM4fPqhuX4z9kIt5xV3b4c9Ov8GNhGTGqFgY4rJXdTKjpSETdPVye4/+zCYWufeyhTeSMUwWkdRC48RgGZp5h9Qa5/n9lMYGnjCBE=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references;
	b=omZq4ju9l3y9Zzkq0+q94G4ltgvUd7zqYJB7JqWo4VU9+eQACTUdCgxbPIk/dh8SSOO+rkmmBuw+nmk+H/Lv4mOTqjETFZ0CqMrl3Jlfu0pb+ykLXaFMbtpK+02GQBArW/J/INVjFVGQAroOAmwZoB+yVpAPO1UVxtIYYsN5tGE=
Received: by 10.141.5.3 with SMTP id h3mr2282376rvi.1187554388457;
	Sun, 19 Aug 2007 13:13:08 -0700 (PDT)
Received: by 10.141.18.12 with HTTP; Sun, 19 Aug 2007 13:13:08 -0700 (PDT)
Message-ID: <ea41f7570708191313t26680a39yfb14760fd00c5fcd@mail.gmail.com>
Date: Sun, 19 Aug 2007 22:13:08 +0200
From: "mark overmeer" <markovermeer@gmail.com>
To: "David Fetter" <david@fetter.org>, pgsql-performance@postgresql.org
Subject: Re: schema design question
In-Reply-To: <20070819182658.GC25214@uio.no>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_41796_22883411.1187554388428"
References: <ea41f7570708190619u6daf7cep96430d20566d6159@mail.gmail.com>
	<20070819181216.GK28490@fetter.org> <20070819182658.GC25214@uio.no>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200708/200
X-Sequence-Number: 26330

------=_Part_41796_22883411.1187554388428
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi,

2007/8/19, Steinar H. Gunderson <sgunderson@bigfoot.com>:
>
> As a general database design paradigm, though, I fully agree with you.
> Databases are databases, not glorified OO data stores or hash tables.

I don't want to use it as an OO data store, I use the filesystem for that.
The intended use is to search for the right object. Since it has separate
data structures for searching (indexes) I guess that is one of its
functions.

However, it still doesn't answer my question about the EV model (where each
attribute is given its own table).

Mark

/* Steinar */
> --
> Homepage: http://www.sesse.net/
>

------=_Part_41796_22883411.1187554388428
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi,<br><br><div><span class="gmail_quote">2007/8/19, Steinar H. Gunderson &lt;<a href="mailto:sgunderson@bigfoot.com">sgunderson@bigfoot.com</a>&gt;:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
As a general database design paradigm, though, I fully agree with you.<br>Databases are databases, not glorified OO data stores or hash tables.</blockquote><div>I don&#39;t want to use it as an OO data store, I use the filesystem for that. The intended use is to search for the right object. Since it has separate data structures for searching (indexes) I guess that is one of its functions. 
<br><br>However, it still doesn&#39;t answer my question about the EV model (where each attribute is given its own table).<br>&nbsp;</div>Mark<br><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
/* Steinar */<br>--<br>Homepage: <a href="http://www.sesse.net/">http://www.sesse.net/</a><br></blockquote></div><br>

------=_Part_41796_22883411.1187554388428--