Method and apparatus for flexible storage and uniform manipulation of XML data in a relational database system
US7024425B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Sep 6, 2001 |
| Grant date | Apr 4, 2006 |
| Priority date | — |
| Expiry date | Nov 30, 2022 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99948
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Techniques are provided for XML data storage and query rewrites in relational databases. According to certain embodiments of the invention, a mechanism is provided to allow the user to store an XML document in a relational database and to submit mapping information that indicates a mapping of each field of the XML document to the column in the relational database in which the data from each field is stored. If the user submits an XML query to access the data in the XML document that is stored in the relational database, then a mechanism is provided to generate a database query based on the XML query and the mapping information.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.