Bank of America Corporation
Database compliance tool

Abstract:

A database compliance tool includes a user interface, a retrieval engine, a data integrity engine, and an update engine. The user interface receives a request to add a row to a table in a database. The retrieval engine retrieves a name for each column of the table and a datatype of each column of the table. The data integrity engine determines, for each column of the table, at least one value based on the retrieved datatype of the column. The at least one value is of the retrieved datatype and the user interface receives a selection of a value from the at least one value for each column. The update engine communicates an update request including the table and the selected value for each column. A row is added to the table in response to the update request. The row includes the selected value for each column of the table.