Re: How To Find Reapeating Row Patterns

Ethan,

I'm stumped. Do you know how to accomplish this in a regular
programming language like Pascal or Java? Is the sequence always the
same length, or is the length arbitrary? Unless someone knows of a
pattern recognition function in Oracle, my guess is that you will
probably write an external C function to do this and then call that
function from Oracle. It sounds pretty compute-intensive to me. It
sounds a little like what the Unix "diff" program does.

Dennis Williams

On 7/21/05, Post, Ethan <Ethan.Post@xxxxxx> wrote:
> Anyone know of some examples of analytical procedures/functions/programs
> that will help me see patterns in repeating sequences of values?
> 
> This is for a application log table that may have dozens of messages in
> repeating orders, I want to try to isolate the message sequence for
> analysis.
> 
> For_Example
> ====================
> A
> B
> C
> D
> E
> F
> A
> B
> C
> D
> E
> F
> 
> Something that would be able to see ABCDEF above. Even perhaps if a
> random X or Y was in the sequence, as long as it was infrequent it would
> be listed as an exeception.
> 
> Thanks!
> --
> http://www.freelists.org/webpage/oracle-l
>
--
http://www.freelists.org/webpage/oracle-l

Other related posts: