18606905. Nested Query Modification Tool simplified abstract (Oracle International Corporation)

From WikiPatents
Jump to navigation Jump to search

Nested Query Modification Tool

Organization Name

Oracle International Corporation

Inventor(s)

Prashant Singh of Lexington MA (US)

Rasika Vaidya Kaura of Dublin CA (US)

Henrik Michael Ammer of Auburn WA (US)

Nested Query Modification Tool - A simplified explanation of the abstract

This abstract first appeared for US patent application 18606905 titled 'Nested Query Modification Tool

The patent application describes techniques for modifying queries in a set of nested queries using a graphical user interface.

  • The graphical user interface displays a query detail region alongside a nested query display region.
  • Users can modify queries in the nested set of queries through the interface.
  • A query modification tool allows users to promote a query attribute from a child query to one or more parent queries.
  • Users can delete an attribute from each query in the set of nested queries.
  • The system can create multiple conditions for a query rule based on user selections.

Potential Applications: - Database management systems - Data analysis tools - Business intelligence software

Problems Solved: - Streamlining query modification processes - Enhancing user control over query attributes - Improving query rule creation and management

Benefits: - Increased efficiency in query modification - Enhanced customization of query attributes - Simplified creation of complex query rules

Commercial Applications: Title: "Enhancing Query Modification in Database Management Systems" This technology could be utilized in various industries such as finance, healthcare, and e-commerce for optimizing data analysis processes and improving decision-making based on query results.

Questions about Query Modification Techniques: 1. How does this technology improve the efficiency of query modification processes? - This technology streamlines the process of modifying queries in a set of nested queries, allowing users to easily promote attributes and create multiple conditions for query rules.

2. What are the potential applications of this technology beyond database management systems? - This technology could also be applied in data analysis tools, business intelligence software, and other systems that involve complex query management.


Original Abstract Submitted

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.