 |
From this data set we can construct other tables that summarize the data
and can be queried on an ad-hoc basis.
- Page views
- SELECT uri FROM weblog WHERE mime_type='text/html'
- Redirects
- SELECT uri,query_string FROM weblog WHERE status='302'
- Bad links
- SELECT uri,referer FROM weblog WHERE status='404'
- Visitors
- SELECT distinct cookie FROM weblog
Putting a query driven front end on all of this in PHP or mod_perl
would constitute a sound beginning of a broad statistics reporting
tool.
|
