Systems and methods for creating and managing a data integration workspace containing automatically updated data models

Patent metadata

Field	Value
Publication number	US-10956508-B2
Application number	US-201815956600-A
Country	US
Kind code	B2
Filing date	Apr 18, 2018
Priority date	Nov 10, 2017
Publication date	Mar 23, 2021
Grant date	Mar 23, 2021

Abstract

Systems and methods are provided for creating and managing a data integration workspace. The workspace may comprise one or more views of data (or datasets) stored in or accessible by the system. Models may be generated and updated based on the plurality of datasets and presented via a graphical user interface. Feedback received via a graphical user interface presenting a model may be used to annotate an underlying dataset associated with the model. Responsive to a modification of the underlying dataset or the rules for using the underlying dataset to generate the model, other related datasets and/or models may be automatically updated accordingly. Templates associated with one or more types of users may be defined. Each template may comprise one or more specific models related to a specific type of user.

First claim

What is claimed is:

1. A system for creating and managing a data integration workspace, the system comprising:
one or more processors; and
memory storing instructions that, when executed by the one or more processors, cause the system to:
present a first model and a second model via one or more graphical user interfaces, wherein the first model and the second model are based on a first dataset, the first model comprising a mathematical model and the second model comprising any of a static report and an interactive report;
receive feedback via a first graphical user interface presenting the first model, wherein the feedback is related to the first model;
obtain first connection information indicating an association between the first dataset and the first model;
annotate at least a first column of the first dataset based on the feedback and the first connection information;

obtain second connection information indicating an association between the first dataset and the second model;
modify one or more features of the first dataset based on the annotation; and
responsive to the modification of the one or more features of the first dataset, cause at least the first model and the second model to be automatically updated, wherein the second model is automatically updated responsive to the modification of the one or more features of the first dataset based on the second connection information;
receive an indication of a subset of models;
generate a template based on the subset of the models, the template being associated with a first type of user;
obtain information indicating that a first user is of the first type;
cause the template to be associated with the first user based on the obtained information; and
cause the subset of the models to be accessible by the first user based on the association between the first user and the template.

2. The system of claim 1 , wherein the system is further caused to:
identify a connection between the first dataset and a second dataset; and
cause a visual representation of the connection to be presented via the first graphical user interface.

3. The system of claim 2 , wherein the connection comprises a link between a first column of the first dataset and a second column of the second dataset.

4. The system of claim 1 , wherein the system is further caused to:
store an access control list, the access control list defining at least a first security permission associated with the first user;
receive, via the first graphical user interface, a request to access a third dataset by the first user; and
restrict access to the third dataset by the first user based on the first security permission, wherein the first security permission indicates that the third dataset is inaccessible by a second user.

5. The system of claim 1 , wherein to modify the one or more features of the first dataset based on the annotation, the system is further caused to:
cause the first dataset and the first model to be displayed simultaneously via a graphical user interface in a split screen view, the split screen view including an indication of the annotation;
receive input via the graphical user interface, the input indicating one or more modifications to the first dataset; and
cause the first dataset to be automatically updated in the split screen view based on the input.

6. The system of claim 1 , wherein the system is further caused to:
store a first version of a model, wherein the first version includes one or more modifications to an original version of the model by the first user;
store a second version of the model, wherein the second version includes one or more modifications to the original version of the model by a second user; and
cause the original version to be replaced by the first version or the second version in response to an input by the first user or the second user.

7. The system of claim 1 , wherein the system is further caused to:
receive an indication that the first user is scheduled to work on a model based on at least the first dataset;
obtain permission information associated with the first user, wherein the permission information indicates that the first user is restricted from accessing the first dataset;
anonymize the first dataset based on the indication that the first user is restricted from accessing the first dataset; and
cause the anonymized first dataset to be distributed to the first user.

8. A method being implemented by a computing system having one or more processors and non-transitory storage media storing machine-readable instructions that, when executed by the one or more processors, cause the computing system to perform the method, the method comprising:
presenting a first model and a second model via one or more graphical user interfaces, wherein the first model and the second model are based on a first dataset, the first model comprising a mathematical model and the second model comprising any of a static report and an interactive report;
receiving feedback via a first graphical user interface presenting the first model, wherein the feedback is related to the first model;
obtaining first connection information indicating an association between the first dataset and the first model;
annotating at least a first column of the first dataset based on the feedback and the first connection information;
obtaining second connection information indicating an association between the first dataset and the second model;
modifying one or more features of the first dataset based on the annotation; and
responsive to the modification of the one or more features of the first dataset, causing at least the first model and the second model to be automatically updated, wherein the second model is automatically updated responsive to the modification of the one or more features of the first dataset based on the second connection information;
receiving an indication of a subset of models;
generating a template based on the subset of the models, the template being associated with a first type of user;
obtaining information indicating that a first user is of the first type;
causing the template to be associated with the first user based on the obtained information; and
causing the subset of the models to be accessible by the first user based on the association between the first user and the template.

9. The method of claim 8 , the method further comprising:
identifying a connection between the first dataset and a second dataset; and
causing a visual representation of the connection to be presented via the first graphical user interface.

10. The method of claim 9 , wherein the connection comprises a link between a first column of the first dataset and a second column of the second dataset.

11. The method of claim 8 , the method further comprising:
storing an access control list, the access control list defining at least a first security permission associated with the first user;
receiving, via the first graphical user interface, a request to access a third dataset by the first user; and
restricting access to the third dataset by the first user based on the first security permission, wherein the first security permission indicates that the third dataset is inaccessible by a second user.

12. The method of claim 8 , wherein modifying the one or more features of the first dataset based on the annotation comprises:
causing the first dataset and the first model to be displayed simultaneously via a graphical user interface in a split screen view, the split screen view including an indication of the annotation;
receiving input via the graphical user interface, the input indicating one or more mod

Assignees

• Palantir Technologies Inc

Inventors

• Maclean Matthew
• Borochoff Adam
• Rafidi Joseph
• Jenny Matthew
• Menon Parvathy
• Rowe Ryan

Classifications

• G06T11/26

  Drawing of charts or graphs · CPC title

• G06F16/21

  Design, administration or maintenance of databases · CPC title

• G06F16/904 Primary

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

• G06F3/0484

  for the control of specific functions or operations, e.g. selecting or manipulating an object, an image or a displayed text element, setting a parameter value or selecting a range · CPC title

• G06F16/23

  Updating · CPC title