Business Object Browser for Simplified BQL Query Generation
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Users face challenges in efficiently searching and retrieving business object data due to the complexity of database query languages and the need for specific knowledge of syntax, leading to time and resource-intensive processes, especially when only specific data is required.
Innovation Solution
A graphical user interface, the Business Object Browser, is developed to facilitate selective and strategic searching and retrieval of business object data using Business Query Language (BQL), allowing users to generate and execute BQL statements by selecting relevant nodes, associations, and attributes, thereby simplifying the process and reducing unnecessary data retrieval.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If a database query language is used to search BO data, then query capability is provided, but user complexity increases due to syntax knowledge requirements
Solution Approach 1:
The patent introduces a Business Object Browser as an intermediary tool between users and the complex BQL query language. This browser provides a graphical user interface that automatically generates BQL statements based on user selections, eliminating the need for users to manually learn and type complex query syntax while maintaining full query capability.
Solution Approach 2:
The system enables self-service by allowing users to construct queries through intuitive graphical selections without requiring formal training in BQL syntax. The automatic statement generation feature serves the user's query needs independently, without requiring expert intervention or manual programming knowledge.
2Loss of information
If all BO data is searched, then complete data retrieval is achieved, but time and resources increase
Solution Approach 1:
The patent segments the BO data structure into hierarchical categories (Business Objects, Attributes, Associations) within the Browser interface. Users can selectively navigate and select only the specific segments relevant to their query, enabling targeted data retrieval that maintains completeness for requested information while avoiding unnecessary search of entire datasets.
Solution Approach 2:
Instead of requiring users to search all BO data, the system enables partial action by allowing selective querying of specific BOs and attributes through the graphical interface. Users can precisely target only the necessary data portions, reducing search time and resources while maintaining sufficient data completeness for their specific business needs.
3Adaptability or versatility
If multiple programs control search and query tasks, then functionality is provided, but operational complexity increases
Solution Approach 1:
The patent merges previously separate functions for browsing BO data, constructing queries, and executing statements into a single integrated Business Object Browser application. This unified interface consolidates multiple operational steps into one coherent tool, reducing the cognitive load and operational complexity users must manage while maintaining comprehensive functionality.
Solution Approach 2:
The Business Object Browser serves as a universal tool that handles multiple functions including data browsing, query construction, statement generation, and execution within a single interface. This multi-functional design eliminates the need to switch between multiple specialized programs, simplifying operation while providing comprehensive functionality for BO data manipulation.
Data Source
AI summary
A method and graphical user interface, the graphical user interface includes a search tool to search for and retrieve specific business object (BO) data located in a business object (BO) database; a business query language (BQL) statement creation tool to create a BQL statement based on the specified BO data; and a BQL execution engine to execute the BQL statement created by the BQL statement creation tool of the graphical user interface. The method includes specifying a BO to search for using a search tool of the graphical user interface; retrieving, from a BO database, BO data associated with the specified BO; creating a business query language (BQL) statement using a BQL creation tool of the graphical user interface based on the specified BO; and executing the BQL statement using a BQL execution engine of the graphical user interface.