Data Warehouse Classes
For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.
This section provides an alphabetical list of the Commerce Server 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) or in the SQL Server Enterprise Manager (for SQL Server 2000), 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, but it is not used by the provider's storage engine for writing parent instances. |