System and method for selection of materialized views

Details System and method for selection of materialized views System and method for selection of materialized views

2007-03-13

2007-03-13

Wong, Don (Department: 2163)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000, C707S793000

Reexamination Certificate

active

10345565

ABSTRACT:
A method for selecting and recommending materialized views is described, in which a set of workload queries is classified in terms of a number of structural features that includes the structure of the join operations in the query (“full query join graph”), the structure of a specific subset of the join operations (“anchor join graph”), and other characteristics such as the measures, selection predicates, and grouping conditions employed in the query. These features are used to implement a two-level partitioned search for the recommended materialized views.

REFERENCES:
patent: 5864842 (1999-01-01), Pederson et al.
patent: 5991754 (1999-11-01), Raitto et al.
patent: 6026390 (2000-02-01), Ross et al.
patent: 6125360 (2000-09-01), Witkowski et al.
patent: 6141655 (2000-10-01), Johnson et al.
patent: 6438542 (2002-08-01), Koo et al.
patent: 6449605 (2002-09-01), Witkowski
patent: 6480836 (2002-11-01), Colby et al.
patent: 6493699 (2002-12-01), Colby et al.
patent: 6510422 (2003-01-01), Galindo-Legaria et al.
patent: 6567802 (2003-05-01), Popa et al.
patent: 6757670 (2004-06-01), Inohara et al.
patent: 6850933 (2005-02-01), Larson et al.
Markl, V, Frank Ramsak and Rudolf Bayer (1999), Improving OLAP Performance by Multidimensional Hierarchical Clustering, pp. 165-177.
Harinarayan et al., Implementing Data Cubes Efficientlly, 1995, 25, Department of Computer Science, Stanford University, Stanford, CA 94305-2140.
Randall et al, Materialized Views in Oracle, Proceedings of the 24thVLDB Conference New York, USA, 1998, 659-664.

Affiliated with

Also associated with

Rating

System and method for selection of materialized views does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with System and method for selection of materialized views, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System and method for selection of materialized views will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3735852