MatchUp Object:FAQ:Feature Comparison: Difference between revisions

From Melissa Data Wiki
Jump to navigation Jump to search
← Older editNewer edit →
No edit summary
No edit summary
Line 2: Line 2:
==Licenses==
==Licenses==
{|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 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 – deprecated. Can not be set with a Melissa Data ENV
Line 14: Line 14:
==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 35:
*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 46:
==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.
|Redesigned in a more linear fashion for ease of usage.
Repetitive edit controls have been removed
Repetitive edit controls have been removed
|
|
|
|
|-
|- valign="top"
|
|
;Fuzzy:
;Fuzzy:
Line 103: Line 103:
*Alphas
*Alphas
*Numerics
*Numerics
|-
|- valign="top"
|
|
;New Fuzzy Algorithms:
;New Fuzzy Algorithms:
Line 118: Line 118:
|
|
|
|
|-
|- 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 128: Line 128:
==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 143: Line 143:
==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
Line 158: Line 158:
|
|
|
|
|-
|- 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 176: Line 177:


==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
Line 186: Line 187:
*32-bit *nix .so
*32-bit *nix .so
*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 197: Line 198:
|
|
*32-bit windows dll
*32-bit windows dll
|-
|- valign="top"
|
|
;SQL specific
;SQL specific
Line 221: Line 222:
==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 236: Line 237:
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 245: Line 246:
==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
|
|

Revision as of 00:55, 26 July 2013


Licenses

MatchUp Object V3 MatchUp Object V2 Legacy (DTAPI)
Uses new License 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 – 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
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
 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
  • 64-bit windows dll, COM
  • 32-bit *nix .so
  • 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=2213"