DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: How to design (.NET App. & SQL Database)Suspicious Activity Detection Application

  1. #1
    Join Date
    Jul 2007

    How to design (.NET App. & SQL Database)Suspicious Activity Detection Application

    Hello Guys,

    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 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,

    Sameer Gautam

  2. #2
    Join Date
    Jan 2007
    Use some Rules Engine(e.g Ilog), simplest thing would be put few triggers in database and act on it.

Similar Threads

  1. Replies: 0
    Last Post: 12-09-2002, 06:43 PM
  2. C# & .NET
    By Vikas Garg in forum Careers
    Replies: 18
    Last Post: 07-13-2002, 11:58 AM
  3. Access & SQL Server
    By David Jones in forum Database
    Replies: 0
    Last Post: 08-31-2001, 12:22 PM
  4. OO Considered Harmful
    By Richard Dalton . in forum Architecture and Design
    Replies: 33
    Last Post: 07-30-2001, 02:11 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center
Latest Articles
Questions? Contact us.
Web Development
Latest Tips
Open Source

   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center