This content has been marked as final. Show 7 replies
in ADF those table 2 foreign keys should be history columns.
We also have other user columns (owner, supervisor, approver) with foriegn keys to user table. That would not be part of the history table right?
I think this discussion has already become confused, as I see a muddle of terms like "History columns" and "History table", the former an ADF concept, the later a database concept that Forms programmers are familiar with.
So user12168613 let's go back to basics to understand your question.
Firstly are you assessing ADF Business Components (ADF BC) to model your database tables? Your question generically talks about ADF but doesn't talk about what technology in ADF you're going to use to talk to the database. I'd suggest you should use ADF BC anyway if your team comes from a Forms background as it much more closely models the "Forms" way of thinking about database schemas than the other options such as that provided by EJB/JPA.
Secondly why do you think that data model will not work in ADF? It's basically 2 tables involved with multiple FKs. For ADF BC it will not be a problem that there's 4 or more FKs back to the same table. What's your specific concern?
Third, you refer to some forum posts talking about materialized views getting around a problem but you don't give us any hint to what the problem is or links to the posts, so we can't make any assessment on that comment for you.
Finally have you thought about building a small ADF BC application to test this out yourself? The basics of ADF BC aren't that hard to learn.
On a separate note it's worth updating your user ID to a real name, people on the forum appreciate talking to people, not 12168613.
You understood my questions and concerns exactly right. I appreciate your reply.
+"I'd suggest you should use ADF BC anyway if your team comes from a Forms background as it much more closely models the "Forms" way of thinking about database schemas than the other options such as that provided by EJB/JPA"+
--Yes we are planning to make use of ADF BC. For our needs we need to display the names of these users in my .jsf page as supposed to the employee key, how do I do this? Currently we are using List of Values feature to display the user name in our POC app. Is this the correct approach? Or are there better approach?
So what you're looking for is the equivalent in Oracle Forms where you create transient attributes that are populated by a post-update trigger based on some other field in the same row (in this your FK).
The equivalent to what you're attempting to achieve is the concept of "reference Entity Objects" in context of "View Objects with Joins". I recommend you read this chapter of the dev guide:
Thank you very much.