发明授权
US06370522B1 Method and mechanism for extending native optimization in a database system
有权
在数据库系统中扩展本机优化的方法和机制
- 专利标题: Method and mechanism for extending native optimization in a database system
- 专利标题(中): 在数据库系统中扩展本机优化的方法和机制
-
申请号: US09272691申请日: 1999-03-18
-
公开(公告)号: US06370522B1公开(公告)日: 2002-04-09
- 发明人: Nipun Agarwal , Dinesh Das , Viswanathan Krishnamurthy , Ravi Murthy , Anil Nori , Jagannathan Srinivasan
- 申请人: Nipun Agarwal , Dinesh Das , Viswanathan Krishnamurthy , Ravi Murthy , Anil Nori , Jagannathan Srinivasan
- 主分类号: G06F1730
- IPC分类号: G06F1730
摘要:
A method and system for optimizing the execution of database statement is described. An aspect is related to providing a framework for the creation, association, and use of optimizer-related functions to calculate the cost of execution plans involving non-native database entities. Examples of these optimizer-related functions include selectivity, statistics, and costs functions. Another aspect is related to the optimization of database statements having non-boolean predicates. Yet another aspect is related to the determination and use of different granularity levels of information for submitting database statement predicates to optimizer-related functions. Optimizer-related functions can also be defined for system-supplied objects and entities.
信息查询