Hi Rene, I did not mean to suggest that EAV is the only design that one should use. I guess a better attempt to express what I have in mind is this: people use relational design too heavily in DB layer, mostly due to benefit of tooling in other layers.
Good analogy about the pudding :) On Tue, Jun 7, 2011 at 2:56 PM, Rene Spronk (Ringholm) <rene.spronk at ringholm.com> wrote: > Hi Seref, > > ?From what we've seen in HL7 RIMBAA EAV is rarely embraced wholesale - > in practice people (if they use EAV at all) use a mixed RDBMS - EAV > approach. RDBMS for its speed and indexing capabilities, EAV for > blob-type storage of rarely searched/used data. If you don't need the > ultimate flexibility/extendability of EAV, you probably shouldn't use it > if only for performance reasons (and as a human it gets hard to > understand pretty fast). > >> In general, I'm trying to not to sing along with the chorus in the >> software domain, getting ever loud and crowd :) Healthcare is a very >> challenging domain, so practices of e-commerce, or advice from books >> written by academics who has never implemented a single production >> system in their lives won't cut it. > > Like always, no silver bullits .. I agree one should listen to those > that have already built systems within healthcare, and not just theorize > about building such systems. The proof of the pudding is in the eating, > not in the chewing on the recipe. > > TTYL, > > -Rene > > -- > ------------------------------------------------------------ > Rene Spronk ? ? ? ? ? ? ? ? ? ? ? ? Cell: +31 (0)655 363 446 > Senior Consultant ? ? ? ? ? ? ? ? ? ?Fax: +31 (0)318 548 090 > Ringholm bv ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?The Netherlands > http://www.ringholm.com ? ? ?mailto:Rene.Spronk at ringholm.com > twitter:@Ringholm ? ? ? ? ? ? ? ? ? ? ? ?skype:rene_ringholm > Ringholm is registered at ? the Amsterdam KvK reg.# 30155695 > ------------------------------------------------------------ > Ringholm bv - Making Standards Work - Courses and consulting > _______________________________________________ > openEHR-technical mailing list > openEHR-technical at openehr.org > http://lists.chime.ucl.ac.uk/mailman/listinfo/openehr-technical >
