| US 7,478,100 B2 | ||
| Method and mechanism for efficient storage and query of XML documents based on paths | ||
| Ravi Murthy, Fremont, Calif. (US); Nipun Agarwal, Santa Clara, Calif. (US); and Eric Sedlar, San Francisco, Calif. (US) | ||
| Assigned to Oracle International Corporation, Redwood Shores, Calif. (US) | ||
| Filed on Jan. 23, 2004, as Appl. No. 10/763,355. | ||
| Claims priority of provisional application 60/500450, filed on Sep. 05, 2003. | ||
| Prior Publication US 2005/0055355 A1, Mar. 10, 2005 | ||
| Int. Cl. G06F 17/30 (2006.01) | ||
| U.S. Cl. 707—100 [715/234] | 62 Claims |
| 1. A method for storing unstructured XML data into a relational database, comprising:
assigning a document identifier to an XML document;
parsing the XML document to identify a node;
for the identified node in the XML document:
storing a path string for the node in a volatile or non-volatile computer usable storage medium, wherein the path string comprises
a full path for the node from a root node of the XML document;
storing hierarchical information for the node in the volatile or non-volatile computer usable storage medium; and
storing node data for the node in the volatile or non-volatile computer usable storage medium.
|