URI
The URI class represents Uniform Resource Identifiers (URIs) that are used to distinguish a URL and to make queries and transactions on Commerce Server 2009 Web sites. A URI object associates with the Commerce Server 2009 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 2009 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) |