Database query management using a new column type
AssigneeInternational Business Machines Corporation
InventorsSheng Yan Sun, Hong Mei Zhang, Peng Hui Jiang, Meng Wan
Life of this patent
Estimating the term…
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.
Claims20
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.
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.
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.
Dependencies are inferred from the claim text.