Optimizing access to a database by utilizing a star join

Details Optimizing access to a database by utilizing a star join Optimizing access to a database by utilizing a star join

2006-09-27

2010-10-12

Le, Uyen T. (Department: 2163)

Data processing: database and file management or data structures

Database and file access

Query optimization

Reexamination Certificate

active

07814094

ABSTRACT:
A database query is optimized for a star database schema that includes at least one fact table and at least one dimension table, where the database query includes an IN-List condition. During optimization, the IN-List is transformed into a relation and the relation is joined with the dimension table to produce a join result. The join result is then joined to the fact table.

REFERENCES:
patent: 5848408 (1998-12-01), Jakobsson et al.
patent: 5963932 (1999-10-01), Jakobsson et al.
patent: 6397204 (2002-05-01), Liu et al.
patent: 6629102 (2003-09-01), Malloy et al.
Andreas Weininger, “Efficient execution of joins in a star schema”, ACM SIGMOD 2002, pp. 542-545.

Affiliated with

Also associated with

Rating

Optimizing access to a database by utilizing a star join does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Optimizing access to a database by utilizing a star join, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Optimizing access to a database by utilizing a star join will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4162891