Advertisement

Extending the Entity-Attribute-Value Model

  • Prakash M. Nadkarni
Chapter
Part of the Health Informatics book series (HI)

Abstract

In a previous chapter, I introduced the use of the Entity-Attribute-Value model for representing highly variable clinical data. EAV is appropriate for clinical data because the universe of clinical attributes that can apply to a patient are both numerous and sparse. I emphasized that the use of the EAV model is unworkable in the absence of a supporting metadata infrastructure that supports validation and presentation and, of course, code that operates on this metadata.

Keywords

Resource Description Framework Mixed Schema Hybrid Classis Sparse Attribute Object Table 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

References

  1.  1.
    PostGreSQL PostGreSQL documentation. Available from: www.postgresql.org/docs/. [cited 10/5/10], 2010.
  2.  2.
    World Wide Web Consortium. SPARQL query language for RDF. Available from: http://www.w3.org/TR/rdf-sparql-query/. [cited 11/1/10] 2008.
  3.  3.
    Nadkarni PM, 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;6(6):478-493.PubMedCrossRefGoogle Scholar
  4.  4.
    Nadkarni P, Marenco L Easing the transition between attribute-value databases and conventional databases for scientific data: Proceedings of the AMIA Fall Symposium, Washington, DC, Hanley & Belfus; 2001:483-487.Google Scholar
  5.  5.
    Marenco L, Tosches N, Crasto C, Shepherd G, Miller P, Nadkarni P. Achieving evolvable web-database bioscience applications using the EAV/CR framework: recent advances. J Am Med Inform Assoc. 2003;10(5):444-453.PubMedCrossRefGoogle Scholar
  6.  6.
    Marenco L, Nadkarni P, Skoufos E, Shepherd G, Miller P. Neuronal database integration: the Senselab EAV data model: Proceedings of the AMIA Symposium; 1999:102-106.Google Scholar
  7.  7.
    Kimball R, Caserta J. The Data Warehouse ETL Toolkit. New York: Wiley Computer Publishing; 2008.Google Scholar
  8.  8.
    Slezak T, Branscomb E. An integrated browser for chromosome 19 physical mapping data: The Cold Spring Harbor Meeting on Genome Mapping and Sequencing. Cold Spring Harbor, New York; 1992:220.Google Scholar
  9.  9.
    Friedl S SQL injection attacks by example Available from: http://unixwiz.net/techtips/sql-injection.html. [cited 11/5/10] 2010

Copyright information

© Springer-Verlag London Limited 2011

Authors and Affiliations

  • Prakash M. Nadkarni
    • 1
  1. 1.School of MedicineYale UniversityNew HavenUSA

Personalised recommendations