IP Library Granted Patent US 12,072,876
Granted Patent B2
US 12,072,876 · App. 17/664,053 · Granted Aug 27, 2024

Connecting real-time data sets to historical data

Inventors: Ilya Mayorski (Sofia, BG); Ivo Petkov (Sofia, BG); Militsa Arnaudova (Sofia, BG); Kristiyan Yankov (Sofia, BG); Dobromir Ivanov (Sofia, BG)
Assignee: VMware LLC
G06F16/2448G06F16/211G06F16/2457G06F16/248
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 12,072,876
App. No.
17/664,053
Granted
Aug 27, 2024
Kind
B2
Abstract

Examples of generating a result set from a data lake based upon a real-time data set are described. A data lake can be structured across multiple databases or tables that are not necessarily directly linked to one another. A conjunction schema can specify how data can be queried across the data lake. When an incoming real-time data set is obtained, a multi-query can be generated against the data lake by utilizing the conjunction schema.

Claims (40)

1. A method, comprising:

storing, by a management service, historical data in a data store, the historical data associated with a plurality of users and a plurality of devices, wherein the plurality of devices are enrolled as managed devices with the management service;

obtaining, by the management service, an incoming data set associated with a real-time decision;

retrieving, by the management service, a conjunction schema associated with the historical data, the conjunction schema defining a mapping between a plurality of data types associated with the incoming data set to a plurality of data types for the historical data, wherein the conjunction schema maps a relationship between a plurality of data sets in a data lake that are related to one another;

generating, by the management service, a multi-query based upon the conjunction schema specifying the mapping between the data types associated with the incoming data set and the data types for the historical data, the multi-query comprising a first query from a first one of the plurality of data sets of one of the incoming data set or the historical data to obtain a first result, and a second query from a second one of the plurality of data sets of the other of the historical data or incoming data set of which the first one of the plurality of data sets is not a part, to obtain a second result, wherein the second query is constructed using the first result based, at least in part, on the conjunction schema, wherein the conjunction schema specifies how the second query is constructed using the first result;

executing, by the management service, the multi-query; and

generating, by the management service, a result set from the multi-query that specifies one or more results in the historical data that corresponds to the incoming data set.

2. The method of claim 1 , wherein the conjunction schema maps a data type in the incoming data set to a corresponding data type in the historical data.

3. The method of claim 1 , wherein the multi-query comprises a plurality of queries on the historical data that are required to obtain the result set from the historical data.

4. The method of claim 1 , wherein the incoming data set identifies an aspect of a population of devices managed by the management service and the multi-query comprises at least one query mapping the aspect of the population of devices to a particular data type associated with the historical data.

5. The method of claim 1 , wherein the incoming data set identifies an aspect of a user associated with the management service and the multi-query comprises at least one query mapping the aspect of the user to a particular data type associated with the historical data.

6. The method of claim 1 , wherein generating the result set further comprises generating a cartesian product data set that represents one or more items from the historical data that matches one or more data types associated with the incoming data set.

7. The method of claim 6 , wherein the cartesian product set is generated in response to the multi-query generating a plurality of results from the historical data that match a plurality of data types associated with the incoming data sets.

8. A non-transitory computer-readable medium embodying instructions executable by at least one computing device, the instructions, when executed, causing the at least one computing device to at least:

store, by a management service, historical data in a data store, the historical data associated with a plurality of users and a plurality of devices, wherein the plurality of devices are enrolled as managed devices with the management service;

obtain, by the management service, an incoming data set associated with a real-time decision;

retrieve, by the management service, a conjunction schema associated with the historical data, the conjunction schema defining a mapping between a plurality of data types associated with the incoming data set to a plurality of data types for the historical data, wherein the conjunction schema maps a relationship between a plurality of data sets in a data lake that are related to one another;

generate, by the management service, a multi-query based upon the conjunction schema specifying the mapping between the data types associated with the incoming data set and the data types for the historical data, the multi-query comprising a first query from a first one of the plurality of data sets of one of the incoming data set or historical data to obtain a first result, and a second query from a second one of the plurality of data sets of the other of the historical data or incoming data set of which the first one of the plurality of data sets is not a part, to obtain a second result, wherein the second query is constructed using the first result based, at least in part, on the conjunction schema, wherein the conjunction schema specifies how the second query is constructed using the first result;

execute, by the management service, the multi-query; and

generate, by the management service, a result set from the multi-query that specifies one or more results in the historical data that corresponds to the incoming data set.

9. The non-transitory computer-readable medium of claim 8 , wherein the conjunction schema maps a data type in the incoming data set to a corresponding data type in the historical data.

10. The non-transitory computer-readable medium of claim 8 , wherein the multi-query comprises a plurality of queries on the historical data that are required to obtain the result set from the historical data.

11. The non-transitory computer-readable medium of claim 8 , wherein the incoming data set identifies an aspect of a population of devices managed by the management service and the multi-query comprises at least one query mapping the aspect of the population of devices to a particular data type associated with the historical data.

12. The non-transitory computer-readable medium of claim 8 , wherein the incoming data set identifies an aspect of a user associated with the management service and the multi-query comprises at least one query mapping the aspect of the user to a particular data type associated with the historical data.

13. The non-transitory computer-readable medium of claim 8 , wherein generating the result set further comprises generating a cartesian product data set that represents one or more items from the historical data that matches one or more data types associated with the incoming data set.

14. The non-transitory computer-readable medium of claim 13 , wherein the cartesian product set is generated in response to the multi-query generating a plurality of results from the historical data that match a plurality of data types associated with the incoming data sets.

15. A system, comprising:

at least one computing device comprising a hardware processor; and

instructions accessible by the hardware processor of the at least one computing device, wherein the instructions are executed causing the at least one computing device to at least:

store, by a management service, historical data in a data store, the historical data associated with a plurality of users and a plurality of devices, wherein the plurality of devices are enrolled as managed devices with the management service;

obtain, by the management service, an incoming data set associated with a real-time decision;

retrieve, by the management service, a conjunction schema associated with the historical data, the conjunction schema defining a mapping between a plurality of data types associated with the incoming data set to a plurality of data types for the historical data, wherein the conjunction schema maps a relationship between a plurality of data sets in a data lake that are related to one another;

generate, by the management service, a multi-query based upon the conjunction schema specifying the mapping between the data types associated with the incoming data set and the data types for the historical data, the multi-query comprising a first query from a first one of the plurality of data sets to obtain a first result associated with the incoming data set and a second query from a second one of the plurality of data sets associated with the historical data to obtain a second result, wherein the second query is constructed using the first result based, at least in part, on the conjunction schema, wherein the conjunction schema specifies how the second query is constructed using the first result;

execute, by the management service, the multi-query; and

generate, by the management service, a result set from the multi-query that specifies one or more results in the historical data that corresponds to the incoming data set.

16. The system of claim 15 , wherein the conjunction schema maps a data type in the incoming data set to a corresponding data type in the historical data.

17. The system of claim 15 , wherein the multi-query comprises a plurality of queries on the historical data that are required to obtain the result set from the historical data.

18. The system of claim 15 , wherein the incoming data set identifies an aspect of a population of devices managed by the management service and the multi-query comprises at least one query mapping the aspect of the population of devices to a particular data type associated with the historical data.

19. The system of claim 15 , wherein the incoming data set identifies an aspect of a user associated with the management service and the multi-query comprises at least one query mapping the aspect of the user to a particular data type associated with the historical data.

20. The system of claim 15 , wherein generating the result set further comprises generating a cartesian product data set that represents one or more items from the historical data that matches one or more data types associated with the incoming data set.

Assignments (4)
PATENT ASSIGNMENT Recorded Aug 5, 2024
From: VMWARE LLC
To: OMNISSA, LLC
Reel/Frame 068327/0365 →
SECURITY INTEREST Recorded Jul 3, 2024
From: OMNISSA, LLC
To: UBS AG, STAMFORD BRANCH
Reel/Frame 068118/0004 →
CHANGE OF NAME Recorded Apr 15, 2024
From: VMWARE, INC.
To: VMWARE LLC
Reel/Frame 067102/0242 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded May 19, 2022
From: MAYORSKI, ILYA; PETKOV, IVO; ARNAUDOVA, MILITSA; YANKOV, KRISTIYAN; IVANOV, DOBROMIR
To: VMWARE, INC.
Reel/Frame 059954/0345 →