home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.oracle      Overblown overpriced overengineered SHIT      2,288 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 1,459 of 2,288   
   Mikito Harakiri to ctcgag@hotmail.com   
   Re: SQL for Modeling Generalization Hier   
   02 Jun 04 10:25:01   
   
   XPost: comp.databases, comp.databases.theory, comp.databases.ms-sqlserver   
   XPost: comp.databases.oracle.server   
   From: mikharakiri@iahu.com   
      
    wrote in message   
   news:20040602125733.647$6f@newsreader.com...   
   > robertbrown1971@yahoo.com (Robert Brown) wrote:   
   > If the main or only goal is to satisfy nosy Nellies, I would either go   
   > with a auxilliary table of name-value pairs (and another auxilliary table   
   > with listing allowed or suggested attributes for each job type, or just   
   > do away with all those tables and make a "free text" clob column on the   
   > employee table (or call it XML rather than free text, if that type of   
   > things turns you on).   
      
   Yeah, right, make it XML, and watch your performance going down the drain.   
      
   If you want "flexible" structure, use auxilliary name-value table. Convert   
   it into nested collection if you have object fever.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca