Oracle International Corporation

Martin Hogg

James Adam Steadman

Richard Stephen Grieve

Adam Chesney

Simon Leaver Lord

Suman Karmakar

Conor O'Neill

Stephen Vangasse

Paolo Fragapane

Natascha Kearsey

Steve Corbett

Christian Evans

Chris Evans

Paul Harry

Tony Barrett-Powell

Phil Bates

Geoffrey Weeks

Paul Davis

Joel Crisp

Adam Bloom

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 query generator is operable to generate a query for retrieving data that satisfy a conditional expression from a database, and/or perform an arbitrary calculation on at least part of the retrieved data. The query generator can receive an input query and analyze the query to ascertain whether it contains a replaceable token. If the query contains a replaceable token, the query generator can replace that token with user input specifying a parameter of the conditional expression and/or the arbitrary calculation, thereby generating an output query for retrieving the data that satisfy the conditional expression and/or performing the arbitrary calculation on the retrieved data.

Query generation

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

A method and system is provided for use in business intelligence and reporting. The method and system are able to implement one or more definable actions when presented with data. The data may be produced by a business intelligence application. The actions may relate to activities performed by a user or an agent. The system comprises an action manager, a repository, a data association manager and an implementation engine. In one embodiment a data mining engine is provided. The system enables the availability of an action in response to the execution of analytic queries to be determined based on a relationship defined by the data association manager. If an action is available, an action definition is used to invoke a target in response to selection of the action by an entity, the invocation of the target including propagating data produced by an analytic engine into the target based on metadata to perform the action.

Method and system for implementing definable actions

A method of retrieving data from any one of a plurality of data sources is disclosed. The data stored by each data source are arranged according to an associated data format. The method comprises: issuing a retrieval request for data stored on a designated one of the plurality of data sources to a control process; passing the retrieval request from the control process to the one a plurality of retrieval processes that is associated with the designated data source, said one of the retrieval processes retrieving the requested data from the designated data source and rearranging the retrieved data into a common output format, if it is not already in the common output format; and passing the data in the common output format to the control process.

Data retrieval method

Growing community of inventors

Nailsea, United Kingdom

Martin Hogg