Systems and methods for access control over changing big data structures

US10055444B2 · 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 VSM Durvasula · Phoenix, US
• Manoj Kumar Rana · Naperville, US
• Nitish Sharma · Bengaluru, IN

Key dates

• Filing date: Dec 16, 2015
• Grant date: Aug 21, 2018
• Expiry date: Dec 6, 2036

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.