Unified Entity Resolution and SQL Search System
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
In entity resolution systems, users often need to perform multiple searches using different techniques, such as entity resolution searches and SQL queries, to find entities effectively, which can be cumbersome and inefficient.
Innovation Solution
A combined search system that integrates entity resolution searches and SQL queries to generate a single search result set, using resolution searches to identify candidate entities and query searches to refine results based on generic attribute types, thereby reducing the need for multiple searches and improving accuracy.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Measurement precision
If multiple search techniques (entity resolution search and SQL query) are used to find entities, then search accuracy is improved, but user effort and time consumption increase
Solution Approach 1:
The patent combines entity resolution search and SQL query techniques into a single unified search operation. The system executes both search methods simultaneously or in sequence and merges their results, eliminating the need for users to perform multiple separate searches while maintaining comprehensive search coverage and accuracy.
Solution Approach 2:
The unified search system performs multiple functions (entity resolution and SQL querying) through a single search interface. This multi-functional approach allows the system to handle diverse search requirements without requiring users to switch between different search techniques, reducing time consumption while preserving search accuracy.
2Measurement precision
If multiple search techniques are used to find entities, then search accuracy is improved, but operation complexity increases
Solution Approach 1:
The patent merges entity resolution search and SQL query operations into a single unified search interface. Users interact with one search system that automatically employs both techniques, eliminating the complexity of managing multiple search operations while achieving comprehensive and accurate results.
Solution Approach 2:
The unified search system automatically determines and executes the appropriate search techniques without requiring users to manually select between entity resolution search and SQL query. The system self-manages the complexity of coordinating multiple search methods, providing users with a simple, ease-of-use interface.
3Ease of operation
If entity resolution search is used alone, then operation simplicity is maintained, but search completeness deteriorates when generic attribute values are present
Solution Approach 1:
The patent combines entity resolution search with SQL query capabilities in a unified search system. When generic attribute values are present, the system automatically supplements entity resolution results with SQL query results, ensuring search completeness while maintaining operational simplicity through a single search interface.
Data Source
AI summary
Provided are techniques to search for an entity in an entity resolution system. Search input comprising one or more attribute values of one or more attribute types is received. A resolution search is performed to generate a search result set comprising one or more entities and zero or more generic attribute values for generating additional entities. In response to determining that the resolution search generated at least two generic attribute values, one or more query searches are performed for a unique generic group by generic attribute type to identify the additional entities, wherein the unique generic group comprises a subset of the search input and includes at least two generic attribute types; the identified additional entities are combined with the entities in the search result set; and the search result set is returned.