Physical Schema
This topic describes the physical data store underlying the Data Warehouse.
By default, a logical class is mapped to a physical table of the same name. To override this behavior, in the row of the clsdef table that corresponds to the class, set the value of the GenerateTableDef column to False (0) and specify the table name as the value of the DefaultTableName column.
By default, a data member that is neither inherited nor multivalued is mapped to a physical column of the same name. To override this behavior, in the row of the memdef table that corresponds to the data member, set the GenerateColumnDef attribute to False (0) and specify the physical column name as the value of the ColumnName column.
Inherited data members are mapped to the associated column of the parent table.
For multivalued data members (IsMultiValued = True (1) in the memdef table), the associated link and value tables are automatically generated without a provision for overriding the behavior. The names of these tables are stored in the LinkTableName and ValTableName columns in the memdef table.
Table names are limited to 57 characters. Column names are limited to 100 characters.
Commerce Server 2009 does not support partitions. Therefore, there is one partition per data source.