# US 2022/0035781 A1 · Database access performance improvement > Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt - Number: US 2022/0035781 A1 - Document ID: US20220035781A1 - Status: Published application - Kind: A1 - Application number: 16/983,044 - Filed: 2020-08-03 - Published: 2022-02-03 - Earliest claimed: 2020-08-03 - Assignees: International Business Machines Corporation - Applicants: International Business Machines Corporation - Inventors: Nirmal Kumar; Pravin Kailashnath Kedia; Gaurav Mehrotra; Jagadisha Bhat - Web page: https://patentgrep.com/patent/US20220035781A1 ## CPC - G06F 16/217: {Database tuning (G06F16/2282 takes precedence; database performance monitoring G06F11/3409)} - G06F 16/245: Query processing - G06F 16/273: {Asynchronous replication or reconciliation} - G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N) ## Abstract In an approach for database log management and log access performance improvement, a processor receives an access request for an optimal control file to minimize a database access performance impact. A processor determines the optimal control file based on usage of a plurality of control files for a database. A processor outputs the optimal control file to a user to access the database. A processor provides an incremental sub-control file of the optimal control file to the user. The incremental sub-control file is an incremental view of the optimal control file to query the incremental log data in the database. ## Claims ### Claim 1 A computer-implemented method comprising: receiving, by one or more processors, an access request for an optimal control file to minimize a database access performance impact; determining, by one or more processors, the optimal control file based on usage of a plurality of control files for a database; and outputting, by one or more processors, the optimal control file to a user to access the database. ### Claim 2 (depends on 1) The computer-implemented method of claim 1, further comprising: providing, by one or more processors, an incremental sub-control file of the optimal control file to the user, the incremental sub-control file being an incremental view of the optimal control file to query the incremental log data in the database. ### Claim 3 (depends on 2) The computer-implemented method of claim 2, further comprising: querying, by one or more processors, the incremental sub-control file of the optimal control file. ### Claim 4 (depends on 2) The computer-implemented method of claim 2, wherein the optimal control file includes two or more incremental sub-control files, each of the two or more incremental sub-control files being an incremental view of the optimal control file to query the incremental log data in the database. ### Claim 5 (depends on 1) The computer-implemented method of claim 1, wherein each of the plurality of control files is a binary file that contains database information and records a physical structure of the database. ### Claim 6 (depends on 5) The computer-implemented method of claim 5, wherein each of the plurality of control files includes a logged history of the database. ### Claim 7 (depends on 1) The computer-implemented method of claim 1, wherein the plurality of control files includes one or more control files for database production usage and one or more control files for database log-based replication usage. ### Claim 8 A computer program product comprising: one or more computer readable storage media, and program instructions collectively stored on the one or more computer readable storage media, the program instructions comprising: program instructions to receive an access request for an optimal control file to minimize a database access performance impact; program instructions to determine the optimal control file based on usage of a plurality of control files for a database; and program instructions to output the optimal control file to a user to access the database. ### Claim 9 (depends on 8) The computer program product of claim 8, further comprising: program instructions, stored on the one or more computer-readable storage media, to provide an incremental sub-control file of the optimal control file to the user, the incremental sub-control file being an incremental view of the optimal control file to query the incremental log data in the database. ### Claim 10 (depends on 9) The computer program product of claim 9, further comprising: program instructions, stored on the one or more computer-readable storage media, to query the incremental sub-control file of the optimal control file. ### Claim 11 (depends on 9) The computer program product of claim 9, wherein the optimal control file includes two or more incremental sub-control files, each of the two or more incremental sub-control files being an incremental view of the optimal control file to query the incremental log data in the database. ### Claim 12 (depends on 8) The computer program product of claim 8, wherein each of the plurality of control files is a binary file that contains database information and records a physical structure of the database. ### Claim 13 (depends on 12) The computer program product of claim 12, wherein each of the plurality of control files includes a logged history of the database. ### Claim 14 (depends on 8) The computer program product of claim 8, wherein the plurality of control files includes one or more control files for database production usage and one or more control files for database log-based replication usage. ### Claim 15 A computer system comprising: one or more computer processors, one or more computer readable storage media, and program instructions stored on the one or more computer readable storage media for execution by at least one of the one or more computer processors, the program instructions comprising: program instructions to receive an access request for an optimal control file to minimize a database access performance impact; program instructions to determine the optimal control file based on usage of a plurality of control files for a database; and program instructions to output the optimal control file to a user to access the database. ### Claim 16 (depends on 15) The computer system of claim 15, further comprising: program instructions, stored on the one or more computer-readable storage media, to provide an incremental sub-control file of the optimal control file to the user, the incremental sub-control file being an incremental view of the optimal control file to query the incremental log data in the database. ### Claim 17 (depends on 16) The computer system of claim 16, further comprising: program instructions, stored on the one or more computer-readable storage media, to query the incremental sub-control file of the optimal control file. ### Claim 18 (depends on 16) The computer system of claim 16, wherein the optimal control file includes two or more incremental sub-control files, each of the two or more incremental sub-control files being an incremental view of the optimal control file to query the incremental log data in the database. ### Claim 19 (depends on 15) The computer system of claim 15, wherein each of the plurality of control files is a binary file that contains database information and records a physical structure of the database. ### Claim 20 (depends on 19) The computer system of claim 19, wherein each of the plurality of control files includes a logged history of the database.