In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.
Customer, --name of the customer Bank Name, --name of the bank the transaction took place Balance, --current balance at the time of the transaction Deposited, -- amount deposited Withdrawn, -- amount withdrawn Declined -- amount declined
the Bank, Count of withdrawals Count of Deposits Count of where the withdrawn = balance, -- gives me the number of trans where the customer withdrew everything Count of where the Deposited = balance, -- gives me the number of trans where the customer doubled their balance Count of where Declined > 0 Percentage of monies withdrawn in terms of balance -- % of monies withdrawn in terms of balance
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.