Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Automated and dynamic management of query views for database workloads

a database and database technology, applied in the field of automatic and dynamic management of query views for database workloads, can solve the problem of high processing cost of mqts, and achieve the effect of reducing processing cos

Inactive Publication Date: 2008-07-24
IBM CORP
View PDF9 Cites 35 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Benefits of technology

[0007]The embodiments of the invention provide a method, program storage device, etc. for automated and dynamic management of query views for database workloads. More specifically, a method begins by executing queries, which includes accessing a set of data tables (also referred to herein as “materialized views”) for each of the queries. The data tables summarize common portions of the queries. During the executing of the queries, the m...

Problems solved by technology

Since the creation of MQTs can be expensive compared to the benefit of the MQTs to a single query, MQTs are usually created for the whole batch query workload so that the accumulated benefits exceed the cost of their materialization.

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Automated and dynamic management of query views for database workloads
  • Automated and dynamic management of query views for database workloads
  • Automated and dynamic management of query views for database workloads

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0021]The embodiments of the invention and the various features and advantageous details thereof are explained more fully with reference to the non-limiting embodiments that are illustrated in the accompanying drawings and detailed in the following description. It should be noted that the features illustrated in the drawings are not necessarily drawn to scale. Descriptions of well-known components and processing techniques are omitted so as to not unnecessarily obscure the embodiments of the invention. The examples used herein are intended merely to facilitate an understanding of ways in which the embodiments of the invention may be practiced and to further enable those of skill in the art to practice the embodiments of the invention. Accordingly, the examples should not be construed as limiting the scope of the embodiments of the invention.

[0022]The embodiments herein provide an automated, dynamic view management scheme that materializes views on-demand as a workload is executing a...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The embodiments of the invention provide a method, program storage device, etc. for automated and dynamic management of query views for database workloads. More specifically, a method begins by executing queries, which includes accessing a set of data tables for each of the queries. During the executing of the queries, the method accesses a required data table from a cache if the required data table is present in the cache and creates the required data table if the required data table is not present in the cache. The accessing of the required data table from the cache has a lower processing cost than accessing the required data table from a base table. Also during the executing of the queries, created data tables are stored in the cache, wherein one or more of the created data tables are removed from the cache when the cache becomes full.

Description

BACKGROUND[0001]1. Field of the Invention[0002]The embodiments of the invention provide a method, program storage device, etc. for automated and dynamic management of query views for database workloads.[0003]2. Description of the Related Art[0004]Within this application several publications are referenced by arabic numerals within parentheses. Full citations for these, and other, publications may be found at the end of the specification immediately preceding the claims. The disclosures of all these publications in their entireties are hereby expressly incorporated by reference into the present application for the purposes of indicating the background of the present invention and illustrating the state of the art.[0005]A materialized view, or materialized query table (also referred to herein as “MQT” or “data table”), is an auxiliary table with precomputed data that can be used to significantly improve the performance of a database query. With its MQT matching capability, a database ...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): G06F7/06
CPCG06F17/30312G06F17/3046G06F17/30457G06F16/22G06F16/2454G06F16/24539
Inventor LI, WEN-SYANPHAN, THOMAS
Owner IBM CORP
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com