公开(公告)号：US20050160074A1

公开(公告)日：2005-07-21

申请号：US11058775

申请日：2005-02-16

申请人： Melody Vos ,  Jeff Slavin

发明人： Melody Vos ,  Jeff Slavin

IPC分类号： G06F7/00 ,  G06F11/34 ,  G06F17/30

CPC分类号： G06F17/30306 ,  G06F17/30442 ,  G06F2201/80 ,  G06F2201/86 ,  Y10S707/955 ,  Y10S707/99942 ,  Y10S707/99943 ,  Y10S707/99944 ,  Y10S707/99945 ,  Y10S707/99948

摘要： 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.

公开(公告)号：US09037536B2

公开(公告)日：2015-05-19

申请号：US11928730

申请日：2007-10-30

申请人： Melody Vos ,  Jeff Slavin

发明人： Melody Vos ,  Jeff Slavin

IPC分类号： G06F17/00 ,  G06F17/30

CPC分类号： G06F17/30306 ,  G06F17/30442 ,  G06F2201/80 ,  G06F2201/86 ,  Y10S707/955 ,  Y10S707/99942 ,  Y10S707/99943 ,  Y10S707/99944 ,  Y10S707/99945 ,  Y10S707/99948

摘要： 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.

摘要翻译： 提供了一种用于自动化数据库管理的系统和方法。 可以收集与数据库的操作有关的统计数据，其中数据库包括一个或多个数据库对象。 数据库对象的特征可以通过使用收集的统计信息，一个或多个策略和/或一个或多个定义来自动地或通过用户干预来确定。 策略和定义可以是默认值，也可以由用户定制。 可以基于数据库对象的特性，自动地或通过用户干预来确定要对数据库对象执行的操作。 可以自动确定用于对数据库对象执行动作的调度。 可以基于日程表对数据库对象执行动作。

公开(公告)号：US08271457B2

公开(公告)日：2012-09-18

申请号：US09990770

申请日：2001-11-21

申请人： Melody Vos ,  Jeff Slavin

发明人： Melody Vos ,  Jeff Slavin

IPC分类号： G06F7/00 ,  G06F17/00

CPC分类号： G06F17/30306 ,  G06F17/30442 ,  G06F2201/80 ,  G06F2201/86 ,  Y10S707/955 ,  Y10S707/99942 ,  Y10S707/99943 ,  Y10S707/99944 ,  Y10S707/99945 ,  Y10S707/99948

摘要： 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.

摘要翻译： 提供了一种用于自动化数据库管理的系统和方法。 可以收集与数据库的操作有关的统计数据，其中数据库包括一个或多个数据库对象。 数据库对象的特征可以通过使用收集的统计信息，一个或多个策略和/或一个或多个定义来自动地或通过用户干预来确定。 策略和定义可以是默认值，也可以由用户定制。 可以基于数据库对象的特性，自动地或通过用户干预来确定要对数据库对象执行的操作。 可以自动确定用于对数据库对象执行动作的调度。 可以基于日程表对数据库对象执行动作。 可以确认对数据库对象的操作。 可以分析或监视对数据库对象的操作的结果。 可以基于结果重新配置策略和/或定义。 系统和方法可以根据统计信息自动决定对数据库对象执行一个或多个REORG动作。 可以基于统计信息来生成对一个或多个数据库对象的修改的建议。 作为检测到数据库对象中的至少一个的特性或使用的变化的结果，调度动作可以被修改。

公开(公告)号：US06996576B2

公开(公告)日：2006-02-07

申请号：US09991561

申请日：2001-11-21

申请人： Melody Vos ,  Jeff Slavin

发明人： Melody Vos ,  Jeff Slavin

IPC分类号： G06F17/30

CPC分类号： G06F17/30306 ,  G06F17/30442 ,  G06F2201/80 ,  G06F2201/86 ,  Y10S707/955 ,  Y10S707/99942 ,  Y10S707/99943 ,  Y10S707/99944 ,  Y10S707/99945 ,  Y10S707/99948

摘要： 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.

公开(公告)号：US06944630B2

公开(公告)日：2005-09-13

申请号：US09990583

申请日：2001-11-21

申请人： Melody Vos ,  Jeff Slavin

发明人： Melody Vos ,  Jeff Slavin

IPC分类号： G06F7/00 ,  G06F11/34 ,  G06F17/30

CPC分类号： G06F17/30306 ,  G06F17/30442 ,  G06F2201/80 ,  G06F2201/86 ,  Y10S707/955 ,  Y10S707/99942 ,  Y10S707/99943 ,  Y10S707/99944 ,  Y10S707/99945 ,  Y10S707/99948

摘要： 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.

摘要翻译： 提供了一种用于自动化数据库管理的系统和方法。 可以收集与数据库的操作有关的统计数据，其中数据库包括一个或多个数据库对象。 数据库对象的特征可以通过使用收集的统计信息，一个或多个策略和/或一个或多个定义来自动地或通过用户干预来确定。 策略和定义可以是默认值，也可以由用户定制。 可以基于数据库对象的特性，自动地或通过用户干预来确定要对数据库对象执行的操作。 可以自动确定用于对数据库对象执行动作的调度。 可以基于日程表对数据库对象执行动作。 可以确认对数据库对象的操作。 可以分析或监视对数据库对象的操作的结果。 可以基于结果重新配置策略和/或定义。 系统和方法可以根据统计信息自动决定对数据库对象执行一个或多个REORG动作。 可以基于统计信息来生成对一个或多个数据库对象的修改的建议。 作为检测到数据库对象中的至少一个的特性或使用的变化的结果，调度动作可以被修改。

公开(公告)号：US07302449B2

公开(公告)日：2007-11-27

申请号：US11058775

申请日：2005-02-16

申请人： Melody Vos ,  Jeffrey D Slavin

发明人： Melody Vos ,  Jeffrey D Slavin

IPC分类号： G06F17/00

CPC分类号： G06F17/30306 ,  G06F17/30442 ,  G06F2201/80 ,  G06F2201/86 ,  Y10S707/955 ,  Y10S707/99942 ,  Y10S707/99943 ,  Y10S707/99944 ,  Y10S707/99945 ,  Y10S707/99948

摘要： 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.

摘要翻译： 提供了一种用于自动化数据库管理的系统和方法。 可以收集与数据库的操作有关的统计数据，其中数据库包括一个或多个数据库对象。 数据库对象的特征可以通过使用收集的统计信息，一个或多个策略和/或一个或多个定义来自动地或通过用户干预来确定。 策略和定义可以是默认值，也可以由用户定制。 可以基于数据库对象的特性，自动地或通过用户干预来确定要对数据库对象执行的操作。 可以自动确定用于对数据库对象执行动作的调度。 可以基于日程表对数据库对象执行动作。 可以确认对数据库对象的操作。 可以分析或监视对数据库对象的操作的结果。 可以基于结果重新配置策略和/或定义。 系统和方法可以根据统计信息自动决定对数据库对象执行一个或多个REORG动作。 可以基于统计信息来生成对一个或多个数据库对象的修改的建议。 作为检测到数据库对象中的至少一个的特性或使用的变化的结果，调度动作可以被修改。