{"id":"https://openalex.org/W2158166765","doi":"https://doi.org/10.1016/s1386-5056(02)00047-3","title":"Metadata-driven creation of data marts from an EAV-modeled clinical research database","display_name":"Metadata-driven creation of data marts from an EAV-modeled clinical research database","publication_year":2002,"publication_date":"2002-11-01","ids":{"openalex":"https://openalex.org/W2158166765","doi":"https://doi.org/10.1016/s1386-5056(02)00047-3","mag":"2158166765","pmid":"https://pubmed.ncbi.nlm.nih.gov/12414020"},"language":"en","primary_location":{"id":"doi:10.1016/s1386-5056(02)00047-3","is_oa":false,"landing_page_url":"https://doi.org/10.1016/s1386-5056(02)00047-3","pdf_url":null,"source":{"id":"https://openalex.org/S53142634","display_name":"International Journal of Medical Informatics","issn_l":"1386-5056","issn":["1386-5056","1872-8243"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320990","host_organization_name":"Elsevier BV","host_organization_lineage":["https://openalex.org/P4310320990"],"host_organization_lineage_names":["Elsevier BV"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Medical Informatics","raw_type":"journal-article"},"type":"article","indexed_in":["crossref","pubmed"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5038171056","display_name":"Cynthia Brandt","orcid":"https://orcid.org/0000-0001-8179-1796"},"institutions":[{"id":"https://openalex.org/I32971472","display_name":"Yale University","ror":"https://ror.org/03v76x132","country_code":"US","type":"education","lineage":["https://openalex.org/I32971472"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Cynthia A Brandt","raw_affiliation_strings":["Center for Medical Informatics, Yale University School of Medicine, P.O. Box 208009, New Haven, CT 06520-8009, USA. cynthia.brandt@yale.edu","Center for Medical Informatics, Yale University School of Medicine, P.O. Box 208009, New Haven, CT 06520-8009, USA"],"affiliations":[{"raw_affiliation_string":"Center for Medical Informatics, Yale University School of Medicine, P.O. Box 208009, New Haven, CT 06520-8009, USA. cynthia.brandt@yale.edu","institution_ids":["https://openalex.org/I32971472"]},{"raw_affiliation_string":"Center for Medical Informatics, Yale University School of Medicine, P.O. Box 208009, New Haven, CT 06520-8009, USA","institution_ids":["https://openalex.org/I32971472"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5063531896","display_name":"R.I. Morse","orcid":null},"institutions":[{"id":"https://openalex.org/I32971472","display_name":"Yale University","ror":"https://ror.org/03v76x132","country_code":"US","type":"education","lineage":["https://openalex.org/I32971472"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Richard Morse","raw_affiliation_strings":["Center for Medical Informatics, Yale University School of Medicine, P.O. Box 208009, New Haven, CT 06520-8009, USA"],"affiliations":[{"raw_affiliation_string":"Center for Medical Informatics, Yale University School of Medicine, P.O. Box 208009, New Haven, CT 06520-8009, USA","institution_ids":["https://openalex.org/I32971472"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5000991755","display_name":"Keri Matthews","orcid":null},"institutions":[{"id":"https://openalex.org/I32971472","display_name":"Yale University","ror":"https://ror.org/03v76x132","country_code":"US","type":"education","lineage":["https://openalex.org/I32971472"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Keri Matthews","raw_affiliation_strings":["Center for Medical Informatics, Yale University School of Medicine, P.O. Box 208009, New Haven, CT 06520-8009, USA"],"affiliations":[{"raw_affiliation_string":"Center for Medical Informatics, Yale University School of Medicine, P.O. Box 208009, New Haven, CT 06520-8009, USA","institution_ids":["https://openalex.org/I32971472"]}]},{"author_position":"middle","author":{"id":null,"display_name":"Kexin Sun","orcid":null},"institutions":[{"id":"https://openalex.org/I32971472","display_name":"Yale University","ror":"https://ror.org/03v76x132","country_code":"US","type":"education","lineage":["https://openalex.org/I32971472"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Kexin Sun","raw_affiliation_strings":["Center for Medical Informatics, Yale University School of Medicine, P.O. Box 208009, New Haven, CT 06520-8009, USA"],"affiliations":[{"raw_affiliation_string":"Center for Medical Informatics, Yale University School of Medicine, P.O. Box 208009, New Haven, CT 06520-8009, USA","institution_ids":["https://openalex.org/I32971472"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5038583014","display_name":"Aniruddha M. Deshpande","orcid":null},"institutions":[{"id":"https://openalex.org/I32971472","display_name":"Yale University","ror":"https://ror.org/03v76x132","country_code":"US","type":"education","lineage":["https://openalex.org/I32971472"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Aniruddha M Deshpande","raw_affiliation_strings":["Center for Medical Informatics, Yale University School of Medicine, P.O. Box 208009, New Haven, CT 06520-8009, USA"],"affiliations":[{"raw_affiliation_string":"Center for Medical Informatics, Yale University School of Medicine, P.O. Box 208009, New Haven, CT 06520-8009, USA","institution_ids":["https://openalex.org/I32971472"]}]},{"author_position":"middle","author":{"id":null,"display_name":"Rohit Gadagkar","orcid":null},"institutions":[{"id":"https://openalex.org/I32971472","display_name":"Yale University","ror":"https://ror.org/03v76x132","country_code":"US","type":"education","lineage":["https://openalex.org/I32971472"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Rohit Gadagkar","raw_affiliation_strings":["Center for Medical Informatics, Yale University School of Medicine, P.O. Box 208009, New Haven, CT 06520-8009, USA"],"affiliations":[{"raw_affiliation_string":"Center for Medical Informatics, Yale University School of Medicine, P.O. Box 208009, New Haven, CT 06520-8009, USA","institution_ids":["https://openalex.org/I32971472"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5088830653","display_name":"Dorothy B. Cohen","orcid":null},"institutions":[{"id":"https://openalex.org/I32971472","display_name":"Yale University","ror":"https://ror.org/03v76x132","country_code":"US","type":"education","lineage":["https://openalex.org/I32971472"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Dorothy B Cohen","raw_affiliation_strings":["Center for Medical Informatics, Yale University School of Medicine, P.O. Box 208009, New Haven, CT 06520-8009, USA"],"affiliations":[{"raw_affiliation_string":"Center for Medical Informatics, Yale University School of Medicine, P.O. Box 208009, New Haven, CT 06520-8009, USA","institution_ids":["https://openalex.org/I32971472"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5028341826","display_name":"Perry L. Miller","orcid":null},"institutions":[{"id":"https://openalex.org/I32971472","display_name":"Yale University","ror":"https://ror.org/03v76x132","country_code":"US","type":"education","lineage":["https://openalex.org/I32971472"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Perry L Miller","raw_affiliation_strings":["Center for Medical Informatics, Yale University School of Medicine, P.O. Box 208009, New Haven, CT 06520-8009, USA"],"affiliations":[{"raw_affiliation_string":"Center for Medical Informatics, Yale University School of Medicine, P.O. Box 208009, New Haven, CT 06520-8009, USA","institution_ids":["https://openalex.org/I32971472"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5108276842","display_name":"Prakash M. Nadkarni","orcid":"https://orcid.org/0000-0002-9628-4700"},"institutions":[{"id":"https://openalex.org/I32971472","display_name":"Yale University","ror":"https://ror.org/03v76x132","country_code":"US","type":"education","lineage":["https://openalex.org/I32971472"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Prakash M Nadkarni","raw_affiliation_strings":["Center for Medical Informatics, Yale University School of Medicine, P.O. Box 208009, New Haven, CT 06520-8009, USA"],"affiliations":[{"raw_affiliation_string":"Center for Medical Informatics, Yale University School of Medicine, P.O. Box 208009, New Haven, CT 06520-8009, USA","institution_ids":["https://openalex.org/I32971472"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":9,"corresponding_author_ids":["https://openalex.org/A5038171056"],"corresponding_institution_ids":["https://openalex.org/I32971472"],"apc_list":{"value":3210,"currency":"USD","value_usd":3210},"apc_paid":null,"fwci":0.5729,"has_fulltext":false,"cited_by_count":36,"citation_normalized_percentile":{"value":0.66156151,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":98},"biblio":{"volume":"65","issue":"3","first_page":"225","last_page":"241"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11710","display_name":"Biomedical Text Mining and Ontologies","score":0.9994000196456909,"subfield":{"id":"https://openalex.org/subfields/1312","display_name":"Molecular Biology"},"field":{"id":"https://openalex.org/fields/13","display_name":"Biochemistry, Genetics and Molecular Biology"},"domain":{"id":"https://openalex.org/domains/1","display_name":"Life Sciences"}},"topics":[{"id":"https://openalex.org/T11710","display_name":"Biomedical Text Mining and Ontologies","score":0.9994000196456909,"subfield":{"id":"https://openalex.org/subfields/1312","display_name":"Molecular Biology"},"field":{"id":"https://openalex.org/fields/13","display_name":"Biochemistry, Genetics and Molecular Biology"},"domain":{"id":"https://openalex.org/domains/1","display_name":"Life Sciences"}},{"id":"https://openalex.org/T10215","display_name":"Semantic Web and Ontologies","score":0.9939000010490417,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9850000143051147,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/metadata","display_name":"Metadata","score":0.8611918687820435},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7487398386001587},{"id":"https://openalex.org/keywords/data-element","display_name":"Data element","score":0.7272121906280518},{"id":"https://openalex.org/keywords/metadata-repository","display_name":"Metadata repository","score":0.7005326151847839},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.6106165051460266},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.5300443172454834},{"id":"https://openalex.org/keywords/database-transaction","display_name":"Database transaction","score":0.49977898597717285},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.48355910181999207},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.4751550853252411},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.46345019340515137},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.45649993419647217},{"id":"https://openalex.org/keywords/data-mapping","display_name":"Data mapping","score":0.4482996165752411},{"id":"https://openalex.org/keywords/transaction-processing","display_name":"Transaction processing","score":0.4471811354160309},{"id":"https://openalex.org/keywords/process","display_name":"Process (computing)","score":0.42633116245269775},{"id":"https://openalex.org/keywords/data-modeling","display_name":"Data modeling","score":0.4254749119281769},{"id":"https://openalex.org/keywords/metadata-modeling","display_name":"Metadata modeling","score":0.41529595851898193},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.14629769325256348}],"concepts":[{"id":"https://openalex.org/C93518851","wikidata":"https://www.wikidata.org/wiki/Q180160","display_name":"Metadata","level":2,"score":0.8611918687820435},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7487398386001587},{"id":"https://openalex.org/C30872290","wikidata":"https://www.wikidata.org/wiki/Q1172389","display_name":"Data element","level":3,"score":0.7272121906280518},{"id":"https://openalex.org/C153048206","wikidata":"https://www.wikidata.org/wiki/Q3454922","display_name":"Metadata repository","level":3,"score":0.7005326151847839},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6106165051460266},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.5300443172454834},{"id":"https://openalex.org/C75949130","wikidata":"https://www.wikidata.org/wiki/Q848010","display_name":"Database transaction","level":2,"score":0.49977898597717285},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.48355910181999207},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.4751550853252411},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.46345019340515137},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.45649993419647217},{"id":"https://openalex.org/C137314826","wikidata":"https://www.wikidata.org/wiki/Q2330408","display_name":"Data mapping","level":2,"score":0.4482996165752411},{"id":"https://openalex.org/C72108876","wikidata":"https://www.wikidata.org/wiki/Q844565","display_name":"Transaction processing","level":3,"score":0.4471811354160309},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.42633116245269775},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.4254749119281769},{"id":"https://openalex.org/C110326360","wikidata":"https://www.wikidata.org/wiki/Q17149476","display_name":"Metadata modeling","level":4,"score":0.41529595851898193},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.14629769325256348},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0}],"mesh":[{"descriptor_ui":"D001943","descriptor_name":"Breast Neoplasms","qualifier_ui":"Q000473","qualifier_name":"pathology","is_major_topic":false},{"descriptor_ui":"D001943","descriptor_name":"Breast Neoplasms","qualifier_ui":"Q000473","qualifier_name":"pathology","is_major_topic":false},{"descriptor_ui":"D001943","descriptor_name":"Breast Neoplasms","qualifier_ui":"Q000473","qualifier_name":"pathology","is_major_topic":false},{"descriptor_ui":"D003628","descriptor_name":"Database Management Systems","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D003628","descriptor_name":"Database Management Systems","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D003628","descriptor_name":"Database Management Systems","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D005260","descriptor_name":"Female","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D005260","descriptor_name":"Female","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D005260","descriptor_name":"Female","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D006801","descriptor_name":"Humans","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D006801","descriptor_name":"Humans","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D006801","descriptor_name":"Humans","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D008491","descriptor_name":"Medical Informatics Applications","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D008491","descriptor_name":"Medical Informatics Applications","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D008491","descriptor_name":"Medical Informatics Applications","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D012984","descriptor_name":"Software","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D012984","descriptor_name":"Software","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D012984","descriptor_name":"Software","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D016247","descriptor_name":"Information Storage and Retrieval","qualifier_ui":"Q000379","qualifier_name":"methods","is_major_topic":false},{"descriptor_ui":"D016247","descriptor_name":"Information Storage and Retrieval","qualifier_ui":"Q000379","qualifier_name":"methods","is_major_topic":false},{"descriptor_ui":"D016247","descriptor_name":"Information Storage and Retrieval","qualifier_ui":"Q000379","qualifier_name":"methods","is_major_topic":false},{"descriptor_ui":"D019992","descriptor_name":"Databases as Topic","qualifier_ui":"Q000458","qualifier_name":"organization & administration","is_major_topic":false},{"descriptor_ui":"D019992","descriptor_name":"Databases as Topic","qualifier_ui":"Q000458","qualifier_name":"organization & administration","is_major_topic":false},{"descriptor_ui":"D019992","descriptor_name":"Databases as Topic","qualifier_ui":"Q000458","qualifier_name":"organization & administration","is_major_topic":false}],"locations_count":2,"locations":[{"id":"doi:10.1016/s1386-5056(02)00047-3","is_oa":false,"landing_page_url":"https://doi.org/10.1016/s1386-5056(02)00047-3","pdf_url":null,"source":{"id":"https://openalex.org/S53142634","display_name":"International Journal of Medical Informatics","issn_l":"1386-5056","issn":["1386-5056","1872-8243"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320990","host_organization_name":"Elsevier BV","host_organization_lineage":["https://openalex.org/P4310320990"],"host_organization_lineage_names":["Elsevier BV"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Medical Informatics","raw_type":"journal-article"},{"id":"pmid:12414020","is_oa":false,"landing_page_url":"https://pubmed.ncbi.nlm.nih.gov/12414020","pdf_url":null,"source":{"id":"https://openalex.org/S4306525036","display_name":"PubMed","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I1299303238","host_organization_name":"National Institutes of Health","host_organization_lineage":["https://openalex.org/I1299303238"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International journal of medical informatics","raw_type":null}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/16","score":0.6399999856948853,"display_name":"Peace, Justice and strong institutions"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":23,"referenced_works":["https://openalex.org/W24051059","https://openalex.org/W65034982","https://openalex.org/W69578548","https://openalex.org/W116577868","https://openalex.org/W120004692","https://openalex.org/W1495046469","https://openalex.org/W1505413869","https://openalex.org/W1527889792","https://openalex.org/W1558143179","https://openalex.org/W1580479626","https://openalex.org/W1709754610","https://openalex.org/W2006324536","https://openalex.org/W2006952048","https://openalex.org/W2096267157","https://openalex.org/W2097601626","https://openalex.org/W2122824930","https://openalex.org/W2138709157","https://openalex.org/W2151785374","https://openalex.org/W2230496145","https://openalex.org/W2246616378","https://openalex.org/W2402157972","https://openalex.org/W2914967825","https://openalex.org/W6825121530"],"related_works":["https://openalex.org/W2807292920","https://openalex.org/W4289754504","https://openalex.org/W3103113537","https://openalex.org/W2151972543","https://openalex.org/W756399425","https://openalex.org/W2372299323","https://openalex.org/W2186093090","https://openalex.org/W3199626854","https://openalex.org/W119440456","https://openalex.org/W2158166765"],"abstract_inverted_index":null,"counts_by_year":[{"year":2021,"cited_by_count":1},{"year":2018,"cited_by_count":1},{"year":2017,"cited_by_count":1},{"year":2016,"cited_by_count":3},{"year":2015,"cited_by_count":3},{"year":2014,"cited_by_count":4},{"year":2013,"cited_by_count":2},{"year":2012,"cited_by_count":2}],"updated_date":"2026-04-21T08:09:41.155169","created_date":"2025-10-10T00:00:00"}