wiki:table_example3

需要从各维度统计下载的情况

Categorize downloads by the following hierarchies
Date (UTC)
	Year
	Month
	Day
	Hour
	Minute
Product
	Product Name
	Product Major Version
	Product Full Version
	Upgrade From Version ( determined by version string after -partial suffix )
	Rebuild tag ( suffix string after primary version string )
Target OS ( from &os= parameter )
Request Info
Download Type
	manual | partial | complete ( determined by -partial vs -complete vs any other )
Request Type
	download | check | other ( determined by GET vs HEAD vs any other )
Request Result
	success | failure ( determined via 302 vs 404 or any other )
Locale ( localization of product )
Location
	Continent
	Country
	Region
	City
Latitude
Longitude
User Agent Info ( Possible to be deferred for later version )
UA OS
Platform
OS Name
OS Version
UA Browser
Classification
	Desktop | Mobile | Spider | Bot | Other | Unknown
Category
	Gecko | MSIE | WebKit | Opera | Other | Unknown
Name
Version
Engine A
Engine B

即时表,每分钟一条记录,rowkey 是时间,各种条件的统计在column里面保存

Table Name: dmo_metrics_realtime
Rowkey format concatenation of
	{utc_timestamp_to_minute} (i.e. yyyy-mm-ddTHH:MM )
Counter Columns
dimension product column name format
counter:product:
	{download_type}:
	{product_name}:
	{product_major_version}:
	{product_version}:
	{product_os}:
	{product_rebuild}:
	{upgrade_from}
dimension server_info column name format
counter:server_info:
	{datacenter_code}:
	{server_name}
dimension locale column name format
counter:locale:
	{locale_code}
dimension location column name format
counter:location:
	{continent_code}:
	{country_code}:
	{region_code}:
	{city_name}:
	{latitude}:
	{longitude}
dimension user_agent_info *TBD*
examples
	rowkey: minutes_2010-05-24T03:33
columns:
	counter:product:manual:firefox:3.6:3.6.1:win:: = 1356
	counter:product:complete:firefox:3.6:3.6.7:win:: = 12456
	counter:product:partial:firefox:3.6:3.6.7:win::3.6.6 = 16334
	counter:product:manual:thunderbird:3.1:3.1b2:mac:: = 50
	counter:locale:en-US = 50000
	counter:locale:pt-PT = 400
	counter:locale:ru = 430
	counter:location:NA:US:NH:0.000:0.000 = 30
	counter:location:NA:US:CA:30.555:-100.999 = 5000

每小时进行多维度的统计

Table Name: dmo_metrics_hourly
Rowkey format concatenation of
	{utc_timestamp_to_hour}_
	{datacenter_code}:{server_name}_
	{download_type}:{product_name}:{product_major_version}:{product_version}:		{product_os}:{product_rebuild}:{upgrade_from}_
	{locale_code}_
	{continent_code}:{country_code}:{region_code}:{city_name}:{latitude}:{longitude}
Dimension Columns
product
	dimension:product_download_type = {download_type}
	dimension:product_name = {product_name}
	dimension:product_major_version = {product_major_version}
	dimension:product_version = {product_version}
	dimension:product_os = {product_os}
	dimension:product_rebuild = {product_rebuild}
	dimension:product_upgrade_from = {upgrade_from}
server_info
	dimension:datacenter_code = {datacenter_code}
	dimension:server_name = {server_name}
locale
	dimension:locale_code = {locale_code}
location
	dimension:location_continent_code = {continent_code}
	dimension:location_country_code = {country_code}
	dimension:location_region_code = {region_code}
	dimension:location_city_name = {city_name}
	dimension:location_latitude = {latitude}
	dimension:location_longitude = {longitude}
	dimension user_agent_info *TBD*
Counter Column -- long integer updated via incrementColumn API
	counter:requests