Patent · US Active

Efficient storage of columns with inappropriate data types in relational databases

US11593382B2 · kind B2 · utility

0Cited by

0References

15Claims

0Family size

Assignee

International Business Machines Corporation · US

Inventors

Felix Beier · Haigerloch, DE
Knut Stolze · Jena, DE
Reinhold Geiselhart · Liebfrauenhöhe, DE
Luis Eduardo Oliveira Lizardo · Böblingen, DE

Key dates

Filing date	Mar 22, 2021
Grant date	Feb 28, 2023
Priority date	—
Expiry date	Mar 22, 2041

Classification

Technology area (CPC G)Physics
CPC primaryG06F16/248
WIPO fieldComputer technology
WIPO sectorElectrical engineering

Abstract

A computer-implemented method, a computer program product, and a computer system for detecting an inappropriate data type of a column in a database and correcting an encoding for the column. The computer system detects in a table a candidate column that has a mismatching type definition, using database usage statistics. The computer system determines whether conversion of the candidate column is possible. In response to determining that the conversion of the candidate column is possible, the computer system converts values in the candidate column with a first data type to values in a new column with a second data type. The computer system appends the new column in the table. The computer system registers the new column and the second data type in a metadata catalog. The computer system generates a query plan operator for processing a query for the new column.

Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.