Abstract
We have previously developed and described a modeling and development framework called EAV/CR, which is appropriate for designing databases containing highly heterogeneous and evolving data, as in the case of scientific databases for rapidly advancing domains. The use of EAV/CR has been hampered by the lack of generic tools for non-procedurally transferring data into or out of legacy systems or analytical packages: the transfer task is complicated by the different representation of EAV vs. conventional data, which is not addressed by commercial data-transfer programs. We have therefore created such a tool, which works with a wide variety of data sources that are accessible via Microsoft OLE DB technology. The data transfer tool requires minimal programmer intervention to set up, and no programming to use on a regular basis. Current limitations of the tool are also noted.
Full text
PDF
Selected References
These references are in PubMed. This may not be the complete list of references from this article.
- Huff S. M., Haug P. J., Stevens L. E., Dupont R. C., Pryor T. A. HELP the next generation: a new client-server architecture. Proc Annu Symp Comput Appl Med Care. 1994:271–275. [PMC free article] [PubMed] [Google Scholar]
- Nadkarni P. M., Brandt C. M., Marenco L. WebEAV: automatic metadata-driven generation of web interfaces to entity-attribute-value databases. J Am Med Inform Assoc. 2000 Jul-Aug;7(4):343–356. doi: 10.1136/jamia.2000.0070343. [DOI] [PMC free article] [PubMed] [Google Scholar]
- Nadkarni P. M., Brandt C., Frawley S., Sayward F. G., Einbinder R., Zelterman D., Schacter L., Miller P. L. Managing attribute--value clinical trials data using the ACT/DB client-server database system. J Am Med Inform Assoc. 1998 Mar-Apr;5(2):139–151. doi: 10.1136/jamia.1998.0050139. [DOI] [PMC free article] [PubMed] [Google Scholar]
- Nadkarni P. M., Marenco L., Chen R., Skoufos E., Shepherd G., Miller P. Organization of heterogeneous scientific data using the EAV/CR representation. J Am Med Inform Assoc. 1999 Nov-Dec;6(6):478–493. doi: 10.1136/jamia.1999.0060478. [DOI] [PMC free article] [PubMed] [Google Scholar]
- Shepherd G. M., Mirsky J. S., Healy M. D., Singer M. S., Skoufos E., Hines M. S., Nadkarni P. M., Miller P. L. The Human Brain Project: neuroinformatics tools for integrating, searching and modeling multidisciplinary neuroscience data. Trends Neurosci. 1998 Nov;21(11):460–468. doi: 10.1016/s0166-2236(98)01300-9. [DOI] [PubMed] [Google Scholar]