System and method for querying a data repository

Patent metadata

Field	Value
Publication number	US-12321394-B2
Application number	US-202217960622-A
Country	US
Kind code	B2
Filing date	Oct 5, 2022
Priority date	Oct 5, 2017
Publication date	Jun 3, 2025
Grant date	Jun 3, 2025

Abstract

A search request relating to one or more datasets in the data repository can be received, the search request comprising a display request to display at least a portion of the one or more datasets. In response to the search request, a searchable database can be generated from the one or more datasets in a data repository based on ontological data associated with the one or more datasets. An object view of at least the portion of one or more datasets can be generated from the searchable database, the view being generated based on the ontological data. The generated object view can be provided to be displayed on a display device.

First claim

The invention claimed is:

1. A method, performed by one or more processors, of querying data in a data repository comprising:
receiving a search request relating to datasets in the data repository, the datasets representing objects;
in response to the search request, generating or resynchronizing a searchable database from the one or more datasets in the data repository based on ontological data;
generating, in response to generating or resynchronizing of the searchable database, an object view of at least the portion of the datasets corresponding to the search request, the object view being generated based on the ontological data, the ontological data defining any one or more joins between the datasets, an order of presentation of properties corresponding to the objects, any abbreviations of any of the properties, a type of chart, graph, histogram, table, or type of view to present the objects, or a display prominence of the objects, wherein the object view is displayed on a same interface as a feeds tab, the feeds tab indicative of any saved searches that continuously or periodically refresh;
receiving a customised object view for an object of the objects, wherein the customised object view has a difference compared to the object view;
receiving any change in the ontological data of the objects;
determining whether the customised object view is compatible with the any change; and
selectively presenting, using the customised object view, the object according to the any change based on the determination of whether the customised object view is compatible with the any change.

2. The method of claim 1 , further the ontological data comprises the display prominence of the objects and an order in which each of the objects is rendered.

3. The method of claim 2 , wherein the determining of the display prominence is based on a fraction of column or row values that contain unique values.

4. The method of claim 2 , wherein the display prominence is associated with an order in which the objects are displayed.

5. The method of claim 1 , further comprising:
displaying the object view at a first device;
transmitting the difference to a second device; and
displaying the customised object view at the second device.

6. The method of claim 5 , further comprising:
storing the difference in a storage associated with the first device.

7. The method of claim 1 , wherein the customised object view comprises an additional tab or widget compared to the default object view.

8. The method of claim 1 , further comprising:
detecting simultaneous attempts to edit the one or more datasets; and
resolving conflicts among the simultaneous attempts using vector clocks.

9. The method of claim 1 , wherein the changes to the visualization are stored in a volatile memory of a device on which the customized object view is displayed.

10. The method of claim 1 , further comprising:
predicting, based on the ontological data, one or more filters applicable to the one or more datasets; and
populating the predicted one or more filters onto the object view.

11. A system comprising:
one or more physical processors; and
a memory storing instructions that, when executed by the one or more physical processors, cause the system to perform:
receiving a search request relating to datasets in the data repository, the datasets representing objects;
in response to the search request, generating or resynchronizing a searchable database from the one or more datasets in the data repository based on ontological data;
generating, in response to generating or resynchronizing of the searchable database, an object view of at least a portion of the datasets corresponding to the search request, the object view being generated based on the ontological data, the ontological data defining any one or more joins between the datasets, an order of presentation of properties corresponding to the objects, any abbreviations of any of the properties, a type of chart, graph, histogram, table, or type of view to present the objects, or a display prominence of the objects, wherein the object view is displayed on a same interface as a feeds tab, the feeds tab indicative of any saved searches that continuously or periodically refresh;
receiving a customised object view for an object of the objects, wherein the customised object view has a difference compared to the object view;
receiving any change in the ontological data of the objects;
determining whether the customised object view is compatible with the any change; and
selectively presenting, using the customised object view, the object according to the any change based on the determination of whether the customised object view is compatible with the any change.

12. The system of claim 11 , further the ontological data comprises the display prominence of the objects and an order in which each of the objects is rendered.

13. The system of claim 12 , wherein the determining of the display prominence is based on a fraction of column or row values that contain unique values.

14. The system of claim 11 , wherein the instructions that, when executed by the one or more physical processors, further cause the system to perform:
displaying the object view at a first device;
transmitting the difference to a second device; and
displaying the customised object view at the second device.

15. The system of claim 14 , wherein the instructions that, when executed by the one or more physical processors, further cause the system to perform:
storing the difference in a storage associated with the first device.

16. The system of claim 11 , wherein the instructions that, when executed by the one or more physical processors, further cause the system to perform:
detecting simultaneous attempts to edit the one or more datasets; and
resolving conflicts among the simultaneous attempts using vector clocks.

Assignees

• Palantir Technologies Inc

Inventors

• Spencer-Harper Quentin
• Rahill-Marier Bianca
• Grossman Jack
• Inoue Jim
• Scolnick Myles
• Niemi Richard
• Mcintyre Thomas

Classifications

• G06F16/248

  Presentation of query results · CPC title

• G06F16/24544

  Join order optimisation · CPC title

• G06F16/9024

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

• G06F16/335

  Filtering based on additional data, e.g. user or group profiles (filtering in web context G06F16/9535, G06F16/9536) · CPC title

• G06F16/9038

  Presentation of query results · CPC title