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_at_ps.net> 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