Dynamic Database Search Query Builder Using Configurable Templates
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing systems for automated database search queries lack efficiency in dynamically building and executing queries across different types, leading to potential errors and increased complexity in managing search requests.
Innovation Solution
A method that receives search request parameters, generates URL request parameters, and dynamically builds Elasticsearch queries using DSL, comparing these to search query templates in a configuration file, and transmits them to a search cluster for execution, with authentication and error handling mechanisms.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If multiple separate query builders are used for different search query types, then each query type can be handled with specialized logic, but the system complexity increases and maintenance becomes difficult
Solution Approach 1:
The patent implements a universal query builder that can handle multiple search query types (first search query type and second search query type) through a single integrated component. This universal builder uses configurable templates to adapt to different query requirements, eliminating the need for multiple separate query builders while maintaining the ability to execute specialized queries accurately.
Solution Approach 2:
The patent segments the query building process into distinct template definitions and a centralized execution engine. Search query templates are separated into configuration files with specific parameters for each query type, while the query builder dynamically selects and applies the appropriate template based on the incoming search request, reducing system complexity through modular design.
2Manufacturing precision
If manual query building is used for each search request, then query accuracy can be maintained, but the time required to process searches increases
Solution Approach 1:
The patent pre-defines search query templates with all necessary parameters and structures in configuration files before runtime. When a search request arrives, the system automatically matches the request parameters against these pre-configured templates and generates the final query through parameter substitution, eliminating manual query construction while maintaining accuracy through the predefined template structure.
3Adaptability or versatility
If dynamic query building is implemented, then flexibility in handling different search types is improved, but the potential for errors in query generation increases
Solution Approach 1:
The patent implements validation mechanisms that verify the generated search queries against the original search request parameters and template definitions. The system checks whether all required parameters are present and correctly formatted before finalizing the query, providing feedback loops that ensure query generation reliability while maintaining dynamic flexibility.
Solution Approach 2:
The patent introduces template configuration files as an intermediary layer between the dynamic search requests and the actual query execution. These templates act as mediators that enforce proper query structure and parameter validation, reducing errors in dynamic query generation while maintaining flexibility in handling different search types.
4Adaptability or versatility
If multiple query templates are maintained for different search types, then comprehensive search coverage is achieved, but the complexity of managing templates increases
Solution Approach 1:
The patent uses a universal template management system that can handle multiple search query types through a common framework. The system automatically selects and applies the appropriate template based on the search request type, providing comprehensive search coverage while simplifying template management through centralized configuration and automated selection logic.
Data Source
AI summary
A method for automated entity field correction includes receiving multiple search request parameters at multiple text entry fields of a user interface of an application, the multiple search request parameters corresponding to at least one of a first and second search query types, generating uniform resource locator (URL) request parameters according to the received multiple search request parameters, and dynamically building a search query by comparing the URL request parameters to multiple search query templates in a configuration file, the multiple search query templates including at least a first search query corresponding to the first search query type and a second search query corresponding to the second search query type. The method includes transmitting the dynamically built search query to a search cluster of a database, obtaining a search query result from the search cluster, and displaying the obtained search query result on the user interface of the application.