Re: Modelling objects with variable number of properties in an RDBMS
Date: 2 Nov 2005 10:11:48 -0800
Gene Wirchenko wrote:
> On Wed, 2 Nov 2005 06:00:46 -0500, "VC" <boston103_at_hotmail.com> wrote:
> >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.
> Gene Wirchenko
Received on Wed Nov 02 2005 - 19:11:48 CET