Data Warehouse Classes
This section provides an alphabetical list of the Data Warehouse logical classes. Information about the class data members, class relations, and class keys is included. The physical tables that correspond to these logical classes can be found in the Microsoft SQL Server Management Studio (for SQL Server 2005), in the datawarehouse database. The datawarehouse database name is prefixed by the site name, for example "Yoursite_datawarehouse".
The following table contains the relation types and the corresponding type codes used in the Relations table of each class description.
Relation Type |
Code |
Description |
|---|---|---|
One-to-Many |
2 |
Each parent has zero or more children, each child has one parent. The identifier (ClassnameID) of the parent is used as a foreign key by the child. |
Many-to-Many |
3 |
Each parent has zero or more children. Each child has one or more parents. |
Application Defined |
5 |
Defined in the schema for completeness and purposes of discovery through the OLE DB provider for Commerce Server 2009, but it is not used by the provider's storage engine for writing parent instances. |