Web Log Import Classes in the Data Warehouse
This section describes the classes used to store Web log import data. This data includes visits to a Web site, order form requisitions, and shopping basket transactions. The individual classes are described after the following figure. For more information about these classes, see Data Warehouse Classes.
The following figure shows the major classes used for log import and their relationships.
Web Log Import Classes
Basket Class
This class represents the business transaction involved in adding or removing a product from a shopping basket.
CampaignEvent Class
This class stores event information for marketing campaigns. An event for a marketing campaign includes hits on CampaignItem objects and business transactions involving CampaignItem objects.
See Also
HostnameRef Class
This class represents the host name reference for an IP address.
HttpStatus Class
This class represents the HTTP status codes as stored in the Web log file.
ImportOptions Class
The class represents import options.
IPRef Class
This class represents an IP reference for a LogUser object. An IPRef object contains information about the IP address, number of look-ups associated with the address, and the status of the reference.
An IPRef object associates with a HostNameRef object, describing the host associated with the IP address.
See Also
HostNameRef Class
IPRef Class
LogUser Class
LevelNDir Class
This class represents the six classes used to symbolize the six levels in a hierarchical directory structure. Each level contains a directory name and a link to a URI object.
See Also
URI Class
LinkMVQStringName Class
This class links a SiteURL object to an MVQStringName object. The MVQStringName object represents a custom query string that queries multi-valued columns in the data store.
LinkSVQStringName Class
This class links a SiteURL object to an SVQStringName object. The SVQStringName object represents a custom query string that queries single-valued columns in the data store.
LogImportJobSummary Class
This class is an internal class that tracks log import information such as start time and end time.
LogImportSubtask Class
This class is used by the Web Log Import DTS task to store information used by the Restart feature.
LogUser Class
This class stores information about user interactions with a Commerce Server 2002 Web site. It is the primary link between the RegisteredUser class and the actions taken during a visit to the Web site.
Someone who visits a Commerce Server 2002 Web site is called a user. A LogUser object is created for every user, and is used to record information about that user (such as cookie data, user name, and so on). A Visit object is created every time the user visits the Web site. The new Visit object is linked to the LogUser object for that user. A LogUser object can represent an anonymous user, a user who is part of an organization, or a user who is registered on the Commerce Server 2002 Web site.
The IP information for the user is stored in an IPRef object associated with the LogUser object. A HostNameRef object stores host name information for the IPRef object.
See Also
HostNameRef Class
IPRef Class
Visit Class
MVQStringName Class
This class represents the names for custom multi-valued query strings. The MVQStringName object associates with a SiteURL object through a LinkMVQStringName object.
OpenUserVisit Class
This class represents a visit to a Web site that was open when the containing log files were imported. This allows the open visit to be connected and closed in the following log imports. After a visit is completed (closed), the OpenUserVisit object is deleted and a VisitInfo object is instantiated.
See Also
VisitInfo Class
Order Class
This class stores requests to save or submit purchase orders.
Referrer Class
This class represents the referring URL for a request.
ReferrerDomain Class
This class represents the referring domain for a request.
Request Class
This class stores information about requests. A request is made in the context of a visit. A Request object connects to information describing the user and other details of the visit.
A request can be a part of a URI, in which case a URI object is linked to the Request object. The query string contained in the URI is represented by a URIQuery object linked to the Request object.
Alternatively, a Request can be made through a site URL. The site URL is represented by a SiteURL object linked to the Request object through a URI object. The SiteURL object can represent an actual Web site or a virtual server. If the Request object involves query strings through the site, the SiteURL object will have one or more LinkSVQStringName or LinkMVQStringName objects linking the SiteURL object to the query strings.
See Also
URI Class
URIQuery Class
SVQStringName Class
This class represents custom single-valued query strings associated with a Uniform Resource Locator (URL). An SVQStringName object associates with a SiteURL object through a LinkSVQStringName object.
TaskHistory Class
This class tracks DTS task execution and the outcome of the execution. It maintains a history of all instances of imports (and deletes) that have occurred within the Data Warehouse.
URI Class
This class represents Uniform Resource Identifiers (URI) used to distinguish a URL, as well as to make queries and transactions on Commerce Server 2002 Web sites. A URI object associates with the Commerce Server 2002 Web site through a SiteURL object.
A site is identified by a SiteURL object that stores the first portion, or top level, (for example, domain name) of a site and a linked URI object that stores the remainder of the URL for the site. If the URI object represents a hierarchical directory structure, it will be linked to the appropriate LevelNDir objects.
A business transaction can occur through a URI query—this is represented by a link between one or more Request objects and the URI object.
A URI object only represents a page, not graphics, banners, and so forth.
See Also
LevelNDir Class
Request Class
URIQuery Class
This class represents a URI query associated with one or more transaction requests.
UserAgent Class
This class represents the software infrastructure, such as the operating system and browser, used by a user in a visit to a Web site.
Visit Class
This class stores information describing user activity on a Commerce Server 2002 Web site. A Visit object is associated with a LogUser object and a Site object. The LogUser object contains information about the user. A Visit object describes the context of a visit, including the time and date of the visit.
See Also
LogUser Class
VisitInfo Class
This class represents information about a completed visit to a Web site. If a visit has not been completed at log import time, an OpenUserVisit object is instantiated instead.
The VisitInfo class is the primary structure for recording user activity on a Commerce Server 2002 Web site. Someone who interacts with a Commerce Server 2002 Web site is called a user. The VisitInfo class records information describing user activity.
A VisitInfo object is associated with a LogUser object and a UserAgent object. The LogUser object contains information about the user. The UserAgent object contains information describing the software and computer the user is using.
A VisitInfo object describes the context of a visit, including the time and date of the visit. The VisitInfo object links to a Date structure that contains date information.
See Also
LogUser Class
OpenUserVisit Class
UserAgent Class
Win32Status Class
This class represents the Win32 status codes as stored in the Web log file.
Copyright © 2005 Microsoft Corporation.
All rights reserved.