# US 2004/0083197 A1 · Database management method and system

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2004/0083197 A1
- Document ID: US20040083197A1
- Status: Published application
- Kind: A1
- Application number: 10/424,882
- Filed: 2003-04-28
- Published: 2004-04-29
- Earliest claimed: 2002-10-25
- Assignees: Hitachi, Ltd.
- Inventors: Morihiro Iwata; Yoshitaka Tokusho; Kentaro Chigusa
- Web page: https://patentgrep.com/patent/US20040083197A1

## CPC

- G06F 16/217: {Database tuning (G06F16/2282 takes precedence; database performance monitoring G06F11/3409)}
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

A database management system that performs a first internal database operational management according to instruction information concerning the first database operational management. When a second database operational management additionally is performed by the database management system according to instruction information given from outside concerning the second database operational management, the database management system extracts information that includes a time range scheduled for executing the second database operational management. The database management system also extracts, from the first instruction information concerning the internal database operational management, operational management schedule information including a time range scheduled and a time range changeable for executing the first database operational management that is scheduled to be executed within the time range scheduled for executing the second database operational management, and determines, based on the operational management schedule information extracted, whether the time range scheduled for executing the first database operational management can be shifted outside the time range scheduled for executing the second database operational management.

## Claims

### Claim 1

A database operational management method for a database management system that performs a first database operational management according to instruction information concerning the first database operational management, the database operational management method comprising the steps of:
when a second database operational management additionally is performed, accepting instruction information concerning the second database operational management;
extracting information that includes a time range scheduled for executing the second database operational management;
extracting, from the instruction information concerning the first database operational management, operational management schedule information including a time range scheduled and a time range changeable for executing the first database operational management that is scheduled to be executed within the time range scheduled for executing the second database operational management; and
determining, based on the operational management schedule information extracted from the instruction information concerning the first database operational management, whether the time range scheduled for executing the first database operational management can be shifted outside the time range scheduled for executing the second database operational management.

### Claim 2 (depends on 1)

A database operational management method according to claim 1, wherein, when the first database operational management that is scheduled to be executed in the time range scheduled for executing the second database operational management does not exist, the second database operational management is executed in the time range scheduled for executing the second database operational management.

### Claim 3 (depends on 1)

A database operational management method according to claim 1, wherein, when the first database operational management that is scheduled to be executed in the time range scheduled for executing the second database operational management exists, and the time range scheduled for executing the first database operational management can be shifted outside the time range scheduled for executing the second database operational management, the time range scheduled for executing the first database operational management is shifted outside the time range scheduled for executing the second database operational management, and the second database operational management is executed in the time range scheduled for executing the second database operational management.

### Claim 4 (depends on 1)

A database operational management method according to claim 1, wherein, when the first database operational management that is scheduled to be executed in the time range scheduled for executing the second database operational management exists, and the time range scheduled for executing the first database operational management can be shifted outside the time range scheduled for executing the second database operational management, a notification is issued as output information in response to instruction information concerning the second database operational management to change the time range scheduled for executing the second database operational management.

### Claim 5

A database management system that performs a first database operational management according to instruction information concerning the first database operational management, comprising:
an operational management acceptance processing section that accepts information for a second database operational management instruction and extracts a time range scheduled for executing the second database operational management;
an operational management schedule information extraction processing section that extracts, from the instruction information concerning the first database operational management, operational management schedule information that includes the time range scheduled, as well as a time range changeable to, for executing the first database operational management;
an operational management time range shift determination processing section that, based on the operational management schedule information extracted from the instruction information concerning the first database operational management, determines whether the time range scheduled for executing the first database operational management can be shifted outside the time range scheduled for executing the second database operational management; and
an operational management time range change processing section that, when the first database operational management that is scheduled to be executed in the time range scheduled for executing the second database operational management exists, and the time range scheduled for executing the first database operational management can be shifted outside the time range scheduled for executing the second database operational management, shifts the time range scheduled for executing the first database operational management outside the time range scheduled for executing the second database operational management, and when the first database operational management that is scheduled to be executed in the time range scheduled for executing the second database operational management exists, and the time range scheduled for executing the first database operational management can be shifted outside the time range scheduled for executing the second database operational management, issues a notification as output information in response to the instruction information concerning the second database operational management to change the time range scheduled for executing the second database operational management.

### Claim 6

A database operational management method for a database management system that performs a first database operational management according to first instruction information, the database operational management method comprising the steps of:
accepting second instruction information concerning a second database operational management different from the first database operational management;
extracting information concerning a first time range scheduled for executing the first database operational management;
extracting information including a second time range scheduled for executing the second database operational management;
determining if the first time range interferes with the second time range; and
determining whether the first time range can be shifted outside the second time range.

### Claim 7 (depends on 6)

A database operational management method according to claim 6, wherein, when the first time range does not interfere with the second time range, the second database operational management is executed in the second time range.

### Claim 8 (depends on 6)

A database operational management method according to claim 6, wherein, when the first time range interferes with the second time range, and the first time range can be shifted outside the second time range, the first time range is shifted outside the second time range, and the second database operational management is executed in the second time range.

### Claim 9 (depends on 6)

A database operational management method according to claim 6, wherein, when the first time range interferes with the second time range, and the first time range can be shifted outside the second time range, a notification is issued as output information in response to the instruction information concerning the second database operational management to change the second time range scheduled for executing the second database operational management.

### Claim 10

A database operational management system that performs a first database operational management according to first instruction information, the database operational management system comprising:
a section that accepts second instruction information concerning a second database operational management different from the first database operational management;
a section that extracts information concerning a first time range scheduled for executing the first database operational management;
a section that extracts information including a second time range scheduled for executing the second database operational management;
a section that determines if the first time range interferes with the second time range; and
a section that determines whether the first time range can be shifted outside the second time range.

### Claim 11 (depends on 10)

A database operational management system according to claim 10, wherein, when the first time range does not interfere with the second time range, the second database operational management is executed in the second time range.

### Claim 12 (depends on 10)

A database operational management system according to claim 10, wherein, when the first time range interferes with the second time range, and the first time range can be shifted outside the second time range, the first time range is shifted outside the second time range, and the second database operational management is executed in the second time range.

### Claim 13 (depends on 10)

A database operational management system according to claim 10, wherein, when the first time range interferes with the second time range, and the first time range can be shifted outside the second time range, a notification is issued as output information in response to the instruction information concerning the second database operational management to change the second time range scheduled for executing the second database operational management.

### Claim 14

A database operational management system that performs a first database operational management according to first instruction information concerning the first database operational management, comprising:
a module that accepts second instruction information for a second database operational management and extracts a time range scheduled for executing the second database operational management;
a module that extracts from the first instruction information operational management schedule information that includes a time range scheduled and a time range changeable for executing the first database operational management; and
a module that, based on the operational management schedule information extracted from the first instruction information, determines whether the time range scheduled for executing the first database operational management can be shifted outside the time range scheduled for executing the second database operational management.

### Claim 15 (depends on 14)

A database operation management system according to claim 14, further comprising a time range changing module, when the first database operational management that is scheduled to be executed in a time range scheduled for executing the second database operational management does not exist, that executes the second database operational management in the time range scheduled for executing the second database operational management.

### Claim 16 (depends on 14)

A database operational management system according to claim 14, wherein, when the first database operational management that is scheduled to be executed in a time range scheduled for executing the second database operational management exists, and the time range scheduled for executing the first database operational management can be shifted outside the time range scheduled for executing the second database operational management, the time range changing module shifts the time range scheduled for executing the first database operational management outside the time range scheduled for executing the second database operational management, and the second database operational management is executed in the time range scheduled for executing the second database operational management.

### Claim 17 (depends on 14)

A database operational management system according to claim 14, wherein, when the first database operational management that is scheduled to be executed in the time range scheduled for executing the second database operational management exists, and the time range scheduled for executing the first database operational management can be shifted outside the time range scheduled for executing the second database operational management, the time range changing module issues a notification as output information in response to the second instruction information to change the time range scheduled for executing the second database operational management.

### Claim 18

A database operational management program for a database management system that performs a first database operational management according to first instruction information, the database operational management program comprising:
accepting second instruction information concerning a second database operational management different from the first database operational management;
extracting information concerning a first time range scheduled for executing the first database operational management;
extracting information including a second time range scheduled for executing the second database operational management;
determining if the first time range interferes with the second time range; and
determining whether the first time range can be shifted outside the second time range.

### Claim 19 (depends on 18)

A database operational management program according to claim 18, wherein, when the first time range does not interfere with the second time range, the second database operational management is executed in the second time range.

### Claim 20 (depends on 18)

A database operational management program according to claim 18, wherein, when the first time range interferes with the second time range, and the first time range can be shifted outside the second time range, the first time range is shifted outside the second time range, and the second database operational management is executed in the second time range.

### Claim 21 (depends on 18)

A database operational management program according to claim 18, wherein, when the first time range interferes with the second time range, and the first time range can be shifted outside the second time range, a notification is issued as output information in response to the instruction information concerning the second database operational management to change the second time range scheduled for executing the second database operational management.
