openEHR - Persistence of Data
Hello guys, i'm starting a research about the persistence model of Archetype data, that stores the information entered by the user of the system. I would like to know if there is a indication of the openEHR standard for what kind of model schema should be used in DataBase, and if there are researchs in this area. Thanks in advance, *M?rcio Costa* B.Sc. in Computer Science @ Cin/UFPE M.Sc. Candidate in Computer Science @ CIn/UFPE MSN: mdckoury at gmail.com -- next part -- An HTML attachment was scrubbed... URL: http://lists.openehr.org/mailman/private/openehr-technical_lists.openehr.org/attachments/20120216/a419bae2/attachment.html
openEHR - Persistence of Data
I have good experience, fast and lean with a path/value-database, only a few tables is needed, no relations between, not many indexes, and can be compatible with new big-data databases, as you can find in the emerging new technologies. Check the book: big data glossary from Pete Warden, O'Reilly. But you have to figure it out yourself how to do it exactly. Good luck, Bert Verhees On 16-02-12 20:53, M?rcio Costa wrote: Hello guys, i'm starting a research about the persistence model of Archetype data, that stores the information entered by the user of the system. I would like to know if there is a indication of the openEHR standard for what kind of model schema should be used in DataBase, and if there are researchs in this area. Thanks in advance, *M?rcio Costa* B.Sc. in Computer Science @ Cin/UFPE M.Sc. Candidate in Computer Science @ CIn/UFPE MSN: mdckoury at gmail.com mailto:mdckoury at gmail.com ___ 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/20120216/41904a5a/attachment.html
openEHR - Persistence of Data
Hi M?rcio, There is no standard persistence model, the persistence mechanism is not in the standard scope. There are many ways of storing openEHR RM instances (archetyped data), the only thing to take into account is that the information to store will be highly hierarchical. Said that, in EHRGen [1] we use a relational model with an Object-Relational Mapping [2] tool (GORM from Grails Framework[3]). The advantage of that is that you have a complete and validated RM instance persisted on the DB, and you can query for complete objects or single data ELEMENTS. I've written ORM tools myself [4] and the main problem is the amount of joins you need to load a complete structure, but in my experience you never load a complete structure for a real time interaction with the user, and you alway can cach? some data. This approach is straight forward, because all you need are the classes of the RM, and you delegate DB stuff to the ORM tool. Other models are viable too, like K/V [5] or EAV [6] approaches (mentioned by Bert). This approaches are fast for saving and loading data, the problem is that you need to have some complex logic above that for constructing a complete RM instance on memory, because K/V is a flat representation of a higly hierarchical tree structure. 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 Hope that helps. [1] http://code.google.com/p/open-ehr-gen-framework/ [2] http://grails.org/[3] http://en.wikipedia.org/wiki/Object-relational_mapping [4] http://code.google.com/p/yupp/[5] http://en.wikipedia.org/wiki/NoSQL[6] http://en.wikipedia.org/wiki/Entity%E2%80%93attribute%E2%80%93value_model -- 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 From: mdcko...@gmail.com Date: Thu, 16 Feb 2012 16:53:19 -0300 Subject: openEHR - Persistence of Data To: openehr-technical at openehr.org Hello guys, i'm starting a research about the persistence model of Archetype data, that stores the information entered by the user of the system. I would like to know if there is a indication of the openEHR standard for what kind of model schema should be used in DataBase, and if there are researchs in this area. Thanks in advance, M?rcio Costa B.Sc. in Computer Science @ Cin/UFPE M.Sc. Candidate in Computer Science @ CIn/UFPE MSN: mdckoury at gmail.com ___ 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/20120216/6351fcf2/attachment.html
Meaningful Use and Beyond - O'Reilly press - errata
is the bottom line reality: the Open Source EHR space has matured dramatically in the last 10 years. There are handful of projects that I know of that have literally hundreds of installations worldwide: the VistA variants, OpenMRS, OpenEMR, and ClearHealth. There are some other important projects that have potential, like Tolven, that I know of, but they simply have not garnered hundreds of installations. I would be very happy to be proven wrong here, but as far as I know, there is no Open Source EHR that has been installed at even over 100 sites that has been based on the OpenEHR. I do not really care about proprietary land, because there are literally hundreds of different ways to architect an EHR system that are implemented by proprietary vendors. Again, please correct me if I am wrong, but I believe that means that the vast majority of EHR installations do not use OpenEHR. Frankly only a substantial fraction of those know anything about SNOMED/UMLS/RIM. Please do not reply to me and tell me but we are using OpenEHR in my hospital/clinic/school that is great for you but that is not anything like wide-scale adoption. I know that OpenEHR has made inroads to several of the national systems, and that is really great. It is what earned OpenEHR a mention in the book at all. But nationalized EHR systems are a the perfect place to have standardization for the sake of itself, which means that while OpenEHR is being used successfully, there is no compelling reason why they could not just have gone with some other solution. As far as I am concerned, the nationalized systems that have adopted OpenEHR really count as a handful of really enormous installations. I respect that you all have worked hard on this and I respect the careful thinking that you all seem to be doing, but OpenEHR is the kind of standard that is only really helpful if everyone is doing it. I do not see that kind of adoption happening. OpenEHR seems to be, in my eyes and in they eyes of on the ground Health IT implementors as a solution looking for a problem. With that in mind I challenge you to find any health IT book, aimed at the US market, by a major publisher that even mentions OpenEHR. I know you guys are working hard and I know you have managed to convince some impressive technologists to your way of thinking (most notably Tim Cook). I do not see other books on meaningful use, or health IT in the US covering you -at all-. I am doing this to hedge my bets. I know I could be totally wrong about where OpenEHR is heading. Guessing what the future holds is pretty difficult. At this point my mental summary for OpenEHR is one of the many technically right but will never be adopted technology ideas. I cannot write a book which is intended to warn IT people about all of the fruitless investments that they should expect to see all over the place in Health IT and give OpenEHR a free pass because I know and like some of the founders. Is OpenEHR a relevant technology or an interesting foot note? It is my job to make that technical decision and then include the results in the book. Right now, OpenEHR made the cut to get a mention in the book, but not the cut for me to say hey this is a good idea. With that in mind, I would be happy to have factual corrections regarding OpenEHR which we can include in the next update to the book. I would also be happy to have someone on this list convince me that I am wrong about my assessment of OpenEHR. It is difficult because I see so much of what I have concerns about already mirrored on the OpenEHR list: http://www.openehr.org/mailarchives/openehr-implementers/msg00880.html Again, you do not need to convince me that you are right about the OpenEHR designs, you need to convince me that OpenEHR is relevant. Being right, sadly, has little to do with adoption. For instance, I am typing on a QWERTY keyboard right now, but I am convinced that this lady is technically right: http://workawesome.com/productivity/dvorak-keyboard-layout/ I am just convinced that she is relevant. -FT -- Fred Trotter http://www.fredtrotter.com -- next part -- An HTML attachment was scrubbed... URL: http://lists.openehr.org/mailman/private/openehr-technical_lists.openehr.org/attachments/20120216/25b9c355/attachment.html
