Share via


Data Warehouse Classes

This section provides an alphabetical list of the Commerce Server 2000 Data Warehouse logical classes. Information about the class data members, class relations, and class keys is included. The physical classes corresponding to these logical classes can be found in the Microsoft Management Console (MMC) under Microsoft SQL Servers\SQL Server Group\<server name>\Databases\<data warehouse database>\Tables.

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 ("Classname"ID) 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.
One-to-many with inheritance 194 Same as a one-to-many relation except all members of the parent are visible to the children. (In a regular one-to-many relation, only the key members of the parent class are visible.)

Commerce Server 2000 Data Warehouse Logical Classes

The following table contains links to the logical classes of the Data Warehouse.

Address HttpStatus Referrer
AdItem ImportOptions ReferrerDomain
Basket IndustryCode RegisteredUser
Campaign IPRef Request
CampaignEvent LastUriByDate RequestByDateByUriBy
QueryString
CampaignEventsByDate
AndUser
Level1Dir ServerBinding
CampaignItem Level2Dir ServerGroup
CampaignItemTypes Level3Dir Site
CatalogGlobal Level4Dir SiteSummary
Category Level5Dir SiteURL
CatHierarchy Level6Dir SVQStringName
CommerceEvent LinkMVQString
Name
Target
Crawler LinkSVQStringName TargetGroup
Creative LogUser TargetGroupXRef
CreativeSize MVQStringName TaskHistory
CreativeType OpenUserVisit UniqueUserKey
ByDate
CreativeTypeXRef Order URI
Customer OrderDiscount URIQuery
Date OrderFormHeader UserAgent
DMItem OrderFormLine
Items
VirtualServer
EventType OrderGroup Visit
FirstUriByDate OrderGroupAddresses VisitInfo
HitsByHour PageGroup Win32Status
HitsInfo PageGroupXRef  
HostnameRef Products  


All rights reserved.