US 11,941,004 B1
System and method for executing database operations based on a policy
Glen Alan Becker, San Antonio, TX (US)
Assigned to United Services Automobile Association (USAA), San Antonio, TX (US)
Filed by United Services Automobile Association (USAA), San Antonio, TX (US)
Filed on Sep. 28, 2020, as Appl. No. 17/035,036.
Int. Cl. G06F 16/2455 (2019.01); G06F 16/21 (2019.01); G06F 16/22 (2019.01)
CPC G06F 16/2455 (2019.01) [G06F 16/2228 (2019.01); G06F 16/217 (2019.01)] 19 Claims
OG exemplary drawing
 
1. A system, comprising:
one or more hardware processors; and
non-transitory memory storing instructions that, when executed by the one or more hardware processors, cause the one or more hardware processors to perform actions comprising:
receiving a policy defining maintenance rules of data in a data store, wherein the policy comprises a string of alphanumeric characters and an additional string of alphanumeric characters to be adjusted, wherein the string of alphanumeric characters is different than the additional string of alphanumeric characters;
retrieving a global index in response to receiving the policy and based on the global index comprising the string of alphanumeric characters, wherein the global index indicates, in the data store, a row of a table containing the string of alphanumeric characters;
retrieving an additional global index in response to receiving the policy and based on the additional global index comprising the additional string of alphanumeric characters, wherein the additional global index indicates, in the data store, an additional row of the table containing the additional string of alphanumeric characters;
batching operations via, at a particular time, initiating and performing a search query on the table by scanning the row of the table for the string of alphanumeric characters according to the global index and scanning the additional row of the table for the additional string of alphanumeric characters according to the additional global index to identify a table entry containing the string of alphanumeric characters based on the row of the table indicated by the global index and to identify an additional table entry based on the additional row of the additional table indicated by the additional global index; and
adjusting the table entry and the additional table entry in accordance with the policy after identification of the table entry and the additional table entry by performing the search query.