PURPOSE: To introduce the goals of EAV database modeling, to describe the situations where entity-attribute-value (EAV) modeling is a useful alternative to conventional relational methods of database modeling, and to describe the fine points of implementation in production systems. METHODS: We analyze the following circumstances: (1) data are sparse and have a large number of applicable attributes, but only a small fraction will apply to a given entity; (2) numerous classes of data need to be represented, each class has a limited number of attributes, but the number of instances of each class is very small. We also consider situations calling for a mixed approach where both conventional and EAV design are used for appropriate data classes. RESULTS AND CONCLUSIONS: In robust production systems, EAV-modeled databases trade a modest data sub-schema for a complex metadata sub-schema. The need to design the metadata effectively makes EAV design potentially more challenging than conventional design.
PURPOSE: To introduce the goals of EAV database modeling, to describe the situations where entity-attribute-value (EAV) modeling is a useful alternative to conventional relational methods of database modeling, and to describe the fine points of implementation in production systems. METHODS: We analyze the following circumstances: (1) data are sparse and have a large number of applicable attributes, but only a small fraction will apply to a given entity; (2) numerous classes of data need to be represented, each class has a limited number of attributes, but the number of instances of each class is very small. We also consider situations calling for a mixed approach where both conventional and EAV design are used for appropriate data classes. RESULTS AND CONCLUSIONS: In robust production systems, EAV-modeled databases trade a modest data sub-schema for a complex metadata sub-schema. The need to design the metadata effectively makes EAV design potentially more challenging than conventional design.
Authors: Cynthia A Brandt; Richard Morse; Keri Matthews; Kexin Sun; Aniruddha M Deshpande; Rohit Gadagkar; Dorothy B Cohen; Perry L Miller; Prakash M Nadkarni Journal: Int J Med Inform Date: 2002-11-12 Impact factor: 4.046
Authors: Luis Marenco; Nicholas Tosches; Chiquito Crasto; Gordon Shepherd; Perry L Miller; Prakash M Nadkarni Journal: J Am Med Inform Assoc Date: 2003-06-04 Impact factor: 4.497
Authors: J Marc Overhage; Patrick B Ryan; Christian G Reich; Abraham G Hartzema; Paul E Stang Journal: J Am Med Inform Assoc Date: 2011-10-28 Impact factor: 4.497
Authors: Daniel R Harris; Adam D Baus; Tamela J Harper; Traci D Jarrett; Cecil R Pollard; Jeffery C Talbert Journal: Conf Proc IEEE Eng Med Biol Soc Date: 2016-08
Authors: Stefan Kraus; Dennis Toddenroth; Martin Staudigel; Wolfgang Rödle; Philipp Unberath; Lena Griebel; Hans-Ulrich Prokosch; Sebastian Mate Journal: Appl Clin Inform Date: 2020-05-13 Impact factor: 2.342
Authors: Ted D Wade; Pearlanne T Zelarney; Richard C Hum; Sylvia McGee; Deborah H Batson Journal: J Biomed Inform Date: 2014-02-15 Impact factor: 6.317
Authors: Newton Shydeo Brandão Miyoshi; Daniel Guariz Pinheiro; Wilson Araújo Silva; Joaquim Cezar Felipe Journal: BMC Bioinformatics Date: 2013-06-06 Impact factor: 3.169