[SQLDownUnder] Real time enterprise database design

[Tanvir Huda]

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 for financial institutions.

 

When are we making transaction how the record is kept and tables are designed? This is must not be basic ER solutions. The database must be designed to ensure a highly scalable,high performance and high throughput one. So, when millions of people are making transactions for their day-to-day saving accounts how the records are kept and how they are updated. Don’t think about 100s, I am thinking about thousands per minutes. So, when a transaction has been made their current balance is available at the next moment for next transaction or view.

 

This is done both at the application software and hardware level.

 

My objective is to know the best practices in software industries in tackling this issue.

 

Thanks for your co-operation in advance.

 

Regards

 

Tanvir

  

 

 

to unsubscribe to this list, please send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com - List managed by http://www.readify.net