Patent US6643633B2 successfully refreshed from Google Patents.
US6643633B2
Expired / Lapsed
US
⏱️ 0.0 years remaining
Storing fragmented XML data into a relational database by decomposing XML documents with application specific mappings
Assignee: Huawei Technologies Co Ltd
•
Filing: 2002-01-31
•
Granted: 2003-11-04
•
Expires: 2022-01-31
Abstract
Abstract A technique is provided to store fragmented XML data into a relational database by decomposing XML documents with application specific mappings. Data stored on a data store that is connected to a computer is transformed. Initially, an XML document containing XML data is received. A document access definition that identifies one or more relational tables and columns is received. The XML data is mapped from the application DTD to the relational tables and columns using the document access definition by generating a first document object model tree using the XML document, generating a second document object model tree using the document access definition, and mapping the data from the first document object model tree into columns in one or more relational rabies using the second document object model tree.
Inventors
- 👤 Hoang K. Chau
- 👤 Isaac Kam-Chak Cheng
- 👤 Josephine Miu Cheng
- 👤 Suet Mui Chiu
- 👤 Jyh-Herng Chow
- 👤 Michael Leon Pauser
- 👤 Jian Xu
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-07 13:46
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/80; G06F16/84; G06F16/86; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99933; Y10S707/99934
Claims Analysis
Total Claims: 24
Claim 1
Independent Claim
104 words
A method of transforming data stored on a data store that is connected to a computer, comprising: receiving an XML document containing XML data; receiving a document access definition that identifies one or more relational tables and columns; and mapping the XML data to the relational tables and columns using the document access definition by generating a first document object model tree using the XML document, generating a second document object model tree using the document access definition, and mapping the data from the first document object model tree into columns in one or more relational tables using the second document object model tree.
Claim 2
Independent Claim
104 words
A method of transforming data stored on a data store that is connected to a computer, comprising: receiving an XML document containing XML data; receiving a document access definition that identifies one or more relational tables and columns; and mapping the XML data to the relational tables and columns using the document access definition by generating a first document object model tree using the XML document, generating a second document object model tree using the document access definition, and mapping the data from the first document object model tree into columns in one or more relational tables using the second document object model tree.
Claim 3
Dependent Claim
20 words
The method of claim 1 , wherein the first document object model tree is generated by parsing the XML document.
Claim 4
Dependent Claim
21 words
The method of claim 1 , wherein the second document object model tree is generated by parsing the document access definition.
Claim 5
Dependent Claim
17 words
The method of claim 1 , wherein the XML data is stored untagged into the relational tables.
Claim 6
Dependent Claim
13 words
The method of claim 1 , wherein the relational tables are new tables.
Claim 7
Dependent Claim
13 words
The method of claim 1 , wherein the relational tables are existing tables.
Claim 8
Dependent Claim
15 words
The method of claim 1 , wherein the mapping is performed by a stored procedure.
Claim 9
Independent Claim
118 words
An apparatus for transforming data, comprising: a computer having a data store coupled thereto, wherein the data store stores data; and one or more computer programs, performed by the computer, for receiving an XML document containing XML data, receiving a document access definition that identifies one or more relational tables and columns, and mapping the XML data to the relational tables and columns using the document access definition by generating a first document object model tree using the XML document, generating a second document object model tree using the document access definition, and mapping the data from the first document object model tree into columns in one or more relational tables using the second document object model tree.
Claim 10
Independent Claim
118 words
An apparatus for transforming data, comprising: a computer having a data store coupled thereto, wherein the data store stores data; and one or more computer programs, performed by the computer, for receiving an XML document containing XML data, receiving a document access definition that identifies one or more relational tables and columns, and mapping the XML data to the relational tables and columns using the document access definition by generating a first document object model tree using the XML document, generating a second document object model tree using the document access definition, and mapping the data from the first document object model tree into columns in one or more relational tables using the second document object model tree.
Claim 11
Dependent Claim
20 words
The apparatus of claim 8 , wherein the first document object model tree is generated by parsing the XML document.
Claim 12
Dependent Claim
21 words
The apparatus of claim 8 , wherein the second document object model tree is generated by parsing the document access definition.
Claim 13
Dependent Claim
17 words
The apparatus of claim 8 , wherein the XML data is stored untagged into the relational tables.
Claim 14
Dependent Claim
13 words
The apparatus of claim 8 , wherein the relational tables are new tables.
Claim 15
Dependent Claim
13 words
The apparatus of claim 8 , wherein the relational tables are existing tables.
Claim 16
Dependent Claim
15 words
The apparatus of claim 7 , wherein the mapping is performed by a stored procedure.
Claim 17
Dependent Claim
123 words
An article of manufacture comprising a program storage medium readable by a computer and embodying one or more instructions executable by the computer to perform steps for transforming data in a data store connected to the computer comprising: receiving XML document containing XML data; receiving a document access definition that identifies one or more relational tables and columns; and mapping the XML data to the relational tables and columns using the document access definition by generating a first document object model tree using the XML document generating a second document object model tree using document access definition, and mapping the data from the first document object model tree into columns in one or more relational tables using the second document object model tree.
Claim 18
Dependent Claim
123 words
An article of manufacture comprising a program storage medium readable by a computer and embodying one or more instructions executable by the computer to perform steps for transforming data in a data store connected to the computer comprising: receiving XML document containing XML data; receiving a document access definition that identifies one or more relational tables and columns; and mapping the XML data to the relational tables and columns using the document access definition by generating a first document object model tree using the XML document generating a second document object model tree using document access definition, and mapping the data from the first document object model tree into columns in one or more relational tables using the second document object model tree.
Claim 19
Dependent Claim
22 words
The article of manufacture of claim 15 , wherein the first document object model tree is generated by parsing the XML document.
Claim 20
Dependent Claim
23 words
The article of manufacture of claim 15 , wherein the second document object model tree is generated by parsing the document access definition.
Claim 21
Dependent Claim
19 words
The article of manufacture of claim 15 , wherein the XML data is stored untagged into the relational tables.
Claim 22
Dependent Claim
15 words
The article of manufacture of claim 15 , wherein the relational tables are new tables.
Claim 23
Dependent Claim
15 words
The article of manufacture of claim 15 , wherein the relational tables are existing tables.
Claim 24
Dependent Claim
17 words
The article of manufacture of claim 15 , wherein the mapping is performed by a stored procedure.
References Cited (Backward Citations)
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2006-11-03 | 2007-05-05 | 2007-11-04 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2010-11-03 | 2011-05-05 | 2011-11-04 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2014-11-03 | 2015-05-05 | 2015-11-04 | $7700.00 | Window Closed / Lapsed |