Example Database Usage and UUID-Field Construction

Client Tools Guide › Unique User ID (UUID) Menu › User Databases in the UUID Tool › Master vs. Other Databases › Example Database Usage and UUID-Field Construction

Example Database Usage and UUID-Field Construction

This example shows two separate databases that treat data for a single employee in an organization. In Database 1 the employee is referenced by Person Name and the employee Telephone number is provided in the form <Area Code-Number>. In Database 2 the employee is referenced by a Person ID and the employee phone number is provided as two separate fields, Area Code and Phone Number.

Database 1

Fields in Database 1	Person Name	Telephone
Data	John Smith	09-7693219

Database 2

Fields in Database 2	Person ID	Area Code	Phone Number
Data	1234567	09	7693219

By looking at the phone number in each database you can see that the Phone Numbers are identical even though they are referred to in slightly different forms. We can therefore extrapolate from that, that the employee John Smith in Database 1 is the same individual that is referred to by the Person ID of 1234567 in Database 2. Essentially we have used the data provided by the phone numbers to build a virtual bridge between the two databases.