17544010. DATA WAREHOUSE FRAMEWORK FOR HIGH PERFORMANCE REPORTING simplified abstract (INTERNATIONAL BUSINESS MACHINES CORPORATION)

From WikiPatents
Jump to navigation Jump to search

DATA WAREHOUSE FRAMEWORK FOR HIGH PERFORMANCE REPORTING

Organization Name

INTERNATIONAL BUSINESS MACHINES CORPORATION

Inventor(s)

Jijiang (George) Xu of Ottawa (CA)

Hendrik Cazemier of Spencerville (CA)

Ralf Vierich of Ottawa (CA)

Qing Zhu of Nepean (CA)

DATA WAREHOUSE FRAMEWORK FOR HIGH PERFORMANCE REPORTING - A simplified explanation of the abstract

This abstract first appeared for US patent application 17544010 titled 'DATA WAREHOUSE FRAMEWORK FOR HIGH PERFORMANCE REPORTING

Simplified Explanation

The abstract describes a computer-implemented method, system, and computer program product for improving performance in retrieving and reporting information from a data warehouse. Here is a simplified explanation of the abstract:

  • When a query is received, the system checks if a materialized view (a precomputed summary of data) exists and if it was generated within a specific time frame.
  • If a suitable materialized view is found, the query is translated to query that materialized view.
  • The translated query is then sent to the first data storage database of the data warehouse to obtain the materialized object associated with the query.
  • If a suitable materialized view is not found or it is not generated within the designated time frame, the query is sent to the second data storage database of the data warehouse to retrieve and report the appropriate information from the original data.

Potential applications of this technology:

  • Data warehousing and analytics systems that require efficient retrieval and reporting of information.
  • Business intelligence tools that rely on querying large datasets.

Problems solved by this technology:

  • Improved performance in retrieving and reporting information from a data warehouse.
  • Reducing the need to query the original data when suitable precomputed summaries (materialized views) are available.

Benefits of this technology:

  • Faster query response times by utilizing precomputed materialized views.
  • Reduced load on the data storage system by minimizing the need to query the original data.
  • Improved overall system performance and efficiency.


Original Abstract Submitted

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.

Retrieved from "http://wikipatents.org/index.php?title=17544010._DATA_WAREHOUSE_FRAMEWORK_FOR_HIGH_PERFORMANCE_REPORTING_simplified_abstract_(INTERNATIONAL_BUSINESS_MACHINES_CORPORATION)&oldid=25706"