The EAV of Destruction

EAV (“Entity-Attribute-Value”) tables result from a very common schema design error for programmers who started with an OO language, and now work with NoSQL (attribute, value) pairs or a loosely typed programming language. This one schema is supposed to model every possible entity in the universe, but comes with multiple challenges. In this whitepaper, learn about EAV tables and how to work with them using SQL queries.

Download PDF
Share This
Contact IDERA:
+1 (713) 523-4433