Grouping My Graphs

Here is a problem. I have 300 nice pretty graphs. Some graphs are flat, some show spikes and valleys, some show slow growth and slow decline. What would be really nice is to find some easy way of grouping charts that likely have correlation of some sort.

For example, if I have a chart with a peak at 1am and 4am, it would be grouped with other charts that show a spike or valley at 1am and 4am, since they likely correlate.

I am sure there must be some way to do this in PLSQL or SQL and I just thought of this so I have not pondered a solution yet. Has anyone ever heard of anything like this? My guess is I would profile the data for a chart, then go look at all the other charts for the same "profile" and assign the chart to a group within the current profile. A profiling the spikes and valleys would be easy, but slow declines and increases, aka hills, would be much harder to "see" pragmatically.

Perhaps this is one for Joe Celko.

• Ethan

--
http://www.freelists.org/webpage/oracle-l