Reviewing Key Analysis Results - trillium_discovery - trillium_quality - 17.1

After your data is imported into a repository and you have created an entity, you should review the potential keys and determine whether they are relevant to your data investigation.

To review key analysis results

1. Click the Analysis tab and expand the Keys folder.
2. Expand the Key Analysis Results folder. Discovered keys are grouped into folders, one for each entity.
3. Right-click Key Analysis Results and select Drill down to Keys Results. The Key Jobs List View opens. Each row corresponds with a key analysis job for an entity.
4. Double-click the row you want to review. The Keys List View opens displaying keys discovered during the data analysis for the selected entity. (If the List View does not display, there are no keys for that entity.)
5. Review the information for each key.

   When you review keys, the following information is available:

   Column	Description
   Lh Attrs	Attributes that comprise the primary key.
   Status	Indicates status of key: Discovered—indicates that discovered key has not been examined. Status as a valid key has not been verified. Permanent—indicates the key has been verified as a valid key.
   Verified	Indicates whether the key was checked against every row in the imported data, and therefore, if the list of duplicates is complete. If the original data source contains less than 10,000 rows, this column has a value of Yes. Trillium searches for keys in only the first 10,000 rows of imported data. If the original data source has less than 10,000 rows, all rows are automatically included in the key search, and therefore, any keys found are checked against every row.
   Ref	Unique key analysis reference number.
   Quality %	Indicates how well the attributes in the entity form a key.
   Keys	Indicates the number of non-duplicated (distinct) key values.
   Duplicate Keys	Indicates the number of distinct key values duplicated on more than one row.
   Duplicate Rows	Indicates the number of rows with duplicate key values.
   Verified Date	Date the key analysis was last verified.
   Verified By	User who performed the key analysis.
   Created Date	Date the key was created.
   Created By	User who created the key.

6. Double-click a key with a Quality % value that is less than 100%. The Duplicate Keys List View opens. Duplicate keys indicate key values that are non-unique and so are not good candidates for permanent keys.
   Note: Keys that are found by combining two attributes are not checked with a third attribute. Only attributes that fail to be double-attribute keys are checked as triple-attribute keys, quadruple-attribute keys, and so on.

   Note: The Lh Attrs column in the keys List View shows the attributes that comprise the key. If you check more attributes against an existing key, they are not shown in List View because after a key is discovered, it remains a key no matter how many additional attributes are combined with it.