US 12,072,882 B2
Database query processing
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,152.
Prior Publication US 2021/0349902 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:
examining an invoked database query for execution on a database;
scanning zone data from at least one data node of the database in dependence on the examining, the at least one data node of the database having a storage system and storing in the storage system table data of a table, wherein security tags are associated to respective rows of the table, and wherein the zone data specifies attributes of storage of the table within respective storage system extents of the storage system;
identifying, using the zone data, at least one excludible extent of the storage system extents; and
excluding the at least one excludible extent from an IO data access operation in processing of the invoked database query, wherein the at least one data node includes first through Nth data node physical computing nodes, wherein the scanning zone data from at least one data node of a database includes scanning, by a host node physical computing node, zone data from the first through Nth data node physical computing nodes, wherein computing nodes of the first through Nth data node physical computing nodes are external to one another, and wherein the first through Nth data node physical computing nodes are external to the host node physical computing node.