Simple Graph Design For Fraud in Deposit

1

Hi all,

I’m new in graph database, anyone can help me to choose which one correct / better between model 1 & 2 of graph model below ?

image
image1922×814 45.4 KB

My goals is:

  • Get the biggest transaction in deposit
  • Check source of deposit amount based on transaction
  • Fraud detection based on deposit transaction with some criteria
  • etc.

Really appreciate for the help / suggestion, thanks.

Regards

2

@marifnst Good question. Depends on what your data looks like. In general I would lean towards the second one so you can have a unique point for that transaction.

Account - (Sender)-> Account

Then the reverse edge could be

Account -(Receiver)-> Account

Vertex

Transaction

  • transaction_id
  • type
  • amount
  • date_time
  • etc

Account

  • account_id
  • account_created
  • account_closed
  • etc

Edge

Sender

  • type (Credit/Debt) – or store type in the transaction information

Receiver

  • type (Credit/Debt) – or store type in the transaction information
3

Dear jon

Thanks for the answer.

Regards

1 Like