Bank calculate the balance

when bank calculate the balance  it calculate by sum of  all transaction or it have a balance before transaction then they just add or subtract only one row
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

SujithData ArchitectCommented:
There is no "single" answer for this question, it largely depends on the way applications are designed and implemented.

From a few systems that I have seen;
-- There are transaction tables holds the daily transaction details. Deposits/Withdrawals.
-- There is a master table that keeps track of the daily balances of accounts. This master tables are updated by "End of Day" processing from the transaction tables.
-- Generally these master tables are not updated directly by the transaction records.
-- Queries to find the latest balances, subtracts/adds the transaction table data to the master table to get a latest figure.
-- "ENd of Day" processing updates the master tables and purges the processed transaction records.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Mark GeerlingsDatabase AdministratorCommented:
I agree with sujith80, there is no single answer to this question.  Many bank systems record the running balance, so they only have to add or subtract the latest transaction for an account, and update the balance.  But there are certainly many different ways of getting this job done.
awking00Information Technology SpecialistCommented:
Not meaning to be cute, but the answer is yes. I was in the banking business for nearly 20 years and it depends on the processing method of each individual institution. Most banks today operate on an "on-line" processing mechanism where running balances are maintained in real time. A number of banks, however, still use "batch processing" in which balances are reconciled on a periodic (generally daily) basis through an update based on transaction processing. There are also some banks that use a hybrid processing methodology that processes some transactions in real-time and some in batch. Ask the bank and they'll tell you what processing method they use.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.