1129 深入探索 SQL 数据洞察_1756972900866001hytD.pdf.pdf

1、Orlando,FLOctober 69IBM TechXchange 2025Session code 1129Thomas BaumannSwiss MobiliarData EvangelistDeep Dive Into SQL Data InsightsAgenda0102030405Credit Card Fraud DetectionIntro to SQL Data Insights&Swiss MobiliarInsurance Fraud DetectionBufferpool Tuning with SDISummaryCharming Moments in Apulia

2、(Italy):A Beautiful Escape Before the Shadow of Fraud3Why You Should Never Ignore Your Monthly Credit Card StatementSELECT*FROM CC ORDER BY ITEM_NO;ItemDateTypeShopLocationCountryCURvalueCHF value106/14 Supermarkets,groceries Migros MM MoratMurtenCHCHF(null)16.70206/18 InsurancesSZurichCHCHF(null)83

3、.15306/23 Supermarkets,groceries Migros MM DudingenDudingenCHCHF(null)9.4406/25 Supermarkets,groceries CONADMARTANOITEUR66.7764.6506/25 RestaurantsDA UMBERTO 1972MAGLIEITEUR154149.05606/26 Parking garagesPARK MELEDUGNOCORCIANOITEUR2.72.6706/26 Supermarkets,groceries DITTA TRAMACERE BIAGIO MELENDUGNO

4、 ITEUR16.5215.9806/26 Tax paymentsCOMUNE DI MELENDUGNO MELENDUGNO ITEUR1211.55906/26 Supermarkets,groceries THE FRAUDULENT SHOPPJOENGJANG NKKPW500.051006/26 Parking garagesPARC.MELENDUGNOMELENDUGNO ITEUR54.81106/27 Fast food restaurantsLIDO 2 MORIOTRANTOITEUR46.544.851206/27 Fast food restaurantsLID

5、O DUE MORIOTRANTOITEUR4543.41306/28 ClothingSUMUP*ANNA LINCIANOLEQUILEITEUR5048.255Which Items Look Like Fraud(if any)?https:/ Items Look Like Fraud(if any)?ItemDateTypeShopLocationCountryCURvalueCHF value106/14 Supermarkets,groceries Migros MM MoratMurtenCHCHF(null)16.70206/18 InsurancesSZurichCHCH

6、F(null)83.15306/23 Supermarkets,groceries Migros MM DudingenDudingenCHCHF(null)9.4406/25 Supermarkets,groceries CONADMARTANOITEUR66.7764.6506/25 RestaurantsDA UMBERTO 1972MAGLIEITEUR154149.05606/26 Parking garagesPARK MELEDUGNOCORCIANOITEUR2.72.6706/26 Supermarkets,groceries DITTA TRAMACERE BIAGIO M