Data Modelling question

General
, , ,
1

Hi All,

This is regarding the data modelling. When to save the data in blob and when to save the data in the plain tables with all the columns?

Lets say an example customer has the address. Customer is a data object and Address is an another data object.

Which is the best practice?

saving the address in the separate table with the customer id relation or saving the data the address as blob in the customer data object its self

2

@P.Siva.Praveen

  1. Blobs are suitable for storing large binary data, such as images, videos, or documents. If the data you need to store is primarily binary and sizable, using a Blob can be more efficient and performant.

  2. If you don’t require frequent querying or processing of the binary data within Pega, storing it as a Blob can be a simpler solution. BLOB data is typically accessed and manipulated as a whole, rather than individual columns.

  3. Storing binary data in a Blob can help optimize the performance of your database by reducing the size and complexity of the table.

you can decide now based on the above point.

3

@P.Siva.Praveen

My 2 cents…

It depends on your reporting requirements in the BLOB data and the number of properties stored in the BLOB data.

For example: if you have 12 properties stored in the BLOB, and you need to report only on 2 properties, then you can store it as BLOB.

Thanks,