Complex database / business logic architecture

Hello,

we have complex database calculation requirements in the banking field. A running solution exists but we want to explore if there are better / easier ways of building a solution. Everything should be built with the help of Microsoft products.

 

Here is a short description of the system:In general there are lots of input databases from different servers. On these databases complex business logic is executed and the results are saved in a format accessible by reports. Until now these are a couple of output databases. Because the output data must be accessible quite fast for reporting, the business logic is mainly writing its calculated data into temporary databases and just updating the delta changes. The reporting accesses mainly this temporary data but additionally also uses some on the fly calculations via stored procedures.

 

So, the logic of the system is defined using self written "stored pro ...