(SM-2408) BLOB Storage (Primary Database)

Owned by SNP
Aug 20, 2024
1 min read

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

Storage Management

Create new storage with BLOB storage type in the Storage Management Setup (/DVD/SM_SETUP).

image-20240320-141707.png

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 the 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.

  • Enable update: Support of the direct update statements.