System and Method for Performing Blended Data Operations

Patent metadata

Field	Value
Publication number	US-2017193058-A1
Application number	US-201514984528-A
Country	US
Kind code	A1
Filing date	Dec 30, 2015
Priority date	Dec 30, 2015
Publication date	Jul 6, 2017
Grant date	—

Abstract

Embodiments relate to techniques for performing data blending operations across multiple different data sets comprising data structures with columns and rows. The data sets may be classified and displayed in a visualization (i.e., chart) in a client interface. Columns and rows from the blended data sets may be mapped together (i.e., linked). Updates to the visualization, including adding elements from the data sets, may trigger a data blending process on the backend server in communication with a database. The server may blend the specified data by generating a runtime artifact representing a calculation graph for the blend operation and query the database to retrieve a resulting data set. The data blending operation may comprise collapsing dimensions of a primary data set with linked dimensions of a secondary data sets into a blended column and aggregating values of measures in rows of the blended column of the resulting data structure.

First claim

What is claimed is:

1 . A method comprising:
receiving a plurality of data sets to be displayed in a visualization in a client graphical interface at a client system, wherein each of the plurality of data sets comprises a data structure having one or more columns and one or more rows, and wherein columns of each data set are classified as either a dimension or a measure; receiving input at the client interface selecting a dimension from a first data set of the plurality of data sets to be displayed in the visualization, wherein the first data set selected comprises a primary data set; receiving input at the client interface selecting a dimension from one or more secondary data sets of the plurality of data sets to be displayed in the visualization; receiving input at the client interface linking the selected dimension of the primary data set with the selected dimensions of the one or more secondary data sets; generating a client query to perform a data blending operation on the dimensions of each of the one or more secondary data sets that are linked with the dimension of the primary data set; and communicating the client query to a server in communication with a database, wherein the server is configured to perform the data blending operation on the selected dimension of the primary data set and the selected dimensions of the one or more secondary data sets in response to the client query, and wherein the data blending operation comprises generating a runtime artifact representing a calculation graph for the data blending operation and querying the database to retrieve a resulting data set.

2 . The method of claim 1 wherein the data blending operation comprises:
collapsing the dimensions of the one or more secondary data sets linked with the dimension of the primary data set into a blended column of a result set data structure; and
aggregating values of measures in rows of the blended column of the result set data structure.

3 . The method of claim 2 wherein the dimensions and measures of the blended column are determined based on a designated join type.

4 . The method of claim 3 wherein the designated join type is selected from the group consisting of a left-outer join, a full-outer join, an intersection join, or an exception join.

5 . The method of claim 1 wherein the server is further configured to:
receive a query response from the database comprising the resulting data set;
generate layout data for formatting the resulting data set to be rendered in the visualization at the client interface according to a selected visualization type; and
communicate a response to the client query containing the layout data.

6 . The method of claim 1 further comprising applying a filter to one or more of the plurality of data sets specifying dimensions to be displayed in the visualization.

7 . The method of claim 1 wherein at least one of the plurality of data sets comprises a subset of a database table stored in the database.

8 . The method of claim 1 further comprising:
generating, for each of the plurality of data sets, a data structure model representing the classified dimensions and measures, wherein each dimension and measure in the data structure model includes a local identifier; and
assigning a global identifier for each local identifier, wherein each global identifier is unique across the plurality of data sets.

9 . The method of claim 8 further comprising storing the mapping information between the local identifiers and the global identifiers.

10 . The method of claim 8 further comprising generating a visualization definition for each resulting data set comprising the global identifiers.

11 . A system comprising:
a server in communication with a database; a computer system in communication with the server over a network, the computer system comprising a processor and a system memory in communication with the processor via a communication medium, the system memory configured to store programmed computer code, which when executed by the processor, causes the processor to perform data blending operations comprising: receiving a plurality of data sets to be displayed in a visualization in a client graphical interface at a client system, wherein each of the plurality of data sets comprises a data structure having one or more columns and one or more rows, wherein columns of each data set are classified as either a dimension or a measure; receiving input at the client interface selecting a dimension from a first data set of the plurality of data sets to be displayed in the visualization, wherein the first data set selected comprises a primary data set; receiving input at the client interface selecting a dimension from one or more secondary data sets of the plurality of data sets to be displayed in the visualization; receiving input at the client interface linking the selected dimension of the primary data set with the selected dimensions of the one or more secondary data sets; generating a client query to perform a data blending operation on the dimensions of each of the one or more secondary data sets that are linked with the dimension of the primary data set; and communicating the client query to a server in communication with a database, wherein the server is configured to perform the data blending operation on the selected dimension of the primary data set and the selected dimensions of the one or more secondary data sets in response to the client query, and wherein the data blending operation comprises generating a runtime artifact representing a calculation graph for the data blending operation and querying the database to retrieve a resulting data set.

12 . The system of claim 11 wherein the data blending operation comprises:
collapsing the dimensions of the one or more secondary data sets linked with the dimension of the primary data set into a blended column of a result set data structure; and
aggregating values of measures in rows of the blended column of the result set data structure.

13 . The system of claim 11 wherein the dimensions and measures of the blended column are determined based on a designated join type.

14 . The system of claim 13 wherein the designated join type is selected from the group consisting of a left-outer join, a full-outer join, an intersection join, or an exception join.

15 . The system of claim 11 wherein the server is further configured to:
receive a query response from the database comprising the resulting data set;
generate layout data for formatting the resulting data set to be rendered in the visualization at the client interface according to a selected visualization type; and
communicate a response to the client query containing the layout data.

16 . The system of claim 11 wherein the operations further comprise applying a filter to one or more of the plurality of data sets specifying dimensions to be displayed in the visualization.

17 . A non-transitory computer readable storage medium embodying programmed computer code, which when executed by a computer system, causes the computer system to perform operations comprising:
receiving a plurality of data sets to be displayed in a visualization in a client graphical interface at a client system, wherein each of the plurality of data sets comprises a data structure having one or more columns and one or more rows, wherein columns of each data set are classified as either a dimension or a measure; receiving input at the client interface selecting a dimension from a first data set of the plurality of data sets to be disp

Assignees

• Business Objects Software Ltd

Inventors

• Fung Alfred
• Moosavi Ali
• Schmidt Erik
• Mosimann David
• Han Jung-Rung

Classifications

• G06F16/248 Primary

  Presentation of query results · CPC title

• G06F16/283

  Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP · CPC title

• G06F16/2456

  Join operations · CPC title

• G06F17/30498

  Physics · mapped topic

• G06F17/30554 Primary

  Physics · mapped topic