Oracle Forms (MOSC)

MOSC Banner

EAV tables and column attributes migrated to the EAV table with name, type of value, value, does For

edited Mar 2, 2011 8:23PM in Oracle Forms (MOSC) 5 commentsAnswered
 Hello,
We're working on the upgrade of some application where we found the need also to make some changes and upgrading to data model.

Some of the entitites in the data model would be candidates to transform into the form where previous attributes/columns would become
separate entity list of the parameters with values.

According to perception to some theory articles this is called EAV model: Entity-attribute-value model.

For example:

Table1( PK_ID, attr1 number(14,2 ) , attr2 varchar2( 80 ), ...........attr100 date ) would
become.

Table1( Pk_Id number,
            ...list of common mandatory attributes for each instance of entity     )

Table2( Pk_Id number,
            Id_of_Parameter the varchar2( 40 ),

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center