Jump to content

Spike detection


rofl90

Recommended Posts

Hi guys i needed some help with logistics for a app i'm building basically it should monitor a social network stats interface and then do something if it hits a user specified spike

 

eg user can pick a tree which will erupt into something like "bebo_canvas-view_male_18-25" and then they'll choose a parameter for instance a condition eg "When it goes below", when it drops, and then choose a timeframe and a value. if either are applicable. then it should save those in a database of page or what-have-you and a corn should be run every hour to check if any conditions are met, what would you suggest logic for this should be, also could you maybe give me some example sql. the database is like this

 

tables:

 

minute

minuteArchive

hour

day

month

 

minutes are archived every time the day cron is run and the table on each looks like

 

x---id--------type---------count---------date--------

|||||1|||bebo-canvas..|||6274|||07-02-08 01:01:01||

 

 

date is in that form, type is the type of stat and count is how many times its happened eg saved profile or viewed page.

 

 

thanks!

Link to comment
https://forums.phpfreaks.com/topic/113405-spike-detection/
Share on other sites

I have no idea what you're asking.  At all.  I got lost around this line:

"user can pick a tree which will erupt into something"

 

>_>  And I kind of chuckled at "corn job".  Try to explain it as best as you can.  A tree which will erupt into something doesn't really help.

Link to comment
https://forums.phpfreaks.com/topic/113405-spike-detection/#findComment-583182
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.