Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!proxad.net!212.101.4.254.MISMATCH!solnet.ch!solnet.ch!dedekind.zen.co.uk!hamilton.zen.co.uk!zen.net.uk!fuller.zen.co.uk!shaftesbury.zen.co.uk.POSTED!not-for-mail Message-ID: <9Dc+bybsWUZDFw5n@shrdlu.com> Date: Sun, 30 Oct 2005 22:14:04 +0000 From: Bernard Peek Sender: Bernard Peek Newsgroups: comp.databases.theory Subject: Re: Modelling objects with variable number of properties in an RDBMS References: <1130610162.744817.239070@g14g2000cwa.googlegroups.com> <2D89f.3422$AS6.3019@newsread3.news.atl.earthlink.net> Organization: Etaoin Shrdlu MIME-Version: 1.0 Content-Type: text/plain;charset=us-ascii;format=flowed User-Agent: Turnpike/6.04-U () Lines: 29 NNTP-Posting-Host: 82.69.127.193 X-Trace: 1130710890 shaftesbury.zen.co.uk 349 82.69.127.193:63386 X-Complaints-To: abuse@zen.co.uk Xref: dp-news.maxwell.syr.edu comp.databases.theory:34142 In message <2D89f.3422$AS6.3019@newsread3.news.atl.earthlink.net>, David Cressey writes >There is a very simple reason why people keep reinventing E-A-V. > >They want all the benefits that go with structured data together with all >the benefits that go with unstructured data. >They aren't sophisticated enough to see the trade-off in advance. > >They don't understand the down side of that design until after they have >shot themselves in the foot. Sometimes they have changed jobs by then. Then it's the person who succeeds them who wants to shoot them. > >After that, some of them learn, and do better on their next project. >Others keep making the same mistake, over and over again, and blame the >consequences on the tools they are using. That's one reason why people keep trying to use it. The second one, unfortunately, is that sometimes it's the only alternative. Sometimes you just don't know the whole data structure at design-time. -- Bernard Peek London, UK. DBA, Manager, Trainer & Author.