US 12,360,969 B2
In-database data cleansing
Pedro Miguel Barbas, Dunboyne (IE); Shaikh Shahriar Quader, Oshawa (CA); Adrian Mahjour, Toronto (CA); Hima Patel, Bengaluru (IN); and Nitin Gupta, Saharanpur (IN)
Assigned to INTERNATIONAL BUSINESS MACHINES CORPORATION, Armonk, NY (US)
Filed by INTERNATIONAL BUSINESS MACHINES CORPORATION, Armonk, NY (US)
Filed on Oct. 27, 2023, as Appl. No. 18/495,952.
Prior Publication US 2025/0139069 A1, May 1, 2025
Int. Cl. G06F 16/215 (2019.01); G06F 16/22 (2019.01); G06F 16/23 (2019.01)
CPC G06F 16/215 (2019.01) [G06F 16/221 (2019.01); G06F 16/2365 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A computer program product for facilitating processing within a computing environment, the computer program product comprising:
at least one computer readable storage medium and program instructions collectively stored on the at least one computer readable storage medium, the program instructions collectively stored comprising:
program instructions to obtain a cleansing operation defined for a data structure of a database managed by a database management system;
program instructions to perform the cleansing operation on data of the data structure to obtain clean data, wherein the cleansing operation is performed by the database management system, and
program instructions to store the clean data in the data structure independent of the data, wherein the data structure is defined as column-major and a column group of the data structure is stored as one or more blocks, and wherein the clean data is stored as one or more other blocks of the data structure.