...

UniPayGateway

December 1, 2014
Written by
James Davis
Written by James Davis
Senior Technical Writer at United Thinkers

Author of the Paylosophy blog, a veteran writer, and a stock analyst with extensive knowledge and experience in the financial services industry that allows me to cover the latest payment industry news, developments, and insights.

My works have been cited across media and payment blogs. I do my best to help businesses make the most efficient financial decisions that can positively and significantly improve their business growth.

Whether you are a seasoned investor or just starting out in the world of payments, my writing is designed to be accessible to everyone and help people navigate the complex world of payments. So if you want to stay up-to-date on the latest trends and insights in the payment industry, be sure to check out Paylosophy and my published works.

Reviewed by
Kathrine Pensatori
Product Specialist at United Thinkers

Product specialist with more than 10 years of experience in the Payment Processing Industry. I help payment facilitators and PSPs solve their various payment processing issues. On a regular basis, I work with a team of knowledgeable technical people in the space, and I am passionate about finding creative solutions to the challenges presented by the Payments Industry.

I would be happy to help with any questions you might have regarding credit card payment processing, merchant services, EMV certifications, the various ways of becoming a payment facilitator or a payment platform, as well as any other Payment Industry related issues you might be struggling with. Feel free to follow me on Quora, and don’t hesitate to send me links to the specific Quora questions you would like me to answer.

Challenges of Transaction Data Archiving

Data archiving can be a challenge with any database system. Particularly, transaction data archiving presents significant problems for many database systems in payment industry.

Accumulate Transactional Data

Companies with high transactional throughput have to store enormous data volumes, because they accumulate transactional data very fast. Transactional data has to be stored and easily accessed. Access to data must be ensured in order to make it possible to compile historical reports and get back to transactions which resulted in refunds, chargebacks, and ACH returns.

Transaction data archiving problems concern several aspects of database maintenance. For example, database size may become very large and occupy all the space on the hard drive, large data volume may lead to decrease in the overall database performance, long indexes may slow down the search. Finally, the larger the table, the longer it takes to introduce any changes into it.

In order to solve the above mentioned problems, several approaches are utilized. The most common one is data partitioning according to time intervals (on weekly or monthly basis). Beside that, in order to optimize transaction data archiving and record search process in large-size databases, two tables are maintained, each intended for some particular operations: authorization table and archiving table.

Read more about transaction data archiving techniques in the respective article on Paylosophy. 

 

Useful articles to help you: