US 11,775,526 B1
Systems and methods for joining non-relational database search results over multiple database indexes
John Stephen Townsend, San Antonio, TX (US); Nicholas Paul Metzger, San Antonio, TX (US); and Paul Barrera, 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 Aug. 17, 2022, as Appl. No. 17/890,033.
Application 17/890,033 is a continuation of application No. 16/697,768, filed on Nov. 27, 2019, granted, now 11,449,511.
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/2455 (2019.01); G06F 16/901 (2019.01); G06F 16/904 (2019.01)
CPC G06F 16/2456 (2019.01) [G06F 16/901 (2019.01); G06F 16/904 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A system, comprising:
a non-relational database cluster comprising a plurality of non-relational databases;
a plurality of database indexes stored in the non-relational database cluster, wherein each database index of the plurality of database indexes comprises multiple types of documents having a plurality of fields and wherein said each database index of the plurality of database indexes is different from another database index; and
a computing device comprising: a processor and a volatile memory, wherein the volatile memory comprises processor-executable instructions configured to cause the processor to:
perform a plurality of index queries on the plurality of database indexes to receive the plurality of database indexes;
perform a plurality of field queries to receive a plurality of field lists based on the plurality of database indexes, wherein each list of the plurality of field lists corresponds to a list of a respective plurality of fields associated with a database index of the plurality of database indexes;
receive a selection of fields from the plurality of field lists, wherein each field of the selection of fields is from a different list of the plurality of field lists;
perform a plurality of search queries on the plurality of database indexes based on the selection of fields to generate a plurality of search results, wherein the plurality of search results comprises records retrieved from the plurality of non-relational databases;
convert one or more datasets contained within the selection of fields to a same data type; and
join the plurality of search results into a joined dataset by associating each field from the selection of fields with another field, wherein the joined dataset comprises a joined field corresponding to a first field and a second field and comprises records having the same data type.