Forum Stats

  • 3,853,673 Users
  • 2,264,253 Discussions
  • 7,905,427 Comments

Discussions

Support for Entity Attribute Value tables (International CAB)

Tmicheli-Oracle
Tmicheli-Oracle Member Posts: 24 Red Ribbon
edited Jan 11, 2016 5:48PM in Database Ideas - Ideas
  • Detail : A feature in which the entity-attribute-value model is built-in to the standard table. The e-a-v is a new type of column where the attribute name is stored in metadata, and could be different for different rows.
  • Comment:
    • –Maybe partitioning data by data type specified for Attribute row.
    • –Improved performance
    • –Ability to paralyze
    • –Would not break storage model.
  • Drivers :
    • –Several Key application rely on storing information in EAV structures and developers see as a must have.  Other options be to store this type of information in a different data store, which defeats one home for related data.
    • – Unified platform, common security model, consistent approach.
  • Issues:
    • §  • Performance
    • §  • Ability to go through large numbers of EAV' attributes fast.
    • §  • Remove the need to store data in customer format in generic types.  Better optimization make data usable by Oracle.
User259623 -Oraclectrieb
13 votes

Active · Last Updated

Comments

  • Tmicheli-Oracle
    Tmicheli-Oracle Member Posts: 24 Red Ribbon

    We, Oracle are working on our internal process as to how to evaluate and prioritize the IDEAS submitted.  But the more votes obviously the more priority we will put on the request.  However votes/popularity alone will not determine the priority.

    As we move through the process the IDEA will change stages: (not in flow order)

    - Active

    - Already Offered

    - Archived

    - Coming Soon

    - For Future Consideration

    - in Progress

    - Partially Implemented

    - Under Review

  • BPeaslandDBA
    BPeaslandDBA Member Posts: 4,615 Blue Diamond

    I voted this down. Every time I see a EAV implementation, performance it terrible. And normally, the EAV type of table was created because someone was too lazy to implement a proper data model.  Just my thoughts on it...

    Sven W.William Robertson
  • William Robertson
    William Robertson Member Posts: 9,568 Bronze Crown

    I agree with Brian. There are many well-documented conceptual and practical problems with EAV, including inflexible reporting, poor performance and lack of constraints, and so unless some game-changing transparent EAV-to-relational technology could be somehow invented, it will always be a terrible idea that Oracle should not encourage.

  • Niels Hecker
    Niels Hecker Member Posts: 28 Bronze Badge
    edited Oct 2, 2017 3:30PM

    I think this could be easily modeled by using an object type with an attribute "Name" of type VARCHAR2 and an attribute "Val" of type AnyData. Furtheron also an nested table of such object types can be stored in one record.