Oracle International Corporation

Prashant Singh

Hugh Zhang

Jairam Ramanathan

Yi Dai

Rasika Vaidya Kaura

Henrik Michael Ammer

Brendon Charles Glazer

David Kamholz

Jindrich Dinga

Pangus Ho

Chun-Yi Chen

Julian Challenger

Sally Stratton Baggett

Lulit Bezuayehu

Gary Look

Kevin Chow

Teck Hua Lee

Aylin Uysal

Mark Robertson

Brandon Yoshimoto

Peter Budavari

Mary E G Bear

Diar Ahmed

Amy Christine Wilson

Tamika Tannis

Melinda Tang

Bret Hekking

Lory Dean Molesky

Kris L Hanson

Aaron Green

Ritchard Shadian

Baofeng Yu

Aylin Ulysal

Techniques for modifying queries in a set of nested queries are disclosed. A graphical user interface displays a query detail region alongside a nested query display region. The graphical user interface includes functionality to provide for modification of queries in the nested set of queries. Based on a selection by a user, a query modification tool promotes a query attribute from a child query to one or more parent queries. Based on another selection by a user associated with one query in the set of nested queries, the system deletes an attribute from each query in the set of nested queries. Responsive to a selection to create multiple conditions for a query rule, the system modifies the functionality of the user interface to enable entry of multiple condition characteristics. Based on a further selection, the system creates the multiple conditions for the query rule.

Nested query modification tool

Techniques for generating an interactive visualization tool for building nested queries are disclosed. The interactive nested query visualization tool allows a user to observe, analyze, and modify query characteristics and attributes of a set of nested queries. A system displays an interactive visual depiction of a set of nested queries. Visual representations of the nested queries are positioned relative to each other based on the relationships between the nested queries. The system displays, simultaneously with the set of nested queries, editable fields for a selected query. The system modifies a functionality of a user interface based on which of the nested queries is selected.

Visualization tool for building nested queries

Techniques for tracing attributes through queries in a set of nested queries are disclosed. A graphical user interface displays individual sub-queries as separate visual representations. Based on detecting a selection, a system analyzes data underlying the visual representations to identify queries, among the set of nested queries, that are associated with a particular attribute. One selection results in the system analyzing the underlying data to identify an origin query for an attribute, from among the set of nested queries. Another selection results in the system analyzing the underlying data to identify queries, from among the set of nested queries, that use the attribute received from a selected query. Another selection results in the system generating SQL code for a selected subset of queries, among the set of nested queries.

Nested query analysis tool

Techniques for executing operations associated with sub-sets of queries in a set of nested queries are disclosed. A graphical user interface displays individual sub-queries as separate visual representations. Based on detecting a selection, a system executes a selected query in the set of nested queries, without executing parent queries in the set of nested queries. Based on detecting another selection, the system exports a selected query without exporting parent queries of the selected query. The system copies the metadata describing the selected query and transfers the metadata to another set of nested queries. Based on detecting another selection, the system displays a results count for a selected query. The system displays a number representing the number of results returned by the selected query, without displaying the query results.

Nested query execution tool

A chart is displayed without rendering entirely obscured markers. Successive nested pixel maps of a chart of pixels are traversed. Each of the nested pixel maps has fewer data elements than a corresponding next one of the nested pixel maps. Obscurity states of markers of the chart are determined. The obscurity states include an entirely obscured state, an entirely visible state, and a partially visible state. Each of the markers for a particular nested pixel map is associated with a separate pixel for the particular nested pixel map. One or more of the markers associated with the entirely visible state and one or more of the markers associated with the partially visible state are rendered without rendering markers associated with the entirely obscured state.

Displaying a chart without rendering entirely obscured markers

Implementations generally relate to optimizing bar charts. In some implementations, a method includes receiving a plurality of data points, where each data point of the plurality of data points has a value. The method further includes determining a plurality of bars of the bar chart based on the plurality of data points, where each bar of the plurality of bars has a length and a width. The method further includes associating at least portions of a plurality of pixels used to render the bar chart with the plurality of bars. The method further includes determining for each pixel or pixel portion, at least one or more of a highest positive bar and/or a lowest negative bar. The method further includes rendering for individual pixels or pixel portions, one or more of the respective highest positive bar and/or the respective lowest negative bar.

Bar chart optimization

A system and method for facilitating integrating enterprise data from multiple sources for display via in a common interface. An example method includes displaying, via a first user interface display screen, a first set of one or more personnel icons representative of one or more enterprise personnel, and providing a first user option to select one or more of the personnel icons. A second user interface display screen may be displayed in response to or after selection of one or more of the personnel icons. The second user interface display screen presents a first type of data. The second user interface display screen further provides a second user option to select one or more user interface features associated with the first type of data, and to then trigger display of a third user interface display screen. The third user interface display presents a second type of data that is associated with the first type of data.

Providing a user interface that maintains information and context continuity while transitioning between views pertaining to different types of enterprise data

Implementations generally relate to using a nested pixel map to optimize chart rendering in a graphical user interface. In some implementations, a method includes generating a first pixel map for a chart, wherein the first pixel map is a first data structure that includes a first group of first data elements, wherein each first data element corresponds to a pixel of a plurality of pixels used to render the chart. The method further includes generating at least one secondary pixel map for the chart. The method further includes determining one or more obscurity states of one or more markers of the chart based on one or more of the first pixel map and the at least one secondary pixel map. The method further includes rendering one or more of the markers in the chart based on the obscurity state of each of the one or more markers.

Using a nested pixel map for chart rendering optimization

Implementations generally relate to optimizing bar charts. In some implementations, a method includes receiving a plurality of data points, where each data point of the plurality of data points has a value. The method further includes determining a plurality of bars of the bar chart based on the plurality of data points, where each bar of the plurality of bars has a length and a width. The method further includes associating a plurality of pixels used to render the bar chart with the plurality of bars. The method further includes determining for each pixel of the plurality of pixels at least one or more of a highest positive bar and a lowest negative bar. The method further includes rendering for each pixel one or more of the respective highest positive bar and the respective lowest negative bar.

Growing community of inventors

Lexington, MA, United States of America

Prashant Singh