Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!sn-xit-04!sn-xit-10!sn-xit-01!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: Gene Wirchenko Newsgroups: comp.databases.theory Subject: Re: Looking for how to model 3D objects in 2D relational databases Date: Mon, 10 Oct 2005 14:01:15 -0700 Organization: Posted via Supernews, http://www.supernews.com Message-ID: <3hllk113iu4t1tv3jsefucn3asqfngq26q@4ax.com> Reply-To: Gene Wirchenko References: <1128871496.487047.76420@g47g2000cwa.googlegroups.com> X-Newsreader: Forte Free Agent 2.0/32.652 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: abuse@supernews.com Lines: 22 Xref: dp-news.maxwell.syr.edu comp.databases.theory:33978 On 9 Oct 2005 09:01:56 -0700, "Marshall Spight" wrote: [snip] >The first thing you need to observe is that relational databases >are not 2D. A dimension is a measure independent of any other >dimensions. The columns of a relational table are independente; >they are dimensions. That has bothered me for some time now. Given a PK, the columns are not independent. By that, the dimensionality of a table would be the number of columns in the key. What am I missing? [snip] Sincerely, Gene Wirchenko