Bank of America Corporation

Arya Kumar Vedabrata

David Joa

Naveen Gururaja Yeri

Timothy J Bendel

Thayer S Allison

Yanghong Shao

Deepak Verma

Bibhudatta Jena

Jangaiah Kranti Kurva

Vikas Mishra

Chandrashekar Katuri

Chandra Shekar Katuri

Parul Bajaj

Apparatuses, computer readable media, methods, and systems are described for accessing table layout data identifying a plurality of fields included in a table stored in a database, accessing log data identifying a number of times each of the fields of the table has been queried, ranking the fields based on the number of times each of the fields of the table has been queried, determining a first subset of the fields that have not been queried at least a predetermined number of times, and generating an update to the table by removing the first subset of the fields from the table.

Database management by analyzing usage of database fields

Systems and methods for monitoring trigger data quality are provided herein. The systems and methods detect and report whether the current trigger counts are normal or flawed in real time. The systems and methods monitor the triggers to determine the accuracy, completeness, domain of values, and format of the trigger data. In the system and methods, account data associated with the one or more accounts is received and stored in a storage device; the account data is segregated into one or more periods of time; triggers associated with the one or more periods of time are identified based on transactions that occur during the one or more periods of time; a total transaction count for each of the triggers is calculated; and control limits are determined based on the transaction count for each of the triggers.

Trigger data quality monitor

Growing community of inventors

Orissa, India

Arya Kumar Vedabrata