Methods and apparatus for performing multi-data-source, non-ETL queries and entity resolution
AssigneeKnowledge Computing Corporation
InventorsWilliam Oliver, Robert Griffin
Life of this patent
Estimating the term…
Abstract
The application discloses a new system for performing queries and entity resolution on two or more data sources without having to ETL all the documents, entities, and descriptions of entities. Also disclosed, is a method to perform advanced entity resolution without divulging personally sensitive information to end-users and intermediate systems.
Claims10
A method for use with first and second databases, said first database housed within a first computing system, said second database housed within a second computing system, said first and second databases geographically removed from each other, each said database having respective direct users, each said database also made available on a limited basis to users of the other of said first and second databases, each said database containing records not present in the other of said first and second databases, and with a computer-based user interface, the method comprising the steps of:
- carrying out a search in each of said first and second databases,
- whereby each search gives rise to respective first and second search results,
- whereby each of said search results has a respective primary key,
- whereby each of said search results comprises information sharable on said limited basis with users of the other of said first and second databases, and
- whereby each of said search results comprises information not sharable on said limited basis with users of the other of said first and second databases;
- building a list of entries including said first search results and said second search results, each entry having respective content;
- selecting one or more entries from said list of entries and finding associations therewith;
- constructing a consolidated primary key comprising information from the primary key for each of said entries;
- making a query at each of said first and second databases using information from the content of said selected one or more entries,
- thereby deriving respective additional search results therefrom,
- whereby the respective additional search results yield at least one entry not cumulative of said first search results and said second search results;
- updating said list of entries to including the at least one entry not cumulative of said first search results and said second search results;
- and
- displaying said updated list of entries in a graphical user interface for a human user.
A system for performing data queries resulting in fine entity resolution and information consolidation, comprising:
- first and second databases,
- whereby said first database housed within a first computing system;
- whereby said second database housed within a second computing system;
- whereby said first and second databases are geographically removed from each other;
- whereby each said of said databases have respective direct users,
- whereby each of said databases is also made available on a limited basis to users of the other of said first and second databases,
- whereby each said of databases contain records not present in the other of said first and second databases;
- a computer-based user interface;
- wherein a search can be carried out in each of said first and second databases,
- whereby each search gives rise to respective first and second search results,
- whereby each of said search results has a respective primary key,
- whereby each of said search results comprises information sharable on said limited basis with users of the other of said first and second databases, and
- whereby each of said search results comprises information not sharable on said limited basis with users of the other of said first and second databases;
- wherein a list of entries can be built including said first search results and said second search results, each entry having respective content;
- wherein one or more entries can be selected from said list of entries and finding associations therewith;
- wherein a consolidated primary key comprising information from the primary key for each of said entries can be constructed;
- wherein a query can be made at each of said first and second databases using information from the content of said selected one or more entries,
- thereby deriving respective additional search results therefrom,
- whereby the respective additional search results yield at least one entry not cumulative of said first search results and said second search results;
- wherein said list of entries can be updated to including the at least one entry not cumulative of said first search results and said second search results;
- and
- wherein said updated list of entries can be displayed in a graphical user interface for a human user.
Dependencies are inferred from the claim text.