Database systems and user interfaces for interactive data association, analysis, and presentation
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.
1. A system comprising:
one or more data stores configured to store:
computer readable program instructions, and
a set of quality data 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 item, and
the external quality data items are associated with defects found after manufacture or quality control of the manufactured items, or as part of a warranty process related to the manufactured items; and
a plurality of defect matching rules each rule indicative of one of a plurality of species of defects associated with:
internal quality data items indicative of internal defects; or
external quality data items indicative of external defects; and
one or more processors configured to execute the computer readable program instructions in order to:
apply the plurality of defect matching rules to the quality data items to identify the internal defects and external defects of various species;
receive one or more search criteria;
based on the one or more search criteria, identify a set of internal quality data items and a set of external quality data items, wherein each of the internal and external quality data items in the respective sets are associated with a unit identifier of the item;
in response to the identifying of the set of internal quality data items and the set of external quality data items, determine combinations of the internal defects of the various species and the external defects of the various species, wherein each combination includes at least an internal quality data item of the set of internal quality data items and an external quality data item of the set of external quality data items associated with a respective same unit identifier;
generate user interface data configured for rendering a first user interface, the first user interface including a listing of each of the determined combinations;
receive a user input indicating an association between a first internal quality data item and a first external quality data item of one of the determined combinations;
in response to the receiving of the user input, establish a link between the first internal quality data item and the first external quality data item, wherein the link is indicative of an uncaptured defect of a first manufactured item, and wherein the first internal quality data item and first external quality data item are associated with the same unit identifier that is associated with the first manufactured item; and
generate user interface data configured for rendering a second user interface, the second user interface including a table showing a plurality of columns indicating at least the association between the first internal quality data item and the first external quality data item, and the link between the first internal quality data item and the first external quality data item.
2. The system of claim 1 , wherein the table in the second user interface further includes:
in a first column, first indications of one or more internal quality data items of the set of internal quality data items, or first indications of one or more the external quality data items of the set of external quality data items;
in a second column, second indications of numbers of combinations of the one or more internal quality data items and the one or more external quality data items that are linked; and
in a third column, third indications of numbers of combinations of the one or more internal quality data items and the one or more external quality data items that are not linked, thereby indicating numbers of captured defects or undetected defects.
3. The system of claim 2 , wherein the second and third indications of numbers represent numbers of units.
4. The system of claim 2 , wherein the second and third indications of numbers are percentage numbers.
5. The system of claim 1 , wherein a search criterion of the one or more search criteria is received via a user interface presenting internal quality data items in the identified set or external quality data items in the identified set.
6. The system of claim 1 , wherein the one or more processors is further configured to store the established link in a data store.
7. The system of claim 1 , wherein the computer readable program instructions, when executed by the one or more processors, further configure the one or more processors to:
receive an indication of a disassociation of a second external quality data item and a second internal quality data item linked with the second external quality data item; and
de-establish the link between a value of the second external quality data item and a value of the second internal quality data item in response to the indication.
8. The system of claim 1 , wherein the computer readable program instructions, when executed by the one or more processors, further configure the one or more processors to:
classify the uncaptured defect based on a last quality checkpoint in the set of external quality data items and the set of internal quality data items associated with the unit identifier; and
generate a visual presentation based, at least in part, on the classification of the defect.
9. A method comprising:
applying a plurality of defect matching rules to quality data items to identify internal defects and external defects of various species, wherein the quality data items are indicative of defects of manufactured items, and wherein the plurality of defect matching rules comprises rules that are each indicative of one of a plurality of species of defects associated with:
internal quality data items indicative of internal defects found during manufacture or quality control of the item; or
external quality data items indicative of external defects found after manufacture or quality control of the manufactured items, or as part of a warranty process related to the manufactured items;
receiving one or more search criteria;
based on the one or more search criteria, identifying a set of internal quality data items and a set of external quality data items, wherein each of the internal and external quality data items in the respective sets are associated with a unit identifier of the item;
in response to the identifying of the set of internal quality data items and the set of external quality data items, determining combinations of the internal defects of the various species and the external defects of the various species, wherein each combination includes at least an internal quality data item of the set of internal quality data items and an external quality data item of the set of external quality data items associated with a respective same unit identifier;
generating user interface data configured for rendering a first user interface, the first user interface including a listing of each of the determined combinations;
receiving a user input indicating an association between a first internal quality data item and a first external quality data item of one of the determined combinations;
in response to the receiving of the user input, establishing a link between the first internal quality data item and the first external quality data item, wherein the link is indicative of an uncaptured defect of a first manufactured item, and wherein the first internal quality data item and first external quality data item are associated with the same unit identifier that is associated with the first manufactured item; and
generating user interface data configured for rendering a second user interface, the second user interface including a table showing a plurality of columns indicating at least the association between the first internal quality data item and the first external quality data item, and the link between the first internal quality data item and the first external quality data item.
10. The method of claim 9 , wherein the table in the second user interface further includes:
in a first column, first indications of one or more internal quality data items of the set of internal quality data items, or first indications of one or more the external quality data items of the set of external quality data items;
in a second column, second indications of numbers of combinations of the one or more internal quality data items and the one or more external quality data items that are linked; and
in a third column, third indications of numbers of combinations of the one or more internal quality data items and the one or more external quality data items that are not linked, thereby indicating numbers of captured defects or undetected defects.
11. The method of claim 9 , wherein a search criterion of the one or more search criteria is received via a user interface presenting internal quality data items in the identified set or external quality data items in the identified set.
12. The method of claim 9 , further comprising:
storing the established link in a data store.
13. The method of claim 9 , further comprising:
receiving an indication of a disassociation of a second external quality data item and a second internal quality data item linked with the second external quality data item; and
de-establishing the link between a value of the second external quality data item and a value of the second internal quality data item in response to the indication.
14. The method of claim 9 , further comprising:
classifying the uncaptured defect based on a last quality checkpoint in the set of external quality data items and the set of internal quality data items associated with the unit identifier; and
generating a visual presentation based, at least in part, on the classification of the defect.
15. A non-transitory computer-readable medium storing a set of instructions that are executable by one or more processors to cause the one or more processors to:
apply a plurality of defect matching rules to quality data items to identify internal defects and external defects of various species, wherein the quality data items are indicative of defects of manufactured items, and wherein the plurality of defect matching rules comprises rules that are each indicative of one of a plurality of species of defects associated with:
internal quality data items indicative of internal defects found during manufacture or quality control of the item; or
external quality data items indicative of external defects found after manufacture or quality control of the manufactured items, or as part of a warranty process related to the manufactured items;
receive one or more search criteria;
based on the one or more search criteria, identify a set of internal quality data items and a set of external quality data items, wherein each of the internal and external quality data items in the respective sets are associated with a unit identifier of the item;
in response to the identifying of the set of internal quality data items and the set of external quality data items, determine combinations of the internal defects of the various species and the external defects of the various species, wherein each combination includes at least an internal quality data item of the set of internal quality data items and an external quality data item of the set of external quality data items associated with a respective same unit identifier;
generate user interface data configured for rendering a first user interface, the first user interface including a listing of each of the determined combinations;
receive a user input indicating an association between a first internal quality data item and a first external quality data item of one of the determined combinations;
in response to receiving the user input, establish a link between the first internal quality data item and the first external quality data item, wherein the link is indicative of an uncaptured defect of a first manufactured item, and wherein the first internal quality data item and first external quality data item are associated with the same unit identifier that is associated with the first manufactured item; and
generate user interface data configured for rendering a second user interface, the second user interface including a table showing a plurality of columns indicating at least the association between the first internal quality data item and the first external quality data item, and the link between the first internal quality data item and the first external quality data item.
16. The non-transitory computer-readable medium of claim 15 , wherein the table in the second user interface further includes:
in a first column, first indications of one or more internal quality data items of the set of internal quality data items, or first indications of one or more the external quality data items of the set of external quality data items;
in a second column, second indications of numbers of combinations of the one or more internal quality data items and the one or more external quality data items that are linked; and
in a third column, third indications of numbers of combinations of the one or more internal quality data items and the one or more external quality data items that are not linked, thereby indicating numbers of captured defects or undetected defects.
17. The non-transitory computer-readable medium of claim 15 , wherein a search criterion of the one or more search criteria is received via a user interface presenting internal quality data items in the identified set or external quality data items in the identified set.
18. The non-transitory computer-readable medium of claim 15 , wherein the one or more processors is further configured to store the established link in a data store.
19. The non-transitory computer-readable medium of claim 15 , wherein the one or more processors are further configured to:
receive an indication of a disassociation of a second external quality data item and a second internal quality data item linked with the second external quality data item; and
de-establish the link between a value of the second external quality data item and a value of the second internal quality data item in response to the indication.
20. The non-transitory computer-readable medium of claim 15 , wherein the one or more processors are further configured to:
classify the uncaptured defect based on a last quality checkpoint in the set of external quality data items and the set of internal quality data items associated with the unit identifier; and
generate a visual presentation based, at least in part, on the classification of the defect.