US 12,306,812 B2
In-database data cleansing and independent store of clean data
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,919.
Prior Publication US 2025/0139068 A1, May 1, 2025
Int. Cl. G06F 16/215 (2019.01); G06F 16/28 (2019.01)
CPC G06F 16/215 (2019.01) [G06F 16/284 (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 automatically perform, using a database management system, a cleansing operation on data of a data structure stored in the database management system obtain clean data;
program instructions to store, using the database management system, the clean data as part of the data structure, wherein the clean data and the data are stored in the data structure, and the clean data is stored in the data structure separately from the data stored in the data structure;
program instructions to perform a mapping of the data and the clean data provide a set of ordered data that includes the data and the clean data, the set of ordered data including a plurality of data positions, and where the mapping uses a map to select between the clean data and the data to be stored in a data position of the plurality of data positions of the set of ordered data; and
program instructions to provide the set of ordered data, the set of ordered data to used in replying to query requests.