US 11,868,349 B2
Row secure table plan generation
Artur M. Gruszecki, Cracow (PL); Tomasz Sekman, Cracow (PL); Tomasz Kazalski, Balice (PL); and Andrzej Jan Wrobel, Cracow (PL)
Assigned to International Business Machines Corporation, Armonk, NY (US)
Filed by INTERNATIONAL BUSINESS MACHINES CORPORATION, Armonk, NY (US)
Filed on May 5, 2020, as Appl. No. 16/867,228.
Prior Publication US 2021/0349903 A1, Nov. 11, 2021
Int. Cl. G06F 16/2453 (2019.01); G06F 21/62 (2013.01)
CPC G06F 16/24544 (2019.01) [G06F 21/6227 (2013.01)] 20 Claims
OG exemplary drawing
 
1. A computer implemented method comprising:
identifying an invoked database query for execution on a database, the invoked database query being associated to a user;
generating an execution plan for executing the database query on the database;
wherein the generating the execution plan for execution of the database query on the database includes establishing an ordering of first and second tables, the ordering of the first and second tables being in dependence on an access privilege attribute of the user in respect to the first table, wherein the database includes a host node and data nodes, the first and second tables being distributed on the data nodes; and
executing the database query according to the execution plan.