发明公开
- 专利标题: Provision of access paths to data within a database
- 专利标题(中): 提供到文件的路径访问数据库
-
申请号: EP04007174.8申请日: 2004-03-25
-
公开(公告)号: EP1580668A1公开(公告)日: 2005-09-28
- 发明人: Klosterhalfen, Jörg
- 申请人: Software Engineering GmbH
- 申请人地址: Robert-Stolz-Strasse 5 40470 Düsseldorf DE
- 专利权人: Software Engineering GmbH
- 当前专利权人: Software Engineering GmbH
- 当前专利权人地址: Robert-Stolz-Strasse 5 40470 Düsseldorf DE
- 代理机构: Cohausz & Florack
- 主分类号: G06F17/30
- IPC分类号: G06F17/30
摘要:
The invention relates to a method for providing access paths to data within a database, in particular using REBIND for DB2, wherein real time database statistics are determined using a database integrated monitor, wherein the database statistics are output substantially in real time using said database integrated status monitor, and wherein said database statistics from said integrated monitor are used to initiate generation of data set statistics, and to determine said access paths. To allow efficient generation of access paths, the following steps are proposed: determining from said database statistics a total number of rows of at least one data set of said database, comparing said determined total number of rows with a first threshold value, deciding solely based on said total number of rows to provide a database catalogue with said data set statistics in case said total number of rows reaches said threshold value, and determining said access paths to said data based on said data set statistics within said database catalogue.
公开/授权文献
- EP1580668B1 Provision of access paths to data within a database 公开/授权日:2007-12-26
信息查询