Search code examples
sql-serverdatabase-designdata-modelingentity-attribute-value

Where can I find SQL statements to create EAV model?


Alternatively, anyone know of where I can get the EAV model for Erwin?


Solution

  • Why would anybody want to build an EAV system using a SQL database? It's a square peg in a round hole.

    If you are really convinced that EAV is the appropriate solution for your problem domain why not choose a database product which supports it? Cassandra or Voldemort or Dynomite?