Working with the Denormalized Search sample

This sample provides a pattern for extending the product to facilitate faster searches for search criteria that spans multiple database tables.

For example, when a search involves both last name and city, DB2® might need to create large internal join tables as part of its processing, depending on the data profile, which can be expensive from a performance perspective.

The pattern implementation described in this chapter creates a new table that denormalizes some search criteria and uses database triggers for maintaining the table, based on InfoSphere® MDM activity. The pluggable search SQL feature can then be used to redirect the search from the OOTB tables provided with InfoSphere MDM to instead search the new denormalized table, resulting in faster and more efficient search operations.

This Denormalized Search sample provided addresses a single set of requirements and is intended to showcase a pattern that can be leveraged and tailored to meet an implementation's specific needs.