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 ClsDef table, set the GenerateTableDef attribute to False and specify the table name in the DefaultTableName attribute.

By default, a non-inherited, non-multi-valued class member is mapped to a physical column of the same name. To override this behavior, in the MemDef table, set the GenerateColumnDef attribute to False and specify the column name in the ColumnName attribute.

Inherited class members are mapped to the associated column of the parent table.

For multi-valued class members (IsMultiValued = True in the MemDef table), the associated link and value tables are automatically generated with no provision for overriding the behavior. The names of these tables are stored in the LinkTableName and ValTableName attributes in the MemDef table.

Commerce Server 2000 does not support partitions; thus, there is one partition per data source.


All rights reserved.