# US 12,111,810 B2 · Database query management using a new column type > Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt - Number: US 12,111,810 B2 - Document ID: US12111810B2 - Status: Granted - Kind: B2 - Application number: 17/708,202 - Filed: 2022-03-30 - Published: 2023-10-05 - Granted: 2024-10-08 - Earliest claimed: 2022-03-30 - Assignees: International Business Machines Corporation - Applicants: International Business Machines Corporation - Inventors: Sheng Yan Sun; Hong Mei Zhang; Peng Hui Jiang; Meng Wan - Web page: https://patentgrep.com/patent/US12111810B2 ## CPC - G06F 16/2282: {Tablespace storage structures; Management thereof} - G06F 11/3419: {by assessing time} - G06F 16/213: {with details for schema evolution support} - G06F 16/24534: {Query rewriting; Transformation} - G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N) ## Abstract A computer-implemented method includes: 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. ## Claims ### Claim 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. ### Claim 2 (depends on 1) The computer-implemented method of claim 1, further comprising: receiving a query from an application for data in the updated database; determining the query is covered by data in the super union column; and sending a result set to the application using the data in the super union column based on the determination that the query is covered by the data in the super union column. ### Claim 3 (depends on 1) The computer-implemented method of claim 1, wherein the database activities are collected from a database log. ### Claim 4 (depends on 2) The computer-implemented method of claim 2, further comprising: normalizing the query. ### Claim 5 (depends on 4) The computer-implemented method of claim 4, wherein the normalizing the query comprises removing or replacing predicates, functions in where-conditions and subqueries, or case-when structures from the query. ### Claim 6 (depends on 5) The computer-implemented method of claim 5, wherein the result set is based on the normalized query. ### Claim 7 (depends on 1) The computer-implemented method of claim 1, wherein the column transference reduces the bits used by the data in the super union column, and the simple data type is a simpler data type than the one or more data types. ### Claim 8 (depends on 7) The computer-implemented method of claim 7, wherein the super union column is generated by adding a case-when structure to the query. ### Claim 9 (depends on 2) The computer-implemented method of claim 2, wherein the result set includes a query build rule based on the query. ### Claim 10 (depends on 1) The computer-implemented method of claim 1, wherein the computing device includes software provided as a service in a cloud environment. ### Claim 11 A computer program product comprising one or more computer readable storage media having program instructions collectively stored on the one or more computer readable storage media, the program instructions executable to: collect database activities and database structure information of a database; identify related columns in the database; determine one or more data types for column transference of the identified related columns; generate a super union column based on the column transference and the identified related columns; and append the super union column to the database, 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. ### Claim 12 (depends on 11) The computer program product of claim 11, wherein the program instructions are further executable to: receive a query from an application for data in the appended database; determine the query is covered by data in the super union column; and send a result set using the data from the super union column based on the determination that the query is covered by the data in the super union column to the application. ### Claim 13 (depends on 12) The computer program product of claim 12, wherein the result set includes a query build rule based on the query, and the simple data type is a simpler data type than the one or more data types. ### Claim 14 A system comprising: a processor, a computer readable memory, one or more computer readable storage media, and program instructions collectively stored on the one or more computer readable storage media, the program instructions executable to: receive a query from an application for data in a database with a super union column; identify related columns in the database; determine one or more data types for column transference of the identified related columns; determine the query is covered by data in the super union column; and send a result set using the data in the super union column based on the determination that the query is covered by the data in the super union column to the application, 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. ### Claim 15 (depends on 14) The system of claim 14, wherein the program instructions are further executable to: collect database activities and database structure information of a database; generate another super union column based on the column transference and the identified related columns; and update the database with the another super union column. ### Claim 16 (depends on 14) The system of claim 14, wherein the result set includes a super union column rule, and the simple data type is a simpler data type than the one or more data types. ### Claim 17 (depends on 1) The computer-implemented method of claim 1, wherein the super union column has a reduced storage requirement by utilizing the column transference of the identified related columns, and the column transference is included in the super union column for a fast call back. ### Claim 18 (depends on 17) The computer-implemented method of claim 17, further comprising: tracking historical activity of the database for commonly called values and columns from the database; and setting aside the commonly called values and columns in the super union column with a simplified data type. ### Claim 19 (depends on 11) The computer program product of claim 11, wherein the super union column has a reduced storage requirement by utilizing the column transference of the identified related columns, and the column transference is included in the super union column for a fast call back. ### Claim 20 (depends on 14) The system of claim 14, wherein the super union column has a reduced storage requirement by utilizing column transference of the identified related columns, and the column transference is included in the super union column for a fast call back.