Unified data model and interface for databases storing disparate types of data

Patent metadata

Field	Value
Publication number	US-12450208-B2
Application number	US-202217955472-A
Country	US
Kind code	B2
Filing date	Sep 28, 2022
Priority date	May 8, 2018
Publication date	Oct 21, 2025
Grant date	Oct 21, 2025

Abstract

Systems, methods, and non-transitory computer readable media may be configured to access first database and a second database. The first database may be structured for a first data type, and may include a first data of the first data type. The second database may be structured for a second data type different from the first datatype, and may include a second data of the second data type. The second data may be associated with the first data. A first information request relating to the first data and a second information request relating to the second data may be received. A first response to the first information request may be determined based on the second data. A second response to the second information request may be determined based on the first data. An interface, through which the first response or the second response is accessible, may be provided.

First claim

The invention claimed is:

1. A system comprising:
one or more processors; and
a memory storing instructions that, when executed by the one or more processors, cause the system to perform:
storing first data of a first data type in a first database that is structured for the first data type, the first data representing a plurality of entities, the first database being associated with a first ontology;
storing second data of a second data type different from the first data type in second databases that are structured for the second data type, wherein the second data comprises spatial and temporal attributes of the plurality of entities, and a second database is associated with a second ontology different from the first ontology;
obtaining updated second data from data sources;
modifying the second data in the second databases based on the updated second data;
weighting the second data, the updated second data or the modified second data based on accuracy levels of the data sources from which the second data or the updated second data is obtained;
in response to a query that loads first entity data of the first data, wherein the first entity data comprises a first subset of the first data relevant to the query, automatically loading second entity data of the second data, wherein the second entity data comprises a second subset of the second data, the updated second data, or the modified second data that corresponds to the first entity data;
interpolating the second entity data based on the weighting of the second data, the updated second data or the modified second data;
in response to interpolating the second entity data; receiving, from an object-oriented application, connections between two or more of the plurality of entities;
inputting the connections into a machine learning tool;
determining, by the machine learning tool according to the connections and according to generated ontological events with probabilities, additional connections among the plurality of entities based on the interpolated second entity data, wherein the generated ontological events enrich the first data and comprise common characteristics or relationships among the entities and are according to the second ontology; and
providing a merged view displaying the connections and the additional connections among the plurality of entities.

2. The system of claim 1 , wherein the object-oriented application comprises a web application; and the providing of the merged view comprises indicating respective directionalities of the connections and the additional connections and indicating respective temporalities of the connections and the additional connections.

3. The system of claim 1 , wherein the determining of the additional connections among the plurality of entities comprises:
detecting a potential connection between a first and a second entity based on the connections between the two or more of the plurality of entities;
displaying the potential connection; and
in response to receiving a confirmation or a rejection of the potential connection, updating the machine learning tool.

4. The system of claim 1 , wherein the determining of the additional connections among the plurality of entities comprises:
updating one of the connections based on the additional connections, wherein the updating comprises removing or changing at least a subset of the connections.

5. The system of claim 1 , wherein
the modified second data is being continuously generated and stored in the second database, and the instructions that, when executed by the one or more processors, cause the system to perform:
updating the machine learning tool as the modified second data becomes available.

6. The system of claim 1 , the instructions that, when executed by the one or more processors, cause the system to perform:
storing the connections into the first database.

7. The system of claim 1 , wherein the merged view displays the connections and the additional connections using different types of lines.

8. The system of claim 1 , wherein a first rate of generation of the first data is lower than a second rate of generation of the second data.

9. The system of claim 8 , wherein the instructions that, when executed by the one or more processors, cause the system to perform:
storing the interpolated second entity data in the second database as part of the second data.

10. The system of claim 1 , wherein the instructions that, when executed by the one or more processors, cause the system to perform:
performing data projection based on the second data to generate new spatial and temporal attribute data;
the determination of the additional connections is based on
the newly generated spatial and temporal attribute data and the second data.

11. The system of claim 1 , wherein the providing of the merged view comprises:
using a first icon type, displaying first location information of an entity within the plurality of entities from a first source;
using a second icon type, displaying second location information of the entity from a second source; and using a third icon type, displaying third location information of the entity based on interpolation of the first location information and the second location information.

12. A method implemented by one or more hardware processors, the method comprising:
storing first data of a first data type in a first database that is structured for the first data type, the first data representing a plurality of entities, the first database being associated with a first ontology;
storing second data of a second data type different from the first data type in second databases that are structured for the second data type, wherein the second data comprises spatial and temporal attributes of the plurality of entities, and a second database is associated with a second ontology different from the first ontology;
obtaining updated second data from data sources;
modifying the second data in the second databases based on the updated second data;
weighting the second data, the updated second data or the modified second data based on accuracy levels of the data sources from which the second data or the updated second data is obtained;
in response to a query that loads first entity data of the first data, wherein the first entity data comprises a first subset of the first data relevant to the query, automatically loading second entity data of the second data, wherein the second entity data comprises a second subset of the second data, the updated second data, or the modified second data that corresponds to the first entity data;
interpolating the second entity data based on the weighting of the second data, the updated second data or the modified second data;
in response to interpolating the second entity data; receiving, from an object-oriented application, connections between two or more of the plurality of entities;
inputting the connections into a machine learning tool;
determining, by the machine learning tool according to the connections and according to generated ontological events with probabilities, additional connections among the plurality of entities based on the interpolated second entity data, wherein the generated ontological events enrich the first data and comprise common characteristics or relationships among the entities and are according to the second ontology; and
providing a merged view displaying the connections and the additional connections among the plurality of entities.

13. The method of claim 12 , wherein the object-oriented application comprises a web application; and the providing of the merged view comprises indicating respective d

Assignees

• Palantir Technologies Inc

Inventors

• Wilczynski Peter
• Hao Sharon
• Deuschle Will
• Zeidman Ernest

Classifications

• G06F16/248

  Presentation of query results · CPC title

• G06F16/288

  Entity relationship models · CPC title

• G06F16/212 Primary

  with details for data modelling support · CPC title

• G06F16/256 Primary

  in federated or virtual databases · CPC title