RDB vs Report Defnition

General
, ,
1

Please clarify the below

  1. Report Defnition is used for select queries only and Joins. Report Defnition cannot be used for Save , Delete , Open queries. Is this statement correct.

  2. RDB can be used primarly for stored procedure calls. It can be used for Open , Save , Delete queries.

2

@HemaLathaP2674

  1. Yes the statement for the report definition is correct. In addition to that, it offers the chart based reporting and have the features to support the performance (pagination or set the maximum rows to display), security (whether to display the report in report browser) and also the exporting features like export to excel, pdf and there is also an option to change the filters at runtime by editing the report.

  2. The statement you mentioned for RDB is also correct. RDB offers to write the query as per the DB vendor and the same gets executed with the RDB methods and it also used to execute the stored procedure which are there at the db level. As you mention, this is not restricted to select query, this applicable for the other CRUD operations.

3

@P.Siva.Praveen Thanks .

Primary difference between Obj methods and RDB methods.

When using Obj , performance of the application is good compared to RDB. Is this correct.

So do we need to use RDB method only for stored procedures. Use Obj methods for Open , Save , Delete and Select queries.

4

@HemaLathaP2674

Regarding performance, your statement is not true.Obj methods are used to fetch the information from pega based tables and external tables (except objhandle methods). The only advantage here is pega is building the query internally and fetching the data.Obj methods can do the operations on blob data whereas RDB we can’t get blob data directly.

But in RDB we need to write our own query to either fetch, update, delete or create DB related operations and also call the stored procedures.

5

@P.Siva.Praveen Please elaborate on how does Obj method handle BLOB data.

In Obj-Browse , filter criteria accepts only exposed columns right.

6

@HemaLathaP2674

Hi Hema,

Obj Method:

  • Obj Methods will work on Rulebase tables as well as external DB tables.
  • Obj Methods can fetch the content saved inside BLOB column.

RDB Methods:

  • RDB work on Rulebase tables as well as external DB tables, but it can fetch only Exposed columns.
  • RDB methods can NOT fetch content available inside BLOB, it can retrieve BLOB as BLOB.

I hope this will help you.

Thanks,
Ashok

7

@Bhumireddy Thanks.

This answers my question.