Matching objects using match rules and lookup key
First Claim
Patent Images
1. A computer-implemented method comprising:
- generating, by a database system, a match key associated with a lookup field of a database object and associated with another field of the database object;
activating, by the database system, a matching rule associated with the match key;
receiving, by the database system, a request to search for candidates in the database object that are duplicates, the request including a probe entity; and
identifying, by the database system, the duplicate candidates in the database object by;
creating a plurality of candidate keys by applying the match key to a corresponding plurality of candidates in the database object, and creating a probe key by applying the match key to the probe entity,determining whether the probe key matches any of the plurality of candidate keys, anddetermining, when the probe key matches any of the plurality of candidate keys, whether the probe entity matches any of the plurality of candidates corresponding to the matched candidate keys by applying the matching rule to the probe entity and to the candidates corresponding to the matched candidate keys.
2 Assignments
0 Petitions
Accused Products
Abstract
Some embodiments of the present invention include a method for identifying match candidates in a database object and may include generating, by a database system, a match key associated with a lookup field of a database object. The method may further include activating, by the database system, a matching rule associated with the match key, and receiving, by the database system, a request to search for duplicate candidates in the database object. The request may include an input entity. The duplicate candidates in the database object may be identified by using the input entity and the matching rule.
-
Citations
20 Claims
-
1. A computer-implemented method comprising:
-
generating, by a database system, a match key associated with a lookup field of a database object and associated with another field of the database object; activating, by the database system, a matching rule associated with the match key; receiving, by the database system, a request to search for candidates in the database object that are duplicates, the request including a probe entity; and identifying, by the database system, the duplicate candidates in the database object by; creating a plurality of candidate keys by applying the match key to a corresponding plurality of candidates in the database object, and creating a probe key by applying the match key to the probe entity, determining whether the probe key matches any of the plurality of candidate keys, and determining, when the probe key matches any of the plurality of candidate keys, whether the probe entity matches any of the plurality of candidates corresponding to the matched candidate keys by applying the matching rule to the probe entity and to the candidates corresponding to the matched candidate keys. - View Dependent Claims (2, 3, 4, 5, 6, 7)
-
-
8. An apparatus for identifying duplicate candidates in a database object, the apparatus comprising:
-
a processor; and one or more stored sequences of instructions which, when executed by the processor, cause the processor to; generate a match key associated with a lookup field of a database object and associated with another field of the database object; activate a matching rule associated with the match key; receive a request to search for candidates in the database object that are duplicates, the request including a probe entity; and identify the duplicate candidates in the database object by; creating a plurality of candidate keys by applying the match key to a corresponding plurality of candidates in the database object, and creating a probe key by applying the match key to the probe entity, determining whether the probe key matches any of the plurality of candidate keys, and determining, when the probe key matches any of the plurality of candidate keys, whether the probe entity matches any of the plurality of candidates corresponding to the matched candidate keys by applying the matching rule to the probe entity and to the candidates corresponding to the matched candidate keys. - View Dependent Claims (9, 10, 11, 12, 13, 14)
-
-
15. A non-transitory machine-readable medium carrying one or more sequences of instructions for identifying match candidates, which instructions, when executed by one or more processors, cause the one or more processors to:
-
generate a match key associated with a lookup field of a database object and associated with another field of the database object; activate a matching rule associated with the match key; receive a request to search for candidates that are duplicates in the database object, the request including a probe entity; and identify the duplicate candidates in the database object by; creating a plurality of candidate keys by applying the match key to a corresponding plurality of candidates in the database object, and creating a probe key by applying the match key to the probe entity, determining whether the probe key matches any of the plurality of candidate keys, and determining, when the probe key matches any of the plurality of candidate keys, whether the probe entity matches any of the plurality of candidates corresponding to the matched candidate keys by applying the matching rule to the probe entity and to the candidates corresponding to the matched candidate keys. - View Dependent Claims (16, 17, 18, 19, 20)
-
Specification