Aggregate join index utilization in query processing

Details Aggregate join index utilization in query processing Aggregate join index utilization in query processing

2011-03-22

2011-03-22

Lewis, Cheryl (Department: 2167)

Data processing: database and file management or data structures

Database and file access

Query optimization

C707S802000, C707S957000

Reexamination Certificate

active

07912833

ABSTRACT:
A system and method include obtaining a query and identifying an aggregate join index (AJI) at a high level of aggregation. The dimension table may be rolled-up with the grouping key being the union of the grouping key in the AJI and the grouping key of the query. The identified AJI is joined with the rolled-up dimension table to obtain columns in the query that are not in the identified AJI. The joined AJI and rolled-up dimension table are then rolled up to answer the query.

REFERENCES:
patent: 6505188 (2003-01-01), Ghazal et al.
patent: 6505189 (2003-01-01), On Au et al.
patent: 6618720 (2003-09-01), On Au et al.
patent: 6643636 (2003-11-01), Au et al.
patent: 6732096 (2004-05-01), Au
patent: 7319997 (2008-01-01), Morris et al.
patent: 7321898 (2008-01-01), Luo et al.

Affiliated with

Also associated with

Rating

Aggregate join index utilization in query processing does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Aggregate join index utilization in query processing, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Aggregate join index utilization in query processing will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2674973