Grouping My Graphs
- From: "Ethan Post" <post.ethan@xxxxxxxxx>
- To: _oracle_L_list <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 21 Apr 2006 01:47:20 -0500
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
Other related posts:
