×

Database systems and user interfaces for interactive data association, analysis, and presentation

  • US 10,360,238 B1
  • Filed: 12/22/2016
  • Issued: 07/23/2019
  • Est. Priority Date: 12/22/2016
  • Status: Active Grant
First Claim
Patent Images

1. A database system for analyzing a process by accessing one or more data stores or databases and processing data items accessed from those one or more data stores or databases, the database system comprising:

  • one or more data stores configured to store;

    computer readable program instructions,a set of quality data items including internal quality data items and external quality data items, wherein;

    the quality data items are indicative of defects of manufactured items,the internal quality data items are associated with defects found during manufacture or quality control of the manufactured items, andthe external quality data items are associated with defects found after manufacture or quality control of the manufactured items, or as part of warranty processes related to the manufactured items, anda plurality of defect matching rules each indicative of one of a plurality of species of defects, wherein the defect matching rule includes at least;

    a first set of defect matching rules that indicates type/value pairs of internal quality data items indicative of internal defects, anda second set of defect matching rules that indicates type/value pairs of external quality data items indicative of external defects,and wherein the plurality of defect matching rules is user configurable; and

    a communication component for communicating over a communication network or medium; and

    one or more processors configured to execute the computer readable program instructions in order to;

    apply the first set of defect matching rules to the quality data items to identify internal defects of various species, wherein applying the first set of defect matching rules includes identifying quality data items that include type/value pairs that match at least one defect matching rule of the first set of defect matching rules;

    apply the second set of defect matching rules to the quality data items to identify external defects of various species, wherein applying the second set of defect matching rules includes identifying quality data items that include type/value pairs that match at least one defect matching rule of the second set of defect matching rules;

    determine combinations of the internal defects of various species and the external defects of various species, wherein each combination includes at least an internal quality data item and an external quality data item associated with a respective same unit identifier, and wherein the respective same unit identifiers indicate respective particular manufactured items;

    determine one or more uncaptured defects, wherein each uncaptured defect of the one or more uncaptured defects comprises a respective combination of an internal defect and an external defect associated with a respective same unit identifier that indicates a particular manufactured item;

    generate user interface data configured for rendering a user interface, the user interface including;

    selectable indications of one or more categories of groupings of defect data, wherein;

    the defect data includes the internal, external, and uncaptured defects,the categories of groupings include at least groupings by species of defects, andthe categories of groupings indicate how to combine and display at least portions of the defect data;

    a prioritized list indicating, for each of the groupings of defect data associated with a selected category, a respective frequency of uncaptured defects associated with the grouping, wherein the prioritized list is ordered by the rate of uncaptured defects; and

    a bubble chart comprising an x-axis, a y-axis, and a plurality of bubbles each corresponding to one of the groupings of defect data and spatially located based on corresponding values of the x-axis and y-axis;

    in response to receiving a selection of a category of the one or more categories;

    determine groupings of the defect data according the selected category;

    interactively update the prioritized list based on the selected category to indicate the determined groupings;

    interactively update the bubble chart to include bubbles based on defect data that is grouped according to the determined groupings associated with the selected category such that each bubble represents one or more defects; and

    in response to receiving a selection of a grouping of defect data from the prioritized list, further interactively update the bubble chart to highlight bubbles corresponding to the selected grouping of defect data.

View all claims
  • 8 Assignments
Timeline View
Assignment View
    ×
    ×