发明名称 |
OPTIMIZING ACCESS TO A DATABASE BY UTILIZING A STAR JOIN |
摘要 |
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.
|
申请公布号 |
US2007083490(A1) |
申请公布日期 |
2007.04.12 |
申请号 |
US20060535615 |
申请日期 |
2006.09.27 |
申请人 |
AU GRACE;RAMESH BHASHYAM;CHEN HAIYAN |
发明人 |
AU GRACE;RAMESH BHASHYAM;CHEN HAIYAN |
分类号 |
G06F17/30 |
主分类号 |
G06F17/30 |
代理机构 |
|
代理人 |
|
主权项 |
|
地址 |
|