Configuration

Example Configurations

Initialized from a Tabular File - where the first row has column labels

 <component name="NormalizedAssigneeHashTable" subType="default" factoryName="aspire-hash-table">
   <initializeFromFiles>true</initializeFromFiles>
   <file>
     <fileName>data/NormalizedAssigneeFile.csv</fileName>
     <separator>comma</separator>
   </file>
   <hasColumnLabels>true</hasColumnLabels>
   <keyColumn>hashName</keyColumn>
   <valueMap>
     <column label="uniqueAsgnId"/>
     <column label="name"/>
     <column label="normAsgnId"/>
     <column label="count"/>
   </valueMap>
 </component>

Initialized from a Tabular File - with no column labels

 <component name="NormalizedAssigneeHashTable" subType="default" factoryName="aspire-hash-table">
   <initializeFromFiles>true</initializeFromFiles>
   <file>
     <fileName>data/NormalizedAssigneeFile.csv</fileName>
     <separator>comma</separator>
   </file>
   <keyColumn>column1</keyColumn>
   <valueMap>
     <column label="column3"/>
     <column label="column1"/>
     <column label="column8"/>
     <column label="column2"/>
   </valueMap>
 </component>

Initialized from a SQL Select Statement

 <component name="NormalizedAssigneeHashTable" subType="default" factoryName="aspire-hash-table">
   <initialSize>10000000</initialSize>
      
   <initializeFromSQL>true</initializeFromSQL>
   <connectionPoolName>/CPAAssigneeNorm/openRDBConnection</connectionPoolName>
   <sqlQuery><![CDATA[select Name, NormAsgnID
                from AssigneeNormalization.dbo.NormalizedAssignee]]></sqlQuery>
   <keyColumn>Name</keyColumn>
 </component>

Used as a pipeline stage

 <component name="NormalizedAssigneeHashTable" subType="default" factoryName="aspire-hash-table">
   <targetElement>documentId</targetElement>
      
   <metadataMap>
     <map from="name" to="title"/>
     <map from="subCategory" to="subCategory"/>
     <map from="geographicArea" to="geographicArea"/>
     <map from="searchKeywords1" to="searchKeywords1"/>
   </metadataMap>
       
   .
   .
 </component>
 

Note that in the above example, the metadata mapper @from attribute could be names such as "column1", "column2" etc. if the data comes from a tabular file with no column labels specified in the file.

Example use from within a Groovy scripting component

Note how, in the examples below, the hash table is referenced via a "component variable" declared in Groovy. See Groovy Scripting for more details.

Reading from the hash table

 <component name="printPatentPubCount" subType="default" factoryName="aspire-groovy">
   <variable name="normalizedAssigneeHashTable" component="/CPAAssigneeNorm/NormalizedAssigneeHashTable" />
   <variable name="uniqueAssigneeHashTable" component="/CPAAssigneeNorm/UniqueAssigneeHashTable" />        
   <script>
   <![CDATA[
     println "*** Normalized Assignee hash table size: " + normalizedAssigneeHashTable.size();
     println "*** Unique Assignee hash table size: " + uniqueAssigneeHashTable.size();          
   ]]>
   </script>
 </component>

Reading and writing the hash table

 <component name="update" subType="default" factoryName="aspire-groovy">
   <variable name="uniqueAssigneeHashTable" component="/CPAAssigneeNorm/UniqueAssigneeHashTable" />
   <script>
   <![CDATA[
     use(groovy.xml.dom.DOMCategory) {
       .
       .
       dom.'variants'[0].each() {
         if(uniqueAssigneeHashTable.contains(it.getAttribute("hash")))
           normAsgnId = uniqueAssigneeHashTable.get(it.getAttribute("hash"))[2];
       }
         
       dom.'variants'[0].each() {
         .
         .
           
         // update uniqueAssigneeHashTable with the above UniqueAsgnID
         String[] values = [localUniqueID, assigneeName, normAsgnId, '1', 
                            "PATENT", isDocDB, patent, '0', '0', sdf.format(date) ,lang];
           
         def returnValue = uniqueAssigneeHashTable.put(hashName, values);
           
         // Check to see if the key was already in the hash table...
         if(returnValue != null) {
           .
           .
           .
         }
       }
     }
   ]]>
   </script>					
 </component>