(SM-2402) BLOB Storage (Primary Database)

Owned by SNP
Feb 22, 2024
1 min read

BLOB Storage is a binary connector for System's Primary Database.

Storage Management

In the Storage Management Setup (/DVD/SM_SETUP), create new storage with BLOB storage type.

Storage Parameters:

  • Blob size (Kbytes): Data will be split into portions according to Blob size during the data transfer. Every part with binary data will be uploaded to Primary Database and stored as a separate entry in the cluster table.

  • Data class: Determines the physical area (tablespace) of the database in which a database table is created.

  • Database Prefix: The name of the cluster table generated on the storage will contain a database prefix and number with 10 digits.

  • Compute hash: Calculate the hash of data before and after transfer.

  • Generate DB indexes: A default index on the cluster table will be created, improving the performance of reading data, but the performance of writing data could be degraded.