International Business Machines Corporation

Soufiane Azizi

Vladimir Mordvinov

Alexei Pogrebtsov

Bryan Casey

David B Cushing

A computing device outputs a chart matrix defined by associating a first data dimension with a row edge and a second data dimension with a column edge. Members of the first data dimension are displayed as row headers of the chart matrix, and members of the second data dimension are displayed as column headers of the chart matrix. The device outputs charts in matrix cells of the chart matrix defined by intersections of rows defined by the row edge and columns defined by the column edge. The computing device provides user options to perform a drill operation on a selected member displayed in the chart matrix. The computing device outputs, in response to the user input to perform the drill operation, a modified chart matrix displaying related members in at least one of the charts, wherein the related members are related by one hierarchical level from the selected member.

Dimensional data chart matrixes with drill operations

A query processing visualization system comprises a visualization module. The visualization module visualizes logging information of query processing events occurring during processing of a client query requesting data from one or more data sources by analyzing the logging information to identify dependency of the query processing events, formatting visual presentation components representing the logging information in a hierarchy to reflect the dependency of the query processing events, and presenting the visual presentation components in the context of the hierarchy of the visual components as formatted.

Query processing visualization system and method of visualizing query processing

A query that is based on a predefined format of an arbitrary query language is received. A data analyzing component performs the query to obtain a query result. The query result and a report layout specification are provided from the data analyzing component to a data processing component, the data processing component being on a computer. The data processing component associates the query result with at least one element of the report layout specification to generate an association. The query result is provided from the data processing component through an interface based on the report layout specification without reliance on the type of the arbitrary query language to a rendering component. The report layout specification is provided from the data analyzing component to the rendering component to render the query result in a report according to the association without reliance on the type of the arbitrary query language.

Ready to render business intelligence result sets

A tabular operation provider is provided for processing a data agnostic business intelligence query with relational operations, herein called a relational query against a multidimensional datasource. The tabular operation provider comprises a query interceptor, a query decomposer and a query replacer. The query interceptor detects and intercepts a relational query that is issued against one or more multidimensional data sources. The query decomposer decomposes expressions of the relational query into one multidimensional expression and one or more relational expressions. The query replacer replaces the relational query with a stack of operations expressed by the decomposed multidimensional expressions and/or the relational expressions.

System and method of providing date, arithmetic and other relational functions for OLAP sources

A tabular set provider is provided for processing a data agnostic business intelligence query with relational set operations, herein called a relational query against a multidimensional datasource. The tabular set provider comprises a query interceptor, a query decomposer, an OLAP query provider interface, and an operation module. The query interceptor is provided for detecting and intercepting a data agnostic Business intelligence query that has relational set operations that is issued against one or more multidimensional data sources. The query decomposer is provided for decomposing the operands of the set operation in the input query into one or more sub-queries. The OLAP query provider interface is provided for sending the OLAP supported sub-queries to an OLAP query provider and receiving results. The operation module is provided for using set operation functionality provided by a relational query provider that performs the set operations locally on the results of the OLAP data extraction.

System and method of providing relational set operations for multidimensional data sources

A query processing coordination planning unit coordinates a query processing to obtain requested data from one or more data sources. The query processing coordination planning unit comprises a request preparation coordinator and a request execution coordinator. The request planning unit invokes one or more query operation providers in a conditional query processing sequence for translating a logical representation of the user request into a physical representation of a user request, and generates an execution plan expressed by the physical representation of a user request. The request execution coordinator executes the physical representation of the user request in accordance with the execution plan using the query operation providers.

Query planning for execution using conditional operators

A coordination planner is suitably used for a query framework system for processing a user request for data from one or more data sources. The query framework system comprises multiple query processing components including a set of query operation providers, each being capable of providing a specific query operation. The coordination planner prepares a user request for execution by translating a logical representation of the user request into a physical representation of the user request using the query operation providers, and executes the physical representation of the user request to obtain a result data stream using the query operation providers.

Growing community of inventors

Ottawa, Canada

Soufiane Azizi