Invention Grant
- Patent Title: Processing queries containing a union-type operation
-
Application No.: US14746188Application Date: 2015-06-22
-
Publication No.: US10437819B2Publication Date: 2019-10-08
- Inventor: Ian Schechter , Alexander Lavrentyev
- Applicant: Ab Initio Technology LLC
- Applicant Address: US MA Lexington
- Assignee: Ab Initio Technology LLC
- Current Assignee: Ab Initio Technology LLC
- Current Assignee Address: US MA Lexington
- Agency: Fish & Richardson P.C.
- Main IPC: G06F16/24
- IPC: G06F16/24 ; G06F16/242 ; G06F16/28 ; G06F16/901 ; G06F16/2453 ; G06F8/30 ; G06F16/2452

Abstract:
Among other things, a method of generating a computer program based on an SQL query includes 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, and determining 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, and generating the computer program.
Public/Granted literature
- US20160140166A1 PROCESSING QUERIES CONTAINING A UNION-TYPE OPERATION Public/Granted day:2016-05-19
Information query