| Pre-written SQL |
- Customizable by client
- Easier SQL optimization
- Advanced SQL features
- SQL may be pre-compiled for better performance
- Ease of use for all existing search types
|
- One pre-written SQL can only handle one combination of input parameters.
Overuse of this method may result in an excessive number of pre-written
SQL statements.
|
- No predefined criteria method is available for the input parameter
combination.
- A predefined criteria method is available, however its implementation
is not as per specific search transaction requirements (functional
or nonfunctional, e.g. performance).
- Advanced SQL features or an SQL specific to the DBMS is to be
used to perform the search.
|
| searchBy <pre-defined criteria> |
- Ease of use for all predefined search criteria
- Additional and specialized logic possible for each predefined
criteria
|
- Criteria are predefined by the InfoSphere® MDM product
so clients cannot customize it.
- Current® implementation requires multiple
SQL calls to fetch the required search result.
|
- A predefined criteria method is available for the input parameter
combination and its implementation is as per the specific requirements
for the search transaction.
|
| Dynamic SQL construction |
- Customizable by client
- Slight variations in search criteria can be handled with generic
code without having to write SQL for each
|
- A generic implementation to handle SQL construction for various
combinations of input parameters can be complex
- Optimizing the resulting SQL will require the construction code
to be modified which may not be practical.
|
- Similar to pre-written SQL, but is preferable if there is a slight
variation in certain group input search parameters and the number
of combinations are too many to be coded as pre-written SQL for each
combination.
|
IBM InfoSphere Master Data Management, Version 11.3