Question
Sunera Technologies
US
Last activity: 6 Jan 2017 4:28 EST
what is the difference between obj methods and RDB methods?
can we use obj metods for external relational database?
i heard few things about obj methods and rdb methods
1 obj ,methods for pega rules database and rdb methods for external relational database if we use rdb methods for pegarules database we lost the data.because pega rules database is distinct rules and data and while we r using rdb methods the apllication performance also decrease.
2 obj methods retrieve data from BLOB column and ave data into the BLOB.but RDB methods cannot read and save the data to the table,if we have a BLOB column in table.
please clarify these doubts about obj methods and rdb methods and why we use obj methods for pega database and rdb for external relatonal database.
***Updated by moderator: Lochan to add Categories***
Pegasystems Inc.
IN
Hi Suresh,
Obj- operations generate their own SQL while RDB- operations rely on the query written in Rule-Connect-SQL instances. Unless there is a need for custom SQL which cannot be solved by Obj- operations, RDB- operations are best avoided. That said, in situations where you need to insert using a select statement or delete multiple records based on a filter criteria, equivalent Obj- operations are currently not available and thus RDB- operations are useful.
Generally all queries should be through the use of Obj methods. If you use RDB methods, you will not be able to access BLOBs. However, RDB methods are necessary if you want to execute stored procedures.
RDB methods would be considered in the below factors
1) stored procedure
2) custom or complex query
3) SQL function
Hope this helps!
Thanks,
Gisela
Capgemini Sverige
SE
Hi Suresh,
In addition to gisela response,
1. Obj methods can only be queried upon a single class whereas RDB methods can be helpful in querying along with joins involving more than one class.
2. Obj methods are meant for transactional ease as they have the option of deferred save, rollback etc whereas RDB methods are performed immediately with auto-commit.