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

1. A computer-based method for decomposing and storing a markup based document into a set of relational database tables comprising:

(a) identifying multiple items, for a schema of a markup based document, mapping into a same database table-column pair;

(b) for each said multiple item creating a logical table and associating the logical table to 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.

2. The method according to claim 1 , wherein the logical table being created as an alias or view and having a set of row buffers having columns belonging to the database table row, and the step of decomposing each said item into the corresponding logical table column comprises collecting the item content from the markup based document and storing the content in the corresponding row buffer column.

3. The method according to claim 2 , further comprising a step of sending all the row buffers to the DBMS for storage in the corresponding database table.

4. The method according to claim 1 , wherein the mapping annotations comprising a name of each said logical table and describing mapping between each said item and a corresponding table-column pair.

5. The method according to claim 1 , wherein the markup based document being an Extensible Markup Language (XML) document and the mapping document being an annotated XML Schema.

6. The method according to claim 1 , wherein the markup based document being an Extensible Markup Language (XML) document and the mapping document being an Document Access Definition document.

7. A computer-based system for decomposing and storing a markup based document into a set of relational database tables, comprising means for:

(a) identifying multiple items, for a schema of a markup based document, mapping into a same database table-column pair;

(b) for each said multiple item creating a logical table and associating the logical table to 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.

8. The system according to claim 7 , wherein the logical table being created as an alias or view and having a set of row butters having columns belonging to the database table row, and the means for decomposing each said item into the corresponding logical table column comprises means for collecting the item content from the markup based document and storing the content in the corresponding row buffer column.

9. The system according to claim 8 , further comprising a step of sending all the row buffers to the DBMS for storage in the corresponding database table.

10. The system according to claim 7 , wherein the mapping annotations comprising a name of each said logical table and describing mapping between each said item and a corresponding table-column pair.

11. The system according to claim 7 , wherein the markup based document being an Extensible Markup Language (XML) document and the mapping document being an annotated XML Schema.

12. The system according to claim 7 , wherein the markup based document being an Extensible Markup Language (XML) document and the mapping document being an Document Access Definition document.

13. 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 set of relational database tables, comprising:

(a) identifying multiple items, for a schema of a markup based document, mapping into a same database table-column pair;

(b) for each said multiple item creating a logical table and associating the logical table to 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.

14. The method according to claim 13 , wherein the logical table being created as an alias or view and having a set of row buffers having columns belonging to the database table row, and the step of decomposing each said item into the corresponding logical table column comprises collecting the item content from the markup based document and storing the content in the corresponding row buffer column.

15. The method according to claim 14 , further comprising a step of sending all the row buffers to the DBMS for storage in the corresponding database table.

16. The method according to claim 13 , wherein the mapping annotations comprising a name of each said logical table and describing mapping between each said item and a corresponding table-column pair.

17. The method according to claim 13 , wherein the markup based document being an Extensible Markup Language (XML) document and the mapping document being an annotated XML Schema.

18. The method according to claim 13 , wherein the markup based document being an Extensible Markup Language (XML) document and the mapping document being an Document Access Definition document.