US 12,321,333 B2
Minimizing I/O operations when validating flat databases
Christopher Daniel Filachek, Lagrangeville, NY (US); Mark Richard Gambino, Brewster, NY (US); Michael J. Shershin, Poughkeepsie, NY (US); Daniel Howard Jacobs, Poughkeepsie, NY (US); and Steven Edwin Roach, Lagrangeville, NY (US)
Assigned to International Business Machines Corporation, Armonk, NY (US)
Filed by INTERNATIONAL BUSINESS MACHINES CORPORATION, Armonk, NY (US)
Filed on Nov. 6, 2023, as Appl. No. 18/502,549.
Prior Publication US 2025/0147946 A1, May 8, 2025
Int. Cl. G06F 16/23 (2019.01)
CPC G06F 16/2358 (2019.01) 20 Claims
OG exemplary drawing
 
1. A processor-implemented method for minimizing I/O operations when validating databases, the method comprising:
creating a corresponding system-managed chain database for an application database, wherein the chain database is a single side database linked to the application database, the chain database comprising a list of one or more dynamically allocated records, if present, for one or more fixed entries in the application database, wherein each of the one or more fixed entries in the application database comprises a respective chain database array item in the chain database;
scanning, via a validation utility, one or more chain database array items in the chain database;
marking each of the one or more dynamically allocated records listed in the chain database for the or more fixed entries in the application database as found; and
checking, via an indicator with various states, if the one or more dynamically allocated records for the one or more fixed entries in the application database are listed in the respective chain database array item in the chain database.