Performance evaluation of various storage formats for Clinical Data Repositories

Author

Gilchrist, Jeff ; Frize, Monique ; Ennett, Colleen M. ; Bariciak, Erika

Author_Institution

Dept. Syst. & Comput. Eng., Carleton Univ., Ottawa, ON, Canada

fYear

2010

fDate

April 30 2010-May 1 2010

Firstpage

63

Lastpage

68

Abstract

The performance of three different Entity-Attribute-Value (EAV) storage formats for Clinical Data Repositories (CDRs) is compared with regards to querying millions of data points from clinical sources to assess the amount of storage space the data use, the speed with which the data can be obtained, and the complexity of the queries required to retrieve the data. Performance results are presented that show that the hybrid EAV approach provides a nice balance of the simple and multi-data type formats.

Keywords

decision support systems; medical administrative data processing; medical computing; query processing; clinical data repositories; clinical sources; data querying; data retrieval; entity-attribute-value; performance evaluation; queries complexity; storage formats; storage space; Biomedical computing; Biomedical engineering; Biomedical imaging; Biomedical measurements; Hospitals; Medical services; North America; Pediatrics; Spatial databases; Systems engineering and theory; clinical data respository; decision-support systems; entitity-attribute-value; performance evaluation;

fLanguage

English

Publisher

ieee

Conference_Titel

Medical Measurements and Applications Proceedings (MeMeA), 2010 IEEE International Workshop on

Conference_Location

Ottawa, ON

Print_ISBN

978-1-4244-6288-9

Type

conf

DOI

10.1109/MEMEA.2010.5480232

Filename

5480232