Referenced in our Newsletter Volume 3, Issue 7 - July 2004

Integrating Multiple Data Sources Link Chart

VAI supports many of our clients with modeling their data sources, analyzing their contents, and reporting on the results. This usually involves integrating multiple databases through VisuaLinks. Depending on the nature of the data, the sources often contain the names of people, addresses, phone numbers, IDs, or accounts.

This month's link chart illustrates the ability to integrate data from multiple sources using the sample data/models shipped with VisuaLinks. These sample sources have been "tweaked" for this demonstration.

The first source utilized is CRIMINAL-INVESTIGATION and the subject with the name Brad Billings is presented in the display. Showing only the first level of connections, we see that our subject has connections of a variety of different objects including a criminal organization.



At this point, we use all the information pertaining to our criminal subject and cross-check the MONEY-LAUNDERING model to see if there are any reports filed on him.



Immediately, we see that through a shared driver's license number, our subject (identified with a different date-of-birth) is connected to three SAR transactions (suspicious activity reports) that all link to a common account number.

From here, we check the WIRE-TRANSFER dataset to see if any money has been moved in or out of the account.



There are 10 deposits, all below $10,000, that appear against this account. Someone is transferring money into the account and most likely our subject is moving it out in cash to support the criminal operations associated with his affiliated gang.

Using a telephone toll database, the phone numbers are checked to see if they have any communication with other parties.



Our subject heavily calls a phone number registered to a different person. That number, in turn, contacts additional phones and, at the third level of connection, our calling network stops. The thickness of the linkages indicates the frequency of the calls made between the phones.

Finally, we check our 5th and final data source to determine if there are any vehicle registrations affiliated within the network.



As can be seen in the diagram, there are a total of 3 people connected to these phones and, in fact, one of the phones has two connections. The addresses are in a different state from our original subject and the vehicles can be further checked against outstanding tickets, moving violations, or other criminal activities.

In this example, a total of 5 data sources were cross referenced using the Data Walk feature contained within VisuaLinks. The common objects (type/key) appeared in each of the sources with their respective associations.

This scenario can also be accessed from the White Papers area of our web site. Additionally, you can use our Link Charts area to view the Link Charts presented in all of our previous newsletters.