发明授权
US07181461B2 System and method for real time statistics collection for use in the automatic management of a database system
失效
用于实时统计收集的系统和方法,用于数据库系统的自动管理
- 专利标题: System and method for real time statistics collection for use in the automatic management of a database system
- 专利标题(中): 用于实时统计收集的系统和方法,用于数据库系统的自动管理
-
申请号: US10223953申请日: 2002-08-19
-
公开(公告)号: US07181461B2公开(公告)日: 2007-02-20
- 发明人: Charles Roy Bonner , Namik Hrle , James Zu-Chia Teng
- 申请人: Charles Roy Bonner , Namik Hrle , James Zu-Chia Teng
- 申请人地址: US NY Armonk
- 专利权人: International Business Machines Corporation
- 当前专利权人: International Business Machines Corporation
- 当前专利权人地址: US NY Armonk
- 代理商 Samuel A. Kassatly
- 主分类号: G06F17/30
- IPC分类号: G06F17/30 ; G06F15/16 ; G06F17/00
摘要:
A computer program product provides accurate statistics in real time. These statistics can be used to determine if a table space in a database management system (DBMS) requires maintenance operations such as reorganization, back up, fresh access path statistics, and/or larger disk space allocation. The DBMS maintains a set of values that provide indications of whether that operation is due on that object. The indicators are asynchronously externalized in dedicated database tables either periodically in user-specified intervals or at some predefined event such as stopping the database. When the user performs a database administration operation, the database management system resets the associated indicators, and reports objects that are in an exception state based on the indicators collected as described for each operation.
公开/授权文献
信息查询