Systems and methods for database investigation tool

Patent metadata

Field	Value
Publication number	US-12124465-B2
Application number	US-202217819035-A
Country	US
Kind code	B2
Filing date	Aug 11, 2022
Priority date	Sep 4, 2015
Publication date	Oct 22, 2024
Grant date	Oct 22, 2024

Abstract

Computer-implemented systems and methods are disclosed that query collections of documents. Disclosed embodiments may include receiving, via a user interface, a first search query comprising a text string. Disclosed embodiments may include, responsive to receiving the first search query, initializing a first query object based on the text string. Further, disclosed embodiments may include translating the first query object to match the formatting of a search engine, the translated first query object capable of searching a plurality of collections of documents. Disclosed embodiments may also include receiving aggregated query results from a search engine based on the translated first query object. Some disclosed embodiments may include reformatting the aggregated query results based on respective configuration files of the collections. Additionally, disclosed embodiments may include rendering a graphical user interface that facilitates user interaction with the reformatted aggregate query results.

First claim

What is claimed:

1. A system comprising:
one or more computer processors;
one or more computer memories;
a set of instructions stored in the one or more computer memories, the set of instructions configuring the one or more computer processors to perform operations, the operations comprising:
receiving a first input, the first input specifying a request to search a collection of documents for documents having a first attribute;
generating a first query based on the first input;
applying the first query to the collection of documents;
receiving a first set of results, the first set of results corresponding to the first query;
receiving a second input, the second input specifying a refinement for the first set of results, wherein the first set of results is stored and not indexed;
generating a second query based on the second input, the second query including a data field associated with the second input;
combining the first query and the second query into a refined query different from the first query and the second query; and
applying the refined query to the collection of documents to receive a second set of results instead of applying the second query to the first set of results, wherein the second set of results is indexed.

2. The system of claim 1 , the operations further comprising producing an interactive visual representation of the first set of results and wherein the receiving of the second input is based on an interaction by a user with the interactive visual representation, the interaction specifying the refinement.

3. The system of claim 1 , further comprising:
receiving a third input, the third input specifying a request to search the collection of documents for documents having a second attribute that overlap with the second set of results;
generating a third query based on the refined query and the third input rather than aggregating the second set of results with an additional set of results;
applying the third query to receive a third set of results representing the documents having the second attribute that overlap with the second set of results.

4. The system of claim 1 , wherein a set of results corresponding to the second query is not indexed.

5. The system of claim 1 , wherein the collection of documents is indexed.

6. The system of claim 1 , wherein the first attribute corresponds to a value of a field in each document of the collection of documents, the value of the field being an indexed value.

7. A non-transitory computer readable storage medium storing a set of instructions that, when executed by one or more computer processors, cause the one or more computer processors to perform operations, the operations comprising:
receiving a first input, the first input specifying a request to search a collection of documents for documents having a first attribute;
generating a first query based on the first input;
applying the first query to the collection of documents;
receiving a first set of results, the first set of results corresponding to the first query;
receiving a second input, the second input specifying a refinement for the first set of results, wherein the first set of results is stored and not indexed;
generating a second query based on the second input, the second query including a data field associated with the second input;
combining the first query and the second query into a refined query different from the first query and the second query; and
applying the refined query to the collection of documents to receive a second set of results instead of applying the second query to the first set of results, wherein the second set of results is indexed.

8. The non-transitory computer readable storage medium of claim 7 , the operations further comprising producing an interactive visual representation of the first set of results and
wherein the receiving of the second input is based on an interaction by a user with the interactive visual representation, the interaction specifying the refinement.

9. The non-transitory computer readable storage medium of claim 7 , further comprising:
receiving a third input, the third input specifying a request to search the collection of documents for documents having a second attribute that overlap with the second set of results;
generating a third query based on the refined query and the third input rather than aggregating the second set of results with an additional set of results;
applying the third query to receive a third set of results representing the documents having the second attribute that overlap with the second set of results.

10. The non-transitory computer readable storage medium of claim 9 , wherein a set of results corresponding to the second query is not indexed.

11. The non-transitory computer readable storage medium of claim 7 , wherein the collection of documents is indexed.

12. The non-transitory computer readable storage medium of claim 7 , wherein the first attribute corresponds to a value of a field in each document of the collection of documents, the value of the field being an indexed value.

13. A method comprising:
receiving a first input, the first input specifying a request to search a collection of documents for documents having a first attribute;
generating a first query based on the first input;
applying the first query to the collection of documents;
receiving a first set of results, the first set of results corresponding to the first query;
receiving a second input, the second input specifying a refinement for the first set of results, wherein the first set of results is stored and not indexed;
generating a second query based on the second input, the second query including a data field associated with the second input;
combining the first query and the second query into a refined query different from the first query and the second query; and
applying the refined query to the collection of documents to receive a second set of results instead of applying the second query to the first set of results, wherein the second set of results is indexed.

14. The method of claim 13 , further comprising producing an interactive visual representation of the first set of results and wherein the receiving of the second input is based on an interaction by a user with the interactive visual representation, the interaction specifying the refinement.

15. The method of claim 13 , further comprising:
receiving a third input, the third input specifying a request to search the collection of documents for documents having a second attribute that overlap with the second set of results;
generating a third query based on the refined query and the third input rather than aggregating the second set of results with an additional set of results;
applying the third query to receive a third set of results representing the documents having the second attribute that overlap with the second set of results.

16. The method of claim 15 , wherein a set of results corresponding to the second query is not indexed.

17. The method of claim 13 , wherein the collection of documents is indexed.

Assignees

• Palantir Technologies Inc

Inventors

• Streufert Justin
• Giardina Robert
• Bogomolov Arseny
• Marc-Aurele Brandon
• Luck Christopher
• O'Brien Timothy
• Levan Matthew
• Hall Nicholas

Classifications

• G06F16/9538

  Presentation of query results · CPC title

• G06F16/25

  Integrating or interfacing systems involving database management systems · CPC title

• G06F16/24575

  using context · CPC title

• G06F16/9535

  Search customisation based on user profiles and personalisation · CPC title

• G06F16/9024

  Graphs; Linked lists (G06F16/9027 takes precedence) · CPC title