title: Alternatives to relational database: comparison of NoSQL and XML approaches for clinical data storage.
abstract: Clinical data are dynamic in nature, often arranged hierarchically and stored as free text and numbers. Effective management of clinical data and the transformation of the data into structured format for data analysis are therefore challenging issues in electronic health records development. Despite the popularity of relational databases, the scalability of the NoSQL database model and the document-centric data structure of XML databases appear to be promising features for effective clinical data management. In this paper, three database approaches--NoSQL, XML-enabled and native XML--are investigated to evaluate their suitability for structured clinical data. The database query performance is reported, together with our experience in the databases development. The results show that NoSQL database is the best choice for query speed, whereas XML databases are advantageous in terms of scalability, flexibility and extensibility, which are essential to cope with the characteristics of clinical data. While NoSQL and XML technologies are relatively new compared to the conventional relational database, both of them demonstrate potential to become a key database technology for clinical data management as the technology further advances.
authors.affiliation: Centre for Integrative Digital Health, School of Nursing, The Hong Kong Polytechnic University, Hung Hom, Kowloon, Hong Kong. kenleeky@gmail.com
authors.forename: Ken Ka-Yin
authors.initials: KK
authors.lastname: Lee
authors.forename: Wai-Choi
authors.initials: WC
authors.lastname: Tang
authors.forename: Kup-Sze
authors.initials: KS
authors.lastname: Choi
mesh_terms: D003198:Computer Simulation; D003627:Data Interpretation, Statistical; D003628:Database Management Systems; D016208:Databases, Factual / Q000706:statistics & numerical data*; D057286:Electronic Health Records / Q000706:statistics & numerical data; D006801:Humans; D016247:Information Storage and Retrieval / Q000379:methods*; D011381:Programming Languages; D012984:Software