发明申请
- 专利标题： OPTIMIZING ACCESS TO A DATABASE BY UTILIZING A STAR JOIN
- 专利标题（中）： 通过利用STAR加入优化访问数据库
-
申请号： US11535615申请日： 2006-09-27
-
公开(公告)号： US20070083490A1公开(公告)日： 2007-04-12
- 发明人: Grace Au , Bhashyam Ramesh , Haiyan Chen
- 申请人： Grace Au , Bhashyam Ramesh , Haiyan Chen
- 主分类号： G06F17/30
- IPC分类号： G06F17/30
摘要：
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.
公开/授权文献
- US07814094B2 Optimizing access to a database by utilizing a star join 公开/授权日：2010-10-12
信息查询
