Second Try

| | Comments (0) | TrackBacks (0)

Imagine the following table:

Datahour,A,B,C,D,E,F

You get a new record everytime something happens.

In DataHour 11, you get substantially more things happening than happened in DataHour 10.

So, you want to figure out which particular data point might be bulking up to give you more records.

So, you effectively do:

SELECT datahour, a, COUNT(*)

FROM table

GROUP BY datahour, a

for each field A, B, C, D, E and F, hoping to find the particular field where it went from low to high.

There's got to be a term for this type of data analysis, but I can't figure out what it is.

Forget the old website example.  This isn't particular to websites.  Or emu births.  Or lottery tickets sold.  Fields A-F could just as easily be 'Client IP, UserAgent, CountryCode, etc' as it could be 'Weight, Height, Eye Color, Hair Color, Payment Type, etc'.

0 TrackBacks

Listed below are links to blogs that reference this entry: Second Try.

TrackBack URL for this entry: http://www.jaydeflix.com/mt4/mt-tb.cgi/640

Leave a comment

About this Entry

This page contains a single entry by published on August 11, 2008 2:54 PM.

A job prospect... was the previous entry in this blog.

Vacation Advice is the next entry in this blog.

Find recent content on the main index or look in the archives to find all content.

Powered by Movable Type 4.12