RE: How To Find Reapeating Row Patterns

One other thing you would want is to run the same tests but remove repeating values...

so

ABBCDE would be

ABCDE This is because many programs operate in loops as they log messages so you would get patterns if you remove the repeating values, of course you may also need to remove more complicate repeating patterns within patterns...for example

ABCBCBCDE would be

ABCDE hummm, getting more complicated than I thought...

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Post, Ethan Sent: Thursday, July 21, 2005 9:45 PM
To: Dennis Williams
Cc: oracle-l_at_freelists.org
Subject: RE: How To Find Reapeating Row Patterns

Well I am pretty sure there must be plenty of programs out there that do this type of thing. I was hoping one of the new analytical functions in Oracle could handle this. If I was going to design a program like this I would do something like...and I am literally thinking this up as I type...

grab two values, look for # of occurrences with same two values using lag...

if a lot of matches assume I am in some sort of repeating pattern so add a value to the two and test three values...

keep repeating above until I stop getting matches

(throw this in also...even if I don't get a match on 3..4..5 go to the next value and assume some sort of single value not included in sequence and see if we can match on "ABC?E" etc...

--
http://www.freelists.org/webpage/oracle-l