2006
Dynamic Tables: An Architecture for Managing Evolving, Heterogeneous Biomedical Data in Relational Database Management Systems
Corwin J, Silberschatz A, Miller PL, Marenco L. Dynamic Tables: An Architecture for Managing Evolving, Heterogeneous Biomedical Data in Relational Database Management Systems. Journal Of The American Medical Informatics Association 2006, 14: 86-93. PMID: 17068350, PMCID: PMC2215074, DOI: 10.1197/jamia.m2189.Peer-Reviewed Original ResearchConceptsBiomedical dataRelational database management systemRelational database technologySemantic data modelDatabase management systemRelational database enginePerformance of queriesHeterogeneous biomedical dataBiomedical informatics researchersDatabase engineDatabase technologyDatabase schemaData sparsityBioinformatics communityData modelInformatics researchersEvolution issuesTypes of dataManagement systemPerformance resultsRelational designClinical informaticsArchitecturePast approachesRelational techniques
2000
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