Overlap queries on a distributed database

A system comprising:

• one or more hardware processors of a machine;
• and
• at least one memory storing instructions that, when executed by the one or more hardware processors, cause the machine to perform operations comprising:
• identifying a user dataset on a database system;
• generating a similarity score dataset that indicates a similarity between the user dataset and a plurality of datasets of other users of the database system;
• generating, using the one or more processors of the machine, a plurality of overlap queries that are configured to output overlap datasets between the user dataset and one or more of the plurality of datasets based on the similarity score dataset;
• generating a results dataset in an automatic manner without input from a user by applying one or more of the plurality of overlap queries to a joined dataset comprising data fields from the user dataset and one of the plurality of datasets of the other users on the database system, the generating of the results dataset including identifying one or more solvable problems based on the plurality of overlap queries;
• executing the one or more of the plurality of overlap queries for overlap analysis, the overlap analysis identifying one or more unresolved solvable problems based on the one or more solvable problems;
• providing the results dataset comprising the one or more unresolved solvable problems to a computing device of the user;
• and
• providing one or more recommended solutions to the one or more unresolved solvable problems on the computing device of the user.

A machine-readable storage device comprising a non-transitory computer-readable medium embodying instructions that, when executed by a machine, cause the machine to perform operations comprising

• identifying a user dataset on a database system;
• generating a similarity score dataset that indicates a similarity between the user dataset and a plurality of datasets of other users of the database system;
• generating, using the one or more processors of the machine, a plurality of overlap queries that are configured to output overlap datasets between the user dataset and one or more of the plurality of datasets based on the similarity score dataset;
• generating a results dataset in an automatic manner without input from a user by applying one or more of the plurality of overlap queries to a joined dataset comprising data fields from the user dataset and one of the plurality of datasets of the other users on the database system, the generating of the results dataset including identifying one or more solvable problems based on the plurality of overlap queries;
• executing the one or more of the plurality of overlap queries for overlap analysis, the overlap analysis identifying one or more unresolved solvable problems based on the one or more solvable problems;
• providing the results dataset comprising the one or more unresolved solvable problems to a computing device of the user;
• and
• providing one or more recommended solutions to the one or more unresolved solvable problems on the computing device of the user.