Method, system, and program for inverting columns in a database table

• US 6,748,389 B1
• Filed: 09/21/1999
• Issued: 06/08/2004
• Est. Priority Date: 09/21/1999
• Status: Expired due to Term

• Current Assignee: Google LLC (Alphabet Inc.)
• Original Assignee: International Business Machines Corporation
• Inventors: Mandel, Richard Henry III, Cesare, Mark Anthony, Jerves, Julie Ann
• Primary Examiner(s): Alam, Shahid
• Assistant Examiner(s): FLEURANTIN, JEAN B
• Application Number:
  US09/400,690
• Time in Patent Office: 1,722 Days
• Field of Search: 707/1-10, 707/100-104, 709/214-215
• US Class Current: 707/809
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing

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.

Claims

1. 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.

2. The method of claim 1, wherein an input column name parameter indicates a column in the input table, further comprising copying data in the indicated column to a first row of the output table to form column names in the output table, wherein the data for each column in the input table excluding the indicated column is copied into one row in the output table following the first row.

3. The method of claim 2, wherein the input column name has a NULL value, further comprising generating sequential numbers into columns in the first row of the output table to form column names in the output table, wherein the data for each column in the input table is copied into each row of the output table following the first row.

4. The method of claim 1, wherein a sequential number parameter indicates a column in the output table, further comprising inserting sequential numbers in the column in the output table indicated in the sequential number parameter.

5. The method of claim 1, further comprising:

determining whether the data in the input table columns inverted into the rows in the output table form at least one output table column having a first and second data types, wherein the first and second data types are different;

determining whether the first and second data types in the output table column are in a promotion path, such that the first data type is capable of being promoted to the second data type; and

promoting the data in the output table column having the first data type to the second data type if the first data type is capable of being promoted to the second data type.

6. The method of claim 1, wherein copying the data from one column in the input table to one row in the output table comprises copying the data from the column in the input table into a row starting from a column in the output table following a first column.

7. The method of claim 6, wherein the column in the output table including data from the first row in the input table is provided a column name.

8. 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.

9. 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.

10. The system of claim 9, wherein an input column name parameter indicates a column in the input table, further comprising means for copying data in the indicated column to a first row of the output table to form column names in the output table, wherein the data for each column in the input table excluding the indicated column is copied into one row in the output table following the first row.

11. The system of claim 10, wherein the input column name has a NULL value, further comprising means for generating sequential numbers into columns in the first row of the output table to form column names in the output table, wherein the data for each column in the input table is copied into each row of the output table following the first row.

12. The system of claim 9, wherein a sequential number parameter indicates a column in the output table, further comprising means for inserting sequential numbers in the column in the output table indicated in the sequential number parameter.

13. The system of claim 9, further comprising:

means for determining whether the data in the input table columns inverted into the rows in the output table form at least one output table column having a first and second data types, wherein the first and second data types are different;

means for determining whether the first and second data types in the output table column are in a promotion path, such that the first data type is capable of being promoted to the second data type; and

means for promoting the data in the output table column having the first data type to the second data type if the first data type is capable of being promoted to the second data type.

14. The system of claim 9, wherein copying the data from one column in the input table to one row in the output table comprises means for copying the data from the column in the input table into a row starting from a column in the output table following a first column.

15. 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.

16. 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.

17. The article of manufacture of claim 16, wherein an input column name parameter indicates a column in the input table, further comprising copying data in the indicated column to a first row of the output table to form column names in the output table, wherein the data for each column in the input table excluding the indicated column is copied into one row in the output table following the first row.

18. The article of manufacture of claim 17, wherein the input column name has a NULL value, further comprising generating sequential numbers into columns in the first row of the output table to form column names in the output table, wherein the data for each column in the input table is copied into each row of the output table following the first row.

19. The article of manufacture of claim 16, wherein a sequential number parameter indicates a column in the output table, further comprising inserting sequential numbers in the column in the output table indicated in the sequential number parameter.

20. The article of manufacture of claim 16, further comprising:

determining whether the data in the input table columns inverted into the rows in the output table form at least one output table column having a first and second data types, wherein the first and second data types are different;

determining whether the first and second data types in the output table column are in a promotion path, such that the first data type is capable of being promoted to the second data type; and

promoting the data in the output table column having the first data type to the second data type if the first data type is capable of being promoted to the second data type.

21. The article of manufacture of claim 16, wherein copying the data from one column in the input table to one row in the output table, comprises copying the data from the column in the input table into a row starting from a column in the output table following a first column.

22. 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.