|
Hi All,
I would like to solve one business problem with xml-soap
application. Let me explain the spec first.
Customer X information is stored in Database X and Database Y
. Based on the data from both diferrent databases i need to caliculate some
ratios whenever client makes some business transactions.
Say like Customer John. He travelled 8500 KM till now.
This 8500KM is the sum of 6500KM from Database X and 2000KM from Database Y.
Whenever he exceeds 10000KM travel i would like to provide some discount like
15% on travel fare.And if he croses 25000KM , discount 25% will be
given as a business strategy.
If i want to develop this application without
XML , at the time of business transaction data will be
retrived from both databases which is network burdensome.Here server all the
times sends request to both the databases which can be eliminated with central
xml database which will be updated every time when client interacts with one of
the RDBMS databases say Database X or Database Y.
I can write some database triggers to update my central xml
database which will be helpful for caliculations.
Here i can raduce burden on the web server with single xml
database, instead of accessing data from different databases all the
times.
Is this design is good?. If i am wrong please help
me.
Thanx in advance.
Regards,
Ravindra.
.
|
