Which data modeling decision helps in searching while preserving user input formatting?

Which data modeling decision helps in searching while preserving user input formatting?

• A. Store both normalized and original address forms.
• B. Store only the normalized form, no original.
• C. Store addresses as free text only.
• D. Do not store any normalized fields.

Answer: (A)

Balancing searchability and preserving user input. Storing both a normalized form and the original input gives the best of both worlds: the normalized data standardizes street names, abbreviations, casing, and punctuation so searches can match across variations (for example, “St.” vs “Street” or different capitalization), while keeping the original entry lets you display exactly what the user typed, preserving formatting for display, auditing, or user confirmation.

If you only store the normalized form, you lose the exact user-entered formatting, which can be important for how results are presented or verified. If you store addresses as free text only, you miss the reliability and speed of querying against a consistent, structured representation. If you don’t store any normalized fields, search accuracy suffers and comparisons become inconsistent.

So the best approach is to keep both: use the normalized form for robust searching and the original form for faithful display and user context.