Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Modelling objects with variable number of properties in an RDBMS

Re: Modelling objects with variable number of properties in an RDBMS

From: vc <boston103_at_hotmail.com>
Date: 2 Nov 2005 10:11:48 -0800
Message-ID: <1130955108.946513.26490@g49g2000cwa.googlegroups.com>

Gene Wirchenko wrote:
> On Wed, 2 Nov 2005 06:00:46 -0500, "VC" <boston103_at_hotmail.com> wrote:
>
> [snip]
>
> >I know that, but what recipe does Roy suggest for, let's say, MS SQL Server
> >that does not have either UDTs or other means to implement an entity with a
> >higher than the table limit number of attributes, beyond offering a cute
> >saying ?
>
> Are you saying that SQL Server can not model a one-to-one
> relationship? Slice the tables vertically, and have some of the
> attributes in one table and some in another.

I've already responded to the suggestion.

>
> That is assuming that the large number of attributes really is
> necessary. I think it would be worth checking.

See my prev. response.

>
> [snip]
>
> Sincerely,
>
> Gene Wirchenko
Received on Wed Nov 02 2005 - 12:11:48 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US