This could only be done with Forms data block based on procedure and instead of triggers?
#UNIVERSAL DATABASE VS EAV MODELING HOW TO#
Operations how to handle these operations to transform to vertical operation. So When I have horizontal list there is challenge during Once you have this, you can either use the Query as the source of a Database View and then base your Forms data block on this view or you can use the query in a Procedure and base your Forms data block on the procedure or lastely, you could use the query directly and base your Forms data block on the query using the "From Clause" option. This way it is provided to get the survey with the list of assigned parameters in horizontal shape? varchar2 ) to the one that is registered in the View has cast operator that transform data type of each parameter from general ( e.g. But I guess you have in mind to transform vertical set of values to horizontal ( pivoting, transposing )? I am only conceptually familiar with EAV modeling, so I don't claim to be an expert! -) Given the abstract way in which data is stored with EAV, I would suggest that you first create a SQL Query that will produce the desired record set. Let me comment and answer on your text between your lines. This way I can still counted on concepts in RDBMS databases Some exceptional tools or data design ( object modelling and object databases ) suppose to be used. Because since this moment I do not feel this kind of problem as some exception or Till recently I even did not know that this kind of problem could be placed I must confess that I am also not familiar with EAV theoretical background and concept. If someone's response is helpful or correct, please mark it accordingly. Take a look at these links for additional information on using Procedure and From Clause based blocks.įorms: How to base a block on a FROM clause Queryįorms: How to base a data block on a Procedure If you need to be able to change or add new data, I would suggest you use a Procedure based block.
#UNIVERSAL DATABASE VS EAV MODELING UPDATE#
You will not be able to update the data however. The simplest option would be to create a DB view and base your block on the view. My question is how to implement it to maximally make good use of Oracle forms 10g or 11g features and Oracle Reports 10g:Ī) when fulfilling the survey and use of parsing rules supplied in Meta_Survey_Parameter_Registerī) at the producing as the survey report with reportsĬ) in data analyisis in data warehouse impementations. I need to implement this in Forms and Reports. Survey_Parameters( Survey#, Parameter#, Value, Comment ) Then I have table which attaches Parameters to the Survey as the association table This table is meta table so it suppose to be used as some register - static part of the schema. Unit is varchar2 value not resstricted: for example: %, kg as kilo, m as meter, m/s as meter per second, null Type_Of_Value Is restricted to : ATOMIC_VALUE, INTERVAL_VALUE_FROM_TOĭata_Type is restricted to: Date, time, number( X,Y ), varchar2, Meta_Survey_Parameter_Register( Parameter# varchar2( 40 ) not null,Īdditional_Parameter_Desc varchar2( 240 ) null, I am dealing with two tables in data modell which are structured on EAV ( Entity-Attribute-Value ) modelling approach.Ĭontractor_Partner# number not null, - reference foreign key, to Partner's Table
1.7K Training / Learning / Certification.165.3K Java EE (Java Enterprise Edition).7.9K Oracle Database Express Edition (XE).3.8K Java and JavaScript in the Database.
0 kommentar(er)
