ORACLENERD: Fraud Analysis?

Fraud Analysis?

So we are pondering how to go about fraud analysis real time.

One thing currently holding us back is that all the key fields are encrypted (obviously). How do you go about doing fraud analysis with such seemingly high overhead?

My question to you is, do you know of any fraud related off-the-shelf tools or libraries out there? Preferably written in PL/SQL, but Java or C will do as well.

Labels: fraud, java, oracle, plsql

¶ 7/16/2008 09:55:00 PM

Comments:

What kind of fraud? - credit card, receipt, identity? what domain.. point of sale, e-commerce?

How much needs to be encrypted?

So, so many questions...

# posted by

Pete Scott : July 17, 2008 5:42 AM

Yeah, I was lacking in specifics wasn't I?

Credit Card specifically. The idea is to be able to approve instant credit real time.

# posted by

oraclenerd : July 17, 2008 9:03 AM

I think timeten with java , could be a good start.

# posted by

amihay gonen : July 17, 2008 1:38 PM

and that may be where it lives, in memory that is.

but i'm looking for a pl/sql library or something along those lines. There has to be a tool out there somewhere that we could look at...

# posted by

oraclenerd : July 17, 2008 2:21 PM

Tom Kyte posted something last year regarding pattern matching for things like this. Have a look at http://tkyte.blogspot.com/search?q=analytics

# posted by

Anonymous : July 18, 2008 6:39 PM

Encrypted? Is it some external facility? DBMS_Crypto? Transparent Data Encryption?

If you are 11g, then do tablespace encryption!

# posted by

Tom : July 23, 2008 12:28 AM

Also, approve the transaction in real time or approve them for an actual credit card or credit limit increase?

If the transaction, there is a 3rd party product called Falcon that is really good. Or better yet, I have a fraud guy with actuary skills and good IT skills who can write just about anything that you are looking for : )...

He was a math major in college and he does our fraud!

# posted by

Tom : July 23, 2008 12:30 AM