Bank of America Corporation
Performing database file management using statistics maintenance and column similarity

Abstract:

A computing platform may perform computer database file management by implementing statistics maintenance and column similarity. The computing platform may receive an input table and determine a data type for the received input table. The computing platform may determine statistics relevant to the input table, and statistics relevant to historical tables of the data type. Statistics may include overlap, distribution, mean, standard deviation, percentile, median, and the like. Based on the determined statistics, the computing platform may determine a similarity score between the input table and the historical tables. Based on the statistics and column similarity, the computing platform may perform database file management, such as storing records, updating records, identifying data anomalies, sending alerts related to identified data anomalies, moving records, tagging records, and the like. The computing platform may send alerts related to identified data anomalies to remote devices.