SAND Searchable Archive Powers Efficient E-Banking Log Management System for NACF
Posted by Sachin Garg on 2nd July 2005 | Permanent Link
NACF processes a very large volume of e-banking transactions daily, and this is increasing steadily as their customers become more comfortable with Internet banking. Currently, these transactions produce at least 12GB of log data per day, and as much as twice that at month’s end. All this data must be kept available for two months so that call center staff can access it if necessary to respond to customer support requests.
A solution based on SAND Searchable Archive is now used to store two months of transaction log data - nearly a terabyte - in a very compact (approximately 50GB) archive that can be directly searched via a simple application using standard SQL. Results are now returned in minutes rather than days. The archive process is fully automated and accommodates changes to archived objects (i.e., addition or removal of fields in the logs) over time with minimal administrative effort.
Product strengths include high compression rates, the ability to query data directly without decompression and the ability to change structure of the source data (add and drop columns) without requiring restructuring of the archive.
Read more here.