The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Aug. 05, 2003
Filed:
Sep. 21, 1999
Mark Anthony Cesare, San Francisco, CA (US);
Julie Ann Jerves, Saratoga, CA (US);
Richard Henry Mandel, III, San Jose, CA (US);
International Business Machines Corporation, Armonk, NY (US);
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.