Re: Entity Attribute Value model with Cayenne?

From: Andrei Ionescu (aionescu196..ahoo.com)
Date: Wed Aug 25 2010 - 07:37:28 UTC

  • Next message: Victor Antonovich: "Escaping of characters in like/likeIgnoreCase expressions"

    > Has anybody ever tried to implement the Entity Attribute Value (EAV)
    > model [1] with the help of Cayenne.
    >
    > Or do you have another idea how to model fully typified additional
    > fields to existing tables so that administrators can enhance their
    > installation?
    >
    > The idea behind this is that some companies have - as example -
    > different needs to describe their records or to group their assets. Now
    > we could go the simple way and just add a few (varchar) fields in the
    > table here and there. But these additional fields would neither be
    > typified nor would they have sounding names but something like field1,
    > field2. Chaos guaranteed :)
    >
    > Now I am looking for a way to allow an administrator to define which
    > table may have what additional fields. He should be required to define
    > the type, length.. of these additional fields. EAV sounds like the way
    > to go, but I am not sure about extending Cayenne for this.
    >
    > Thanks for your input.
    Generic Persistence Classes seems to be another approach for your
    requirement. Even the CayenneModeler seems to support it:
    http://cayenne.apache.org/doc30/generic-persistent-class.html

    regards,
    Andrei.



    This archive was generated by hypermail 2.0.0 : Wed Aug 25 2010 - 07:38:39 UTC