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. Read more

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. Read more

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: