Re: Grouping My Graphs
- From: "Alex Gorbachev" <gorbyx@xxxxxxxxx>
- To: post.ethan@xxxxxxxxx
- Date: Fri, 21 Apr 2006 11:06:15 +0200
Well, this should be called data mining things. I don't know if Oracle
Data Mining option is just coincidently named the same or it can
really help you.
2006/4/21, Ethan Post <post.ethan@xxxxxxxxx>:
>
> 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
>
>
--
Best regards,
Alex Gorbachev
--
//www.freelists.org/webpage/oracle-l
Other related posts:
