发明授权
US5412806A Calibration of logical cost formulae for queries in a heterogeneous DBMS
using synthetic database
失效
使用合成数据库校正异构DBMS中查询的逻辑成本公式
- 专利标题: Calibration of logical cost formulae for queries in a heterogeneous DBMS using synthetic database
- 专利标题(中): 使用合成数据库校正异构DBMS中查询的逻辑成本公式
-
申请号: US932426申请日: 1992-08-20
-
公开(公告)号: US5412806A公开(公告)日: 1995-05-02
- 发明人: Weimin Du , Ravi Krishnamurthy , Ming-Chien Shan
- 申请人: Weimin Du , Ravi Krishnamurthy , Ming-Chien Shan
- 申请人地址: CA Palo Alto
- 专利权人: Hewlett-Packard Company
- 当前专利权人: Hewlett-Packard Company
- 当前专利权人地址: CA Palo Alto
- 主分类号: G06F12/00
- IPC分类号: G06F12/00 ; G06F17/30 ; G06F15/16 ; G06F15/403
摘要:
A programmable machine system and method for managing electronic data access among multiple different relational databases in a network distributed database environment. The machine is programmed so that it can construct cost-effective access strategies for any of the participating databases absent any DBMS-specific cost models. The system provides query optimization across different database management systems in a network distributed database environment based on a calibrating database relying only on typical relational database statistics and cost data is developed by running queries in the various databases against the calibrating database. A logical cost model is constructed using the resulting cost data and is used to estimate the cost of a given query based on logical characteristics of the DBMS, the relations, and the query itself. The cost of a complex query is estimated using primitive queries. Optimal query access strategies are thereby designed and used to control execution of the queries across relational databases controlled by two or more different database management systems.
公开/授权文献
- US5988995A Housings for miniature fans 公开/授权日:1999-11-23
信息查询