Alternatives to relational database: Comparison of NoSQL and XML approaches for clinical data storage

Computer Methods and Programs in Biomedicine

Volumn 110, Issue 1, 2013, Pages 99-109

  Lee, Ken Ka Yin ^a   Tang, Wai Choi ^b   Choi, Kup Sze ^a  

^a HONG KONG POLYTECHNIC UNIVERSITY   (Hong Kong)

^b Hong Kong Doctors Union   (Hong Kong)

Author keywords

Clinical data; Information storage and retrieval; NoSQL; Relational database; XML

Indexed keywords

CLINICAL DATA; DATABASE APPROACHES; DATABASE TECHNOLOGY; EFFECTIVE MANAGEMENT; ELECTRONIC HEALTH RECORD; INFORMATION STORAGE AND RETRIEVAL; NOSQL; RELATIONAL DATABASE;

DATA STRUCTURES; METADATA; QUERY PROCESSING; SCALABILITY; XML;

INFORMATION MANAGEMENT;

ARTICLE; COMPARATIVE STUDY; COMPUTER MODEL; CONTROLLED STUDY; DATA BASE; ELECTRONIC MEDICAL RECORD; INFORMATION PROCESSING; INFORMATION RETRIEVAL; INFORMATION TECHNOLOGY; MARKUP LANGUAGE; MEDICAL INFORMATICS; NOSQL DATABASE;

COMPUTER SIMULATION; DATA INTERPRETATION, STATISTICAL; DATABASE MANAGEMENT SYSTEMS; DATABASES, FACTUAL; ELECTRONIC HEALTH RECORDS; HUMANS; INFORMATION STORAGE AND RETRIEVAL; PROGRAMMING LANGUAGES; SOFTWARE;

EID: 84875115346     PISSN: 01692607     EISSN: 18727565     Source Type: Journal    
DOI: 10.1016/j.cmpb.2012.10.018     Document Type: Article

References (31)

1. Wasan S., Bhatnagar V. The impact of data mining techniques on medical diagnostics. Data Science Journal 2006, 5:119-126.
2. Atzeni P., Antonellis V.D. Relational Database Theory 1993, Benjamin-Cummings Publishing, San Francisco, CA.
3. Kent W. A simple guide to five normal forms in relational database theory. Communications of the ACM 1983, 26:120-125.
4. Cios K., Moore G. Uniqueness of medical data mining. Artificial Intelligence in Medicine 2002, 26:1-24.
5. McDonald C.J. The barriers to electronic medical record systems and how to overcome them. Journal of the American Medical Informatics Association 1997, 4:213-221.
6. Bergamaschi S., Castano S., Vincini M. Semantic integration of semistructured and structured data sources. ACM SIGMOD Records 1999, 28:54-59.
7. Los R., Ginneken A., De Wilde M., Der Lei J. OpenSDE: row modeling applied to generic structured data entry. Journal of the American Medical Informatics Association 2004, 11:162-165.
8. Prather J.C., Lobach D.F., Goodwin L.K., Hales J.W., Hage M.L., Hammond W.E. Medical data mining: knowledge discovery in a clinical data warehouse. AMIA Annual Fall Symposium 1997, 101-105.
9. Rector A., Nolan W., Kay S. Foundations for an electronic medical record. Methods of Information in Medicine 1991, 30:179-186.
10. Strauch C., Sites U.L.S., Kriha W. NoSQL Databases, Lecture Notes 2011, Stuttgart Media University.
11. Cattell R. Scalable sql and nosql data stores. ACM SIGMOD Records 2011, 39:12-27.
12. Roitman H., Yogev S., Tsimerman Y., Kim D.W., Mesika Y. Exploratory search over social-medical data. Proceedings of the 20th ACM International Conference on Information and Knowledge Management 2011, 2513-2516. ACM, Glasgow, Scotland, UK.
13. Yang J., Tang D., Zheng X. Research on the distributed electronic medical records storage model. 2011 International Symposium on IT in Medicine and Education (ITME) 2011, 288-292.
14. Catley C., Frize M. A prototype XML-based implementation of an integrated 'intelligent' neonatal intensive care unit. 4th International IEEE EMBS Special Topic Conference on Information Technology Applications in Biomedicine 2003, 322-325.
15. Stalidis G., Prentzab A. Medical support system for continuation of care based on XML web technology. International Journal of Medical Informatics 2001, 64:385-400.
16. Araki K., Ohashi K. Medical markup language (MML) for XML-based hospital information interchange. Journal of Medical Systems 2010, 24:195-211.
17. Jagadish H., Al-Khalifa S., Chapma A. TIMBER: a native XML database. The VLDB Journal 2002, 11:274-291.
18. Meier W. eXist: an open source native XML database. Web, Web-Services, and Database Systems 2003, 169-183. Springer, Berlin, Heidelberg. A. Chaudhri, M. Jeckle, E. Rahm, R. Unland (Eds.).
19. Fiebig T., Helmer S., Kanne C.-C., Moerkotte G., Neumann J., Schiele R., Westmann T. Anatomy of a native XML base management system. The VLDB Journal 2002, 11:292-314.
20. Paterson G.I., Shepherd M., Xiaoli W., Watters C., Zitner D. Using the XML-based clinical document architecture for exchange of structured discharge summaries. Proceedings of the 35th Annual Hawaii International Conference on System Sciences (HICSS) 2002, 1200-1209.
21. Li S., Chen F. Native-XML storage method of electronic medical record. Computer Aided Engineering 2006, 4.
22. de la Torre I., Díaz F., Antón M., Díez J., Sainz B., López M., Hornero R., López M. Choosing the most efficient database for a web-based system to store and exchange ophthalmologic health records. Journal of Medical Systems 2011, 35:1455-1464.
23. Beale T. Archetypes: constraint-based domain models for future-proof information systems. OOPSLA 2002 Workshop on Behavioural Semantics 2002, 1-18.
24. Schloeffel P., Beale T., Hayworth G., Heard S., Leslie H. The relationship between CEN 13606, HL7, and openEHR. HIC 2006 Bridging the Digital Divide: Clinician, Consumer and Computer 2006.
25. Boone K.W., Boone K.W. The HL7 clinical document architecture. The CDA TM Book 2011, Springer, London, pp. 17-21.
26. Lavra N. Selected techniques for data mining in medicine. Artificial Intelligence in Medicine 1999, 16:3-23.
27. Weglarz G. Two worlds of data - unstructured and structured. DM Review 2004, 14:19-22.
28. Los R.K., van Ginneken A.M., van der Lei J. Extracting data recorded with OpenSDE: possibilities and limitations. International Journal of Medical Informatics 2005, 74:473-480.
29. Golick J. Introducing Friendly: NoSQL with MySQL in Ruby Available from:. http://jamesgolick.com/2009/12/16/introducing-friendly-nosql-with-mysql-in-ruby.html.
30. Ullman J.D., Widom J. A First Course in Database Systems 2007, Prentice Hall, Upper Saddle River, NJ. 3rd ed.
31. Walmsley P. XQuery 2007, O'Reilly Media, Sebastopol, CA.