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 Class table, set the GenerateTableDef attribute to False (0) 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 Member table, set the GenerateColumnDef attribute to False (0) 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 (1) in the Member 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 Member table.

Table names are limited to 57 characters. Column names are limited to 100 characters.

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

Copyright © 2005 Microsoft Corporation.
All rights reserved.