Optimizing access to a database by utilizing a star join

Data processing: database and file management or data structures – Database and file access – Query optimization

Reexamination Certificate

Rate now

  [ 0.00 ] – not rated yet Voters 0   Comments 0

Details

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.

LandOfFree

Say what you really think

Search LandOfFree.com for the USA inventors and patents. Rate them and share your experience with other people.

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

     

Profile ID: LFUS-PAI-O-4162891

  Search
All data on this website is collected from public sources. Our data reflects the most accurate information available at the time of publication.