Executing structured queries on unstructured data

A computer-implemented system,

• comprising:
• one or more processors;
• and
• one or more non-transitory computer-readable storage mediums containing instructions configured to cause the one or more processors to perform operations including:
• receiving a structured query in a structured query language;
• determining a schema that defines a structure for unstructured data,
• wherein the schema identifies a plurality of fields in the unstructured data;
• conducting a pilot query on the unstructured data, wherein the pilot query is conducted using the schema, and wherein conducting the pilot query identifies one or more fields in the unstructured data;
• converting the structured query in the structured query language into an unstructured query in an unstructured query language, wherein the conversion is done using the one or more fields identified by conducting the pilot query, and wherein the unstructured query is used to access the unstructured data;
• conducting a search on the unstructured data using the unstructured query;
• caching the one or more fields identified by conducting the pilot query;
• conducting a new pilot query on the unstructured data, wherein conducting the new pilot query identifies one or more new fields in the unstructured data;
• and
• merging the one or more cached fields with the one or more new fields.

A computer-program product, tangibly embodied in a non-transitory machine-readable storage medium, including instructions configured to cause a data processing apparatus to:

• receive a structured query in a structured query language;
• determine a schema that defines a structure for unstructured data, wherein the schema identifies a plurality of fields in the unstructured data;
• conduct a pilot query on the unstructured data, wherein the pilot query is conducted using the schema, and wherein conducting the pilot query identifies one or more fields in the unstructured data;
• convert the structured query in the structured query language into an unstructured query in an unstructured query language, wherein the conversion is done using the one or more fields identified by conducting the pilot query, and wherein the unstructured query is used to access the unstructured data;
• conduct a search on the unstructured data using the unstructured query;
• cache the one or more fields identified by conducting the pilot query;
• conduct a new pilot query on the unstructured data, wherein conducting the new pilot query identifies one or more new fields in the unstructured data;
• and
• merge the one or more cached fields with the one or more new fields.