ObjectSize Calculation for Multi-value and Category Specific Attributes

Use these queries to calculate the ObjectSize of the multi-value and category specific attributes.

Object Size Calculation for Multi-value and Category Specific Attributes
Query Usage 
The string length of maximum value of the multi-value database column type * Single Byte or Multi Byte object size * average number of entries in a multi-value attributes

In this way,

  • If Single byte: Total size of multi-value attribute = length of data type * 2 * average number of values
  • If Multibyte byte: Total size of multi-value attribute = length of data type * 3 * average number of values
Retrieves multi-value attribute size. For example,
  • If a column contains the Integer data type, its maximum value is 2,147,483,647. The integers are converted into string. Therefore, these are considered as 10 characters, and eventually its size is considered as 10.
  • If a column contains the String data type, its size is considered as Length of the String defined in database.
For each category specific attribute, the size that is configured in Configurtor is used for calculation. For information on the property, refer to Configuration Properties for Multi-value and Category Specific Attributes. Retrieves category specific attribute size. 
Total ObjectSize = Object Size calculated from Database for repository space + the size of all multi-value attributes columns + category specific attributes’ size