Exploring Performance Issues for a Clinical Database Organized Using an Entity-Attribute-Value Representation

Abstract

This paper describes a pilot project to explore issues in and compare query performance for EAV/CR and conventional database representations. Although attribute-centered queries were less efficient in the EAV/CR model, these inefficiencies may be addressable, at least in part, by the use of more powerful hardware or more memory, or both.