System and method for decomposition of multiple items into the same table-column pair without dedicated mapping constructs

A computer-based system for decomposing and storing a markup based document into a relational database, comprising means for:

• (a) identifying multiple items, for a schema of a markup based document, mapping into a same database table-column pair;
• (b) creating a logical table and associating the logical table to each said item and a corresponding database table;
• (c) creating a mapping document of the markup based document with mapping annotations defining mapping of the items into columns of the logical tables;
• and
• (d) decomposing each said item into a corresponding logical table column.

A computer usable medium tangibly embodying a program of instructions executable by the computer to perform a computer-based method for decomposing and storing a markup based document into a relational database, comprising:

• (a) identifying multiple items, for a schema of a markup based document, mapping into a same database table-column pair;
• (b) creating a logical table and associating the logical table to each said item and a corresponding database table;
• (c) creating a mapping document of the markup based document with mapping annotations defining mapping of the items into columns of the logical tables;
• and
• (d) decomposing each said item into a corresponding logical table column.