Home
Forums
New posts
Search forums
What's new
New posts
New profile posts
Latest activity
Members
Registered members
Current visitors
New profile posts
Search profile posts
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Home
Forums
Pega Very Important Interview Questions & Answers
What is the difference between Obj & RDB methods?
What is the difference between Obj & RDB methods?
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="AllJobsInfo" data-source="post: 59" data-attributes="member: 1"><p><strong>Obj methods</strong> can only be queried upon a single class whereas <strong>RDB methods</strong> can be helpful in querying along with joins involving more than one class.</p><p></p><p><strong>Obj methods</strong> are meant for transactional ease as they have the option of deferred save, rollback etc whereas <strong>RDB methods</strong> are performed immediately with auto-commit.</p><p></p><p><strong>RDB methods would be considered in the below factors</strong></p><p></p><p>Stored procedure</p><p></p><p>Custom or complex query</p><p></p><p>SQL function</p><p></p><p>RDB methods support stored procedures. OBJ methods do not.</p><p></p><p>RDB method support hand-crafted / optimized SQL. OBJ methods generate all SQL on the fly behind the scenes.</p><p></p><p>OBJ methods support a PRPC unit of work / two phase commit. RDB methods are atomic - they are unique transactions and automatically commit on completion.</p><p></p><p>Most Cases you <strong>do NOT have</strong> to map tables to PRPC objects to use RDB methods. RDB methods only see / touch those columns that are in your DB Schema, and you don't even have to map them to objects / properties . On the other side; mapping a table to a PRPC 'external' class and using obj- methods directly extends PRPC object model to the external table.</p></blockquote><p></p>
[QUOTE="AllJobsInfo, post: 59, member: 1"] [B]Obj methods[/B] can only be queried upon a single class whereas [B]RDB methods[/B] can be helpful in querying along with joins involving more than one class. [B]Obj methods[/B] are meant for transactional ease as they have the option of deferred save, rollback etc whereas [B]RDB methods[/B] are performed immediately with auto-commit. [B]RDB methods would be considered in the below factors[/B] Stored procedure Custom or complex query SQL function RDB methods support stored procedures. OBJ methods do not. RDB method support hand-crafted / optimized SQL. OBJ methods generate all SQL on the fly behind the scenes. OBJ methods support a PRPC unit of work / two phase commit. RDB methods are atomic - they are unique transactions and automatically commit on completion. Most Cases you [B]do NOT have[/B] to map tables to PRPC objects to use RDB methods. RDB methods only see / touch those columns that are in your DB Schema, and you don't even have to map them to objects / properties . On the other side; mapping a table to a PRPC 'external' class and using obj- methods directly extends PRPC object model to the external table. [/QUOTE]
Verification
Post reply
Home
Forums
Pega Very Important Interview Questions & Answers
What is the difference between Obj & RDB methods?
What is the difference between Obj & RDB methods?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.
Accept
Learn more…
Top