Re: EAV (Re: Object-relational impedence)
From: topmind <topmind_at_technologist.com>
Date: Thu, 27 Mar 2008 13:41:17 -0700 (PDT)
Message-ID: <a8855c5d-1e3f-46ef-a99a-5c09b94bfba5_at_u10g2000prn.googlegroups.com>
Date: Thu, 27 Mar 2008 13:41:17 -0700 (PDT)
Message-ID: <a8855c5d-1e3f-46ef-a99a-5c09b94bfba5_at_u10g2000prn.googlegroups.com>
(addendum)
For an example of the need for flexible columns/attributes, consider a
relational-based GUI system where widget state and info are tracked in
some kind of RDBMS. We want it to be able to add new widgets from
different vendors without each widget needing its own table(s) (unless
its a really special need).
There seems to be a need for either a EAV table (row-based dynamism)
or Dynamic Relational (column-based dynamism) of some kind so that
attributes that are not known up-front can be tracked.
If you suggest otherwise, please present your design.
-T-
Received on Thu Mar 27 2008 - 21:41:17 CET