Method, system, program, and data structure for pivoting columns in a database table
US6604095B1 · kind B1 · utility
Assignee
Inventors
Key dates
| Filing date | Sep 21, 1999 |
| Grant date | Aug 5, 2003 |
| Priority date | — |
| Expiry date | Sep 21, 2019 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99945
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Disclosed is a method, system, program, and data structure for transforming at least one column in a database input table. An input data table has multiple columns and rows. A determination is made of multiple data column names and multiple pivot columns in the input table. A row is generated in an output table for each data column name, having one data column name field including one data column name and at least one pivot column field including the value in one pivot column field in the input table, wherein each of the rows in the output table for each data column name has different values in at least one of the data column name field and pivot column field.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.