International Business Machines Corporation

Hendrik Cazemier

Celine Goyette

Pascal D Lacombe

Charles Mike Potter

Ralf Vierich

Kevin M Ferguson

Eric McCully

Wayne Salter

Richard F Blackwell

Jijiang (George) Xu

Guy Lacoursiere

Lee Daw-Yong Godfrey

Kenneth R Leese

Claude Tennier

Qing Zhu

A computer-implemented method, system and computer program product for improving performance for retrieving and reporting information from a data warehouse. A query (e.g., SQL query) is received. If a materialized view is present, and if such a materialized view was generated within the designated time frame, then the query is translated to query a materialized view. The translated query is then sent to a first data storage database of the data warehouse storing materialized views to be processed to obtain the materialized object associated with the query. If, on the other hand, the materialized view is not present, or the materialized view is present but has not been generated within the designated time frame, then the query is sent to the second data storage database of the data warehouse storing the original data without any modification to retrieve and report the appropriate information from the second data storage database.

Data warehouse framework for high performance reporting

As disclosed herein a method, executed by a computer, for avoiding double counting in the presence of many-to-many relationships in database data includes receiving a report definition from a data management system, detecting a bridge table defining many-to-many relationships between at least two datasets, generating a query plan with layered sub-queries, and executing the query plan including the layered sub-queries to provide query results corresponding to the report definition. A query plan with layered sub-queries may include instructions to join, partition, normalize, group, and summarize tabular data. Additionally, a conditional selection operation may be used to detect and eliminate duplicated data from a field specified in the report definition. The resulting query plan may be executed as a single query language. A computer program product and an apparatus corresponding to the described method are also disclosed herein.

Avoid double counting of mapped database data

A method, a system and a storage medium for preparing multilingual reports at client sites. The client sites are connected to a server and a data source. Each of the client sites may use a different locale. A product locale is selected at the client site for defining a user interface appearance. After a report specification is generated, a content locale is selected at the client site, which defines an appearance and a format of a report. A metadata model with run-time parameters is then constructed. The run-time parameters include mapping rules for the content locale. The run-time parameters are updated based on the content locale. A query is built using the report specification and the metadata model. Data appropriate to the individual content locale is then extracted from the same data source using the query.

System and method for the support of multilingual applications

Growing community of inventors

Spencerville, Canada

Hendrik Cazemier