System and method for generating visual queries in non-relational databases

A system comprising:

• at least one processor operatively connected to a memory, the at least one processor when executing is configured to:
• receive specification of at least a subset of data within a non-relational database in a user interface display;
• evaluate a sample threshold against the size within the at least a subset of data, and in response to exceeding the sample threshold, sample within the at least a subset of data to generate sampled data from the subset or entire data set;
• generate a visualization of common attributes and respective data elements from the sampled data;
• and
• generate associations between the visualizations of the common attributes, respective data, and query syntax, wherein responsive to an indication of a selection of one or more of the visualizations of the common attributes or the respective data in a user interface, the at least one processor generates at least an executable portion of a query based on a selected attribute or respective data and a data type associated with the selected attribute or the respective data.

A method for generating visual queries for a non-relational database, the method comprising acts of:

• receiving, by at least one processor coupled to a memory, specification of a subset of data within a non-relational database or the entire non-relational database;
• sampling, by the at least one processor, from the subset of data within the non-relational database or from the entire non-relational database;
• identifying, by the at least one processor from within the sample, common attributes with which to build a virtual schema;
• and
• generating, by the at least one processor, visualizations of common attributes and respective data from the sampled data, and mappings to the sampled data associated with the common attributes;
• and
• generating by the at least one processor associations between the visualizations of the common attributes, respective data, and query syntax, and wherein responsive to an indication of a selection of one or more of the visualizations of the common attributes or the respective data in the user interface, generating, by the at least one processor, at least an executable portion of a query based on a selected attribute or respective data and a data type associated with the selected attribute or the respective data.