I would also like to point to an article by openSDE team: OpenSDE: Row modeling applied to generic structured data entry. J Am Med Inform Assoc. 2004 Mar-Apr;11(2):162-5. Epub 2003 Dec 7. PMID: 14662800 [PubMed - indexed for MEDLINE]
Which can be accessed freely from: http://www.pubmedcentral.gov/articlerender.fcgi?tool=pubmed&pubmedid=1466280 0 koray > -----Original Message----- > From: owner-openehr-technical at openehr.org [mailto:owner-openehr- > technical at openehr.org] On Behalf Of Tim Cook > Sent: 19 Ocak 2006 Per?embe 17:26 > To: openehr-technical at openehr.org > Subject: Pesistence Issues was: difficulties starting an implementation > > On Thu, 2006-01-19 at 10:41 +0100, Rong Chen wrote: > > > We did full OR mapping for the openEHR reference model. With the > > complexity of the reference model, the generated relational model is > > quite complex too (50+ tables). We haven't had any performance problem > > yet even the mapping is not fully optimized. On the other hand, we also > > noticed that having whole reference model fully mapped into relational > > model doesn't really give us the advantage of querying the data directly > > using SQL. Therefore, we are also considering other alternatives like > > the one described by Thomas which essentially only maps certain high > > level objects and serialize (native or XML) the rest low level objects > > to reduce the complexity of the relational model. Then the question is > > really where to set the break point. > > > I am completing a MSc thesis on: > "Contextual Persistence in Complex Information Systems: An analysis of > storing and retrieving information in an electronic health record." > > The research for this thesis directly addresses the issues described > above. I will be happy to share the thesis and subsequent papers as > soon as the thesis has been marked (2-3 months?). > > In short, I would suggest that you not let marketing efforts by major > companies color your perception of how to persist data. If you ask the > question; "Why do I want to persist data?". Begin with that answer to > engineer a solution you will (I believe) find an optimal solution. > > Cheers, > -- > Tim Cook
