Oracle International Corporation

James Adam Steadman

Richard Stephen Grieve

Paolo Fragapane

Martin Hogg

Adam Chesney

Suman Karmakar

Stephen Vangasse

Simon Leaver Lord

Conor O'Neill

Andrew P Osborn

Robert Lloyd Lavender

Stephen D Cave

Suresh Mali

Christopher Evans

Ashish Mittal

Jeremy Ashley

Kathryn Nash

Mike Durran

Paul Philip Brickell

Geemon Kadambalil Baby

Mahesh Jayashankar

Jitendra Dhamija

A computing device can automatically generate a flow diagram showing statuses that objects in a system can possess, and the possible transitions between these statuses. Using snapshots of database data, the device can determine how the statuses of these objects have changed over time. The device can analyze the data to suggest which database fields likely represent object status. The device can render the flow diagram to illustrate system states at different selected times. Each rendered flow diagram can indicate, for the selected time point, the quantity of objects that possessed each status at that time, and, for a selected time interval, the quantity of objects that changed from each status to each other status during that time interval. The statuses can be represented in the flow diagram as status bubbles having sizes that are based on the quantities of objects having those bubble's statuses at the selected time point.

Flow fields

Flow state totals and auto flow warehousing

A computing device can automatically generate a flow diagram showing statuses that objects in a system can possess, and the possible transitions between these statuses. Using snapshots of database data, the device can determine how the statuses of these objects have changed over time. The device can analyze the data to suggest which database fields likely represent object status. The device can render the flow diagram to illustrate system states at different selected times. Each rendered flow diagram can indicate, for the selected time point, the quantity of objects that possessed each status at that time, and, for a selected time interval, the quantity of objects that changed from each status to each other status during that time interval. The statuses can be represented in the flow diagram as status bubbles having sizes that are based on the quantities of objects have those bubble's statuses at the selected time point.

Flow pipe totals

Auto draw flow

Facilitating identification of star schemas in database environments. In an embodiment, queries directed to relational database tables (organized according to normalized schema) are examined to determine the relationships specified in the queries. A star schema is then generated by including the specified relationships. A data warehouse may be organized according to the generated star schema and the data previously stored in the database tables may be copied to the data warehouse.

Facilitating identification of star schemas in database environments

A query generator for generating a query for retrieving data from a database comprising at least one table is disclosed. The query refers to one or more data items in a first view defined to expose a portion of the database and to one or more data items that are not exposed by the first view, at least one of which has an associated reach through flag set thereby defining it as a reach through item. The query generator is adapted to: receive user input indicating selected items to be retrieved from the database; ascertain whether any of the selected items that are not exposed by the first view are defined as reach through items; and, if so: create a second view that is a copy of the first view and add a copy of each reach through item to it; and create a query that refers only to the second view and the items exposed by it.

Query generator

A method of rewriting a Structured Query Language (SQL) statement in order to prevent processing of a join between a master table and a detail table in a database is disclosed. The method includes determining in the SQL statement a unique identifier to a row of the master table. The unique identifier is then equated to an identifier to related rows of the detail table using the join condition. A revised SQL statement may then be produced that only refers to the detail table using the identifier to the rows of the detail table. Subsequently, the revised SQL statement is processed.

SQL predicate migration

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

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

Growing community of inventors

Bradlow Ledbury, United Kingdom

James Adam Steadman