Dynamic SQL Search Interface for Metadata-Driven Databases
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Web-based database applications often have inflexible user interfaces that limit users' ability to build custom queries, requiring developer intervention and hindering self-service orientation and productivity.
Innovation Solution
A user-customizable web-based search interface that leverages dynamic HTML, JavaScript, and dynamic SQL, allowing users to select search parameters, operators, and values to dynamically build and save SQL queries without coding, enabling custom report creation and sharing.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Ease of operation
If a simple form with finite search parameters is used, then the user interface is easy to use, but users are limited in their ability to build custom queries
Solution Approach 1:
The search interface is segmented into multiple selectable search criteria fields, where users can choose from predefined search types (e.g., customer name, account number, product code) and combine them dynamically. This allows the interface to maintain simplicity while enabling custom query construction through modular parameter selection.
Solution Approach 2:
The search form is designed to be multi-functional by allowing users to select from various search types and operators (equals, contains, greater than, etc.) for each parameter. The same form structure serves both simple predefined searches and complex custom queries, eliminating the need for separate tools.
2Adaptability or versatility
If reporting front-ends are introduced to enable custom queries, then query flexibility improves, but developer intervention and knowledge are required
Solution Approach 1:
The system enables end-users to independently construct and execute custom SQL queries through a web-based form interface without requiring developer intervention. Users select search parameters, operators, and values from dropdown menus and text fields, and the system automatically generates and executes the corresponding SQL query, returning results directly to the user.
Solution Approach 2:
A server-side intermediary component acts as a mediator between the user-friendly web form and the database. It receives user selections from the form, dynamically constructs the appropriate SQL query string, executes it against the database, and returns results. This intermediary shields users from SQL complexity while maintaining self-service capability.
3Ease of manufacture
If developers create fixed search forms, then the application is easy to maintain, but user productivity decreases due to inflexible interfaces
Solution Approach 1:
The search form transitions from a static, developer-fixed structure to a dynamic, user-configurable interface. Users can dynamically select different search types, operators, and parameter combinations for each query based on their specific needs. The system adapts the SQL query generation in real-time based on user selections, maintaining ease of maintenance through standardized form processing while dramatically improving user productivity.
Data Source
AI summary
Web-based user interface systems and methods for searching metadata-driven relational databases. Instead of requiring developers to determine the exact type and number of search criteria for each application, the present invention advantageously provides a user-customizable search interface that, in certain aspects, leverages dynamic HTML, JavaScript, and dynamic SQL. A user may choose the exact type and number of search parameters, enabling the user to build a custom report without requiring the user to write any code. The system dynamically builds a SQL search query based on the user identified search parameters. Once a user has built a custom search using the interface, that search may be saved for re-use, and shared with other users.