发明授权
US08271457B2 Database management system and method which monitors action results and adjusts user parameters in response
有权
数据库管理系统和方法,用于监视动作结果并调整用户参数
- 专利标题: Database management system and method which monitors action results and adjusts user parameters in response
- 专利标题(中): 数据库管理系统和方法,用于监视动作结果并调整用户参数
-
申请号: US09990770申请日: 2001-11-21
-
公开(公告)号: US08271457B2公开(公告)日: 2012-09-18
- 发明人: Melody Vos , Jeff Slavin
- 申请人: Melody Vos , Jeff Slavin
- 申请人地址: US TX Houston
- 专利权人: BMC Software, Inc.
- 当前专利权人: BMC Software, Inc.
- 当前专利权人地址: US TX Houston
- 主分类号: G06F7/00
- IPC分类号: G06F7/00 ; G06F17/00
摘要:
A system and method for automated database management are provided. Statistics relating to operation of a database may be collected, wherein the database comprises one or more database objects. Characteristics of the database objects may be determined, either automatically or by user intervention, using the collected statistics, one or more policies, and/or one or more definitions. The policies and definitions may be defaults or may be customized by a user. Actions to be performed on the database objects may be determined, either automatically or by user intervention, based on the characteristics of the database objects. A schedule for performing the actions on the database objects may be automatically determined. The actions may be performed on the database objects based on the schedule. The actions on the database objects may be confirmed. The results of the actions on the database objects may be analyzed or monitored. Policies and/or definitions may be reconfigured based on the results. The system and method may automatically decide to perform one or more REORG actions on the database objects based on the statistics. A recommendation of a modification to one or more of the database objects may be generated based on the statistics. The scheduled actions may be modified as a result of detecting a change in the characteristics or usage of at least one of the database objects.
公开/授权文献
信息查询