UriQuery
The UriQuery class represents a Uniform Resource Identifier (URI) query associated with one or more transaction requests. A URIQuery object links to one or more Request objects.
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, URIQueryID, but through the bigint 8-byte URIStringKey. After that, the parentID, URIQueryID is set to a constant, 999.
If the URIQuery class has a multivalue member, or if the class is involved in a many-to-many relationship, the URIQueryID 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 joins 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 allow updates. 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 |
|---|---|---|---|
QueryString |
nvarchar(255) |
No query string |
Stores the unique key for the object. |
QueryStringKey |
bigint |
0 |
Key member. |
Class Key
UriQueryKey is composed of a single datamember, QueryStringKey.
Relations
For a description of the relation type, see Data Warehouse Classes.
Relation Name |
Parent |
Child |
Type |
|---|---|---|---|
UriQueryRequest |
UriQuery |
Request |
5 |
UriQueryRequestByDateByUriByQueryString |
UriQuery |
RequestByDateByUriByQueryString |
5 |