发明授权
- 专利标题: System and method for rewriting relational database queries
- 专利标题(中): 用于重写关系数据库查询的系统和方法
-
申请号: US09654208申请日: 2000-09-01
-
公开(公告)号: US06629094B1公开(公告)日: 2003-09-30
- 发明人: Latha S. Colby , Richard L. Cole , Edward P. Haslam , Nasi Jazayeri , Galt Johnson , William McKenna , Lee E. Schumacher , David G. Wilhite, Jr.
- 申请人: Latha S. Colby , Richard L. Cole , Edward P. Haslam , Nasi Jazayeri , Galt Johnson , William McKenna , Lee E. Schumacher , David G. Wilhite, Jr.
- 主分类号: G06F1730
- IPC分类号: G06F1730
摘要:
A system and method for answering a relational database query is presented. According to an embodiment of the present invention, a database query is received. It is then determined whether that query can be rewritten in such a manner as to be able to utilize a precomputed view, such that an answer to the rewritten query is equivalent to an answer to the original query. If the query can be rewritten, it is determined whether the rewritten query can more efficiently derive the answer than the original query. The query which has the most efficiently derived answer is the query which is utilized to derive that answer.
信息查询