Create new nub match table in clb schema

11537
Reporter: mdoering
Type: Improvement
Summary: Create new nub match table in clb schema
Priority: Major
Resolution: Fixed
Status: Closed
Created: 2012-07-04 10:22:57.871
Updated: 2013-12-09 13:40:58.963
Resolved: 2013-12-09 13:30:42.4
        
Description: Currently the name_usage table contains a nub_fk column linking a non nub usage to a matching nub usage.
Updating the large name_usage table with many constraints is slow and it would be faster to have this relation in a separate table.
This table can then also contain additional properties that are generated during a nub lookup such as match type (e.g. exact, fuzzy) and confidence which should useful for identifying doubtful matches and other quality control.]]>