US 12,111,810 B2
Database query management using a new column type
Sheng Yan Sun, Beijing (CN); Hong Mei Zhang, Haidian District (CN); Peng Hui Jiang, Beijing (CN); and Meng Wan, Beijing (CN)
Assigned to International Business Machines Corporation, Armonk, NY (US)
Filed by INTERNATIONAL BUSINESS MACHINES CORPORATION, Armonk, NY (US)
Filed on Mar. 30, 2022, as Appl. No. 17/708,202.
Prior Publication US 2023/0315710 A1, Oct. 5, 2023
Int. Cl. G06F 16/22 (2019.01); G06F 11/34 (2006.01); G06F 16/21 (2019.01); G06F 16/2453 (2019.01)
CPC G06F 16/2282 (2019.01) [G06F 11/3419 (2013.01); G06F 16/213 (2019.01); G06F 16/24534 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A computer-implemented method, comprising:
collecting, by a computing device, database activities and database structure information of a database;
identifying, by the computing device, related columns in the database;
determining, by the computing device, one or more data types for column transference of the identified related columns;
generating, by the computing device, a super union column based on the column transference and the identified related columns; and
updating, by the computing device, the database with the super union column,
wherein the related columns in the database are identified by return information of a previous user request query of the database, and
the column transference reduces a complexity of the one or more data types of the identified related columns by transferring the one or more data types of the identified related columns to a simple data type which reduces bits of stored memory for the one more data types of the identified related columns.