Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Support for Entity Attribute Value tables (International CAB)

Tmicheli-OracleOct 9 2014 — edited Jan 11 2016
  • 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.

Comments

Sharmela-Oracle

Hi,

Set UseCanonicalName to off and check if it helps.

-Sharmela

1 - 1

Post Details

Added on Oct 9 2014
#active, #database-ideas, #database-ideas-ideas
4 comments
651 views