发明授权
- 专利标题： Optimizing access to a database by utilizing a star join
- 专利标题（中）： 通过利用星形连接来优化对数据库的访问
-
申请号： US11535615申请日： 2006-09-27
-
公开(公告)号： US07814094B2公开(公告)日： 2010-10-12
- 发明人: Grace Au , Bhashyam Ramesh , Haiyan Chen
- 申请人： Grace Au , Bhashyam Ramesh , Haiyan Chen
- 申请人地址： US OH Miamisburg
- 专利权人： Teradata US, Inc.
- 当前专利权人： Teradata US, Inc.
- 当前专利权人地址： US OH Miamisburg
- 主分类号： G06F7/00
- IPC分类号： G06F7/00 ; 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.
公开/授权文献
- US20070083490A1 OPTIMIZING ACCESS TO A DATABASE BY UTILIZING A STAR JOIN 公开/授权日：2007-04-12
信息查询
