# US 11,442,694 B1 · Merging database tables by classifying comparison signatures > Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt - Number: US 11,442,694 B1 - Document ID: US11442694B1 - Status: Granted - Kind: B1 - Application number: 16/787,576 - Filed: 2020-02-11 - Granted: 2022-09-13 - Earliest claimed: 2017-10-11 - Assignees: Amperity, Inc. - Applicants: Amperity, Inc. - Inventors: Derek Slager; Stephen Meyles; Yan Yan; Carlos Sakoda - Web page: https://patentgrep.com/patent/US11442694B1 ## CPC - G06F 7/32: Merging, i.e. combining data contained in ordered sequence on at least two record carriers to produce a single carrier or set of carriers having all the original data in the ordered sequence {merging methods in general}(G06F7/36 takes precedence) - G06F 16/24556: {Aggregation; Duplicate elimination} - G06F 7/14: Merging, i.e. combining at least two sets of record carriers each arranged in the same ordered sequence to produce a single set having the same ordered sequence - G06F 16/215: Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors - G06F 16/2365: {Ensuring data consistency and integrity} - G06F 16/24: Querying - G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N) ## Abstract The present disclosure relates to merging database tables. Systems and methods may involve performing a comparison between the first set of records and the second set of records and identifying a plurality of record pairs based on the comparison. Each record pair may comprise a record in the first set of records and a record in the second set of records. In addition, A feature signature may be generated for each record pair by comparing field values in each record pair. The feature signature may be classified to identify at least one related record pair. A merged database table may be generated such that it comprises the at least one related record pair and comprises a set of unique records among selected from the first set of records and the second set of records. ## Claims ### Claim 1 A system comprising: a database that stores a first database table and a second database table, the first database table comprising a first set of records and a first plurality of fields for the first set of records, the second database table comprising a second set of records and a second plurality of fields for the second set of records; and a memory coupled to a processor, the memory comprising a plurality of instructions that cause the processor to: perform a comparison between the first set of records and the second set of records; identify a plurality of record pairs based on the comparison, each record pair comprising a record in the first set of records and a record in the second set of records; generate a feature signature for each record pair by comparing field values in each record pair; classify the feature signature to identify at least one related record pair; and generate a merged database table comprising the at least one related record pair and comprising a set of unique records among selected from the first set of records and the second set of records. ### Claim 2 (depends on 1) The system of claim 1, wherein the plurality of instructions further cause the processor to preserve the first database table and the second database table after the merged database table is generated. ### Claim 3 (depends on 1) The system of claim 1, wherein the first database table is linked to a first relational table and wherein the merged database table is linked to the first relational table. ### Claim 4 (depends on 1) The system of claim 1, wherein the merged database table is generated according to a user-specified threshold confidence level. ### Claim 5 (depends on 4) The system of claim 4, wherein the plurality of instructions further cause the processor to generate a plurality of merged database tables corresponding to various user-specified threshold confidences levels. ### Claim 6 (depends on 1) The system of claim 1, wherein the plurality of instructions further cause the processor to obtain a database merge rule, the database merge rule indicating a specification of at least one desired field selected from at least one of the first plurality of fields or the second plurality of fields. ### Claim 7 (depends on 1) The system of claim 1, wherein the plurality of instructions that cause the processor to classify the feature signature comprises a binary classifier. ### Claim 8 A system comprising: a database that stores a first database table and a second database table, the first database table comprising a first set of records and a first plurality of fields for the first set of records, the second database table comprising a second set of records and a second plurality of fields for the second set of records; and a processor in data communication with a memory, the processor being configured to: perform a comparison between the first set of records and the second set of records; identify a set of related record pairs based on the comparison by comparing field values to generate a feature signature and classifying the feature signature to generate a confidence score; identify a set of unique records among the first set of records and the second set of records based on the comparison; and generate a merged database table comprising at least a portion of the set of related records and comprising the set of unique records. ### Claim 9 (depends on 8) The system of claim 8, wherein the processor is further configured to preserve the first database table and the second database table after the merged database table is generated. ### Claim 10 (depends on 8) The system of claim 8, wherein the first database table is linked to a first relational table and wherein the merged database table is linked to the first relational table. ### Claim 11 (depends on 8) The system of claim 8, wherein the at least a portion of the set of related records is determined by selecting field values within each related record pair according to a database merge rule, the database merge rule indicating a specification of at least one desired field selected from at least one of the first plurality of fields or the second plurality of fields. ### Claim 12 (depends on 8) The system of claim 8, wherein the processor is configured to obtain a user-specified threshold confidence level, wherein the merged database table is generated based on the user-specified threshold confidence level. ### Claim 13 (depends on 12) The system of claim 12, wherein the processor is configured to generate a plurality of merged database tables corresponding to various user-specified threshold confidence levels. ### Claim 14 (depends on 12) The system of claim 12, wherein the processor is configured to obtain a database merge rule, the database merge rule indicating a specification of at least one desired field selected from at least one of the first plurality of fields or the second plurality of fields, wherein the merged database table is generated according to the merge rule. ### Claim 15 A computer implemented method comprising: storing, in a database, a first database table and a second database table, the first database table comprising a first set of records and a first plurality of fields for the first set of records, the second database table comprising a second set of records and a second plurality of fields for the second set of records; comparing the first set of records and the second set of records; identifying a set of related record pairs based on the comparison, wherein for each related record pair, field values are compared to generate a feature signature for the related record pair and the feature signature being classified by a classifier to generate a confidence score; identify a set of unique records among the first set of records and the second set of records; and generating a merged database table comprising at least a portion of the set of related record pairs and comprising the set of unique records. ### Claim 16 (depends on 15) The method of claim 15, further comprising preserving the first database table and the second database table after the merged database table is generated. ### Claim 17 (depends on 15) The method of claim 15, wherein the first database table is linked to a first relational table and wherein the merged database table is linked to the first relational table. ### Claim 18 (depends on 15) The method of claim 15, wherein the at least the portion of the set of related record pairs is determined by selecting field values within each related record pair according to a merge rule. ### Claim 19 (depends on 15) The method of claim 15, further comprising obtaining a database merge rule, the database merge rule indicating a specification of at least one desired field selected from at least one of the first plurality of fields or the second plurality of fields. ### Claim 20 (depends on 15) The method of claim 15, further comprising generating a plurality of merged database tables corresponding to various user-specified threshold confidence levels.