×

Processing queries containing a union-type operation

  • US 10,437,819 B2
  • Filed: 06/22/2015
  • Issued: 10/08/2019
  • Est. Priority Date: 11/14/2014
  • Status: Active Grant
First Claim
Patent Images

1. A computer-implemented method of generating a computer program based on an SQL query, including:

  • receiving a SQL query, including a reference to a first data set stored at a first data source, and including a reference to a second data set stored at a second data source different from the first data source;

    determining that the SQL query includes two or more commands, the commands including a first union-type operation, and a first aggregation operation, anddetermining that the SQL query describes that the first union-type operation shall be applied to at least a portion of data from the first data set, and applied to at least a portion of data from the second data set;

    determining that the SQL query describes that the first aggregation operation shall be applied to data resulting from the first union-type operation;

    generating, on a first system, a computer program based on the SQL query, the generating includinggenerating at least a first module of the computer program representing a second system, the first module configured for;

    transmitting instructions that direct a second system to perform a second aggregation operation on a portion of data from the first data set, andreceiving, from the second system, a particular data set that is a summary of the portion of data from the first data set; and

    generating at least a second module of the computer program configured for;

    receiving output originating from the first module, andperforming a second union-type operation on the particular data set and a summary of a portion of data from the second data set.

View all claims
  • 3 Assignments
Timeline View
Assignment View
    ×
    ×