Database systems and user interfaces for interactive data association, analysis, and presentation
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.
8 Assignments
0 Petitions
Accused Products
Abstract
Embodiments of the present disclosure relate to systems, techniques, methods, and computer-readable mediums for one or more database systems for data processing, including database and file management, as well as systems for accessing one or more databases or other data structures and searching, filtering, associating, and analyzing data. The present disclosure further relates to computer systems and techniques for interactive data visualization and presentation from one or more databases.
241 Citations
16 Claims
-
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, and the 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, and a 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, and a 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, and the 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 Dependent Claims (2, 3, 4, 5, 6)
-
-
7. 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, and the 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, and a plurality of defect matching rules each indicative of one of a plurality of species of defects, wherein the defect matching rule include at least; a first set of defect matching rules that indicate type/value pairs of internal quality data items indicative of internal defects, and a second set of defect matching rules that indicate type/value pairs of external quality data items indicative of external defects; 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; apply the second set of defect matching rules to the quality data items to identify external defects of various species; 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; 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 included in the groupings of defect data includes the internal, external, and uncaptured defects, the categories of groupings include at least groupings by species of defects, and the 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 of defect data, wherein the prioritized list is ordered by a rate of uncaptured defects; and a heat map containing a layout of a production line showing a plurality of quality control units, wherein representation of a first quality control unit in the plurality of quality control units is based on a last quality checkpoint detecting a defect associated with the first quality control unit; 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 heat map to include visual indicators based on defect data that is grouped according to the determined groupings associated with the selected category such that each visual indicator represents one or more defects; and in response to receiving a selection of a grouting of defect data from the prioritized list, further interactively update the heat map to zoom into and highlight one or more sections of the heat map corresponding to the selected grouping of defect data. - View Dependent Claims (8, 9, 10, 11, 12, 13, 14, 15, 16)
-
Specification