Extending OLAP navigation employing analytic workflows

• US 8,478,715 B2
• Filed: 05/16/2008
• Issued: 07/02/2013
• Est. Priority Date: 05/16/2008
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Dorrell, Wade C., Whitney, William R.
• Primary Examiner(s): Kim, Jung
• Assistant Examiner(s): Wilcox, James J
• Application Number:
  US12/121,939
• Publication Number:
  US 20090287675A1
• Time in Patent Office: 1,873 Days
• Field of Search: None
• US Class Current: 707/603
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling

Abstract

Analytic workflows for performing data analysis and other related operations are stored in an analytic workflow library and provided to a user upon selection of data from a data store. A workflow manager may rank the workflows based on a number of ranking algorithms prior to presentation. User selected workflows are executed in conjunction with relevant external applications and the analysis result provided to the user through the user'"'"'s client application used to select the data. Workflows and associated interfaces may be received from a variety of sources and integrated into the workflow framework for enhancing data analysis.

Claims

1. A method to be executed at least in part in a computing device for data navigation employing analytic workflows, the method comprising:

providing an analytic workflow library having predefined workflows and properties associated therewith;

hosting an analytic workflow host model within a client application to provide workflow functionality from data displayed by the client application;

providing a workflow host view to connect with a user interface of the client application to receive a selection of a data point from the data displayed by the client application;

automatically collecting by the workflow host view a typed tuple and context information based on the selection of the data point;

passing the collected typed tuple and context information to the analytic workflow host model;

ranking, by the analytic workflow host model, a set of analytic workflows obtained from the analytic workflow library based on the collected typed tuple and context information for the selected data point;

providing, by the analytic workflow host model, the user interface for display by the client application presenting the ranked set of analytic workflows for selection of one of the analytic workflows from the ranked set of analytic workflows applicable to the selected data point to a user;

receiving for execution, at the analytic workflow host model, an analytic workflow selected from the ranked set of analytic workflows;

executing, by the analytic workflow host model, the selected analytic workflow on the selected data point; and

providing visualization of the selected data point for presentation by the client application based on properties associated with the selected analytic workflow executed by the analytic workflow host model.

2. The method of claim 1, further comprising:

ranking the available analytic workflows applicable to the selected data point employing at least one ranking algorithm.

3. The method of claim 2, wherein the ranked analytic workflows are ranked based on a total weight factor derived from executing a plurality of ranking algorithms and assigning a weight factor to a result of each ranking algorithm.

4. The method of claim 3, wherein the ranking algorithms include at least one from a set of:

ranking based on a number of matched properties, ranking based on least-recently-used, and ranking based on user community voting.

5. The method of claim 1, further comprising serializing the workflows in the analytic workflow library for storage and distribution.

6. The method of claim 5, wherein data navigation activities are serialized and include one of:

an embedded copy of native serialization of visualization and queries required for the visualization and a link to native serialization content such that the visualization and the required queries are not duplicated for each serialized analytic workflow.

7. The method of claim 1, wherein the executing, by the analytic workflow host model, the selected analytic workflow includes launching of at least one application external to the client application.

8. The method of claim 1, further comprising:

upon receiving, at the analytic workflow host model, selection of the analytic workflow, providing a tertiary user interface for receiving at least one operational parameter associated with the selected analytic workflow from the user.

9. The method of claim 1, wherein the visualization of the selected data point based on properties associated with the selected analytic workflow is presented to the user as one of:

a chart, a diagram, a data listing, and a comprehensive report.

10. A system for data navigation employing analytic workflows, the system comprising:

a processor;

a data store for storing data to be navigated;

an analytic workflow library for storing analytic workflows provided and properties associated therewith from a plurality of sources; and

at least one server configured to facilitate a hosted service for data navigation, wherein the hosted service includes;

a search interface configured to connect to and index the analytic workflow library;

an analytic workflow host model to be hosted within a client application employed by a user, wherein the analytic workflow host model provides analytic workflow functionality from data displayed by the client application;

a workflow host view specific to the client application, configured to;

connect with a user interface of the client application;

in response to receiving a user selection of a data point from the data displayed by the client application, automatically collect a typed tuple and context information based on selection of the data point;

pass the typed tuple and context information to the analytic workflow host model for determining available analytic workflows applicable to the selected data point to provide automated multi-step navigation of the selected data point;

wherein the analytic workflow host model ranking a set of analytic workflows obtained from the analytic workflow library based on the collected typed tuple and context information for the selected data point and providing the user interface for display by the client application presenting the ranked set of analytic workflows for selection of one of the analytic workflows from the ranked set of analytic workflows applicable to the selected data point to the user;

the analytic workflow host model receiving for execution the user selection from the ranked set of analytic workflows;

executing the selected analytic workflow on the selected data point; and

wherein visualization of the selected data point is provided for presentation by the client application based on properties associated with the selected analytic workflow executed by the analytic workflow host model; and

a ranking module for prioritizing the analytic workflows applicable to the user selected data point based on executing at least one ranking algorithm.

11. The system of claim 10, wherein the host view is further configured to:

filter the ranked set of analytic workflows based on a predefined criterion prior to providing them to the user.

12. The system of claim 10, wherein the analytic workflow library is one of a virtual data store and a physical data store.

13. The system of claim 10, wherein the analytic workflow library includes at least one from a set of:

“

required”

properties necessary to initiate a first activity in the selected workflow;

“

optional”

properties necessary to complete all activities in the selected workflow, but not necessary to start the first activity;

activities associated with user interface metadata for obtaining the optional properties from the user; and

navigation activity that is a final activity in the selected workflow generating a new visualization for the user based on the “

required”

properties.

14. The system of claim 13, wherein the “

required”

properties are exposed such that the analytic workflow library is readily searchable.

15. A data store running on a computer, the data store including computer readable instructions, that when executed by a processor perform the method for data navigation employing analytic workflows, the method comprising:

providing an analytic workflow library having predefined workflows and properties associated therewith;

hosting an analytic workflow host model within a client application to provide workflow functionality from data displayed by the client application;

providing a workflow host view to connect with a user interface of the client application to receive a selection of a data point from the data displayed by the client application;

automatically collecting by the workflow host view a typed tuple and context information based on the selection of the data point;

passing the collected typed tuple and context information to the analytic workflow host model;

ranking, by the analytic workflow host model, a set of analytic workflows obtained from the analytic workflow library based on the collected typed tuple and context information for the selected data point;

providing, by the analytic workflow host model, the user interface for display by the client application presenting the ranked set of analytic workflows for selection of one of the analytic workflows from the ranked set of analytic workflows applicable to the selected data point to a user;

receiving for execution, at the analytic workflow host model, an analytic workflow selected from the ranked set of analytic workflows;

executing, by the analytic workflow host model, the selected analytic workflow on the selected data point; and

providing visualization of the selected data point for presentation by the client application based on properties associated with the selected analytic workflow executed by the analytic workflow host model.

16. The data store of claim 15, further comprising:

ranking the available analytic workflows applicable to the selected data point employing at least one ranking algorithm.

17. The data store of claim 16, wherein the ranked analytic workflows are ranked based on a total weight factor derived from executing a plurality of ranking algorithms and assigning a weight factor to a result of each ranking algorithm.

18. The data store of claim 17, wherein the ranking algorithms include at least one from a set of:

ranking based on a number of matched properties, ranking based on least-recently-used, and ranking based on user community voting.

19. The data store of claim 15, further comprising serializing the workflows in the analytic workflow library for storage and distribution.

20. The data store of claim 15, wherein the selected analytic workflow includes launching of at least one application external to the client application.