Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse TOP LEVEL DOMAIN Table


List of internet top-level domains and descriptions. For use with web statistics reporting. Top level domains are the codes which come at the end of a URL and can describe the type of organization or refer to a country. Example - 'COM' (Company) or 'CA' (Canada).


Field Name

Description

Data Type

Length

TOP_LEVEL_DOMAIN

Internet top-level domain code. The last part of a URL or internet address - for example for the URL "WEB.MIT.EDU", the top-level domain is "EDU". Can refer to a type of organization or a country.

VARCHAR2

6

TOP_LEVEL_DOMAIN_DESCRIPTION

Description of an internet top-level domain. For example "Educational Institution" or "Spain".

VARCHAR2

100

TOP_LEVEL_DOMAIN_KEY

Key used for joining the TOP_LEVEL_DOMAIN and WEB_HITS_DETAIL tables together. This field should be used only for joining tables, and should not be placed on reports.

VARCHAR2

6

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE

8