How to design (.NET App. & SQL Database)Suspicious Activity Detection Application
I know this is basic and different people do that in different ways according to their needs; but I would like to know about the best practices to design a highly scalable real time enterprise databases/application for financial institutions.
Here is a scenario. This application would be import Customerís Transactional as well as updated profile from Bankís Core Banking Solution or Data warehouse daily in a batch mode.
Now our application has to determine the suspicious activities by running some rule sets on the transactions. Let me let you some example of rule sets :
1. Generate suspicious activity alert if customer does debit/credit transactions amount sum exceeds 1 million dollars within a month.
2. Generate alert if Customer Debit transaction amount > X% of A (where A=maximum debit transaction amount over y1 period)
This application should be able to find suspicious activity for at least 5 millions customers and 1 million transaction would be imported daily to our engine DB.
I would appreciate if could suggest me how this application should be designed on (VS.2005,SQL 2005) platform. Should we have two DB ,one OLTP for keeping customer profile & his transactions and another OLAP DB where analysis services, business intelligence, data mining would store customer past history in fact tables so at the time of rule processing those result can be queried from here. Should we build rule engine in VS.net or in SQL 2005 analysis services or in Biz Talk server or web services or data mining.How analysis services, business intelligence, data mining of SQL/.NET can be used to achieve this application.
Thanks & Regards,
Use some Rules Engine(e.g Ilog), simplest thing would be put few triggers in database and act on it.
Last Post: 12-09-2002, 06:43 PM
By Vikas Garg in forum Careers
Last Post: 07-13-2002, 12:58 PM
By David Jones in forum Database
Last Post: 08-31-2001, 01:22 PM
By Richard Dalton . in forum Architecture and Design
Last Post: 07-30-2001, 03:11 AM
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL