US 2020/0394178 A1Published application

Database Tool

AssigneeBank of America Corporation

InventorsSanchit Taggar, Sandeep Kumar Chauhan

Life of this patent

Estimating the term…

Loading patent…

Abstract

A system includes a first database, a second database, a first processor, a second processor, a third processor, and a fourth processor. The first database includes a first segment assigned to the first processor and a first transaction type and a second segment assigned to the second processor and a second transaction type. Each of the first and second processors receives a request, assigned to its associated transaction type, from the third hardware processor, to store data in the first database. The processor then writes the data into the segment of first database assigned to the processor/transaction type. The processor further stores a command to write the data into the second database in a queue. The fourth processor then executes the commands stored in the queue, thereby writing the data into the second database.

Claims20

Dependent claims

A system comprising:

a first database comprising a first segment assigned to a first transaction type and a second segment assigned to a second transaction type;
a second database;
a first hardware processor assigned to the first transaction type and configured to:
receive a first request from a third hardware processor to store a first piece of data in the first database, the first request assigned to the first transaction type;
write the first piece of data into the first segment of the first database;
and
in response to writing the first piece of data into the first segment, store a first command to write the first piece of data into the second database in a first queue comprising
a first series of commands;
a second hardware processor assigned to the second transaction type and configured to:
receive a second request from the third processor to store a second piece of data in the first database, the second request assigned to the second transaction type;
write the second piece of data into the second segment of the first database;
and
in response to writing the second piece of data into the second segment, store a second command to write the second piece of data into the second database in a second queue comprising a second series of commands;
a third hardware processor configured to:
receive a third request from a user to store a third piece of data;
in response to receiving the third request:
determine that the third request is assigned to the first transaction type;
in response to determining that the third request is assigned to the first transaction type, send the third request to the first processor assigned to the first transaction type;
receive a fourth request from the user to store a fourth piece of data;
in response to receiving the fourth request:
determine that the fourth request is assigned to the second transaction type;
in response to determining that the fourth request is assigned to the second transaction type, send the fourth request to the second processor, assigned to the second transaction type;
receive a fifth request from the user to retrieve a fifth piece of data;
and
in response to receiving the fifth request:
read the fifth piece of data from the second database;
and
send the fifth piece of data to the user;
and
a fourth hardware processor configured to:
access the first queue;
in response to accessing the first queue, execute the first series of commands stored in the first queue, wherein executing the first series of commands stored in the first queue comprises writing the first piece of data into one or more locations in the second database;
access the second queue;
and
in response to accessing the second queue, execute the second series of commands stored in the second queue, wherein executing the second series of commands stored in the second queue comprises writing the second piece of data into one or more locations in the second database.

32 more elements

A method comprising:

receiving a first request from a user to store a first piece of data in a system comprising a first database and a second database, the first database comprising a first segment assigned to a first transaction type and a second segment assigned to a second transaction type;
in response to receiving the first request:
determining that the first request is assigned to the first transaction type;
in response to determining that the first request is assigned to the first transaction type, sending the first request to a first hardware processor assigned to the first transaction type, the first processor configured to:
receive the first request to store the first piece of data in the first database;
write the first piece of data into the first segment of the first database;
and
in response to writing the first piece of data into the first segment:
store a first command to write the first piece of data into the second database in a first queue comprising a first series of commands, wherein a fourth hardware processor is configured to:
access the first queue;
and
in response to accessing the first queue, execute the first series of commands stored in the first queue, wherein executing the first series of commands stored in the first queue comprises writing the first piece of data into one or more locations in the second database;
receiving a second request from the user to store a second piece of data in the system;
in response to receiving the second request:
determining that the second request is assigned to the second transaction type;
in response to determining that the second request is assigned to the second transaction type, sending the second request to a second processor assigned to the second transaction type and having a second available processing capacity, the second processor configured to:
receive the second request to store the second piece of data in the first database;
write the second piece of data into the second segment of the first database;
and
in response to writing the second piece of data into the second segment:
store a second command to write the second piece of data into the second database in a second queue comprising a second series of commands, wherein the fourth processor is configured to:
access the second queue;
and
in response to accessing the second queue, execute the second series of commands stored in the second queue, wherein executing the second series of commands stored in the second queue comprises writing the second piece of data into one or more locations in the second database;
receive a third request from the user to retrieve a third piece of data;
and
in response to receiving the third request:
reading the third piece of data from the second database;
and
sending the third piece of data to the user.

27 more elements

A system comprising:

a first storage element comprising a first segment assigned to a first transaction type and a second segment assigned to a second transaction type;
a second storage element;
a first processing element assigned to the first transaction type and operable to:
receive a first request from a third processing element to store a first piece of data in the first storage element, the first request assigned to the first transaction type;
write the first piece of data into the first segment of the first storage element;
and
in response to writing the first piece of data into the first segment, store a first command to write the first piece of data into the second storage element in a first queue comprising a first series of commands;
a second processing element assigned to the second transaction type and operable to:
receive a second request from the third processing element to store a second piece of data in the first storage element, the second request assigned to the second transaction type;
write the second piece of data into the second segment of the first storage element;
and
in response to writing the second piece of data into the second segment, store a second command to write the second piece of data into the second storage element in a second queue comprising a second series of commands;
the third processing element operable to:
receive a third request from a user to store a third piece of data;
in response to receiving the third request:
determine that the third request is assigned to the first transaction type;
in response to determining that the third request is assigned to the first transaction type, send the third request to the first processing element assigned to the first transaction type;
receive a fourth request from the user to store a fourth piece of data;
in response to receiving the fourth request:
determine that the fourth request is assigned to the second transaction type;
in response to determining that the fourth request is assigned to the second transaction type, send the fourth request to the second processing element, assigned to the second transaction type;
receive a fifth request from the user to retrieve a fifth piece of data;
and
in response to receiving the fifth request:
read the fifth piece of data from the second storage element;
and
send the fifth piece of data to the user;
a fourth processing element operable to:
access the first queue;
in response to accessing the first queue, execute the first series of commands stored in the first queue, wherein executing the first series of commands stored in the first queue comprises writing the first piece of data into one or more locations in the second database;
access the second queue;
in response to accessing the second queue, execute the second series of commands stored in the second queue, wherein executing the second series of commands stored in the second queue comprises writing the second piece of data into one or more location in the second database;
compare the first storage element to the second storage element at a scheduled time each day;
determine that a sixth piece of data stored in the first storage element is not stored in the second storage element;
and
in response to determining that the sixth piece of data stored in the first storage element is not stored in the second storage element:
copy the sixth piece of data from the first storage element;
and
write the sixth piece of data into one or more third locations in the second storage element.

36 more elements

Dependencies are inferred from the claim text.