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

Patent metadata

Field	Value
Publication number	US-11250027-B2
Application number	US-201916444493-A
Country	US
Kind code	B2
Filing date	Jun 18, 2019
Priority date	Dec 22, 2016
Publication date	Feb 15, 2022
Grant date	Feb 15, 2022

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.

First claim

What is claimed is:

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 plur

Assignees

• Palantir Technologies Inc

Inventors

• O'Brien John
• Krishna Advaya
• Mallah Amr Al
• Poh Andrew
• Yu Christopher
• Puller Daniel
• Cooke Dylan
• Chlipala Jason
• Cinali Mark
• Dorin Randall
• Barton Robert
• Sinensky Samuel
• Seaton William
• Moranis Mitchell

Classifications

• G06F16/26 Primary

  Visual data mining; Browsing structured data · CPC title

• G06F16/282 Primary

  Hierarchical databases, e.g. IMS, LDAP data stores or Lotus Notes · CPC title

• G06F16/25

  Integrating or interfacing systems involving database management systems · CPC title

• G06F16/27

  Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor · CPC title