Web Log Import
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
UriQuery
HitsInfo
Win32
Status
Http
Status
Request
OpenUser
Visit
Visit
Info
Referrer
Domain
User
Agent
Visit
URI
LevelNDir
LogUser
Task History
Hostname
Ref
IpRef
Referrer
Import
Options
HitsInfo
This class represents summary information about hits on a Web site.
HostnameRef
This class represents the host name reference for an IP address.
HttpStatus
This class represents the HTTP status codes as codes as stored in the Web log file.
ImportOptions
The class represents the options for import.
IPRef
This class represents an IP reference for a LogUser object. An IPRef object contains information on 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.
LevelNDir
This symbolizes the six classes used to represent the six levels in a hierarchical directory structure. Each level contains a directory name and a link to a URI object.
LogUser
This class stores information on user interactions with a Commerce Server 2000 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 2000 Web site is called a user. A LogUser object is created for every user and 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 may represent an anonymous user, a user who is part of an organization, or a user who is registered on the Commerce Server 2000 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.
OpenUserVisit
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. Once a visit is completed (closed), the OpenUserVisit object is deleted and a VisitInfo object is instantiated.
Referrer
This class represents the referring URL for a request.
ReferrerDomain
This class represents the referring domain for a request.
Request
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 may 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 may be made through a site URL. The site URL is represented by a SiteURL object linked to the Request object via a URI object. The SiteURL object may 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.
TaskHistory
This class tracks DTS task execution and the outcome of the execution. It maintains a history of all the imports (and deletes) that have occurred within the Data Warehouse.
URI
This class represents Uniform Resource Identifiers (URI) used to distinguish a URL, as well as make queries and transactions on Commerce Server 2000 Web sites. A URI object associates with the Commerce Server 2000 Web site through a SiteURL object.
A site is identified by a SiteURL object which stores the first portion, or top level, (for example, domain name) of a site and a linked URI object which 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 may 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, etc.
URIQuery
This class represents a URI query associated with one or more transaction requests.
UserAgent
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
A Visit object records information describing user activity on a Commerce Server 2000 Web site. A Visit object is associated with a LogUser object and a Site object. The LogUser object contains information on the user. A Visit object describes the context of a visit, including the time and date of the visit.
VisitInfo
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 2000 Web site. Someone who interacts with a Commerce Server 2000 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 on 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.
Win32Status
This class represents the Win32 status codes as stored in the Web log file.