What is this called?
I have a table that shows, lets say, hits on my web server. Let's give it fields of:
Client Country Code, ClientIP, UserAgent, DataHour, Referrer, DomainName, Datadate.
(the real table is much deeper than this, but, it'll do for my question)
I think my website is being flooded, but I'm unsure as to the vector. Is it one particular IP address? One particular country? One particular referrer? So, what I'd like to do is run something like this:
SELECT xyzzy, COUNT(*)
FROM mytable
WHERE datahour = '##'
GROUP BY xyzzy
ORDER BY count(*) DESC
where xyzzy ends up being populated by each field in the table in succession until all the fields have been done. I'm planning on doing it in code, it's easy enough to do, but, what is this kind of data analysis called?
Is there even a name for it? I mean, in english, it's 'What is the source of the majority of my web traffic for this hour?'
Metrics?
Web metrics?
Web traffic analysis?
No, sorry, you're reading too much into the actual data I gave.
Forget that 'web' is involved.
Heck, it could be a table of... uh...
phone calls.
Anything really. I'm looking for the name of the statistical analysis routine that would involve pivoting the entire table on each field individually.
so, lets say the three fields are Flubber, Flibber and Flabber. You'd end up with a count of all records based on unique values of Flubber, unique values of Flibber and unique values of Flabber.
good work man cheapest ephedrine kwenu
please look at this adipex diet pills dwvvx
interesting site man ephedrine hcl 8(((