Database server with enhanced management and self-configuration features

• US 7,383,287 B2
• Filed: 08/23/2002
• Issued: 06/03/2008
• Est. Priority Date: 01/29/1999
• Status: Expired due to Term

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: So, John John E., Ganti, Lalitha, Ellison, Lawrence J., Maturi, Srinivas, Doherty, C. Gregory, Ou, Yuanjiang, Malla, Venkat, Banerjee, Niloy, Rossiter, Jay, Bhaduri, Pari
• Primary Examiner(s): MIZRAHI, DIANE D
• Application Number:
  US10/226,461
• Publication Number:
  US 20030023603A1
• Time in Patent Office: 2,111 Days
• Field of Search: 707 1- 10, 707100-205, 709/222, 709/240, 378/207, 370/257, 713/155
• US Class Current: 707/609
• CPC Class Codes: G06F 16/21 Design, administration or maintenance of databases
• CPC Class Codes: G06F 8/70 Software maintenance or management
• CPC Class Codes: G06F 9/46 Multiprogramming arrangements
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99953 Recoverability

Abstract

A database system that incorporates numerous features that reduce the total cost of maintaining the database system is provided. That database system includes a database appliance that executes a database server on a platform that includes a special purpose operating system specifically tailored to the services required by the database server. The database appliance configures itself by detecting the environment in which it resides and setting operational parameters based on the detected environment. The configuration metadata of all components of the system are stored in a centralized repository which itself may reside external to the system. Both the database server configuration and the operating system configuration are managed by a remotely located integrated management console, which interacts with and configures the system at the database system level, the operating system level and, optionally, at the hardware subsystem level. Backup management may also be performed remotely. The remote components, such as the integrated management console, the backup server, and the configuration repository, may communicate with the system through a wide area network, such as the Internet, or directly through a dial-up connection.

Claims

1. A database appliance comprising:

a database server that includes self configuration software that automatically;

detects an amount of resources that are available at a particular installation of the database appliance; and

changes one or more parameters of the database server based upon the amount of resources that are detected.

2. A database appliance comprising:

a database server;

a special purpose operating system whose features and configuration are dictated by the database server and supporting components; and

a management agent for dynamically changing parameters associated with said database server and said operating system.

3. A database appliance comprising:

a database server; and

an operating system;

wherein the database server includes self configuration software that automatically;

detects an amount of resources that are available at a particular installation of the database appliance; and

changes one or more parameters of the operating system based upon the amount of resources that are detected.

4. A database appliance comprising:

a database server; and

hardware for executing the database server;

wherein the database server includes self configuration software that automatically;

detects an amount of resources that are available at a particular installation of the database appliance; and

changes one or more parameters of the hardware based upon the amount of resources that are detected.

5. A computer implemented method, comprising:

a software component automatically detecting an amount of resources that are available at a particular installation of a database appliance, said database appliance comprising a database server, said database server including said software component as self configuration software; and

said software component changing one or more parameters of the database server based upon the amount of resources that are detected.

9. A computer-readable storage medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 5.

6. A computer implemented method comprising:

a management agent dynamically changing parameters associated with a database server and a special purpose operating system whose features and configuration are dictated by the database server and supporting components; and

wherein a database appliance comprises said database server and said special purpose operating system.

10. A computer-readable storage medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 6.

7. A computer implemented method, comprising:

a software component automatically detecting an amount of resources that are available at a particular installation of a database appliance, said database appliance comprising a database server and an operating system, said database server including said software component as self configuration software; and

said software component changing one or more parameters of the operating system based upon the amount of resources that are detected.

11. A computer-readable storage medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 7.

8. A computer implemented method comprising:

a software component automatically detecting an amount of resources that are available at a particular installation of a database appliance, said database appliance comprising a database server and hardware for executing said database server, said database server including said software component as self configuration software; and

said software component changing one or more parameters of the hardware based upon the amount of resources that are detected.

12. A computer-readable storage medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 8.