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


Gene Wirchenko wrote:
> On Wed, 2 Nov 2005 06:00:46 -0500, "VC" <boston103@xxxxxxxxxxx> 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

.

Relevant Pages

  • Re: VFP jobs in Sacramento,CA
    ... Thanks for response, I am on my way to send the resume. ... I am Microsoft ... in VFP,VB.NET/VS.NET and SQL Server 2000. ... Prev by Date: ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Truncated Decimals
    ... > Thank you for your response. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ... Prev by Date: ...
    (comp.databases.ms-sqlserver)
  • RE: Problem: Changing the SQL Server services password
    ... be guaranteed a response within two business days according to the service ... Are the passwords of SQL Server service account and Microsoft Cluster ... By default the error logs are located in the folder ...
    (microsoft.public.sqlserver.server)
  • Re: Distribution agent action messages in session details
    ... > The replication subsystem issues commands and waits for responses. ... > waiting for a response from one of backend connections. ... >> between our publishing SQL server and subcribing SQL server. ... >> cpu time), the publishing SQL server's cpu time is very minimal but the ...
    (microsoft.public.sqlserver.replication)
  • Re: Access 2007 and MySQL
    ... think that response was worth posting? ... post more as a recommendation to use SQL Server instead of MySQL ... is better than your original post at addressing the question asked. ...
    (comp.databases.ms-access)