Patents by Inventor Henrik Michael Ammer
Henrik Michael Ammer has filed for patents to protect the following inventions. This listing includes patent applications that are pending as well as patents that have already been granted by the United States Patent and Trademark Office (USPTO).
-
Patent number: 11947527Abstract: 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.Type: GrantFiled: September 30, 2021Date of Patent: April 2, 2024Assignee: Oracle International CorporationInventors: Prashant Singh, Rasika Vaidya Kaura, Henrik Michael Ammer
-
Publication number: 20230350884Abstract: 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.Type: ApplicationFiled: July 10, 2023Publication date: November 2, 2023Applicant: Oracle International CorporationInventors: Prashant Singh, Rasika Vaidya Kaura, Henrik Michael Ammer
-
Publication number: 20230306019Abstract: 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.Type: ApplicationFiled: May 31, 2023Publication date: September 28, 2023Applicant: Oracle International CorporationInventors: Prashant Singh, Rasika Vaidya Kaura, Henrik Michael Ammer
-
Patent number: 11741088Abstract: 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.Type: GrantFiled: September 30, 2021Date of Patent: August 29, 2023Assignee: Oracle International CorporationInventors: Prashant Singh, Rasika Vaidya Kaura, Henrik Michael Ammer
-
Patent number: 11714806Abstract: 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.Type: GrantFiled: September 30, 2022Date of Patent: August 1, 2023Assignee: Oracle International CorporationInventors: Prashant Singh, Rasika Vaidya Kaura, Henrik Michael Ammer
-
Publication number: 20230214381Abstract: 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.Type: ApplicationFiled: March 9, 2023Publication date: July 6, 2023Applicant: Oracle International CorporationInventors: Prashant Singh, Rasika Vaidya Kaura, Henrik Michael Ammer
-
Patent number: 11636101Abstract: 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.Type: GrantFiled: September 30, 2021Date of Patent: April 25, 2023Assignee: Oracle International CorporationInventors: Prashant Singh, Rasika Vaidya Kaura, Henrik Michael Ammer
-
Publication number: 20230029161Abstract: 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.Type: ApplicationFiled: September 30, 2022Publication date: January 26, 2023Applicant: Oracle International CorporationInventors: Prashant Singh, Rasika Vaidya Kaura, Henrik Michael Ammer
-
Patent number: 11494373Abstract: 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.Type: GrantFiled: September 28, 2021Date of Patent: November 8, 2022Assignee: Oracle International CorporationInventors: Prashant Singh, Rasika Vaidya Kaura, Henrik Michael Ammer
-
Publication number: 20220253438Abstract: 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.Type: ApplicationFiled: September 30, 2021Publication date: August 11, 2022Applicant: Oracle International CorporationInventors: Prashant Singh, Rasika Vaidya Kaura, Henrik Michael Ammer
-
Publication number: 20220253442Abstract: 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.Type: ApplicationFiled: September 30, 2021Publication date: August 11, 2022Applicant: Oracle International CorporationInventors: Prashant Singh, Rasika Vaidya Kaura, Henrik Michael Ammer
-
Publication number: 20220253436Abstract: 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.Type: ApplicationFiled: September 28, 2021Publication date: August 11, 2022Applicant: Oracle International CorporationInventors: Prashant Singh, Rasika Vaidya Kaura, Henrik Michael Ammer
-
Publication number: 20220253437Abstract: 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.Type: ApplicationFiled: September 30, 2021Publication date: August 11, 2022Applicant: Oracle International CorporationInventors: Prashant Singh, Rasika Vaidya Kaura, Henrik Michael Ammer