发明申请
- 专利标题： DATABASE OPTIMIZATION APPARATUS AND METHOD
- 专利标题（中）： 数据库优化装置和方法
-
申请号： US11277229申请日： 2006-03-22
-
公开(公告)号： US20060155675A1公开(公告)日： 2006-07-13
- 发明人: Jeremy Arnold , Eric Barsness , Richard Dettinger , John Santosuosso
- 申请人： Jeremy Arnold , Eric Barsness , Richard Dettinger , John Santosuosso
- 申请人地址： US NY Armonk
- 专利权人： International Business Machines Corporation
- 当前专利权人： International Business Machines Corporation
- 当前专利权人地址： US NY Armonk
- 主分类号： G06F17/30
- IPC分类号： G06F17/30
摘要：
A database optimizer collects statistics regarding applications accessing a database, and makes one or more changes to the database schema to optimize performance according to the collected statistics. In a first embodiment, the optimizer detects when a certain type of application accesses the database a percentage of time that exceeds a predefined threshold level, and if the data in the database is stored in a less-than-optimal format for the application, the data type of one or more columns in the database is changed to a more optimal format for the application. In a second embodiment, the optimizer detects when one type of application accesses a column a percentage of time that exceeds a first predefined threshold level and is less than a second predefined threshold level, and creates a new column in the database so the data is present in both formats.