URI

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

The URI class represents Uniform Resource Identifiers (URIs) that are used to distinguish a URL and to make queries and transactions on Commerce Server 2007 Web sites. A URI object associates with the Commerce Server 2007 Web site through a SiteURL object.

A site is identified by two objects:

  • A SiteURL object that stores the first portion, or top level (for example, the domain name) of a site.

  • A linked URI object, which stores the rest of the URLs for the site.

If the URI object represents a hierarchical directory structure, it will be linked to the appropriate LevelNDir objects.

A business transaction may occur through a URI query. This query is represented by a link between one or more Request objects and the URI object.

A URI object represents a page only. It does not represent graphics, banners, or content pieces.

Because the LogUser, URI, and UriQuery classes are the largest classes in the Data Warehouse, they have been altered to increase their performance. These classes do not have formal reldef relationships. Instead, they have an application-specific relationship with their children. This relationship is defined in the schema for completeness and purposes of discovery through the provider, but it is not used by the storage engine of the OLE DB provider for Commerce Server for writing parent instances. In application-specific relationships, the joining between the child and parent is not through the parentID, URIID, but through the bigint 8-byte URIKey. After that, the parentID, URIID is set to a constant, 999.

If the URI class has a multivalue member, or if the class is involved in a many-to-many relationship, the URIID is populated just like any other dimension. In this case, the linking table uses the IDs as the linking key, but the child classes still join them through the QueryStringKey.

When you add a new relation to this class, you must update the stored procedure that is invoked for deleting orphans. Deleting information from this table without deleting orphans is not supported.

This class cannot be changed to be updatable. In the ClsDef table, the IsTransactioned field for this class cannot be changed from 1 to 0.

Data Members

Data Member Name

Data Type

Default Value

Description

Title

nvarchar(255)

None

Stores a title for the URI.

URI

nvarchar(255)

None

Stores the unique key for the object.

URIKey

bigint

{00000000-0000-0000-0000-000000000000}

Stores the hash value of the URI.

LevelDirID

binary

1

None.

Class Key

URIKey is composed of a single data member, URIKey.

Relations

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

Relation Name

Parent

Child

Type

LevelDirURIRel

LevelDir

URI

2

UriBasket

URI

Basket

5

UriCampaignEvent

URI

CampaignEvent

5

UriFirstUriByDate

URI

FirstUriByDate

5 (key is FirstUriKey)

UriHitsInfo

URI

HitsInfo

5

UriLastUriByDate

URI

LastUriByDate

5 (key is LastUriKey)

URILevel1Dir2

Level1Dir

URI

2

URILevel2Dir3

Level2Dir

URI

2

URILevel3Dir4

Level3Dir

URI

2

URILevel4Dir5

Level4Dir

URI

2

URILevel5Dir6

Level5Dir

URI

2

URILevel6Dir7

Level6Dir

URI

2

UriOpenUserVisit1

URI

OpenUserVisit

5 (key is FirstUriKey)

UriOpenUserVisit2

URI

VisitInfo

5 (key is SecondUriKey)

UriOpenUserVisit3

URI

VisitInfo

5 (key is LastUriKey)

UriOrder

URI

Order

5

UriRequest

URI

Request

5

UriRequestByDateByUriByQueryString

URI

RequestByDateByUriByQueryString

5

UriVisitInfo1

URI

VisitInfo

5 (key is FirstUriKey)

UriVisitInfo2

URI

VisitInfo

5 (key is SecondUriKey)

UriVisitInfo3

URI

VisitInfo

5 (key is LastUriKey)

See Also

Other Resources

Data Warehouse Classes