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_at_gmail.com>:
>
> 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
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Apr 21 2006 - 04:06:15 CDT
