Summary
To determine effective database architecture for a specific neuroscience application, one must consider the distinguishing features of research databases and the requirements that the particular application must meet. Research databases manage diverse types of data, and their schemas evolve fairly steadily as domain knowledge advances. Database search and controlled-vocabulary access across the breadth of the data must be supported. We provide examples of design principles employed by our group as well as others that have proven successful and also introduce the appropriate use of entity–attribute–value (EAV) modeling. Most important, a robust architecture requires a significant metadata component, which serves to describe the individual types of data in terms of function and purpose. Recording validation constraints on individual items, as well as information on how they are to be presented, facilitates automatic or semi-automatic generation of robust user interfaces.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
Gene Ontology Consortium. (2004) An Introduction to the Gene Ontology; http://www.geneontology.org/GO.doc.html. Last accessed: 11/26/04.
Lindberg, D. A. B., Humphreys, B. L. and McCray, A. T. (1993) The Unified Medical Language System. Methods Inf. Med. 32, 281–91.
Slezak, T., Wagner, M., Yeh, M., Ashworth, L., Nelson, D., Ow, D., et al. (1995) A Database System for Constructing, Integrating, and Displaying Physical Maps of Chromosome 19. In: Hunter, L. and Shriver, B. D., editors. Proceedings of the 28th Hawaii International Conference on System Sciences, Wialea, Hawaii. IEEE Computer Society Press, Los Alamitos, CA, p. 14–23.
National Center for Biotechnology Information. (1998) NCBI Software Development Toolkit. National Center for Biotechnology Information, National Library of Medicine, Bethesda, MD.
Winston, P. H. (1984) Artificial Intelligence. 2nd ed. Addison-Wesley, Reading, MA.
Stead, W. W. and Hammond, W. E. (1988) Computer-Based Medical Records: The Centerpiece of TMR. MD Comput. 5(5), 48–62.
Huff, S. M., Haug, D. J., Stevens, L. E., Dupont, C. C. and Pryor, T. A. (1994) HELP the Next Generation: A New Client-Server Architecture. In: Proceedings of the 18th Symposium on Computer Applications in Medical Care, Washington, DC. IEEE Computer Press, Los Alamitos, CA, p. 271–5.
Friedman, C., Hripcsak, G., Johnson, S., Cimino, J. and Clayton, P. (1990) A Generalized Relational Schema for an Integrated Clinical Patient Database. In: Proceedings of the 14th Symposium on Computer Applications in Medical Care, Washington, DC. IEEE Computer Press, Los Alamitos, CA, p. 335–9.
Petrusha, R. (1996) Inside the Windows 95 Registry. O’Reilly Associates, Sebastopol, CA.
World Wide Web Consortium. (2002) Resource Description Framework (RDF); http://www.w3c.org/RDF/. Last accessed: 02/23/02.
Nadkarni, P. M., Marenco, L., Chen, R., Skoufos, E., Shepherd, G. and Miller, P. (1999) Organization of Heterogeneous Scientific Data Using the EAV/CR Representation. J Am Med Inform Assoc 6(6), 478–93.
Shepherd, G. M., Healy, M. D., Singer, M. S., Peterson, B. E., Mirsky, J. S., Wright, L., et al. (1997) Senselab: A Project in Multidisciplinary, Multilevel Sensory Integration. In: Koslow, S. H. and Huerta, M. F., editors. Neuroinformatics: An Overview of the Human Brain Project. Lawrence Erlbaum Associates, Mahwah, NJ, p. 21–56.
Koslow, S. H. and Huerta, M. F. (1997) Neuroinformatics: An Overview of the Human Brain Projects. Lawrence Erlbaum Associates, Mahwah, NJ.
Marco, D. (2000) Building and Managing the Metadata Repository. Wiley, New York.
Microsoft Corporation. (2005) Microsoft SQL Server 2005. Microsoft Corporation, Redmond, WA.
Nadkarni, P. M., Brandt, C. A. and Marenco, L. (2000) WebEAV: Automatic Metadata-Driven Generation of Web Interfaces to Entity-Attribute-Value Databases. J Am Med Inform Assoc 7(7), 343–56.
Microsoft Corporation. (2003) Microsoft Access for Office. Microsoft Corporation, Redmond, WA.
McCray, A., Aronson, A., Browne, A., Rindflesch, T., Razi, A. and Srinivasan, S. (1993) UMLS Knowledge for Biomedical Language Processing. Bull Med Libr Assoc 81(2), 184–94.
Pidcock, W. and Uschold, M. (2003) What are the Differences Between a Vocabulary, a Taxonomy, a Thesaurus, an Ontology, and a Meta-Model? http://www.metamodel.com/article.php?story=20030115211223271. Last Accessed: 03/24/06.
Ceusters, W., Smith, B. and Flanagan, J. (2003) Ontology and Medical Terminology: Why Description Logics are Not Enough. In: Towards an Electronic Patient Record (TEPR), San Antonio, TX. Medical Records Institute, Boston, MA.
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2007 Humana Press Inc.
About this protocol
Cite this protocol
Nadkarni, P., Marenco, L. (2007). Database Architectures for Neuroscience Applications. In: Neuroinformatics. Methods in Molecular Biology™, vol 401. Humana Press. https://doi.org/10.1007/978-1-59745-520-6_3
Download citation
DOI: https://doi.org/10.1007/978-1-59745-520-6_3
Publisher Name: Humana Press
Print ISBN: 978-1-58829-720-4
Online ISBN: 978-1-59745-520-6
eBook Packages: Springer Protocols