公开(公告)号：US12265527B2

公开(公告)日：2025-04-01

申请号：US18606905

申请日：2024-03-15

Applicant: Oracle International Corporation

Inventor： Prashant Singh ,  Rasika Vaidya Kaura ,  Henrik Michael Ammer

IPC: G06F16/242 ,  G06F3/0482 ,  G06F3/0486 ,  G06F16/2453 ,  G06F16/2458 ,  G06F16/248 ,  G06F16/25

Abstract: 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.

公开(公告)号：US12259880B2

公开(公告)日：2025-03-25

申请号：US18598230

申请日：2024-03-07

Applicant: Oracle International Corporation

Inventor： Prashant Singh ,  Rasika Vaidya Kaura ,  Henrik Michael Ammer

IPC: G06F16/242 ,  G06F3/0482 ,  G06F3/0486 ,  G06F16/2453 ,  G06F16/2458 ,  G06F16/248 ,  G06F16/25

Abstract: 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.

公开(公告)号：US11430163B2

公开(公告)日：2022-08-30

申请号：US15930338

申请日：2020-05-12

Applicant: Oracle International Corporation

Inventor： Pangus Ho ,  Hugh Zhang ,  Prashant Singh

IPC: G06T11/20 ,  G06F16/338 ,  G06F16/332 ,  G06F16/26

Abstract: 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.

公开(公告)号：US20220253442A1

公开(公告)日：2022-08-11

申请号：US17449631

申请日：2021-09-30

Applicant: Oracle International Corporation

Inventor： Prashant Singh ,  Rasika Vaidya Kaura ,  Henrik Michael Ammer

IPC: G06F16/2458 ,  G06F16/242 ,  G06F16/25 ,  G06F16/248

Abstract: 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.

公开(公告)号：US20220253437A1

公开(公告)日：2022-08-11

申请号：US17449628

申请日：2021-09-30

Applicant: Oracle International Corporation

Inventor： Prashant Singh ,  Rasika Vaidya Kaura ,  Henrik Michael Ammer

IPC: G06F16/242 ,  G06F16/2453 ,  G06F3/0486

Abstract: 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.

公开(公告)号：US20220253436A1

公开(公告)日：2022-08-11

申请号：US17449201

申请日：2021-09-28

Applicant: Oracle International Corporation

Inventor： Prashant Singh ,  Rasika Vaidya Kaura ,  Henrik Michael Ammer

IPC: G06F16/242

Abstract: 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.

公开(公告)号：US10672157B2

公开(公告)日：2020-06-02

申请号：US15679589

申请日：2017-08-17

Applicant: Oracle International Corporation

Inventor： Pangus Ho ,  Hugh Zhang ,  Prashant Singh

IPC: G06T11/20 ,  G06F16/248

Abstract: 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.

公开(公告)号：US10175855B2

公开(公告)日：2019-01-08

申请号：US14684171

申请日：2015-04-10

Applicant: Oracle International Corporation

Inventor： Jairam Ramanathan ,  Prashant Singh ,  Yi Dai ,  Jindrich Dinga ,  David Kamholz

IPC: G06F3/0482 ,  G06F3/0481 ,  G06F3/0484 ,  G06F3/0488 ,  G06T11/20 ,  G06T13/80 ,  H04L29/08

Abstract: A system and method for facilitating interacting with data and/or functionality via a visualization. An example method includes determining number of hierarchical levels to display in an orbit visualization; displaying the number of hierarchical levels via one or more nodes and one or more orbit paths, wherein each child node of a parent node of the one or more nodes is confined to one or more orbit paths that at least partially circumscribe the parent node; providing a first user option to navigate downward or upward in the hierarchy, at least in part via user selection of a node of the orbit visualization; and selectively updating the orbit visualization in response to user selection of the first user option so that a resulting updated visualization illustrates a navigated-to location, wherein the updated visualization illustrates the number of hierarchical levels.

公开(公告)号：US20180286091A1

公开(公告)日：2018-10-04

申请号：US15476802

申请日：2017-03-31

Applicant: Oracle International Corporation

Inventor： Pangus Ho ,  Hugh Zhang ,  Prashant Singh

IPC: G06T11/20 ,  G06T15/00 ,  G06T15/04 ,  G06F17/30 ,  G06T3/40 ,  G06F3/0481

CPC classification number: G06T11/206 ,  G06F16/26 ,  G06F16/3328 ,  G06F16/338

Abstract: 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.

公开(公告)号：US09678645B2

公开(公告)日：2017-06-13

申请号：US14302887

申请日：2014-06-12

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Yi Dai ,  Hugh Zhang ,  Jairam Ramanathan ,  Prashant Singh

IPC: G06F3/048 ,  G06F3/0484

CPC classification number: G06F3/04845 ,  G06F3/04842 ,  G06F3/04847

Abstract: A system for providing an interactive map displays an interactive map marker that includes an associated location on the map, an associated data value, a visual indicator, and an underlying data model. The system receives an interaction from a user that modifies the visual indicator and changes the associated data value based on the visual indicator modification. The system then changes the underlying data model based on the visual indicator modification.