Skip to main content
SpringerLink
Log in

Quasi-Relational Query Language Interface for Persistent Standardized EHRs: Using NoSQL Databases

  • Conference paper
Databases in Networked Information Systems (DNIS 2013)

Part of the book series: Lecture Notes in Computer Science ((LNISA,volume 7813))

Included in the following conference series:

Abstract

Interoperability of health data for information exhange is an area of growing concern. Various new standards such as CEN 13606, HL7 and OpenEHR have been proposed. The OpenEHR standard provides a Standardized Electronic Health Records (EHRs) schema using dual-level modelling for information exchange. The complex structured EHRs and the archetypes form the domain knowledge of the model. It gives rise to the issue of efficient and scalable persistence mechanism for these standardized EHRs. Further, it is desirable to support in-depth query-ability on them. The standardized EHRs database can support a wide range of user queries. In this paper, a persistence mechanism using a NoSQL database for storing the standardized EHRs has been proposed. Further, a high-level QBE-like AQBE (Archetype based Query-By-Example) has been evolved for the EHRs data repository.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Similar content being viewed by others

References

  1. Jacobs, A.: Pathologies of Big Data. Communications of ACM 52(8) (August 2009)

    Google Scholar 

  2. ADL for archetypes downloaded, http://www.openehr.org/svn/knowledge/archetypes/dev/html/index_en.html

  3. Any+time date picker downloaded form, http://www.ama3.com/anytime/

  4. AQL query builder available at, http://www.oceaninformatics.com/Solutions/openehr-solutions/ocean-products/Clinical-Modelling/Ocean-Query-Builder.html

  5. Archetype Query Language, http://www.openehr.org/wiki/display/spec/~Archetype+Query+Language+Description

  6. Beale, T., Heard, S., Kalra, D., Llyod, D.: The OpenEHR Reference Model: EHR Information Model, The OpenEHR release 1.0.2., OpenEHR Foundation (2008)

    Google Scholar 

  7. Beale, T.: The OpenEHR Archetype Model-Archetype Object Model, The OpenEHR release 1.0.2., OpenEHR Foundation (2008)

    Google Scholar 

  8. Casbah plugin available at, https://github.com/mongodb/casbah

  9. CEN 13606 standard, http://www.en13606.org/the-ceniso-en13606-standard

  10. Clinical Knowledge Manager, http://www.openehr.org/knowledge/

  11. Eclipse 4.2.0, http://www.eclipse.org/

  12. Redmond, E., Wilson, J.R.: Book: Seven Databases in Seven Weeks (May 2012)

    Google Scholar 

  13. HTML 5, http://www.w3schools.com/html/html5_intro.asp

  14. http://wako3.u-aizu.ac.jp:8080/aqbe/

  15. ISO 13606-1: Health informatics - Electronic health record communication- Part 1: RM., 1st edn. (2008)

    Google Scholar 

  16. JavaScript, http://www.w3schools.com/js/default.asp

  17. jQuery downloaded from, http://jquery.com/

  18. jQuery UI available at, http://jqueryui.com/

  19. Lift JSON available at, https://github.com/lift/lift/tree/master/framework/lift-base/lift-json/

  20. MongoDB available at, http://www.mongodb.org/

  21. Zloof, M.M.: Query-By-Example: The invocation and definition of tables and forms (1975)

    Google Scholar 

  22. Opereffa Project available at, http://www.openehr.org/wiki/display/projects/Opereffa+Project

  23. Play framework available at, http://www.playframework.org/

  24. PostgreSQL database downloadable from, http://www.postgresql.org/

  25. Scala Plugin available at, http://www.scala-lang.org/

  26. Freire, S.M., Sundvall, E., Karlsson, D., Lambrix, P.: Performance of XML Databases for Epidemiological Queries in Archetype-Based EHRs. In: Scandinavian Conference on Health Informatics 2012, Linköping, Sweden, October 2–3 (2012)

    Google Scholar 

  27. Sachdeva, S., Madaan, A., Chu, W.: Information interchange services for electronic health record databases. IJCSE 7(1), 38–51 (2012)

    Article  Google Scholar 

  28. Sachdeva, S., Yaginuma, D., Chu, W., Bhalla, S.: AQBE - QBE Style Queries for Archetyped Data. IEICE Transactions 95-D(3), 861–871 (2012)

    Google Scholar 

  29. Sachdeva, S., Bhalla, S.: Semantic interoperability in standardized electronic health record databases. J. Data and Information Quality 3(1), 1 (2012)

    Article  Google Scholar 

  30. Beale, T.: OpenEHR: Node + Path Persistence (2008)

    Google Scholar 

  31. Twitter bootstrap framework downloaded from, http://twitter.github.com/bootstrap/

Download references

Author information

Authors and Affiliations

  1. University of Aizu, Aizu Wakamatsu Shi, Fukushima Ken, Japan, 965-8580

    Aastha Madaan, Wanming Chu, Yaginuma Daigo & Subhash Bhalla

Authors
  1. Aastha Madaan
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Wanming Chu
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Yaginuma Daigo
    View author publications

    You can also search for this author in PubMed Google Scholar

  4. Subhash Bhalla
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Graduate Department of Computer and Information Systems, University of Aizu, Ikki Machi, 965-8580, Aizu-Wakamatsu, Fukushima, Japan

    Aastha Madaan , Shinji Kikuchi  & Subhash Bhalla ,  & 

Rights and permissions

Reprints and permissions

Copyright information

© 2013 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Madaan, A., Chu, W., Daigo, Y., Bhalla, S. (2013). Quasi-Relational Query Language Interface for Persistent Standardized EHRs: Using NoSQL Databases. In: Madaan, A., Kikuchi, S., Bhalla, S. (eds) Databases in Networked Information Systems. DNIS 2013. Lecture Notes in Computer Science, vol 7813. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-37134-9_15

Download citation

  • DOI: https://doi.org/10.1007/978-3-642-37134-9_15

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-642-37133-2

  • Online ISBN: 978-3-642-37134-9

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation