IM InfoSphere Identity Insight, Version 8.0

Large Entities query

This SQL query looks for large entities. The more identity records an entity has, the larger it becomes. Sometimes, the results of processing incoming identity data can cause the system to over-resolve identity records during entity and relationship resolution. Large entities can cause a marked slow down in system performance.

Large Entities SQL Query statement

select	entity_id
	count(dsrc_acct) as IDENTITY_CNT
from
	DSRC_ACCT
where
	sys_delete_dt is null
group by
	entity_id
count(dsrc_acct) > 100
order by count(dsrc_acct)desc;

What next?

In the Visualizer, use the Find by Entity ID screen to look up the Entity IDs returned by the Large Entities query results. Verify that the identities associated with this entity are properly associated. For properly constructed entities, the entity has many different data source accounts, while most of the data for associated names, addresses, and numbers of are very similar. If you have questions about whether the entity is properly constructed, contact your IBM Services or Support for further assistance.

Example results of Large Entities query

Here is an example of what the results of running the Large Entities query might look like:
ENTITY_ID IDENTITY_CNT
3015 22
5241 41
7854 36


Feedback

Last updated: 2009