2006
Pivoting approaches for bulk extraction of Entity–Attribute–Value data
Dinu V, Nadkarni P, Brandt C. Pivoting approaches for bulk extraction of Entity–Attribute–Value data. Computer Methods And Programs In Biomedicine 2006, 82: 38-43. PMID: 16556470, DOI: 10.1016/j.cmpb.2006.02.001.Peer-Reviewed Original ResearchConceptsEntity attributesClinical study data management systemsData management systemNumber of attributesDatabase serverHash tableClinical patient dataValue dataManagement systemAlternative algorithmsPatient dataSQLServerRepositoryAlgorithmComplex approachFormatDataAttributesParameter formatOne-columnExtractionAnalytical programPerformanceMemory
2002
Metadata-driven creation of data marts from an EAV-modeled clinical research database
Brandt CA, Morse R, Matthews K, Sun K, Deshpande AM, Gadagkar R, Cohen DB, Miller PL, Nadkarni PM. Metadata-driven creation of data marts from an EAV-modeled clinical research database. International Journal Of Medical Informatics 2002, 65: 225-241. PMID: 12414020, DOI: 10.1016/s1386-5056(02)00047-3.Peer-Reviewed Original ResearchConceptsData martClinical study data management systemsTransaction-oriented systemsData management systemClinical research databaseDatabase schemaEntity attributesAnalytical processingHuman interpretationStudy metadataMetadataManagement systemArbitrary numberData entrySuch dataBrowsingValue modelSchemaMartHigher-level groupingsSystemDataProcessingDatabaseCreation
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 modelWebEAV
Nadkarni P, Brandt C, Marenco L. WebEAV. Journal Of The American Medical Informatics Association 2000, 7: 343-356. PMID: 10887163, PMCID: PMC61439, DOI: 10.1136/jamia.2000.0070343.Peer-Reviewed Original ResearchConceptsWeb development environmentWeb application developmentUser interface issuesClient-server technologyValue databaseWeb technologiesApplication developmentEntity attributesWeb developmentDevelopment environmentWeb interfaceGeneric frameworkInterface issuesComplex systemsFront endDatabaseTechnologyMetadataDevelopersSuitable examplesArchitectureTaskFeaturesFrameworkVehicles
1999
Neuronal database integration: the Senselab EAV data model.
Marenco L, Nadkarni P, Skoufos E, Shepherd G, Miller P. Neuronal database integration: the Senselab EAV data model. AMIA Annual Symposium Proceedings 1999, 102-6. PMID: 10566329, PMCID: PMC2232788.Peer-Reviewed Original Research
1998
Data Extraction and Ad Hoc Query of an Entity—Attribute—Value Database
Nadkarni P, Brandt C. Data Extraction and Ad Hoc Query of an Entity—Attribute—Value Database. Journal Of The American Medical Informatics Association 1998, 5: 511-527. PMID: 9824799, PMCID: PMC61332, DOI: 10.1136/jamia.1998.0050511.Peer-Reviewed Original ResearchConceptsElectronic patient record systemQuery problemAd-Hoc QueriesReal-time retrievalPatient record systemData warehousingEntity attributesComplex subproblemsData retrievalQueriesValue databaseRecord systemSuch systemsRetrievalValue tablePatient dataFront endAttributesMetadataWarehousingDatabaseUsersData extractionSubproblemsIndividual attributes