Oracle International Corporation

Dimitris Nakos

Lawrence J Ellison

Jay Rossiter

Ramkumar Venkataraman

Pari Bhaduri

Venkat Malla

Thivakaram Prakash Sivakumar

Niloy Banerjee

John John E So

Lalitha Ganti

Bala Kumaresan

Muthu Olagappan

Balasubramanyam Sthanikam

Todd Guay

Yuanjiang Ou

Jane Xin Chen

David Stowell

C Gregory Doherty

Srinivas Maturi

Harish Rawat

Joseph Therrattil Koonen

Gregory C Doherty

Techniques for making aggregated entries in a database table which aggregate information from other entries in tables in the database system. The techniques permit the aggregated entries to contain not only metric values aggregated from the other entries by techniques such as averaging in which the individual values are lost, but also sets of individual values from the other entries. One area of application for the techniques is the roll up tables used in the management systems for database management systems to reduce the size of historic information about events that have occurred in the database management system. Each roll up entry in a roll up table is an aggregated entry that contains information about some number of events. A roll up entry that uses the techniques contains a representation of a set whose values are the occurrence times of the events that are represented by the rollup record. Among the techniques that can be used to represent the set of occurrence times are a comma list of the occurrence times and a bit map which has a bit for each second in a day. Roll up entries that contain such representations of sets of occurrence times may be analyzed to determine whether occurrences of events are related, and if they are, the fact of the relationship can be used to design filters that can be applied in the roll up process, in error reporting, and in the analysis of the roll up tables.

Preserving sets of information in rollup tables

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.

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

Special purpose operating system for executing a database server

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

Growing community of inventors

Palo Alto, CA, United States of America

Dimitris Nakos