Site

For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.

The Site class represents a Commerce Server 2007 Web site. All logged information pertaining to the use of a Commerce Server 2007 Web site is stored in or connected to a Site object. The URL for the site is a composition of a SiteURL object and a URI object.

The site may be part of a virtual server group. In that case, the site connects to a VirtualServer object through a SiteURL object. A business transaction may occur through a Uniform Resource Identifier (URI) query. This is represented by a link between one or more Request objects and the URI object. Any visits to the site are linked through one or more Visit objects. If the site has a crawler associated with it, a Crawler object is created and linked to the Site object.

Data Members

Data member name

Data type

Default value

Description

CookieIdentifiers

nvarchar(255)

None

None.

EndImportAction

int

None

Stores a code for the action taken when a log import ends.

IsAdjustTimeStamps

smallint

None

Indicates whether the time stamps in the log data are adjusted for the site.

IsDotNetCookieLessEnabled

smallint

0

None.

IsExcludeSpiders

smallint

None

Indicates whether the site object excludes spiders.

IsSeparateUriAndQueryString

smallint

None

None.

IsUseCookiesForInferences

smallint

None

Indicates whether the site object uses cookies for inferences.

IsUseUPMCookiesForInferences

smallint

None

None.

IsUseUsernameForInferences

smallint

None

Indicates whether the site uses user names for inferences.

OverlapAction

int

None

Stores a code for the action taken when log files for the site overlap.

OverlapMins

int

None

Stores the number of minutes that consecutive log files for the site overlap between imports.

RetryCount

smallint

0

Stores the number of retry attempts.

RetryExhaustAction

smallint

1

None.

SiteName

nvarchar(255)

Unknown

Stores the unique key for the site.

TimeZone

int

None

Stores a code for the time zone of the site.

VisitTimeout

int

None

Stores the time limit (in minutes) applied to visits on the Site object.

WeekStartDay

smallint

None

Stores the day that the week starts on.

Class Key

SiteKey is composed of a single data member, SiteName.

Relations

For a description of the relation type, see Data Warehouse Classes.

Relation name

Parent

Child

Type

CatalogSite

Site

CatalogGlobal

3

OrderGroupSite

Site

OrderGroup

2

SiteAddressRel

Site

Address

3

SiteBasket

Site

Basket

2

SiteCampaignEvent

Site

CampaignEvent

2

SiteCrawlerRel

Site

Crawler

2

SiteFirstUriByDate

Site

FirstUriByDate

2

SiteHitsByHour

Site

HitsByHour

2

SiteHitsInfo

Site

HitsInfo

2

SiteLastUriByDate

Site

LastUriByDate

2

SiteLogImportJobSummaryRel

Site

LogImportJobSummary

2

SiteLogImportSubtaskRel

Site

LogImportSubtask

2

SiteOpenUserVisitRel

Site

OpenUserVisit

2

SiteOrder

Site

Order

2

SiteRegisteredUserRel

Site

RegisteredUser

3

SiteRequestByDateByUriByQueryString

Site

RequestByDateByUriByQueryString

2

SiteRequestRel

Site

Request

2

SiteSiteSummaryRel

Site

SiteSummary

2

SiteSiteURIRel

Site

SiteURL

2

SiteTermSiteRel

Site

SiteTerm

3

SiteVisitInfoRel

Site

VisitInfo

2

SiteVisitRel

Site

Visit

2

See Also

Other Resources

Data Warehouse Classes