Method, system, and program for inverting columns in a database table
AssigneeInternational Business Machines Corporation
InventorsMark Anthony Cesare, Julie Ann Jerves, Richard Henry Mandel, III
Life of this patent
Estimating the term…
Abstract
Disclosed is a method, system, program, and data structure for transforming an input table. The input data table is comprised of multiple columns and rows. For each column, the data from one column in the input table is copied into one row in an output table to invert the input table.
Claims22
A method for transforming an input table comprised of multiple columns and rows, comprising:
- copying, for each column, data from one column in the input table into one row in an output table to invert the input table;
- determining whether a sequential number column is provided, wherein the data from the column in the input table is copied into the output table row starting from a column following the sequential number column in the output table if the sequential number column is provided;
- and
- inserting sequential numbers into the sequential number column in the output table to sequentially number the rows of the output table if the sequential number column is provided.
A method for transforming an input table comprised of multiple columns and rows, comprising:
- determining whether a sequential number column is provided;
- copying data from column in the input table into output table row starting from a column following a first two columns if the sequential number column is provided;
- copying the data from the column in the input table into the output table row starting from the column following a first column if the sequential number column is not provided;
- and
- inserting sequential numbers into one of the first two columns in the output table to sequentially number the rows of the output table if the sequential number column is provided.
A system for transforming an input table comprised of multiple columns and rows, comprising:
- means for copying, for each column, data from one column in the input table into one row in an output table to invert the input table;
- means for determining whether a sequential number column is provided, wherein the data from the column in the input table is copied into the output table row starting from a column following the sequential number column in the output table if the sequential number column is provided;
- and
- means for inserting sequential numbers into the sequential number column in the output table to sequentially number the rows of the output table if the sequential number column is provided.
A system for transforming an input table comprised of multiple columns and rows, comprising:
- means for determining whether a sequential number column is provided;
- means for copying data from column in the input table into output table row starting from a column following a first two columns if the sequential number column is provided;
- means for copying the data from the column in the input table into the output table row starting from the column following the first column if the sequential number column is not provided;
- and
- means for inserting sequential numbers into one of the first two columns in the output table to sequentially number the rows of the output table if the sequential number column is provided.
An article of manufacture for use in transforming an input table in a database comprised of multiple columns and rows, the article of manufacture comprising computer usable media including at least one computer program embedded therein that causes the computer to perform:
- copying, for each column, data from one column in the input table into one row in an output table to invert the input table;
- determining whether a sequential number column is provided, wherein the data from the column in the input table is copied into the output table row starting from a column following the sequential number column in the output table if the sequential number column is provided;
- and
- inserting sequential numbers into the sequential number column in the output table to sequentially number the rows of the output table if the sequential number column is provided.
An article of manufacture for use in transforming an input table in a database comprised of multiple columns and rows, the article of manufacture comprising computer usable media including at least one computer program embedded therein that causes the computer to perform:
- determining whether a sequential number column is provided;
- copying data from column in the input table into output table row starting from a column following a first two columns if the sequential number column is provided;
- copying the data from the column in the input table into the output table row starting from the column following the first column if the sequential number column is not provided;
- and
- inserting sequential numbers into one of the first two columns in the output table to sequentially number the rows of the output table if the sequential number column is provided.
Dependencies are inferred from the claim text.