Re: How To Find Reapeating Row Patterns
- From: Dennis Williams <oracledba.williams@xxxxxxxxx>
- To: Ethan.Post@xxxxxx
- Date: Thu, 21 Jul 2005 19:29:15 -0500
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!
> --
> //www.freelists.org/webpage/oracle-l
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
