Database appliance comprising hardware and software bundle configured for specific database applications

• US 6,487,547 B1
• Filed: 01/29/1999
• Issued: 11/26/2002
• Est. Priority Date: 01/29/1999
• Status: Expired due to Term

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle Corporation
• Inventors: Doherty, Gregory C., Malla, Venkat, Rossiter, Jay, Ellison, Lawrence J., Bhaduri, Pari, Nakos, Dimitris
• Primary Examiner(s): Alam, Hosain T.
• Application Number:
  US09/240,229
• Time in Patent Office: 1,397 Days
• Field of Search: 707/2, 707/3, 707/1, 707/10, 709/104, 709/106, 709/221, 709/223-224, 709/226
• US Class Current: 707/600
• 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 special purpose operating system; and

a special purpose database server;

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

wherein the special purpose database server is specially adapted based upon the services required by a specific database application;

wherein said specific database application is one of an online transaction processing application and an online analytical processing application;

wherein said database appliance is configured with an amount of resources dedicated to I/O services that is based upon whether said specific database application is an online transaction processing application or an online analytical processing application; and

wherein said database appliance is configured with an amount of resources dedicated to computational services that is based upon whether said specific database application is an online transaction processing application or an online analytical processing application.

2. The database appliance of claim 1 wherein said specific database application is an online transaction processing application and said database appliance is configured with relatively more resources dedicated to I/O services and relatively fewer resources dedicated to computational services.