Oracle International Corporation

Jose Omar Alvizo Flores

Zhen Hua Liu

Francisco Alonso Alavez Sosa

Qin Yu

Alfonso Colunga Sosa

Madhupriya Ravishankar

Tixtla Iñaqui Medina Julia

To-Ju Huang

Rodrigo Fuentes Hernandez

Harichandan Roy

A structured document storage format is provided in which tokens used for encoding and decoding are contained within the encoded document in an inline dictionary. Each document is encoded independently, and there is no central dependency or any dependency on other documents during DML and query execution. Each encoded document has all information with it on disk so that the document can be independently shared, decoded, or distributed. A mechanism is provided for quickly determining a mapping between tags and tokens without having to scan the entire inline token dictionary for each document. This allows the database system to process multiple documents, each having its own inline token dictionary, without having to fully scan the inline dictionary of every document for each tag that referenced in an operation.

Scalable, transportable, and self-contained binary storage format for extensible markup language

When a coordinator of a sharded DBMS receives from a client a query that has an XML operator that references a column in a sharded table and returns an XML image having an XML image type, then the coordinator issues a remote query that uses a new operator to ensure that the shard returns a TBX BLOB having a TBX type. In response to receiving the remote query with the new operator, each shard extracts a binary large object (BLOB) out of the XML image at the shard and returns the TBX BLOB data to the coordinator. In addition, the sharded DBMS provides a make-XML operator that the coordinator uses to work with the TBX BLOB received from each shard and recreate an XML type image, which is the result that the client expects.

Heterogeneous XML document support in a sharded database

Growing community of inventors

Foster City, CA, United States of America

Jose Omar Alvizo Flores