Business Object with multiple tables and a question about "business object wrapper"


Business Object with multiple tables and a question about "business...
Author
Message
Kari Paukku
Kari Paukku
StrataFrame Novice (73 reputation)StrataFrame Novice (73 reputation)StrataFrame Novice (73 reputation)StrataFrame Novice (73 reputation)StrataFrame Novice (73 reputation)StrataFrame Novice (73 reputation)StrataFrame Novice (73 reputation)StrataFrame Novice (73 reputation)StrataFrame Novice (73 reputation)
Group: Forum Members
Posts: 65, Visits: 820
Hi,

in one of the previous posts was mentioned "a wrapper business object" that would allow to create a business object having data/columns from several tables.

The BusinessObject = 1 table is slightly problematic in the case when you would need to create a business object that would include columns from several tables (a SQL join)  and perhaps some computed fields (some computation rather done in the database than in the application).

In a Oracle environment would

a) this kind of wrapper solve this problem or
b) DDT bring any help on this issue
c) something else...? 

Lastly, is this true: the data structure of the business object is just a place holder and the query populating the data structure can be whatever, e.g any SQL-statement? If this true, then it would be possible to create just some dummy tables/views into the database. However, a wrapper approach would perhaps be "cleaner" as it wouldn't add anything to the database.

Kari
 

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search