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

Claim 7:
8. The computer implemented method of claim 1, characterized by one or more the following selected from the group consisting of (a), (b), and (c) as follows: (a) wherein the generating the execution plan for execution of the database query on the database is in dependence on statistics data returned from the data nodes of the database to the host node of the database in response to the host node sending statistics generation command data to the data nodes, wherein the first table is a row secure table (RST), wherein access privilege data of the user in respect to the table specifies a number of rows of the RST which the user has access to, and wherein the method includes using the number of rows for determining the ordering of the first table and the second table, wherein the establishing an execution plan is performed by the host node, and wherein the establishing is in dependence on the statistics data, 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, wherein the host node uses the security data to determine the number of rows of the RST which the user has access to, (b) wherein the generating the execution plan for execution of the database query on the database is in dependence on statistics data returned from the data nodes of the database to the host node of the database in response to the host node sending statistics generation command data to the data nodes, wherein the first table is a row secure table (RST), wherein access privilege data of the user in respect to the first table specifies a number of rows of the RST which the user has access to, and wherein the method includes using the number of rows for determining the ordering of the first table and the second table, wherein the establishing an execution plan is performed by the host node, and wherein the establishing is in dependence on the statistics data, 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, wherein the host node uses the security data to determine the number of rows of the RST which the user has access to, and wherein the executing the database query includes the host node sending the security rules command data to nodes of the data nodes for applying the security rules to the RST, and (c) 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.