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:
Jul. 20, 2010
Filed:
Mar. 31, 2004
Eric Y. Shan, Saratoga, CA (US);
Fabio Casati, Palo Alto, CA (US);
Maria Guadalupe Castellanos, Sunnyvale, CA (US);
Ming-chien Shan, Saratoga, CA (US);
Eric Y. Shan, Saratoga, CA (US);
Fabio Casati, Palo Alto, CA (US);
Maria Guadalupe Castellanos, Sunnyvale, CA (US);
Ming-Chien Shan, Saratoga, CA (US);
Hewlett-Packard Development Company, L.P., Houston, TX (US);
Abstract
Various approaches are disclosed for loading data from a vertical database table into a horizontal database table. In one embodiment, a number of rows in a vertical database table and a number of columns in a horizontal database table are determined. Entries in a first column of the vertical table contain object identifiers, entries in a second column contain attribute names corresponding to the object identifiers, and entries in a third column contain attribute values corresponding to the attribute names. The horizontal table includes a column for the object identifiers and respective attribute columns for the attributes names. One of a plurality of methods is selected and used for reading data from the vertical database table and writing data to the horizontal database table based in part on the number of rows in the vertical database table and the number of columns in the horizontal database table.