Table of Contents

Search

  1. Preface
  2. Introduction
  3. The Design Issues
  4. Standard Population Choices
  5. Parsing, Standardization and Cleaning
  6. Customer Identification Systems
  7. Fraud and Intelligence Systems
  8. Marketing Systems
  9. Simple Search
  10. Composite Keys
  11. Summary

Application and Database Design Guide

Application and Database Design Guide

Generating keys for Simple Search

Generating keys for Simple Search

Before you implement a simple search, the keys required by the search must be generated:
  1. Identify the data that you need to search. For example, you might need to search employee records in a database table EMPLOYEE stored in columns NAME and ADDRESS.
  2. Generate SSA-NAME3 keys for data in these columns. Ensure that separate calls are made to
    ssan3_get_keys
    for each column.
  3. Save the SSA-NAME3 keys along with a reference to the EMPLOYEE record. In the previous example, the keys for NAME, and ADDRESS should be stored in a single database table. An optional type indicator may be stored in this table to contain information about the type of entity such as
    Person_Name
    or Address and the index was generated from.

0 COMMENTS

We’d like to hear from you!