# US 2019/0377720 A1 · Methods and systems for data management and analysis

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2019/0377720 A1
- Document ID: US20190377720A1
- Status: Published application
- Kind: A1
- Application number: 16/548,524
- Filed: 2019-08-22
- Published: 2019-12-12
- Earliest claimed: 2013-09-24
- Assignees: Qliktech International AB
- Applicants: Qliktech International AB
- Inventors: Anders Nilsson; Ingemar Carlo; José Dìaz López; Håkan Wolgé; Anders Helmer; Thomas Lindén
- Web page: https://patentgrep.com/patent/US20190377720A1

## CPC

- G06F 16/2272: {Management thereof}
- G06F 16/245: Query processing
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

Provided are methods comprising receiving a query for information from the database, determining particular data element types and data element values that are the subject of the query, instantiating a query data structure containing the data element types and the data element values that are the subject of the query, identifying records within the database that contain one or more data element types and/or data element values that are included in the query data structure, and instantiating a results data structure comprising information relating to the identified records.

## Claims

### Claim 1

A method comprising:
identifying unique data element types in a first database comprising a plurality of records having one or more data element types and one or more data element values;
generating, by a first device, a plurality of initial data structures corresponding to the unique data element types, wherein the plurality of initial data structures comprise representations of unique data element values associated with the corresponding unique data element type;
generating, by the first device, a final data structure based on one or more records of the plurality of records, wherein the final data structure is based upon the data element values included in the one or more records and the data element values represented in the plurality of initial data structures;
storing the final data structure in a portion of the system memory of the first device;
determining first information relating to first data to be retrieved from the final data structure;
determining second information relating to second data to be retrieved from a second database external to the system memory, wherein the second information comprises identifying information relating to the location and specification of the second data; and
joining the second data to the final data structure to generate an updated data state without modifying the first database.

### Claim 2 (depends on 1)

The method of claim 1, wherein generating the final data structure comprises generating binary codes for corresponding unique data elements values.

### Claim 3 (depends on 1)

The method of claim 1, wherein generating the final data structure comprises combining at least two of the plurality initial data structures.

### Claim 4 (depends on 3)

The method of claim 3, wherein combining at least two of the plurality of initial data structures comprises resolving at least one of data element dependency and data element redundancy between the at least two of the plurality of initial data structures.

### Claim 5 (depends on 1)

The method of claim 1, further comprising providing a visualization comprising one or more graphical objects representing the updated data state.

### Claim 6 (depends on 5)

The method of claim 5, wherein the one or more graphical objects display the first data and the second data.

### Claim 7

A method comprising:
recalling a visualization of data into a portion of system memory of a first device, wherein the visualization comprises information relating to a first result data structure, and wherein the visualization comprises one or more graphical objects representing the first result data structure;
determining additional information is required to be retrieved;
determining identifying information for retrieving the additional information;
retrieving, by the first device, the additional information; and
appending, by joining the first result data structure and the second result data structure, the retrieved additional information to the recalled visualization to represent, by the one or more graphical objects, both the first results data structure and a second results data structure.

### Claim 8 (depends on 7)

The method of claim 7, wherein the first result data structure comprises a multidimensional hypercube data structure.

### Claim 9 (depends on 7)

The method of claim 7, wherein the additional information is retrieved from storage external to the system memory using the identifying information.

### Claim 10 (depends on 7)

The method of claim 7, wherein the additional information comprises the second results data structure.

### Claim 11

A method comprising:
receiving a query for information from a database;
identifying data element types relevant to the query and data element values relevant to the query;
generating a query structure based on the identified data element types and data element values;
identifying data in the database based on the query structure; and
generating a results structure containing information relating to the identified data, wherein the query structure and the results structure represent a data state;
selectively capturing one or more data states based upon the query structure and results structure, wherein the one or more data states reflect a current data state, wherein selectively capturing comprises storing, for later retrieval, a dynamic snapshot comprising 1) the one or more data states at the time of the capturing and 2) a visualization comprising one or more graphical objects representing the data, and wherein the one or more graphical objects comprise one or more of a graph or a chart, and wherein a user can modify how the data is displayed by the visualization by later interacting with the one or more graphical objects; and
generating a current state structure for the captured one or more data states.

### Claim 12 (depends on 11)

The method of claim 11, further comprising:
selectively displaying a representation of the one or more data states;
selectively capturing the displayed representation of the one or more data states; and
generating a displayed elements structure for the captured displayed representation of the one or more data states.

### Claim 13 (depends on 12)

The method of claim 12, further comprising:
selectively retrieving one or more data states based upon the displayed elements structure.

### Claim 14

A method comprising:
receiving a query for information from a database;
identifying data element types relevant to the query and data element values relevant to the query;
generating a query structure based on the identified data element types and data element values;
identifying data in the database based on the query structure;
generating a results structure containing information relating to the identified data;
selectively capturing one or more first data states based upon the query structure and results structure, wherein the one or more first data states are an indicia of a current data state, wherein selectively capturing comprises storing, for later retrieval, a dynamic snapshot comprising 1) the one or more data states at the time of the capturing and 2) a visualization comprising one or more graphical objects representing the data, and wherein the one or more graphical objects comprise one or more of a graph or a chart, and wherein a user can modify how the data is displayed by the visualization by later interacting with the one or more graphical objects;
selectively displaying one or more second data states of the query structure, the results structure, or a combination thereof;
selectively capturing the displayed second data states along with the first data states that are the indicia of the current state; and
modifying the displayed data states.

### Claim 15 (depends on 14)

The method of claim 14, further comprising selectively capturing the modified displayed data states.

### Claim 16 (depends on 14)

The method of claim 14, further comprising selectively discarding the modified displayed data states.

### Claim 17

A method comprising:
reading a plurality of records stored in a database comprising one or more database structures which collectively contain the plurality of records, wherein each record of the plurality of records comprises at least two data element types, wherein at least one of the data element types comprises a different data element value from the data element value for the corresponding data element type in at least one other record of the plurality of records;
instantiating an initial data structure for each unique data element type within the plurality of records;
creating an entry in the initial data structure for each data element type for each unique data element value within that data element type;
selecting one or more database structures within the database;
instantiating a final data structure for the selected database structures in which the data element value for each data element type reflects the entry made in the initial data structures for that data element value;
receiving a query for information from the database;
instantiating and storing in memory a query data structure containing the database element types, the database element values and the functions that are the subject of the query, using the entries stored in the initial data structures for the data element values of the query;
identifying data within the database that contain one or more database element types and/or database element values that are included in the query data structure;
instantiating and storing in memory a results data structure containing information relating to the identified data including the database element types and database element values of the identified one or more records;
selectively capturing one or more data states of the query data structure and results data structure, wherein the one or more data states reflect the current data state, wherein selectively capturing comprises storing, for later retrieval, a dynamic snapshot comprising 1) the one or more data states at the time of the capturing and 2) a visualization comprising one or more graphical objects representing the data, and wherein the one or more graphical objects comprise one or more of a graph or a chart, and wherein a user can modify how the data is displayed by the visualization by later interacting with the one or more graphical objects; and
instantiating a current state data structure for the captured one or more data states and saving the captured one or more data states in the current state data structure.

### Claim 18 (depends on 17)

The method of claim 17, further comprising:
selectively displaying one or more data states of the query data structure and results data structure;
selectively capturing the displayed one or more data states; and
instantiating a displayed elements data structure, wherein the captured displayed one or more data states are saved in the displayed elements data structure.

### Claim 19 (depends on 18)

The method of claim 18, further comprising selectively retrieving one or more elements from the displayed elements data structure.

### Claim 20 (depends on 19)

The method of claim 19, further comprising selectively capturing the modified displayed one or more second data states.
