Converting a language type of a query

US11755560B2 · kind B2 · utility

Assignee

• American Express Travel Related Services Company, Inc. · US

Inventors

• Shubham Arora · Meerut, IN
• Balaji Balaraman · Bengaluru, IN
• Sandeep Bose · Scottsdale, US
• Arindam Chatterjee · Redwood City, US
• Sastry Durvasula · Phoenix, US
• Manoj Kumar Rana · Naperville, US
• Nitish Sharma · Bengaluru, IN

Key dates

• Filing date: Aug 20, 2018
• Grant date: Sep 12, 2023
• Expiry date: Mar 12, 2039

Classification

• Technology area (CPC G): Physics
• CPC primary: G06F21/6227
• WIPO field: Computer technology
• WIPO sector: Electrical engineering

Abstract

A system may receive a query configured to access a column in a data table. The data table may be in a flat file in a big data storage format. The system may detect the language type of the query and validate the query against the syntax of the language type. The system may also validate an access permission for data in the data table. The access permission may be stored in a permissions database. The system may generate a temporary table including the column with the temporary table configured to support the language type. The system may execute the query against the temporary table to generate a query result based on the temporary table as though it were the underlying data table. The system may enforce column-level or row-level access permissions by excluding columns or rows from the temporary table.