公开(公告)号：US20060026212A1

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

申请号：US10903594

申请日：2004-07-29

申请人： Alex Tsukerman ,  Jane Chen ,  Jacco Draaijer ,  Eric Voss ,  Mineharu Takahara ,  Mark Ramacher

发明人： Alex Tsukerman ,  Jane Chen ,  Jacco Draaijer ,  Eric Voss ,  Mineharu Takahara ,  Mark Ramacher

IPC分类号： G06F17/30

CPC分类号： G06F17/30289 ,  Y10S707/99945 ,  Y10S707/99948

摘要： Various embodiments of the invention provide solutions to facilitate the management and/or automation of various database tasks, in particular system tasks. Merely by way of example, some embodiments provide methods systems and/or software products that can facilitate automation of such tasks. In accordance with certain embodiments, a maintenance window may be defined. The maintenance window can provide an opportunity for system tasks (and/or other tasks, especially those that consume significant database resources) to execute without significantly impacting the usability of the database. In particular embodiments, a maintenance window may be defined to coincide with a period of relatively low user activity. In some cases, a maintenance window may be implemented in conjunction with a job scheduler and/or a resource manager. Merely by way of example, a resource manager might allocate relatively more system and/or database resources to system tasks during the maintenance window, and/or a job scheduler may schedule system tasks to execute during the maintenance window.

摘要翻译： 本发明的各种实施例提供了便于各种数据库任务（特别是系统任务）的管理和/或自动化的解决方案。 仅仅作为示例，一些实施例提供了可以促进这些任务的自动化的方法系统和/或软件产品。 根据某些实施例，可以定义维护窗口。 维护窗口可以提供系统任务（和/或其他任务，特别是那些消耗大量数据库资源的任务）执行的机会，而不会显着影响数据库的可用性。 在特定实施例中，可以将维护窗口定义为与相对低的用户活动的周期相一致。 在某些情况下，可以结合作业调度器和/或资源管理器来实现维护窗口。 仅仅作为示例，资源管理器可以在维护窗口期间向系统任务分配相对更多的系统和/或数据库资源，和/或作业调度器可以调度在维护窗口期间执行的系统任务。

公开(公告)号：US07440973B2

公开(公告)日：2008-10-21

申请号：US10903594

申请日：2004-07-29

申请人： Alex Tsukerman ,  Jane Xin Chen ,  Jacco Draaller ,  Eric P. Voss ,  Mineharu Takahara ,  Mark Ramacher

发明人： Alex Tsukerman ,  Jane Xin Chen ,  Jacco Draaller ,  Eric P. Voss ,  Mineharu Takahara ,  Mark Ramacher

IPC分类号： G06F7/00

CPC分类号： G06F17/30289 ,  Y10S707/99945 ,  Y10S707/99948

摘要： Various embodiments of the invention provide solutions to facilitate the management and/or automation of various database tasks, in particular system tasks. Merely by way of example, some embodiments provide methods systems and/or software products that can facilitate automation of such tasks. In accordance with certain embodiments, a maintenance window may be defined. The maintenance window can provide an opportunity for system tasks (and/or other tasks, especially those that consume significant database resources) to execute without significantly impacting the usability of the database. In particular embodiments, a maintenance window may be defined to coincide with a period of relatively low user activity. In some cases, a maintenance window may be implemented in conjunction with a job scheduler and/or a resource manager. Merely by way of example, a resource manager might allocate relatively more system and/or database resources to system tasks during the maintenance window, and/or a job scheduler may schedule system tasks to execute during the maintenance window.

摘要翻译： 本发明的各种实施例提供了便于各种数据库任务（特别是系统任务）的管理和/或自动化的解决方案。 仅仅作为示例，一些实施例提供了可以促进这些任务的自动化的方法系统和/或软件产品。 根据某些实施例，可以定义维护窗口。 维护窗口可以提供系统任务（和/或其他任务，特别是那些消耗大量数据库资源的任务）执行的机会，而不会显着影响数据库的可用性。 在特定实施例中，可以将维护窗口定义为与相对低的用户活动的周期相一致。 在某些情况下，可以结合作业调度器和/或资源管理器来实现维护窗口。 仅作为示例，资源管理器可以在维护窗口期间向系统任务分配相对更多的系统和/或数据库资源，和/或作业调度器可以调度在维护窗口期间执行的系统任务。