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

Composite Keys

Composite Keys

To speed up searches and reduce the number of records that a search request retrieves, you can use a composite key.
A composite key is a combination of multiple SSA-NAME3 fields. For example, to search for a person, such as John Doe, who resides at a specific address, you can create a composite key by combining the Person_Name and Address_Part1 fields. This approach returns only the records of John Doe that match the composite key, instead of records that pertain to any John Doe.
When you use the
ssan3_get_keys
or
ssan3_get_ranges
calls to build keys and ranges, you can specify multiple fields. SSA-NAME3 concatenates the key for each field and builds a composite key instead of using multiple keys.

0 COMMENTS

We’d like to hear from you!