Extended handling of ambiguous joins

Details Extended handling of ambiguous joins Extended handling of ambiguous joins

2007-10-04

2011-10-04

Robinson, Greta (Department: 2169)

Data processing: database and file management or data structures

Database and file access

Query optimization

Reexamination Certificate

active

08032520

ABSTRACT:
A system, method and article for handling ambiguous joins among a plurality of tables based on a query are disclosed. Metadata associated with the plurality tables is generated. The metadata comprises ambiguous join dimensions and special measures, where the ambiguous join dimensions provide a list of all dimensions used in conditions of the query that are ambiguous, and the special measures provide a list of measures that are affected by the ambiguous join dimensions. Data is aggregated in the plurality of tables according to an aggregation level expressed in the query and based on the metadata.

REFERENCES:
patent: 4497039 (1985-01-01), Kitakami et al.
patent: 6640221 (2003-10-01), Levine et al.
patent: 7519606 (2009-04-01), Hernandez-Sherrington et al.
patent: 2003/0217048 (2003-11-01), Potter et al.
patent: 2004/0122844 (2004-06-01), Malloy et al.
patent: 2007/0282789 (2007-12-01), Deshpande et al.
patent: 2008/0033907 (2008-02-01), Woehler et al.
patent: 1134671 (2001-09-01), None
Kung et al., Vague Joins—An Extension of the Vague Query System VQS, Database and Expert Systems Applications, 1998. Proceedings. Ninth International Workshop on, Aug. 26-28, 1998, pp. 997-1001.
Lee et al., Adaptive Selection of Access Path and Join Method, Computer Software and Applications Conference. 1989. COMPSAC 89. Proceedings of the 13th Annual International , Sep. 20-22, 1989, pp. 250-256.

Affiliated with

Also associated with

Rating

Extended handling of ambiguous joins does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Extended handling of ambiguous joins, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Extended handling of ambiguous joins will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4275627