Invention Grant
- Patent Title: Database load tool
-
Application No.: US15153810Application Date: 2016-05-13
-
Publication No.: US10223408B2Publication Date: 2019-03-05
- Inventor: Mitul S. Shah , Ruchi R. Jain
- Applicant: BANK OF AMERICA CORPORATION
- Applicant Address: US NC Charlotte
- Assignee: Bank of America
- Current Assignee: Bank of America
- Current Assignee Address: US NC Charlotte
- Agent Michael A. Springs
- Main IPC: G06F17/30
- IPC: G06F17/30 ; G06F21/62

Abstract:
A database load tool includes a user interface, a retrieval engine, an authorization engine, and an update engine. The a user interface receives a request to add to a database a first table comprising a plurality of rows and a plurality of columns. The retrieval engine retrieves an authorization table from the database. The authorization table is separate from the table and indicates a plurality of users who are authorized to edit the database. The authorization engine determines whether the plurality of users includes the user. The update engine: generates a first Structured Query Language query to create in the database a second table; generates, for each row of the plurality of rows, a second Structured Query Language query to add that row to the second table; and communicates the first and second Structured Query Language queries.
Public/Granted literature
- US20170329816A1 Database Load Tool Public/Granted day:2017-11-16
Information query