Question
Infosys Limited
IN
Last activity: 5 Feb 2024 12:19 EST
Data Modelling question
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
Accepted Solution
Updated: 5 Feb 2024 12:19 EST
Pegasystems Inc.
CA
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,
Aaseya IT Services Pvt Ltd
SA
-
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.
-
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.
-
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.
Accepted Solution
Updated: 5 Feb 2024 12:19 EST
Pegasystems Inc.
CA
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,