{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,4,1]],"date-time":"2026-04-01T14:19:12Z","timestamp":1775053152278,"version":"3.50.1"},"reference-count":27,"publisher":"Elsevier BV","issue":"3","license":[{"start":{"date-parts":[[2002,11,1]],"date-time":"2002-11-01T00:00:00Z","timestamp":1036108800000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/www.elsevier.com\/tdm\/userlicense\/1.0\/"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["International Journal of Medical Informatics"],"published-print":{"date-parts":[[2002,11]]},"DOI":"10.1016\/s1386-5056(02)00047-3","type":"journal-article","created":{"date-parts":[[2002,11,4]],"date-time":"2002-11-04T20:06:14Z","timestamp":1036440374000},"page":"225-241","source":"Crossref","is-referenced-by-count":28,"title":["Metadata-driven creation of data marts from an EAV-modeled clinical research database"],"prefix":"10.1016","volume":"65","author":[{"given":"Cynthia A","family":"Brandt","sequence":"first","affiliation":[]},{"given":"Richard","family":"Morse","sequence":"additional","affiliation":[]},{"given":"Keri","family":"Matthews","sequence":"additional","affiliation":[]},{"given":"Kexin","family":"Sun","sequence":"additional","affiliation":[]},{"given":"Aniruddha M","family":"Deshpande","sequence":"additional","affiliation":[]},{"given":"Rohit","family":"Gadagkar","sequence":"additional","affiliation":[]},{"given":"Dorothy B","family":"Cohen","sequence":"additional","affiliation":[]},{"given":"Perry L","family":"Miller","sequence":"additional","affiliation":[]},{"given":"Prakash M","family":"Nadkarni","sequence":"additional","affiliation":[]}],"member":"78","reference":[{"key":"10.1016\/S1386-5056(02)00047-3_BIB1","unstructured":"Cancer Genetics Network, NCI, National Cancer Institute, available from http:\/\/epi.grants.cancer.gov\/CGN\/, last accessed on 6\/11\/2002."},{"key":"10.1016\/S1386-5056(02)00047-3_BIB2","unstructured":"D.J. Nigrin, I.S. Kohane, Data mining by clinicians, Proceedings of the AMIA Symposium, 1998 pp. 957\u2013961."},{"key":"10.1016\/S1386-5056(02)00047-3_BIB3","unstructured":"A. Wilcox, G. Hripcsak, C. Chen, Creating an environment for linking knowledge-based systems to a clinical database: a suite of tools, Proceedings of the AMIA Annual Fall Symposium, 1997 pp. 303\u2013307."},{"key":"10.1016\/S1386-5056(02)00047-3_BIB4","unstructured":"A. Wilcox, G. Hripcsak, CPMC Query Builder. 1998, available from http:\/\/www.cpmc.columbia.edu\/arden\/qbr\/."},{"issue":"4","key":"10.1016\/S1386-5056(02)00047-3_BIB5","doi-asserted-by":"crossref","first-page":"328","DOI":"10.1055\/s-0038-1634607","article-title":"A graphical query generator for clinical research databases","volume":"34","author":"Banhart","year":"1995","journal-title":"Methods Inf. Med."},{"issue":"4","key":"10.1016\/S1386-5056(02)00047-3_BIB6","doi-asserted-by":"crossref","first-page":"288","DOI":"10.1136\/jamia.1996.96413137","article-title":"Access to data: comparing AccessMed with Query by Review","volume":"3","author":"Hripcsak","year":"1996","journal-title":"J. Am. Med. Inform. Assoc."},{"issue":"1","key":"10.1016\/S1386-5056(02)00047-3_BIB7","doi-asserted-by":"crossref","first-page":"151","DOI":"10.1016\/0020-7101(94)01094-H","article-title":"Exploration and exploitation of clinical databases","volume":"39","author":"Safran","year":"1995","journal-title":"Int. J. Biomed. Comput."},{"issue":"4","key":"10.1016\/S1386-5056(02)00047-3_BIB8","doi-asserted-by":"crossref","first-page":"369","DOI":"10.1197\/jamia.M1034","article-title":"Metadata-driven ad hoc query of patient data: meeting the needs of clinical studies","volume":"9","author":"Deshpande","year":"2002","journal-title":"J. Am. Med. Info. Assoc."},{"key":"10.1016\/S1386-5056(02)00047-3_BIB9","unstructured":"P. Wang, et al., The Web enabled IHC Enterprise Data Warehouse for clinical process improvement and outcomes measurement, in: 1997 AMIA Fall Symposium. 1997. Hanley & Belfus, Philadelphia, PA, Nashville, TN."},{"issue":"1","key":"10.1016\/S1386-5056(02)00047-3_BIB10","doi-asserted-by":"crossref","first-page":"16","DOI":"10.1055\/s-0038-1634148","article-title":"ArchiMed: a medical information and retrieval system","volume":"38","author":"Dorda","year":"1999","journal-title":"Meth. Inf. Med."},{"issue":"2\u20133","key":"10.1016\/S1386-5056(02)00047-3_BIB11","doi-asserted-by":"crossref","first-page":"153","DOI":"10.1016\/S0169-2607(00)00130-9","article-title":"Extracting a statistical data matrix from electronic patient records","volume":"66","author":"Gall","year":"2001","journal-title":"Comput. Meth. Prog. Biomed."},{"key":"10.1016\/S1386-5056(02)00047-3_BIB12","unstructured":"A. Gouveia-Oliveira, Salgado N.C., A database system for integrated clinical trial management, control, statistical analysis and ICH-compliant reporting, Proceedings of the AMIA Symposium, 1999, pp. 72\u201376."},{"key":"10.1016\/S1386-5056(02)00047-3_BIB13","unstructured":"N.C. Salgado, A. Gouveia-Oliveira, Towards a common framework for clinical trials information systems, Proceedings of the AMIA Symposium, 2000 pp. 754\u2013758."},{"key":"10.1016\/S1386-5056(02)00047-3_BIB14","unstructured":"Clinical Data Interchange Standards Consortium, C.D.I.S., Specification for the Operational Data Model (ODM) 2002, available from http:\/\/www.cdisc.org-\/models\/odm\/v1.1\/odm1-1-0.html, Last accessed on: July 1,2002."},{"key":"10.1016\/S1386-5056(02)00047-3_BIB15","unstructured":"3M Health Information Systems, The 3M Clinical Data Repository. 1998: Murray, UT, USA, available from http:\/\/www.3m.com\/market\/healthcare\/his\/us\/products\/care_inno\/."},{"key":"10.1016\/S1386-5056(02)00047-3_BIB16","unstructured":"S.M. Huff, et al., Evaluation of a SQL Model of the Help Patient Database, in: Proceedings of the 15th Symposium on Computer Applications in Medical Care 1991, IEEE Computer Press, Los Alamitos, CA, Washington, DC."},{"key":"10.1016\/S1386-5056(02)00047-3_BIB17","unstructured":"S.M. Huff, et al., HELP the next generation: a new client-server architecture, in: Proceedings of the 18th Symposium on Computer Applications in Medical Care 1994, IEEE Computer Press, Los Alamitos, CA, Washington, DC."},{"key":"10.1016\/S1386-5056(02)00047-3_BIB18","unstructured":"S. Johnson, et al., Using metadata to integrate medical knowledge in a clinical information system, in: Proceedings of the 14th Symposium on Computer Applications in Medical Care 1990., IEEE Computer Press, Los Alamitos, CA, Washington, DC."},{"key":"10.1016\/S1386-5056(02)00047-3_BIB19","unstructured":"C. Friedman, et al., A generalized relational schema for an integrated clinical patient database, in: Proceedings of the 14th Symposium on Computer Applications in Medical Care 1990, IEEE Computer Press, Los Alamitos, CA, Washington, DC."},{"issue":"5","key":"10.1016\/S1386-5056(02)00047-3_BIB20","doi-asserted-by":"crossref","first-page":"475","DOI":"10.1136\/jamia.2000.0070475","article-title":"Exploring performance issues for a clinical database organized using an entity-attribute-value representation","volume":"7","author":"Chen","year":"2000","journal-title":"J. Am. Med. Inform. Assoc."},{"issue":"6","key":"10.1016\/S1386-5056(02)00047-3_BIB21","doi-asserted-by":"crossref","first-page":"511","DOI":"10.1136\/jamia.1998.0050511","article-title":"Data extraction and ad hoc query of an Entity-Attribute-Value Database","volume":"5","author":"Nadkarni","year":"1998","journal-title":"J. Am. Med. Info. Assoc."},{"key":"10.1016\/S1386-5056(02)00047-3_BIB22","series-title":"Algorithms in C++","author":"Sedgewick","year":"2002"},{"key":"10.1016\/S1386-5056(02)00047-3_BIB23","series-title":"An Introduction to Database Systems","author":"Date","year":"2001"},{"key":"10.1016\/S1386-5056(02)00047-3_BIB24","first-page":"42","article-title":"A proposal and challenge for a new approach to integrated electronic solutions","volume":"February","author":"Ruberg","year":"2002","journal-title":"Appl. Clin. Trials"},{"issue":"3","key":"10.1016\/S1386-5056(02)00047-3_BIB25","doi-asserted-by":"crossref","first-page":"266","DOI":"10.1055\/s-0038-1634605","article-title":"Semi-automated database design by the end-user","volume":"34","author":"d'Hollosy","year":"1995","journal-title":"Meth. Inf. Med."},{"key":"10.1016\/S1386-5056(02)00047-3_BIB26","series-title":"OLAP Solutions: Building Multidimensional Information Systems","author":"Thomsen","year":"2000"},{"key":"10.1016\/S1386-5056(02)00047-3_BIB27","series-title":"Data Warehouse Performance","author":"Inmon","year":"1998"}],"container-title":["International Journal of Medical Informatics"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/api.elsevier.com\/content\/article\/PII:S1386505602000473?httpAccept=text\/xml","content-type":"text\/xml","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/api.elsevier.com\/content\/article\/PII:S1386505602000473?httpAccept=text\/plain","content-type":"text\/plain","content-version":"vor","intended-application":"text-mining"}],"deposited":{"date-parts":[[2020,3,10]],"date-time":"2020-03-10T23:37:04Z","timestamp":1583883424000},"score":1,"resource":{"primary":{"URL":"https:\/\/linkinghub.elsevier.com\/retrieve\/pii\/S1386505602000473"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2002,11]]},"references-count":27,"journal-issue":{"issue":"3","published-print":{"date-parts":[[2002,11]]}},"alternative-id":["S1386505602000473"],"URL":"https:\/\/doi.org\/10.1016\/s1386-5056(02)00047-3","relation":{},"ISSN":["1386-5056"],"issn-type":[{"value":"1386-5056","type":"print"}],"subject":[],"published":{"date-parts":[[2002,11]]}}}