Patent ID: 11868349
Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
Field: Computer technology (Electrical engineering)
Classification: CPC G | IPC G

Claim 10:
11. The computer implemented method of claim 1, characterized by one or more the following selected from the group consisting of (a), (b), (c) and (d) as follows: (a) wherein the database includes the host node performing the establishing, and wherein the first and second tables are distributed amongst storage systems of the data nodes, wherein the method includes sending, by the host node, statistics generating command data to the data nodes and the data nodes responsively sending table statistics data to the host node in response to the statistics generating command data, and wherein the establishing is in dependence on the statistics data, wherein the first table is a row secure table (RST), and wherein sending, by the host node, the statistics generating command data includes the host node sending security rules command data for applying security rules to the RST, the nodes of the data nodes responsively sending RST statistics to the host node, wherein the RST statistics includes security data in respect to rows of the RST, (b) wherein the database includes the host node performing the establishing and a plurality of data nodes in communication with the host node, and wherein the first and second tables are distributed amongst respective storage systems of the data nodes, wherein the method includes examining, by the host node, the invoked database query to identify a user associated to the database query and a row secure table (RST), wherein the RST is provided by the first table, wherein the method includes locating in a data repository of the host node a statistics system table associated to the first table, and using the statistics system table, determining an access privilege attribute of the user in reference to the first table, adjusting the table size of the first table in dependence on the determining to provide an adjusted table size for the first table and performing the establishing of the ordering of first and second tables using the adjusted table size of the first table, (c) wherein the database includes a host node that performs the establishing and a plurality of data nodes in communication with the host node, and wherein the first and second tables are distributed amongst respective storage systems of the data nodes, wherein the method includes examining, by the host node, the invoked database query to identify a user associated to the database query, a row secure table (RST) and a JOIN clause, wherein the RST is provided by the first table, wherein the method includes locating in a data repository of the host node a statistics system table associated to the first table, and using the statistics system table and one or more security association table stored in the data repository, determining an access privilege attribute of the user in reference to the first table, adjusting the table size of the first table in dependence on the determining to provide an adjusted table size for the first table and performing the establishing of the ordering of first and second tables using the adjusted table size of the first table, wherein the establishing of the ordering of first and second tables using the adjusted table size of the first table is for execution of the JOIN clause, (d) wherein the database includes a host node that performs the establishing and a plurality of data nodes in communication with the host node, and wherein the first and second tables are distributed amongst respective storage systems of the data nodes, wherein the method includes examining, by the host node, the invoked database query to identify (i) a user associated to the database query, (ii) a row secure table (RST) referenced by the database query and (iii) a JOIN clause referenced by the database query, wherein the RST is provided by the first table, wherein the method includes locating in a data repository of the host node statistical data that has been extracted in response to the host node, prior to a time of invoking of the invoked database query and in idle time of the database, applying security rules to the first table, adjusting the table size of the first table in dependence on the statistical data to provide an adjusted table size for the first table, and performing, by the host node, the establishing of the ordering of first and second tables using the adjusted table size of the first table, wherein the establishing of the ordering of first and second tables using the adjusted table size of the first table is for execution of the JOIN clause.