Techniques for managing a database system including one or more database servers

• US 7,035,840 B2
• Filed: 08/31/2001
• Issued: 04/25/2006
• 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., Venkataraman, Ramkumar, Ganti, Lalitha, Kumaresan, Bala, Banerjee, Niloy, Sivakumar, Thivakaram Prakash, Nakos, Dimitris
• Primary Examiner(s): ALAM, SHAHID AL
• Application Number:
  US09/945,438
• Publication Number:
  US 20020049744A1
• Time in Patent Office: 1,698 Days
• Field of Search: 707/2, 707/102, 707/103.R, 707/100, 707/10, 707/3, 705/7, 705/8, 705/10, 709/203, 709/220, 709/226, 709/224, 709/106, 709/219, 709/227, 717/104, 714/1, 714/4
• US Class Current: 1/1
• 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 method for managing a database system including one or more database servers, the method comprising the steps of:

executing, at a console, an integrated management module configured to manage at least two of the following layers in the database system;

a database application layer, a database server layer, an operating system layer, and a hardware layer; and

interacting with a user interface provided by said integrated management module to change operational parameters of said at least two layers.

2. The method of claim 1 wherein:

the database server layer includes one or more database servers;

the operating system layer includes one or more operating systems that reside on machines that are executing said database servers;

the integrated management module is configured to manage the one or more database servers and one or more operating systems; and

the step of interacting with the user interface provided by said integrated management module changes operational parameters of said one or more database servers and said one or more operating systems.

3. The method of claim 2 wherein:

the system includes one or more database clients;

said database clients are executing one or more database applications that comprise said database application layer; and

said integrated management module is further configured to manage said one or more database applications.

4. The method of claim 2 wherein:

at least one hardware subsystem is used to execute said one or more database servers; and

said integrated management module is further configured to manage said at least one hardware subsystem.

5. The method of claim 4 wherein said at least one hardware subsystem includes a RAID subsystem managed by said integrated management module.

6. The method of claim 2 wherein:

said one or more database servers reside on a local network; and

said console does not belong to said local network.

7. The method of claim 6 wherein the console is connected to a wide area network and said local network is connected to said wide area network, wherein said console manages said one or more database servers through messages communicated through said wide area network.

8. The method of claim 6 wherein the console manages said one or more database servers by messages sent over a dial up connection established between said console and said local network.

9. The method of claim 7 wherein said console manages said one or more database servers and said one or more operating systems by changing metadata stored in a centralized repository that resides on a device connected to said wide area network, wherein said metadata includes data that reflects configuration parameters of said one or more database servers and said one or more operating systems, wherein changes made to said metadata in said centralized repository are propagated over said wide area network to devices on said local network.