Database Search Integration via Federated Query Adaptation
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
The complexity of software systems leads to varying search functionalities across different applications, resulting in inconsistent user experiences and difficulties in translating search capabilities between applications, due to differences in supported search parameters and query building methods.
Innovation Solution
A computer-implemented method that integrates a search engine into a database server, allowing search operations to be performed directly on database views without data replication, and uses an integration service to adapt search requests and provide harmonized search results across applications, enabling a central launchpad for federated search with different configurations and authentication schemes.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If search operations are performed using data replication across different applications, then search functionality can be provided to multiple applications, but replication delays and errors occur resulting in inconsistent search experiences
Solution Approach 1:
The patent extracts the search operation from the application layer and moves it directly to the database server. Instead of replicating data to multiple search servers, the search function is taken out and executed natively at the data source, eliminating replication delays and ensuring consistent results across all applications that use the same database.
Solution Approach 2:
The database server acts as an intermediary between multiple applications and the underlying data. By providing a unified search interface at the database level, it mediates between different application-specific search requirements and the actual data storage, ensuring consistent and accurate search results for all applications without data replication.
2Adaptability or versatility
If different applications implement their own search models and query methods, then each application can have customized search functionality, but user experience varies across applications and search knowledge cannot be translated between applications
Solution Approach 1:
The database server provides a universal search interface that serves multiple applications with different requirements. By implementing a standardized search model at the database level that can handle various search types (full-text, structured, unstructured), it enables one search system to fulfill multiple application-specific needs while maintaining consistent user experience across all applications.
Solution Approach 2:
The patent segments the search functionality into two parts: a standardized interface layer at the database server that ensures consistency, and application-specific configuration parameters that allow customization. This segmentation enables each application to have its own search preferences and parameters while relying on the unified database search engine, maintaining both consistency and adaptability.
3Adaptability or versatility
If search parameters and query building methods vary across applications, then each application can support its specific search requirements, but users cannot transfer search capabilities between applications
Solution Approach 1:
The database server creates an equipotential search environment by standardizing the search parameter interface at the database level. All applications interact with the same search parameters and query structure through the database server, eliminating the complexity variations between applications. Users learn one search methodology that works consistently across all applications, reducing the overall system complexity despite supporting diverse search requirements.
Data Source
AI summary
The present disclosure pertains to systems and methods for providing search results. A database server may include both a database and a search engine. The database server can receive a search request from an application of a remote computer. The search request can include one or more search terms and permission information. The database server can determine adapting information using the permission information. The database server can provide a search call based on the search request and the adapting information to the search engine. The search engine can determine one or more search statements for the search call. The search engine can execute the one or more search statements on one or more stored search models to obtain database results reflecting the permission information. The database server can provide search results based on the database results to the application of the remote computer.