Reversed SubDomains Table


The Reversed SubDomains table contains detailed information on each sub domain, derived from the domain name that accesses the Web server. This information is summarized in the Reversed SubDomains Summary table to allow a variety of statistical reports to be generated.

The following terminology is used to refer to domain names, or parts of domain names.

SyntaxExample
Domain Namewww.everyware.com, watt.eng.uwaterloo.edu
Sub-Domaineveryware.com, eng.uwaterloo.edu
Reversed Sub-Domaincom.everyware, edu.uwaterloo.eng
Client Domaincom, edu

Reversed sub domains are implemented to make working with sub domains simpler. 'Begins With' searches tend to be quicker than 'Ends With' searches. Reversed sub domains are provided for this reason. For instance, if you wish to find the total hits to your site from EveryWare Development Corp., you would search for reversedSubDomain = 'com.everyware', rather than searching on the DomainNames table for domainNames ending with 'everyware.com'.


Columns
reversedSubDomainID
webServerID
reversedSubDomain
firstHitTimestamp
lastHitTimestamp
hitsToDate
bytesSentToDate
transferTimeToDate




Indices

Unique
  1. reversedSubDomainID


Non-Unique
  1. webServerID, reversedSubDomain


Column Definitions

reversedSubDomainID

The unique ID of the Reversed Sub Domain derived from the Domain Name.


webServerID

The unique ID of Web server that sent the log entry. The corresponding Web Server can be found in the WebServers table.


reversedSubDomain

The Reversed Sub-Domain.


firstHitTimestamp

The date and time of the first hit on the Web server.


lastHitTimestamp

The date and time of the last hit on the Web server.


hitsToDate

The total number of hits up to and including the present time.


bytesSentToDate

The total number of bytes sent up to and including the present time.


transferTimeToDate

The total time spent transmitting data up to and including the present time.


Home Page - Reports