Oracle International Corporation

Robert Lloyd Lavender

Stephen D Cave

Andrew P Osborn

Paolo Fragapane

James Adam Steadman

Jeremy Ashley

Richard Stephen Grieve

Kathryn Nash

Natascha Kearsey

Paul Philip Brickell

James Lear

The present invention relates to a query generator for generating a query for obtaining selected data from a database. The query generator includes a processor which is adapted to receive an input indicating the selected data to be obtained. The processor then analyses the input to determine whether the input requires a joining of data in different tables, and an aggregation step. If so, the processor generates a query which causes the database to aggregate the data within each of the tables as required; and, join the aggregated data, the joined aggregated data representing the selected data.

Query generator

The present invention relates to a repository which stores properties of database objects. The repository includes a first store for storing a number of predetermined properties, and a second store for storing additional properties. A processor is provided for determining or modifying the properties stored in the first and second stores.

Property extensions

Method for retrieving data from a database

The present invention relates to apparatus for creating summaries of a database. The apparatus includes a processor which is adapted to monitor the usage of the database and, determine one or more summaries in accordance with the usage.

Summary creation

The present invention relates to a user interface control for controlling the value of a variable in a processing system. The user interface control includes, a display, an input device and a processor. The processor is adapted to cooperate with the display and the input device to generate an input representation on the display, the input representation allowing the value of the variable to be specified by the user using the input device. The processor then generates a graphical representation on the display, the graphical representation showing a relationship between the variable and a parameter. Finally, the processor generates an indicator on the display, the indicator indicating a value of the parameter for the value of the variable specified using the input representation.

User interface

A self monitoring system that identifies optimum summary table(s) for use by a database management system, and that automatically creates or deletes summary tables based on selected summary table recommendations.

Summary table management in a computer system

Methods and apparatus for effective and efficient usage of summary tables in a computer system including a database. In a computer system it is common for a database to include one or more summary tables which have pre-generated aggregations of data from one or more original, detailed database tables. In order to achieve the benefits of summary tables, they must be accessed when appropriate. Thus, information regarding the available summary database tables, including summary bitmaps for all the summary tables, is maintained in the metadata of a computer system. This information is updated whenever a summary table is created. The summary bitmaps are a main key for determining if any summary table is responsive to a user query to the computer system. The summary bitmaps map to corresponding SQL statements, which are generated to access the respective summary tables in the database. Once an SQL statement for accessing a respective summary table is identified for a particular user query, that SQL statement is then incorporated in the executable SQL query that is thereafter executed.

Growing community of inventors

Nr Wedmore, United Kingdom

Robert Lloyd Lavender