US 11,755,560 B2
Converting a language type of a query
Shubham Arora, Meerut (IN); Balaji Balaraman, Bangalore (IN); Sandeep Bose, Scottsdale, AZ (US); Arindam Chatterjee, Bangalore (IN); Sastry Durvasula, Phoenix, AZ (US); Manoj Kumar Rana, Bangalore (IN); and Nitish Sharma, Bangalore (IN)
Assigned to American Express Travel Related Services Company, Inc., New York, NY (US)
Filed by American Express Travel Related Services Company, Inc., New York, NY (US)
Filed on Aug. 20, 2018, as Appl. No. 16/105,308.
Application 16/105,308 is a continuation of application No. 14/971,314, filed on Dec. 16, 2015, granted, now 10,055,444.
Prior Publication US 2019/0034476 A1, Jan. 31, 2019
Int. Cl. G06F 16/182 (2019.01); G06F 16/176 (2019.01); G06F 16/2452 (2019.01); G06F 16/23 (2019.01); G06F 16/248 (2019.01); G06F 21/62 (2013.01); G06F 16/435 (2019.01); G06F 16/17 (2019.01); G06F 16/2457 (2019.01); G06F 16/215 (2019.01); G06F 16/22 (2019.01)
CPC G06F 16/2365 (2019.01) [G06F 16/173 (2019.01); G06F 16/176 (2019.01); G06F 16/183 (2019.01); G06F 16/215 (2019.01); G06F 16/22 (2019.01); G06F 16/248 (2019.01); G06F 16/2457 (2019.01); G06F 16/24524 (2019.01); G06F 16/435 (2019.01); G06F 21/6227 (2013.01)] 20 Claims
OG exemplary drawing
 
1. A method comprising:
detecting, by a computing device, a first language type of a query configured to access a column in a data table, wherein the query is requested by a user;
determining, by the computing device, that the first language type does not conform with a data storage format of the data table;
converting, by the computing device, the query from the first language type to a second language type that conforms with the data storage format of the data table;
after converting the query to the second language type, generating, by the computing device, a temporary table including the column and excluding restricted data for which the user does not have an access permission by formatting the temporary table to support the second language type and be compliant with the access permission;
executing, by the computing device, the query against the temporary table to generate a query result; and
deleting, by the computing device, the temporary table after execution of the query against the temporary table.