Intelligent normalization and de-normalization of tables for multiple processing scenarios

A system comprising:

• a processor;
• a data bus coupled to the processor;
• and
• a computer-usable medium embodying computer program code, the computer-usable medium being coupled to the data bus, the computer program code used for determining vertically and horizontally aligned cells in a structure data and comprising instructions executable by the processor and configured for:
• creating a two dimensional (2D) table from the structure data that includes orthogonal rows and columns of cells with values or object references, wherein the structure data is an HTML file representing a table, and the creating is performed using an algorithm that converts a table defined by the HTML file with row spanning and column spanning;
• determining spanning rows and columns in the 2D table;
• copying the values or object references of adjacent cells in the spanning rows columns to create an expanded table with spanning rows and columns;
• copying for a row of the 2D array, all attributes of a cell “i” to an adjacent cell “i+1” if the cell “i+1” does not have data until the rows of the 2D array are complete;
• and
• copying for column of the 2D array, all attributes of a cell “j” to an adjacent cell “j+1 if the cell “j+1” does not data for until the columns of the 2D array are complete.

A non-transitory, computer-readable storage medium embodying computer program code, the computer program code comprising computer executable instructions configured for:

• creating a two dimensional (2D) array from the structure data that includes orthogonal rows and columns of cells with object references, wherein the structure data is an HTML file representing a table, and the creating is performed using an algorithm that converts a table defined by the HTML file with row spanning and column spanning;
• determining spanning rows and columns in the 2D array;
• copying the object references of adjacent cells in the spanning rows and columns to create an expanded table with spanning rows and columns;
• copying for a row of the 2D array, all attributes of a cell “i” to an adjacent cell “i+1” if the cell “i+1” does not have data until the rows of the 2D array are complete;
• and
• copying for column of the 2D array, all attributes of a cell “j” to an adjacent cell “j+1 if the cell “j+1” does not data for until the columns of the 2D array are complete.