Re: object oriented vs object relational

From: James <jraustin1_at_hotmail.com>
Date: 11 Jun 2002 06:57:09 -0700
Message-ID: <a6e74506.0206110557.4f98604e_at_posting.google.com>


> > [in oodb] generic code to copy any data structure of arbitrary complexity
> > For details see: www.xdb1.com/HowTo/CopyObj.asp
> 
> [in rdb] Update some_relation
> Set some_attribute = some_arbitrarily_complex_data_structure;

How could one show this using MS Access or SQL Server on a data structure similar to below?

Corvette [Car]
  .Mfg
->GM

  .Colors
->Silver
->Gray

  Passengers Fldr
->Mary

    John [Person]

      .Age
        ->32 yr
      .Friends
        ->John
        ->Bob

  ToolBox [StorageBox]
    .Capacity
      ->50 lb
    TopDrawer [Drawer]
      ->ScrewDriver(3)
      ->Plier(2)
    BottomDrawer [Drawer]
      ->Hammer
Received on Tue Jun 11 2002 - 15:57:09 CEST

Original text of this message