Pre-defined hardware and software bundle ready for database applications

• US 7,752,164 B2
• Filed: 01/21/2004
• Issued: 07/06/2010
• 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: Olagappan, Muthu, Chen, Jane, Ou, Yuanjiang, Venkataraman, Ramkumar, Rossiter, Jay, Bhaduri, Pari, Sivakumar, Thivakaram Prakash, Stowell, David
• Primary Examiner(s): ALAM, SHAHID AL
• Application Number:
  US10/762,949
• Publication Number:
  US 20040153438A1
• Time in Patent Office: 2,358 Days
• Field of Search: 707/1, 707/2, 707/3, 707/10, 707/100, 707/200, 707/103.R, 707/104.1, 709/106, 709/203, 709/220, 709/224, 711/150
• US Class Current: 707/603
• 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. The 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 hardware may also be specially tailored to the services required by the database server. The database sever may be generated from another database server by modifying the code of the other database server optimize the code for execution on said database appliance. According to another aspect, the database appliance includes an operating system and a database server generated from another database server by modifying the code of the other database server optimize the code for execution on said database appliance.

Claims

1. A database appliance, comprising:

a database server;

a special purpose operating system having a set of components that include some, but not all, components of a general purpose operating system, whose configuration is dictated based on a set of services required by the database server; and

a self-configuration module that is capable of performing the steps of;

detecting an environment in which the database appliance is being used; and

configuring the database appliance based upon the detected environment;

wherein the database server is 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 type of database usage;

wherein said type of database usage is one of an online transaction processing application or an online analytical processing application;

wherein said database appliance is configured with an amount of resources dedicated to I/O services that is based on whether said specific type of database usage 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 type of database usage is an online transaction processing application or an online analytical processing application.

2. The database appliance of claim 1, wherein the database server was generated from another database server by modifying the code of the other database server to optimize the code for execution on said database appliance.

3. The database appliance of claim 1, wherein the hardware for said database appliance is selected and configured to optimize performance of one or more services to be performed by the database server.

4. The database appliance of claim 1, wherein the hardware for said database appliance is selected and configured to optimize a cache hit ratio experienced by the database appliance.

5. The database appliance of claim 1, wherein the special purpose operating system performs process scheduling based on shares of CPU time.

6. The database appliance of claim 1, wherein the special purpose operating system employs a microkernel and an associated service module.

7. The database appliance of claim 1, wherein the database server includes a mechanism for reading resource information within an address space of a kernel of the operating system without causing a context switch to the operating system kernel address space.

8. The database appliance of claim 1, wherein said specific type of database usage 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.

9. The database appliance of claim 1, wherein the step of modifying the general purpose operating system includes adding one or more features to the general purpose operating system, and wherein the one or more features are used to provide said set of services to the database server.

10. A method for constructing a database appliance, comprising:

installing, on a computer readable medium accessible to one or more processors, a database server;

generating a set of components of a special purpose operating system by removing one or more features of a general purpose operating system that are not required to provide a set of services required by the database server; and

installing, on the computer readable medium, the special purpose operating system;

wherein the set of components include some, but not all, components of the general purpose operating system;

wherein configuration of the special purpose operating system is dictated based on the set of services.

11. The method of claim 10, wherein the database server was generated from another database server by modifying the code of the other database server to optimize the code for execution on said database appliance.

12. The method of claim 10, wherein the hardware for said database appliance is selected and configured to optimize performance of one or more services to be performed by the database server.

13. The method of claim 10, wherein the hardware for said database appliance is selected and configured to optimize a cache hit ratio experienced by the database appliance.

14. The method of claim 10, wherein the database server is 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, and wherein the special purpose database server is specially adapted based upon the services required by a specific type of database usage.

15. The method of claim 14, wherein said type of database usage 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 on whether said specific type of database usage 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 type of database usage is an online transaction processing application or an online analytical processing application.

16. The method of claim 14, wherein said specific type of database usage 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.

17. The method of claim 10, wherein the special purpose operating system performs process scheduling based on shares of CPU time.

18. The method of claim 10, wherein the method further comprises:

installing on the computer readable medium a self-configuration module that is capable of performing the steps of;

detecting an environment in which the database appliance is being used; and

configuring the database appliance based upon the detected environment.

19. The method of claim 10, wherein the special purpose operating system employs a microkernel and an associated service module.

20. The method of claim 10, wherein the database server includes a mechanism for reading resource information within an address space of a kernel of the operating system without causing a context switch to the operating system kernel address space.

21. The method of claim 10, wherein the step of modifying the general purpose operating system includes adding one or more features to the general purpose operating system, and wherein the one or more features are used to provide said set of services to the database server.