IP Library Granted Patent US 12,248,469
Granted Patent B2
US 12,248,469 · App. 18/175,917 · Granted Mar 11, 2025

Methods and systems for undetermined query analytics

Inventors: Akash Patel (Ottawa, CA); Steven Pressland (Kent, GB); Mohsen Rais-Ghasem (Ottawa, CA)
Assignee: QlikTech International AB
G06F16/24534
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,248,469
App. No.
18/175,917
Granted
Mar 11, 2025
Kind
B2
Abstract

Set analysis may be used to determine the best data analysis model(s) (e.g., data charts, data tables, data graphs, data maps, graphical objects, key performance indicators (KPIs), etc.) for representing the results of an undetermined query (e.g., an imprecise query, an undefined query, an incomplete query, a partially expressed query, a portioned query, etc.).

Claims (40)

1. A method comprising:

determining, based on undetermined query information, one or more data constraints and a plurality of data analysis models;

determining, based on the one or more data constraints, a first aggregated dataset and a second aggregated dataset, wherein the first aggregated dataset comprises in-memory data and the second aggregated dataset comprises externally-sourced data, and wherein the in-memory data at least partially differs from the externally-sourced data; and

causing, based on the first aggregated dataset and the second aggregated dataset, a first data analysis model of the plurality of data analysis models to be output, wherein one or more portions of the second aggregated dataset correspond to one or more visual elements of the first data analysis model, wherein causing the first data analysis model to be output comprises: determining an amount of correspondence between elements of each data analysis model of the plurality of data analysis models and the one or more portions of the second aggregated dataset.

2. The method of claim 1 , wherein at least one of:

the in-memory data is associated with at least one user interface selection;

the externally-sourced data is associated with an external engine; or

the externally-sourced data is associated with a public domain.

3. The non-transitory computer-readable medium of claim 1 , wherein at least one of:

the in-memory data is associated with at least one user interface selection;

the externally-sourced data is associated with an external engine; or

the externally-sourced data is associated with a public domain.

4. The method of claim 1 , wherein the undetermined query information comprises one or more of imprecise query information, undefined query information, incomplete query information, partially expressed query information, or portioned query information.

5. The method of claim 1 , wherein the one or more data constraints comprise one or more temporal data constraints, logical data constraints, or data-type constraints.

6. The method of claim 1 , wherein determining the one or more data constraints comprises mapping one or more textual elements of the undetermined query information to the one or more data constraints.

7. The method of claim 1 , wherein the plurality of data analysis models comprises one or more of: a data chart, a data table, a data graph, a data map, or key performance indicators (KPIs).

8. The method of claim 1 , wherein determining the first aggregated dataset and the second aggregated dataset comprises applying the one or more data constraints to an aggregation function.

9. The method of claim 1 , wherein the second aggregated dataset comprises one or more portions of data that correspond to one or more elements of the first data analysis model.

10. A non-transitory computer-readable medium storing processor-executable instructions that, when executed by at least one processor, cause the at least one processor to:

determine, based on undetermined query information, one or more data constraints and a plurality of data analysis models;

determine, based on the one or more data constraints, a first aggregated dataset and a second aggregated dataset, wherein the first aggregated dataset comprises in-memory data and the second aggregated dataset comprises externally-sourced data, and wherein the in-memory data at least partially differs from the externally-sourced data; and

cause, based on the first aggregated dataset and the second aggregated dataset, a first data analysis model of the plurality of data analysis models to be output, wherein one or more portions of the second aggregated dataset correspond to one or more visual elements of the first data analysis model, wherein the processor-executable instructions that cause the at least one processor to cause the first data analysis model to be output further cause the at least one processor to determine an amount of correspondence between elements of each data analysis model of the plurality of data analysis models and the one or more portions of the second aggregated dataset.

11. The non-transitory computer-readable medium of claim 10 , wherein the undetermined query information comprises one or more of imprecise query information, undefined query information, incomplete query information, partially expressed query information, or portioned query information.

12. The non-transitory computer-readable medium of claim 10 , wherein the one or more data constraints comprise one or more temporal data constraints, logical data constraints, or data-type constraints.

13. The non-transitory computer-readable medium of claim 10 , wherein the processor-executable instructions that cause the at least one processor to determine the one or more data constraints further cause the at least one processor to map one or more textual elements of the undetermined query information to the one or more data constraints.

14. The non-transitory computer-readable medium of claim 10 , wherein the plurality of data analysis models comprises one or more of: a data chart, a data table, a data graph, a data map, or key performance indicators (KPIs).

15. The non-transitory computer-readable medium of claim 10 , wherein the processor-executable instructions that cause the at least one processor to determine the first aggregated dataset and the second aggregated dataset further cause the at least one processor to apply the one or more data constraints to an aggregation function.

16. The non-transitory computer-readable medium of claim 10 , wherein the second aggregated dataset comprises one or more portions of data that correspond to one or more elements of the first data analysis model.

17. An apparatus comprising:

one or more processors; and

memory storing processor-executable instructions that, when executed by the one or more processors, cause the apparatus to:

determine, based on undetermined query information, one or more data constraints and a plurality of data analysis models;

determine, based on the one or more data constraints, a first aggregated dataset and a second aggregated dataset, wherein the first aggregated dataset comprises in-memory data and the second aggregated dataset comprises externally-sourced data, and wherein the in-memory data at least partially differs from the externally-sourced data; and

cause, based on the first aggregated dataset and the second aggregated dataset, a first data analysis model of the plurality of data analysis models to be output, wherein one or more portions of the second aggregated dataset correspond to one or more visual elements of the first data analysis model, wherein the processor-executable instructions that cause the one or more processors to cause the apparatus to cause the first data analysis model to be output further cause the apparatus to determine an amount of correspondence between elements of each data analysis model of the plurality of data analysis models and the one or more portions of the second aggregated dataset.

18. The apparatus of claim 17 , wherein at least one of:

the in-memory data is associated with at least one user interface selection;

the externally-sourced data is associated with an external engine; or

the externally-sourced data is associated with a public domain.

19. The apparatus of claim 17 , wherein the processor-executable instructions that cause the apparatus to determine the one or more data constraints further cause the apparatus to map one or more textual elements of the undetermined query information to the one or more data constraints.

20. The apparatus of claim 17 , wherein the processor-executable instructions that cause the apparatus to determine the first aggregated dataset and the second aggregated dataset further cause the apparatus to apply the one or more data constraints to an aggregation function.

Assignments (3)
SECOND LIEN INTELLECTUAL PROPERTY SECURITY AGREEMENT Recorded May 8, 2025
From: QLIKTECH INTERNATIONAL AB
To: MORGAN STANLEY SENIOR FUNDING, INC., AS COLLATERAL AGENT
Reel/Frame 071224/0394 →
SECURITY INTEREST Recorded Apr 18, 2024
From: QLIKTECH INTERNATIONAL AB
To: MORGAN STANLEY SENIOR FUNDING, INC., AS COLLATERAL AGENT
Reel/Frame 067168/0117 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Apr 21, 2023
From: PATEL, AKASH; PRESSLAND, STEVEN; RAIS-GHASEM, MOHSEN
To: QLIKTECH INTERNATIONAL AB
Reel/Frame 063406/0794 →
Continuity (2)
Continuation 17157591 · Jan 25, 2021
Related Publication 20230315728A1 · Oct 5, 2023
References Cited (11)
US 20020099692A1 · Shah et al. · 2002 [cited by applicant]
US 20070094236A1 · Otter · 2007 [cited by examiner]
US 20100274756A1 · Inokuchi et al. · 2010 [cited by applicant]
US 20120130940A1 · Gattani et al. · 2012 [cited by applicant]
US 20130262279A1 · Finley · 2013 [cited by examiner]
US 20180144064A1 · Krasadakis · 2018 [cited by applicant]
US 20190102412A1 · MacNicol · 2019 [cited by examiner]
US 20210326339A1 · Sherman · 2021 [cited by examiner]
US 20220035802A1 · Penzo et al. · 2022 [cited by applicant]
WO 0072201A1 · 2000 [cited by applicant]
European Search Report mailed on Jun. 21, 2022 by European Patent Office for EP Application No. 22153253.4 (Applicant—QlikTech International AB) (7 Pages). [cited by applicant]