Hi Erik, you are right, the uglyness depends on 1. the queries you want to execute and 2. the programmer background. For 1. the "common" queries like get all records for this patient in this time window, are not that ugly, but more complex queries could be.For 2. for a XML guy, writing xPath based queries is ok, but for a SQL is a pain in the a55.
:D I'm hoping to see that paper on AQL->xQuery soon! I totally agree that inside the system maybe you don't need a complete RM structure to handle data instances, but for the service layer (sharing information with other systems) this is a must. -- Kind regards, Ing. Pablo Pazos Guti?rrez LinkedIn: http://uy.linkedin.com/in/pablopazosgutierrez Blog: http://informatica-medica.blogspot.com/ Twitter: http://twitter.com/ppazos > Date: Fri, 17 Feb 2012 16:21:29 +0100 > Subject: Re: openEHR - Persistence of Data > From: erik.sundvall at liu.se > To: openehr-technical at openehr.org > > Hi! > > On Thu, Feb 16, 2012 at 23:26, pablo pazos <pazospablo at hotmail.com> wrote: > > Other models I didn't try yet are Object Oriented DBs and > > Document Oriented DBs (XML, JSON, ...) [6]. I think DODBs > > are a good option, fast for store highly hierarchical structures, > > but you need to write some ugly queries if you want your data back :D > > Not necessarily that ugly... we curently auto-convert AQL to XQuery > and execute towards an XML database. Those queries are very readable. > > Then the question is what kind of client system you are aiming at. For > some use cases you don't really need to map things back to > openEHR-RM-objects, in web browser based GUIs for example you can keep > treating the data as documents, document fragments, fragment lists > etc. and use DOM manipulations, jQuery or similar approaches for most > data manipulation needs. > > Good luck with your work M?rcio and please keep us informed! > > Best regards, > Erik Sundvall > erik.sundvall at liu.se http://www.imt.liu.se/~erisu/ Tel: +46-13-286733 > > _______________________________________________ > openEHR-technical mailing list > openEHR-technical at openehr.org > http://lists.chime.ucl.ac.uk/mailman/listinfo/openehr-technical -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.openehr.org/mailman/private/openehr-technical_lists.openehr.org/attachments/20120217/89e04227/attachment.html>
