Difference between revisions of "MatchUp Object:FAQ:Feature Comparison"

From Melissa Data Wiki
Jump to navigation Jump to search
(Created page with "{{CustomTOC}} ==Licenses== {|class="alternate01" cellspacing="0" !MatchUp Object V3 !MatchUp Object V2 !style="border-right:0px;"|Legacy (DTAPI) |- |Uses new License class for...")
 
 
(7 intermediate revisions by the same user not shown)
Line 1: Line 1:
[[MatchUp Object|← MatchUp Object]]
{{CustomTOC}}
{{CustomTOC}}
==Licenses==
==License Keys==
{|class="alternate01" cellspacing="0"
{|class="alternate01" cellspacing="0"
!MatchUp Object V3
!style="background-color:#ddd;"|MatchUp Object V3
!MatchUp Object V2
!style="background-color:#ddd;"|MatchUp Object V2
!style="border-right:0px;"|Legacy (DTAPI)
!style="background-color:#ddd;"|Legacy (DTAPI)
|-
|- valign="top"
|Uses new License class for easy integration With other Melissa Data products. Can be set as ENV variable
|Uses new License Key class for easy integration With other Melissa Data products. Can be set as ENV variable
|Uses old style license – deprecated. Can not be set with a Melissa Data ENV
|Uses old style License Key – deprecated. Can not be set with a Melissa Data ENV
|Uses old style license – deprecated. Can not be set with a Melissa Data ENV
|Uses old style License Key – deprecated. Can not be set with a Melissa Data ENV
|}
|}


Line 14: Line 15:
==Deduping Engines==
==Deduping Engines==
{|class="alternate01" cellspacing="0"
{|class="alternate01" cellspacing="0"
!MatchUp Object V3
!style="background-color:#ddd;"|MatchUp Object V3
!MatchUp Object V2
!style="background-color:#ddd;"|MatchUp Object V2
!style="border-right:0px;"|Legacy (DTAPI)
!style="background-color:#ddd;"|Legacy (DTAPI)
|-
|- valign="top"
|Read-Write (batch, or full database(s))
|Read-Write (batch, or full database(s))
|Read-Write (batch, or full database(s))
|Read-Write (batch, or full database(s))
|Read-Write (batch, or full database(s))
|Read-Write (batch, or full database(s))
|-
|- valign="top"
|Incremental (real-time deduping)
|Incremental (real-time deduping)
|Incremental (real-time deduping)
|Incremental (real-time deduping)
|Incremental (real-time deduping)
|Incremental (real-time deduping)
|-
|- valign="top"
|Hybrid (more developer flexible)
|Hybrid (more developer flexible)
*Cluster selection
*Cluster selection
Line 35: Line 36:
*Cluster selection
*Cluster selection
*Key storage
*Key storage
|-
|- valign="top"
|Intersecting Deduper
|Intersecting Deduper
*First component in all combinations no longer required
*First component in all combinations no longer required
Line 46: Line 47:
==Matchcode Editor==
==Matchcode Editor==
{|class="alternate01" cellspacing="0"
{|class="alternate01" cellspacing="0"
!MatchUp Object V3
!style="background-color:#ddd;"|MatchUp Object V3
!MatchUp Object V2
!style="background-color:#ddd;"|MatchUp Object V2
!style="border-right:0px;"|Legacy (DTAPI)
!style="background-color:#ddd;"|Legacy (DTAPI)
|-
|- valign="top"
|Completely redesigned Matchcode Editor
|Completely redesigned Matchcode Editor
|Older interface - deprecated
|Older interface - deprecated
|Older interface – deprecated
|Older interface – deprecated
|-
|- valign="top"
|Expanded descriptions for more intuitive understanding
|Expanded descriptions for more intuitive understanding
|
|
|
|
|-
|- valign="top"
|Redesigned in a more linear fashion for ease of usage. Repetitive edit controls have been removed
|Redesigned in a more linear fashion for ease of usage.
Repetitive edit controls have been removed
|
|
|
|
|-
|- valign="top"
|
|
;Fuzzy:
;Fuzzy:
Line 102: Line 104:
*Alphas
*Alphas
*Numerics
*Numerics
|-
|- valign="top"
|
|
;New Fuzzy Algorithms:
;New Fuzzy Algorithms:
Line 115: Line 117:
*Smith-Waterman-Gotoh
*Smith-Waterman-Gotoh
*MD Keyboard
*MD Keyboard
*Double Metaphone
*UTF-8 Near
|
|
|
|
|-
|- valign="top"
|Integrated into SSIS component  
|Integrated into SSIS component  
No need to shell out of SSIS to file system
No need to shell out of SSIS to file system
Line 127: Line 131:
==Matchcode Component Types==
==Matchcode Component Types==
{|class="alternate01" cellspacing="0"
{|class="alternate01" cellspacing="0"
!MatchUp Object V3
!style="background-color:#ddd;"|MatchUp Object V3
!MatchUp Object V2
!style="background-color:#ddd;"|MatchUp Object V2
!style="border-right:0px;"|Legacy (DTAPI)
!style="background-color:#ddd;"|Legacy (DTAPI)
|-
|- valign="top"
|Existing 33 Component types + New:
|Existing 33 Component types + New:
*Date (days)
*Date (days)
Line 142: Line 146:
==Expanded Interfaces and Methods==
==Expanded Interfaces and Methods==
{|class="alternate01" cellspacing="0"
{|class="alternate01" cellspacing="0"
!MatchUp Object V3
!style="background-color:#ddd;"|MatchUp Object V3
!MatchUp Object V2
!style="background-color:#ddd;"|MatchUp Object V2
!style="border-right:0px;"|Legacy (DTAPI)
!style="background-color:#ddd;"|Legacy (DTAPI)
|-
|- valign="top"
|
|
;New Interface
;New Interface
MatchcodeList – easier to develop dynamic
*MatchcodeList
Applications for selecting a matchcode
:Easier to develop dynamic Applications for selecting a matchcode
SetPathToMatchUpFiles  
*SetPathToMatchUpFiles  
InitializeDataFiles
*InitializeDataFiles
GetInitializeErrorString
*GetInitializeErrorString
GetMatchcodeCount  
*GetMatchcodeCount  
GetMatchcodeName  
*GetMatchcodeName  
|
|
|
|
|-
|- valign="top"
|
|
;New Methods
;New Methods
GetResults – conforms to other Melissa Data products for easy integration
*GetResults
:Conforms to other Melissa Data products for easy integration
*GetNearDbl (component)  
*GetNearDbl (component)  
*SetNearDbl (component)  
*SetNearDbl (component)  
Line 169: Line 174:
*RenameMatchcode  
*RenameMatchcode  
*DeleteMatchcode
*DeleteMatchcode
*SetEncoding
*SetMaximumCharacterSize
|GetStatusCode and GetCombinations have been deprecated
|GetStatusCode and GetCombinations have been deprecated
|GetStatusCode and GetCombinations have been deprecated
|GetStatusCode and GetCombinations have been deprecated
|}
|}




==Distributed Libraries==
==Distributed Libraries==
{|class="alternate01" cellspacing="0"
{|class="alternate01" cellspacing="0" align="top"
!MatchUp Object V3
!style="background-color:#ddd;"|MatchUp Object V3
!MatchUp Object V2
!style="background-color:#ddd;"|MatchUp Object V2
!style="border-right:0px;"|Legacy (DTAPI)
!style="background-color:#ddd;"|Legacy (DTAPI)
|-
|- valign="top"
|
|
*32-bit windows dll, COM
*32-bit windows dll, COM (deprecated 2628)
*64-bit windows dll, COM
*64-bit windows dll, COM (deprecated 2628)
*32-bit *nix .so
*32-bit *nix .so (deprecated 2628)
*64-bit *nix .so
*64-bit *nix .so
*Interface wrappers – multiple languages,
*Interface wrappers
*Conform to other Melissa Data products for
:Multiple languages conform to
*Easy integration
:other Melissa Data products for easy integration
*SSIS Component (rapid development)
*SSIS Component (rapid development)
|
|
Line 196: Line 203:
|
|
*32-bit windows dll
*32-bit windows dll
|-
|- valign="top"
|
|
;SQL specific
;SQL specific
Line 220: Line 227:
==Data Files==
==Data Files==
{|class="alternate01" cellspacing="0"
{|class="alternate01" cellspacing="0"
!MatchUp Object V3
!style="background-color:#ddd;"|MatchUp Object V3
!MatchUp Object V2
!style="background-color:#ddd;"|MatchUp Object V2
!style="border-right:0px;"|Legacy (DTAPI)
!style="background-color:#ddd;"|Legacy (DTAPI)
|-
|- valign="top"
|
|
;mdMatchUp.dat
;mdMatchUp.dat
Line 235: Line 242:
Editable override for .dat file allows for streamlined data file updates  
Editable override for .dat file allows for streamlined data file updates  
|*.dbf
|*.dbf
|-
|- valign="top"
|Automatic install of data files to User location Preventing UAC issues
|Automatic install of data files to User location Preventing UAC issues
|
|
Line 244: Line 251:
==Help==
==Help==
{|class="alternate01" cellspacing="0"
{|class="alternate01" cellspacing="0"
!MatchUp Object V3
!style="background-color:#ddd;"|MatchUp Object V3
!MatchUp Object V2
!style="background-color:#ddd;"|MatchUp Object V2
!style="border-right:0px;"|Legacy (DTAPI)
!style="background-color:#ddd;"|Legacy (DTAPI)
|-
|- valign="top"
|.pdf
|.pdf
|.pdf
|.pdf
|*.chm
|*.chm
|-
|- valign="top"
|Direct links to WebHelp – allowing for up to date documentation
|Direct links to WebHelp – allowing for up to date documentation
|
|
Line 258: Line 265:




[[Category:FAQ]]
[[Category:MatchUp Object]]
[[Category:MatchUp Object]]

Latest revision as of 17:54, 16 December 2016

← MatchUp Object


License Keys

MatchUp Object V3 MatchUp Object V2 Legacy (DTAPI)
Uses new License Key class for easy integration With other Melissa Data products. Can be set as ENV variable Uses old style License Key – deprecated. Can not be set with a Melissa Data ENV Uses old style License Key – deprecated. Can not be set with a Melissa Data ENV


Deduping Engines

MatchUp Object V3 MatchUp Object V2 Legacy (DTAPI)
Read-Write (batch, or full database(s)) Read-Write (batch, or full database(s)) Read-Write (batch, or full database(s))
Incremental (real-time deduping) Incremental (real-time deduping) Incremental (real-time deduping)
Hybrid (more developer flexible)
  • Cluster selection
  • Key storage
 Hybrid (more developer flexible)
  • Cluster selection
  • Key storage
 Hybrid (more developer flexible)
  • Cluster selection
  • Key storage
Intersecting Deduper
  • First component in all combinations no longer required
  • No restrictions on first component
 first component restrictions first component restrictions


Matchcode Editor

MatchUp Object V3 MatchUp Object V2 Legacy (DTAPI)
Completely redesigned Matchcode Editor Older interface - deprecated Older interface – deprecated
Expanded descriptions for more intuitive understanding
Redesigned in a more linear fashion for ease of usage.

Repetitive edit controls have been removed

Fuzzy
  • Exact
  • Phonetex
  • Sounex
  • Containment
  • Frequency
  • Fast Near
  • Accurate Near
  • Frequency Near
  • Vowels
  • Consonants
  • Alphas
  • Numerics
Fuzzy
  • Exact
  • Phonetex
  • Sounex
  • Containment
  • Frequency
  • Fast Near
  • Accurate Near
  • Frequency Near
  • Vowels
  • Consonants
  • Alphas
  • Numerics
Fuzzy
  • Exact
  • Phonetex
  • Sounex
  • Containment
  • Frequency
  • Fast Near
  • Vowels
  • Consonants
  • Alphas
  • Numerics
New Fuzzy Algorithms
  • N-Gram
  • Jaro Distance
  • Jaro-Winkler Distance
  • Longest Common Substring
  • Jaccard Index
  • Dices Coefficient
  • Overlap Coefficient
  • Needleman-Wunsch
  • Smith-Waterman-Gotoh
  • MD Keyboard
  • Double Metaphone
  • UTF-8 Near
Integrated into SSIS component

No need to shell out of SSIS to file system


Matchcode Component Types

MatchUp Object V3 MatchUp Object V2 Legacy (DTAPI)
Existing 33 Component types + New:
  • Date (days)
  • Numeric (integer unit)
  • Proximity (miles)
 Existing 33 Component types Existing 33 Component types


Expanded Interfaces and Methods

MatchUp Object V3 MatchUp Object V2 Legacy (DTAPI)
New Interface
  • MatchcodeList
Easier to develop dynamic Applications for selecting a matchcode
  • SetPathToMatchUpFiles
  • InitializeDataFiles
  • GetInitializeErrorString
  • GetMatchcodeCount
  • GetMatchcodeName
New Methods
  • GetResults
Conforms to other Melissa Data products for easy integration
  • GetNearDbl (component)
  • SetNearDbl (component)
  • GetDescription (matchcode)
  • SetDescription (matchcode)
  • GetNGram (matchcode)
  • SetNGram (matchcode)
  • RenameMatchcode
  • DeleteMatchcode
  • SetEncoding
  • SetMaximumCharacterSize
 GetStatusCode and GetCombinations have been deprecated GetStatusCode and GetCombinations have been deprecated


Distributed Libraries

MatchUp Object V3 MatchUp Object V2 Legacy (DTAPI)
  • 32-bit windows dll, COM (deprecated 2628)
  • 64-bit windows dll, COM (deprecated 2628)
  • 32-bit *nix .so (deprecated 2628)
  • 64-bit *nix .so
  • Interface wrappers
Multiple languages conform to
other Melissa Data products for easy integration
  • SSIS Component (rapid development)
  • 32-bit windows dll, COM
  • 64-bit windows dll, COM
  • 32-bit *nix .so
  • 64-bit *nix .so
  • 32-bit windows dll
SQL specific
  • Single library required
  • 32-bit User Defined Fuctions
  • 32-bit Extended Stored Procedures
  • 64-bit User Defined Fuctions
  • 64-bit Extended Stored Procedures
  • CLR interface functions
  • Triggers
SQL specific
  • Single library required
  • 32-bit UDFs and _xps
  • 64-bit UDFs and _xps
SQL specific
  • Separate libraries needed to be maintained
  • 32-bit UDFs and _xps


Data Files

MatchUp Object V3 MatchUp Object V2 Legacy (DTAPI)
mdMatchUp.dat

Existing data files have been rolled into a single data file

mdMatchUp.cfg

Editable override for .dat file allows for streamlined data file updates

mdMatchUp.dat

Existing data files have been rolled into a single data file

mdMatchUp.cfg

Editable override for .dat file allows for streamlined data file updates

*.dbf
Automatic install of data files to User location Preventing UAC issues


Help

MatchUp Object V3 MatchUp Object V2 Legacy (DTAPI)
.pdf .pdf *.chm
Direct links to WebHelp – allowing for up to date documentation
Retrieved from "http://wiki.melissadata.com/index.php?title=MatchUp_Object:FAQ:Feature_Comparison&oldid=11899"