Data source identification mapping in blended data operations

Patent metadata

Field	Value
Publication number	US-10140325-B2
Application number	US-201514984480-A
Country	US
Kind code	B2
Filing date	Dec 30, 2015
Priority date	Dec 30, 2015
Publication date	Nov 27, 2018
Grant date	Nov 27, 2018

Abstract

Data blending operations are disclosed configured to blend data from a primary data set and a secondary data set. Primary and secondary data structure models are generated reflecting selected dimensions and measures of the primary and secondary data structure models upon which the data blending operation is to be performed. Each dimension and measure in the primary and secondary data structure models includes a local identifier. Unique global identifiers are assigned to each local identifier of the primary and secondary data structure models. Client queries are generated and communicated to a backend server to perform data blending on the selected dimensions and measures of the primary data set and the secondary data set. The client queries may comprise the global identifiers and mapping information between the global identifiers and local identifiers. The backend system retrieves a resulting data set in response to the data blending operation based on this mapping.

First claim

What is claimed is:

1. A method comprising:
receiving input, at a client interface comprising a graphical display of a client system, selecting a dimension or measure from a primary data set of a plurality of data sets and selecting a dimension or measure from at least one secondary data set of the plurality of data sets to be displayed in a visualization in the client interface, wherein one or more dimensions of the primary data set are linked with one or more dimensions of the secondary data set;
generating a primary data structure model representing the selected dimensions and measures for the primary data set and a secondary data structure model representing the selected dimensions and measures for the secondary data set, wherein each dimension and measure in the primary data structure model and the secondary data structure model includes a local identifier;
assigning a global identifier to each dimension and measure in the primary data structure model and the secondary data structure model;
generating a client query comprising the global identifiers and mapping information between the global identifiers and the local identifiers of the primary and secondary data structure models; and
communicating the client query to a server, wherein the server is configured to perform a data blending operation on each selected dimension of the one or more dimensions of the primary data set that is linked with the one or more dimensions of the secondary data set in response to the input, the primary data set stored in a database external to the server, and wherein the server is further configured to,
in response to the data blending operation, temporarily store in a local memory for a lifecycle of the client query, a resulting data set that is not stored in the database, and
return the resulting data set to the client system for rendering the visualization in the client interface.

2. The method of claim 1 wherein the server determines which data to include in the resulting data set based on the mapping information between the global identifiers and the local identifiers of the primary and secondary data structure models.

3. The method of claim 1 wherein each of the global identifiers is unique across the plurality of data sets.

4. The method of claim 1 wherein the data blending operation includes generating a runtime artifact representing a calculation graph for the data blending operation.

5. The method of claim 1 wherein the data blending operation is performed without requiring unique values for the dimensions or measures of the primary and secondary data sets.

6. The method of claim 1 wherein the mapping information includes a look-up table.

7. The method of claim 1 wherein the data blending operation is performed without processing an entire database table for each of the primary and secondary data sets.

8. The method of claim 1 wherein the data blending operation is performed in a background process transparent to a user at the client interface.

9. The method of claim 1 further comprising updating the visualization in the client interface based on data provided by the server in response to the client query.

10. 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 input, at a client interface comprising a graphical display of a client system, selecting a dimension or measure from a primary data set of a plurality of data sets and selecting a dimension or measure from at least one secondary data set of the plurality of data sets to be displayed in a visualization in the client interface, wherein one or more dimensions of the primary data set are linked with one or more dimensions of the secondary data set;
generating a primary data structure model representing the selected dimensions and measures for the primary data set and a secondary data structure model representing the selected dimensions and measures for the secondary data set, wherein each dimension and measure in the primary data structure model and the secondary data structure model includes a local identifier;
assigning a global identifier to each dimension and measure in the primary data structure model and the secondary data structure model;
generating a client query comprising the global identifiers and mapping information between the global identifiers and the local identifiers of the primary and secondary data structure models; and
communicating the client query to a server, wherein the server is configured to perform a data blending operation on each selected dimension of the one or more dimensions of the primary data set that is linked with the one or more dimensions of the secondary data set in response to the input, the primary data set stored in a database external to the server, and wherein the server is further configured to,
in response to the data blending operation, temporarily store in a local memory for a lifecycle of the client query, a resulting data set that is not stored in the database, and
return the resulting data set to the client system for rendering the visualization in the client interface.

11. The system of claim 10 wherein the server determines which data to include in the resulting data set based on the mapping information between the global identifiers and the local identifiers of the primary and secondary data structure models.

12. The system of claim 10 wherein the data blending operation includes generating a runtime artifact representing a calculation graph for the data blending operation.

13. The system of claim 10 wherein the data blending operation is performed without requiring unique values for the dimensions or measures of the primary and secondary data sets.

14. The system of claim 10 wherein the mapping information includes a look-up table.

15. The system of claim 10 wherein the operations further comprise generating a visualization definition for the resulting data set comprising the global identifiers.

16. 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 input, at a client interface comprising a graphical display of a client system, selecting a dimension or measure from a primary data set of a plurality of data sets and selecting a dimension or measure from at least one secondary data set of the plurality of data sets to be displayed in a visualization in the client interface, wherein one or more dimensions of the primary data set are linked with one or more dimensions of the secondary data set;
generating a primary data structure model representing the selected dimensions and measures for the primary data set and a secondary data structure model representing the selected dimensions and measures for the secondary data set, wherein each dimension and measure in the primary data structure model and the secondary data structure model includes a local identifier;
assigning a global identifier to each dimension and measure in the primary data structure model and the secondary data structure model;
generating a client query comprising the global identifiers and mapping information between the global identifiers and the local identifiers of the primary and s

Assignees

• Business Objects Software Ltd

Inventors

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

Classifications

• G06F17/30592

  Physics · mapped topic

• G06F17/30466

  Physics · mapped topic

• G06F17/30554

  Physics · mapped topic

• G06F17/30333 Primary

  Physics · mapped topic

• G06F16/24544 Primary

  Join order optimisation · CPC title