Invention Grant
US08688629B2 System maintenance and tuning of databases by using excess capacity in capacity controlled environment
有权
通过在容量受控环境中使用过剩容量来对数据库进行系统维护和调优
- Patent Title: System maintenance and tuning of databases by using excess capacity in capacity controlled environment
- Patent Title (中): 通过在容量受控环境中使用过剩容量来对数据库进行系统维护和调优
-
Application No.: US13285313Application Date: 2011-10-31
-
Publication No.: US08688629B2Publication Date: 2014-04-01
- Inventor: Louis Burger , Douglas P. Brown , Thomas P. Julien , Frank Roderic Vandervort
- Applicant: Louis Burger , Douglas P. Brown , Thomas P. Julien , Frank Roderic Vandervort
- Applicant Address: US OH Dayton
- Assignee: Teradata US, Inc.
- Current Assignee: Teradata US, Inc.
- Current Assignee Address: US OH Dayton
- Agent Ramin Mahboubian
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
Excess capacity available to a database system in a capacity controlled environment can be effectively managed for maintenance and/or tuning activities. In this context, excess capacity can be used as needed and/or on a temporary basis. Furthermore, maintenance and/or tuning activities can be performed without requiring the use of the configured or allotted capacity. As a result, these operations can be performed without adversely affecting other operations which may be deemed more critical by the users of databases. System maintenance and tuning (or fine tuning) of a database environment can, for example, include operations associated with “Physical Tuning,” and “Index Tuning”. Some exemplary operations include collecting Statistics, analyzing a database workload, sampling, analyzing an execution plan, creating indexes.
Public/Granted literature
- US20130085986A1 SYSTEM MAINTENANCE AND TUNING OF DATABASES BY USING EXCESS CAPACITY IN CAPACITY CONTROLLED ENVIRONMENT Public/Granted day:2013-04-04
Information query