Contextual navigation facets panel

• US 10,033,714 B2
• Filed: 09/17/2015
• Issued: 07/24/2018
• Est. Priority Date: 06/16/2015
• Status: Active Grant

• Current Assignee: Business Objects Incorporated (SAP SE)
• Original Assignee: Business Objects Incorporated (SAP SE)
• Inventors: Naibo, Alexis
• Primary Examiner(s): Channavajjala, Srirama
• Application Number:
  US14/856,972
• Publication Number:
  US 20160373423A1
• Time in Patent Office: 1,041 Days
• CPC Class Codes: G06F 16/245 Query processing
• CPC Class Codes: G06F 16/24575 using context
• CPC Class Codes: G06F 16/2465 Query processing support for facilitating data mining operations in structured databases
• CPC Class Codes: G06F 16/248 Presentation of query results
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
• CPC Class Codes: G06F 16/322 Trees
• CPC Class Codes: G06F 16/3322 using system suggestions G06F16/3325 takes precedence
• CPC Class Codes: G06F 16/3329 Natural language query formulation or dialogue systems
• CPC Class Codes: G06F 16/334 Query execution G06F16/335 takes precedence
• CPC Class Codes: G06F 16/9024 Graphs; Linked lists G06F16/9027 takes precedence
• CPC Class Codes: G06F 40/284 Lexical analysis, e.g. tokenisation or collocates
• CPC Class Codes: H04L 63/08 for authentication of entities cryptographic mechanisms or cryptographic arrangements for entity authentication H04L9/32
• CPC Class Codes: H04L 63/102 Entity profiles

Abstract

A computer-implemented method for generating a contextual panel interface with a first interactive display portion for depicting a plurality of selectable datasets associated with the query context, a second interactive display portion for depicting a plurality of selectable measures associated with the query context and with at least one of the plurality of selectable datasets, a third interactive display portion for depicting a plurality of selectable dimensions associated with the query context and with at least one of the plurality of selectable datasets, and an interactive tool display portion configured to determine a query context in response to receiving a search query and to populate the first, second, and third interactive display portions.

Claims

1. A computer-implemented method, the method comprising:

initiating, for a user interface, a plurality of processes associated with a plurality of datasets, the user interface including at least a contextual panel interface providing access to data hierarchies pertaining to the plurality of datasets;

determining a first query context associated with the plurality of datasets, the first query context being determined based on data usage patterns associated with a user accessing the user interface;

displaying, in the user interface, the contextual panel interface adjacent to a graphical depiction of data generated using the first query context, the data usage patterns, and the plurality of datasets, the contextual panel interface depicting selectable data compatible with the first query context, and retrieved from the plurality of datasets;

in response to receiving input on at least a portion of the selectable data in the contextual panel interface,

selecting a subset of the plurality of datasets,

determining compatibility between a plurality of attributes in the subset of the plurality of datasets,

generating a second query context for the subset of the plurality of the datasets based on the determined compatibility between the plurality of attributes, and

generating, for display, an updated user interface that includes updated graphical data generated using the second query context, and generating an updated contextual panel interface with updated selectable data corresponding to the second query context, the updated contextual panel interface indicating a merge of at least two datasets in the subset of datasets and including a plurality of measures and a plurality of dimensions compatible with the second query context,

wherein the second query context modifies the first query context to provide access to additional relevant attributes from the subset of the plurality of datasets and to remove one or more of the plurality of attributes that are incompatible with the input, and

wherein the determining of compatibility between the plurality of attributes includes selecting at least two datasets in the subset that include at least one common attribute from the plurality of attributes, and selecting, using the second query context and the at least one common attribute, a plurality of data measures and a plurality of dimensions in the subset, the plurality of dimensions being sorted based at least in part on usage patterns associated with the user.

2. The method of claim 1, wherein the plurality of measures include a plurality of data objects that quantitatively define at least one attribute in the plurality of attributes and the plurality of dimensions include a plurality of data categories for the at least one attribute in the plurality of attributes.

3. The method of claim 1, further comprising:

sorting the subset of the plurality of datasets determined to be compatible, the sorting based at least in part on the usage patterns associated with the user;

sorting the plurality of measures, the sorting based at least in part on the usage patterns associated with the user; and

displaying, in the updated user interface, the sorted plurality of datasets having attributes determined to be compatible, the plurality of measures, and the plurality of dimensions.

4. The method of claim 3, wherein the usage patterns include a measured time-based statistic, associated with the user, and corresponding to accessing one or more attributes within the subset of the datasets, the plurality of measures, or the plurality of dimensions.

5. The method of claim 1, wherein the first query context is generated by automatically analyzing the plurality of datasets by accessing a knowledge graph to calculate compatibility between the plurality of datasets.

6. The method of claim 1, wherein generating a second query context associated with the plurality of attributes comprises automatically accessing a knowledge graph to select additional content from the subset of the datasets, the additional content determined to be compatible with the subset of the datasets, the compatibility being based at least in part on predefined similarity of nodes and edges in the knowledge graph.

7. The method of claim 1, further comprising:

blending at least two of the subset of the datasets based at least in part on determining that one or more of the plurality of measures or the plurality of dimensions overlap between the one or more of the plurality of datasets; and

displaying in the updated contextual panel interface, a selectable control corresponding to the blended datasets.

8. The method of claim 1, further comprising:

in response to receiving additional input at one of the interactive controls, using the additional input to filter out datasets, measures, and dimensions that are incompatible with the query context for data associated with the additional input;

generating, for display, an additional updated user interface that includes a third query context and an additional updated contextual panel interface that includes interactive controls corresponding to the additional input; and

displaying, the additional updated user interface and the additional updated contextual panel interface.

9. The method of claim 1, further comprising:

removing one or more datasets from the subset of the datasets based on determining insufficient security credentials for the user of the user interface, wherein the removal terminates access, for the user of the user interface, to the one or more datasets in the subset of the datasets.

10. A computer-implemented system including instructions recorded on a non-transitory computer-readable medium and comprising instructions that, when executed by at least one processor, cause the at least one processor to:

initiate, for a user interface, a plurality of processes associated with a plurality of datasets, the user interface including at least a contextual panel interface providing access to data hierarchies pertaining to the plurality of datasets;

determine a first query context associated with the plurality of datasets, the first query context being determined based on data usage patterns associated with a user accessing the user interface;

display, in the user interface, the contextual panel interface adjacent to a graphical depiction of data generated using the first query context, the data usage patterns, and the plurality of datasets, the contextual panel interface depicting selectable data compatible with the first query context, and retrieved from the plurality of datasets;

in response to receiving input on at least a portion of the selectable data in the contextual panel interface,

select a subset of the plurality of datasets,

determine compatibility between a plurality of attributes in the subset of the plurality of datasets,

generate a second query context for the subset of the plurality of the datasets based on the determined compatibility between the plurality of, and

generate, for display, an updated user interface that includes updated graphical data generated using the second query context, and generating an updated contextual panel interface with updated selectable data corresponding to the second query context, the updated contextual panel interface and including a plurality of measures and a plurality of dimensions compatible with the second query context,

wherein the second query context modifies the first query context to provide access to additional relevant attributes from the subset of the plurality of datasets and to remove one or more of the plurality of attributes that are incompatible with the input, and

wherein the determining of compatibility between the plurality of attributes includes selecting at least two datasets in the subset that include at least one common attribute from the plurality of attributes, and selecting, using the second query context and the at least one common attribute, a plurality of data measures and a plurality of dimensions in the subset, the plurality of dimensions being sorted based at least in part on usage patterns associated with the user.

11. The system of claim 10, wherein the security engine is further configured to remove at least a portion of the data from the contextual panel interface in response to determining insufficient security credentials.

12. The system of claim 10, wherein comparing the data to associations defined in the knowledge graph includes determining associations between information stored in the knowledge graph and determining which of those associations are compatible with the data.

13. The system of claim 10, wherein the query context engine:

monitors the query context in response to receiving user input; and

modifies the query context if the input causes changes in the associations between information stored in the knowledge graph.

14. The system of claim 10, wherein the contextual panel interface comprises:

a first interactive display portion for depicting a plurality of selectable datasets associated with the query context;

a second interactive display portion for depicting a plurality of selectable measures associated with the query context and with at least one of the plurality of selectable datasets;

a third interactive display portion for depicting a plurality of selectable dimensions associated with the query context and with at least one of the plurality of selectable datasets; and

an interactive tool display portion configured to determine a query context in response to receiving a search query and to populate the first, second, and third interactive display portions.

15. A non-transitory recordable storage medium having recorded and stored thereon instructions that, when executed, perform actions of:

initiating, for a user interface, a plurality of processes associated with a plurality of datasets, the user interface including at least a contextual panel interface providing access to data hierarchies pertaining to the plurality of datasets;

determining a first query context associated with the plurality of datasets, the first query context being determined based on data usage patterns associated with a user accessing the user interface;

displaying, in the user interface, the contextual panel interface adjacent to a graphical depiction of data generated using the first query context, the data usage patterns, and the plurality of datasets, the contextual panel interface depicting selectable data compatible with the first query context, and retrieved from the plurality of datasets;

in response to receiving input on at least a portion of the selectable data in the contextual panel interface, selecting a subset of the plurality of datasets, determining compatibility between a plurality of attributes in the subset of the plurality of datasets, and generating a second query context for the subset of the plurality of the datasets based on the determined compatibility between the plurality of attributes, and

generating, for display, an updated user interface that includes updated graphical data generated using the second query context, and generating an updated contextual panel interface with updated selectable data corresponding to the second query context, the updated contextual panel interface indicating a merge of at least two datasets in the subset of datasets and including a plurality of measures and a plurality of dimensions compatible with the second query context,

wherein the second query context modifies the first query context to provide access to additional relevant attributes from the subset of the plurality of datasets and to remove one or more of the plurality of attributes that are incompatible with the input, and

wherein the determining of compatibility between the plurality of attributes includes selecting at least two datasets in the subset that include at least one common attribute from the plurality of attributes, and selecting, using the second query context and the at least one common attribute, a plurality of data measures and a plurality of dimensions in the subset, the plurality of dimensions being sorted based at least in part on usage patterns associated with the user.

16. The non-transitory recordable storage medium of claim 15, wherein the instructions further comprise:

sorting the subset of the datasets determined to be compatible, the sorting based at least in part on the usage patterns associated with the user;

sorting the plurality of measures, the sorting based at least in part on the usage patterns associated with the user;

and

displaying, in the updated user interface, the sorted plurality of datasets having attributes determined to be compatible, the plurality of data measures, and the plurality of data dimensions.

17. The non-transitory recordable storage medium of claim 15, wherein the instructions further comprise:

in response to receiving additional input at one of the interactive controls, using the additional input to filter out datasets, measures, and dimensions that are incompatible with the query context for data associated with the additional input;

generating, for display, an additional updated user interface that includes a third query context and an additional updated contextual panel interface that includes interactive controls corresponding to the additional input; and

displaying, the additional updated user interface and the additional updated contextual panel interface.