International Business Machines Corporation
Transformation of composite tables into structured database content

Abstract:

A computer transforms content of a composite table into structured data objects. The computer receives a composite table and identifying a data zone characterized by data columns, and a header zone. The computer identifies first header cells arranged coextensive with a single data column and second header cells arranged coextensive with a set of data columns. The computer generates a hierarchical representation of said header cells, based at least in part, on the header cell arrangements. The computer generates a revised table based on the hierarchical representation, with the first header cells identifying a data column and the second header cells identify a first header cell. The computer generates structured data objects representing the zones and being arranged based, at least in part, on the revised table and where the structured data objects are keyed to the first header cells.