Upgrade to Pro — share decks privately, control downloads, hide ads and more …

ATM Fraud Detection with Oracle Property Graphs

ATM Fraud Detection with Oracle Property Graphs

With a stream of ATM transactions in Apache Kafka, how to detect if a card has been cloned? Turn the stream into a property graph and use PGQL to detect possible frauds. Two challenges in one talk: streams to property graphs and fraud detection. Proving the power and flexibility of graph databases, the mandatory product in your Analytics toolbox!

Gianni Ceresa

October 08, 2019
Tweet

More Decks by Gianni Ceresa

Other Decks in Technology

Transcript

  1. Copyright © 2017, Oracle and/or its affiliates. All rights reserved.

    | bit.ly/OracleACEProgram 450+ Technical Experts Helping Peers Globally Nominate yourself or someone you know: acenomination.oracle.com
  2. edge edge label edge properties edge ID directed edge vertex

    (node) vertex properties vertex ID a vertex can have a label
  3. Every row of a table has a fixed, identical structure

    Connections at a table level (not row) Nodes and edges can have any number of properties Connections at a node level (can be seen as row level)
  4. Spain Italy John Doe Company A Company B Company C

    Company D Located in Located in Located in Located in Buys from Buys from Buys from Buys from Money laundering and VAT frauds Owns
  5. • • • • • • The presentation was a

    live demo, screenshots aren’t as explicit as seeing it…
  6. { "account_id": "a839", "timestamp": "2019-03-10 13:49:32 +0000", "atm": "24/7", "amount":

    20, "location": { "lat": "53.7835061", "lon": "-1.3794149" }, "transaction_id": "555aa4f6-433b-11e9-b9b9-0242ac140005" } Location of the ATM
  7. Kafka stream Property Graph A Java app consume the Kafka

    stream and update the graph with the new messages received.
  8. The UK set of ATMs used is a bit too

    sparse over a big area. Too many of the randomly generated transactions seem to be fraud.
  9. The UK set of ATMs used is a bit too

    sparse over a big area. Too many of the randomly generated transactions seem to be fraud.
  10. • • • • • • • more about graphs:

    Data Lineage Made Easy with Graph Database 14:50-15:20 | Sentosa 1 (the other room) UKOUG Techfest 2019, Dec 2019 in Brighton