System and method for querying a data repository

Patent metadata

Field	Value
Publication number	US-11544325-B2
Application number	US-201816152005-A
Country	US
Kind code	B2
Filing date	Oct 4, 2018
Priority date	Oct 5, 2017
Publication date	Jan 3, 2023
Grant date	Jan 3, 2023

Abstract

A method is disclosed, as well as systems, performed by one or more processors, for interacting with data in a data repository. The method comprises receiving, in a data catalogue environment, a search request relating to one or more items in the data repository and determining an object type associated with the one or more items. Other operations comprise loading an object template in dependence on the determined object type, populating the template with data from the data repository in dependence on the search request to create an object view, and displaying the object view within the data catalogue environment. The data repository comprises a plurality of joined datasets, and wherein the object view comprises one or more links to items in a joined dataset.

First claim

What is claimed is:

1. A method, performed by one or more processors, of interacting with data in a data repository, the method comprising:
receiving, in a data catalogue environment, a search request relating to a data object in a data repository storing a plurality of data objects, wherein the data objects in the data repository are associated with data object types;
determining a data object type associated with the data object by reference to properties associated with the data object and a data ontology;
determining a data object template in dependence on the determined data object type, wherein:
the data object template comprises a plurality of display elements for a graphical user interface, and
the data object template comprises definitions of one or more joins between datasets in the data repository to facilitate identification of additional data items for the data object;

automatically populating one or more display elements of the data object template with data items associated with the data object from a first dataset in the data repository in dependence on the search request to create a data object view graphical user interface;
determining whether the populated data object template includes one or more unpopulated display elements that can be populated with one or more additional data items;
in response to determining that the one or more unpopulated display elements of the populated data object template can be populated with one or more additional data items:
identifying, based on the definitions of the one or more joins between datasets, a second dataset in the data repository that is joined to the first dataset and that includes the one or more additional data items corresponding to the one or more unpopulated display elements;
automatically retrieving the one or more additional data items from the second dataset in the data repository based on the definitions of the one or more joins in the populated data object template; and
automatically populating the one or more unpopulated display elements of the populated data object template with the retrieved additional data items to update the data object view graphical user interface; and

displaying the data object view graphical user interface of the data object,
wherein the data object view graphical user interface comprises one or more selectable links to linked data objects as defined by the data object template.

2. The method of claim 1 , further comprising:
receiving a user input selecting a link from the one or more selectable links;
determining a data object type of a linked data object associated with the selected link;
determining if the data object type of the linked data object associated with the selected link is compatible with the current data object view graphical user interface; and
in the event of a positive determination, repopulating the data object template with data in dependence on the linked data object.

3. The method of claim 2 , further comprising:
in the event of a negative determination:
retrieving a further data object template in dependence on the object type of the linked data object, wherein the data object type of the linked data object is compatible with the further data object template;
populating the further data object template in dependence on the linked data object to generate a linked data object view graphical user interface; and
displaying the linked data object view graphical user interface.

4. The method of claim 3 , wherein determining the object type comprises:
determining one or more properties of the data object.

5. The method of claim 4 , wherein the one or more properties of the data object comprises: a data format; a data use history; a column and/or row title; and/or metadata associated with the data object.

6. The method of claim 5 , wherein determining a data object template in dependence on the determined data object type comprises:
determining if a data object template for the determined data object type is stored in the system; and
in the event of a negative determination, loading a default data object template.

7. The method of claim 6 , wherein the one or more joins between datasets in the data repository are inferred from properties of the datasets.

8. The method of claim 7 , wherein the data repository comprises a plurality of tables.

9. The method of claim 8 , further comprising constructing a virtual table from the plurality of tables in dependence on the search request and the determined data object type.

10. The method of claim 9 , wherein the search request comprises one or more filters.

11. A system comprising:
a data repository comprising a plurality of data objects, wherein the data objects in the data repository are associated with data object types;
wherein the system is configured to:
receive, in a data catalogue environment, a search request relating to a data object in the data repository;
determine a data object type associated with the data object by reference to properties associated with the data object and a data ontology;
determine a data object template based on the determined data object type, wherein:
the data object template comprises a plurality of display elements for a graphical user interface, and
the data object template comprises definitions of one or more joins between datasets in the data repository to facilitate identification of additional data items for the data object;

automatically populate one or more display elements of the data object template with data items associated with the data object from a first dataset in the data repository in dependence on the search request to create a data object view graphical user interface;
determine whether the populated data object template includes one or more unpopulated display elements that can be populated with one or more additional data items;
in response to determining that the one or more unpopulated display elements of the populated data object template can be populated with one or more additional data items:
identify, based on the definitions of the one or more joins between datasets, a second dataset in the data repository that is joined to the first dataset and that includes the one or more additional data items corresponding to the one or more unpopulated display elements;
automatically retrieve the one or more additional data items from the second dataset in the data repository based on the definitions of the one or more joins in the populated data object template; and
automatically populate the one or more unpopulated display elements of the populated data object template with the retrieved additional data items to update the data object view graphical user interface; and

display the data object view graphical user interface of the data object,

wherein the data object view graphical user interface comprises one or more selectable links to linked data object as defined by the data object template.

12. A non-transitory computer readable medium having computer readable code stored thereon, the computer readable code, when executed by at least one processor, causing performance of operations comprising:
receiving, in a data catalogue environment, a search request relating to a data object in a data repository storing a plurality of data objects, wherein the data objects in the data repository are associated with data object types;
determining a data object type associated with the data object by reference to properties associated with the data object and a data ontology;
determining a data object template based on the determined data object type, wherein:
the data object template comprises a plurality of displa

Assignees

• Palantir Technologies Inc

Inventors

• Poor Tony
• Mingione Alessandro
• Chen Roger
• Wu Richard
• Brueckner Sebastian

Classifications

• G06F16/2456

  Join operations · CPC title

• G06F16/9038

  Presentation of query results · CPC title

• G06F16/958

  Organisation or management of web site content, e.g. publishing, maintaining pages or automatic linking · CPC title

• G06F16/904 Primary

  Browsing; Visualisation therefor (for navigating the web G06F16/954; browsing optimisation for the web G06F16/957) · CPC title

• G06F16/90335 Primary

  Query processing · CPC title