Exploring Performance Issues for a Clinical Database Organized Using an Entity-Attribute-Value Representation
Chen R, Nadkarni P, Marenco L, Levin F, Erdos J, Miller P. Exploring Performance Issues for a Clinical Database Organized Using an Entity-Attribute-Value Representation. Journal Of The American Medical Informatics Association 2000, 7: 475-487. PMID: 10984467, PMCID: PMC79043, DOI: 10.1136/jamia.2000.0070475.Peer-Reviewed Original ResearchConceptsEAV/CRDatabase schemaSQL statementsDatabase modelDatabase sizeSystem memoryQuery execution timeHeterogeneous biomedical dataSimple SQL statementsQuery efficiencyQuery performancePowerful hardwareQuery strategyEntity attributesDatabase queriesDatabase representationBiomedical dataExecution timeQueriesMore memoryPerformance issuesSchemaValue representationRepresentationCR model