Take the 2-minute tour ×
User Experience Stack Exchange is a question and answer site for user experience researchers and experts. It's 100% free, no registration required.

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. Name:

    1. First Name
    2. Middle Name
    3. Last Name
    4. Family name

Pie chart 2:

  1. Address

    1. Official
    2. Residential
      1. Home number
      2. street Name
      3. Phone number
      4. 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


  1. How do i tackle the situation (lots of groups) & lay them on the screen?
  2. Making 25 + pie charts and then drill down to x level is cumbersome task. Any suggestions here?
share|improve this question

1 Answer 1

To me this looks like reports of some kind, where admin should resolve issues with duplicates. The pie chart is more used to visualize data as parts of the whole information set. An example of the pie chart can be sales by region of total sales... like this:

Sales by region example

In this case I think a simple list would do the job. Provide a list of possible duplicates where you can switch between showing the whole list and only list items with issues (where you notify admin).


download bmml source – Wireframes created with Balsamiq Mockups

This list of issues is a drill down list where Name expands in the next screen to sub items of name (first, last, middle,...). This is a better way to display issues to be resolved by admins.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.