Oracle International Corporation

Jay Rossiter

Pari Bhaduri

Yuanjiang Ou

Venkat Malla

Muthu Olagappan

Ramkumar Venkataraman

Jane Xin Chen

David Stowell

Thivakaram Prakash Sivakumar

Todd Guay

Lawrence J Ellison

Geoffrey Wilson

Jonathan Fredericks Soule

John John E So

Niloy Banerjee

Dimitris Nakos

Vipul Manubhai Shah

Lalitha Ganti

Yong Feng

C Gregory Doherty

Srinivas Maturi

Balasubramanyam Sthanikam

Gregory Scott Smith

Bala Kumaresan

Harish Rawat

Joseph Therrattil Koonen

Gregory C Doherty

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.

Pre-defined hardware and software bundle ready for database applications

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.

Database server with enhanced management and self-configuration features

Techniques for managing configuration for a system of devices arranged in a network

An intelligent approach for collecting statistical information in information systems generally involves performing a set of administrative function steps within a &ldquo;maintenance window&rdquo; that is defined by one or more specified time periods. First, a set of administrative function steps to be performed are identified. The set of administrative function steps is prioritized to produce a set of prioritized administrative function steps. Then, the set of prioritized administrative function steps is performed during the maintenance window. Aspects and features of the invention include: identifying and prioritizing administrative function steps; estimated function times and maintenance window; failure prediction; environment recommendations; history information and learning techniques; saving state and context information; and user feedback.

Approach for collecting statistical information in information systems

Special purpose operating system for executing a database server

A workload reduction mechanism for index tuning is described that selects relevant database statements from a database workload, standardizes a format of the relevant database statements and reduces the formatted, relevant database statements into a representative set of database statements. These statements may then be provided to an index tuning mechanism.

Workload reduction mechanism for index tuning

An intelligent approach for performing administrative functions generally involves performing a set of administrative function steps within a &ldquo;maintenance window&rdquo; that is defined by one or more specified time periods. First, a set of administrative function steps to be performed are identified. The set of administrative function steps is prioritized to produce a set of prioritized administrative function steps. Then, the set of prioritized administrative function steps is performed during the maintenance window. Aspects and features of the invention include: identifying and prioritizing administrative function steps; estimated function times and maintenance window; failure prediction; environment recommendations; history information and learning techniques; saving state and context information; and user feedback.

Approach for performing administrative functions in information systems

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

Growing community of inventors

Palo Alto, CA, United States of America

Jay Rossiter