I'm working on an application which handles billions of records, where lots of records could be duplicates. My task is to make it easy to find and correct the duplicate data, but I'm bit confused how to show duplicates records so that admin or any authorised user can take action on them
What i'm thinking :
I'll make pie chart with categories
Pie chat 1:
1. First Name 2. Middle Name 3. Last Name 4. Family name
Pie chart 2:
- Home number
- street Name
- Phone number
- Pin code
And there could be lots of fields(25+) per records like ID, bank a/c number, social security number and so on
eg: I have 5 records in a group where each records contain different mobile numbers but rest of the data is same. So i'll group them inside phone category
- How do i tackle the situation (lots of groups) & lay them on the screen?
- Making 25 + pie charts and then drill down to x level is cumbersome task. Any suggestions here?