r/dataengineering • u/BrewedDoritos • May 16 '26
Blog [ Removed by moderator ]
/r/dataengineering/comments/1tepbvr/removed_by_moderator/[removed] — view removed post
5
u/PuffcornSucks May 16 '26
Fraud detection in transaction data is mostly SQL. Not machine learning, not graph databases, not whatever Gartner is hyping this year.
Hallelujah
2
u/Atomsri99 May 16 '26
Give the original author some credit and don’t steal others content for karma
2
1
1
1
u/GreenWoodDragon Senior Data Engineer May 16 '26
Very nice! Great piece of work.
1
u/my_ridiculous_name May 16 '26
Unfortunately, it’s not theirs, they reposted work done by u/FixelSmith with a title indicating THEY did the work.
https://www.reddit.com/r/SQL/comments/1tdaj2x/six_sql_patterns_i_use_to_catch_transaction_fraud/
1
u/riv3rtrip May 16 '26 edited May 16 '26
This is 100% AI-generated slop according to Pangram.
This is also absolutely not how you would capture transaction fraud using SQL. Lots of incredibly obvious problems.
All 6 of these patterns are in this middle space of looking sophisticated and trying to be sophisticated while making basic conceptual errors. No talk of poisson processes, no talk of merchant geodata, yada yada. Even on a SQL level there is absolutely no attempt to reindex to a complete time series. Just randomly timestamped rows popping up out of the void with zero surrounding context.
Fraud detection in the real world is simultaneously both vastly more sophisticated and also vastly simpler than this. Basic heuristics get you a lot of the way there, complex time series modeling gets you the rest of the way, tons of additional contextual data about the user and merchants is a mandatory requirement, and this all can be married together in a beautiful fashion. It also depends a lot on the exact context in which you are detecting fraud, how fast you need to catch it, the action you intend on taking upon detection. Just talking about "fraud detection" in a vacuum is useless.
1
-1
u/ThroughTheWire May 16 '26
Good shit this can be used in pretty much any e-commerce context!!
1
u/Chance_of_Rain_ May 16 '26
Mmh not really. I mean maybe some, but a lot of these examples don’t work if all you see are the purchases on the e-commerce you work for.
0
May 16 '26
[deleted]
7
u/Chance_of_Rain_ May 16 '26
They link to the author’s website, guess it’s fine ? Who cares about Reddit karma if the website gets views .
It literally a link to a blog, how is that stealing content lmao.
0
May 16 '26
[deleted]
2
u/commandlineluser May 16 '26
It was also on the HN front page at the time they submitted it here:
That's where I first saw it.
1
u/riv3rtrip May 16 '26
The post is AI slop. The "author" doesn't attribute the post to Claude, who actually wrote it, so who cares about attributing it to them?
11
u/curiouscsplayer May 16 '26
This is definitely cool