Oracle International Corporation

Alfonso Colunga Sosa

Zhen Hua Liu

Vikas Arora

Douglas James McMahon

Beda Christoph Hammerschmidt

Hui Joe Chang

Sriram Krishnamurthy

Ying Lu

Geeta Arora

Joshua Jeffrey Spiegel

Hui Zhang

Sundeep Abraham

Srikrishnan Suresh

Jose Omar Alvizo Flores

Francisco Alonso Alavez Sosa

Rodrigo Fuentes Hernandez

Tixtla Iñaqui Medina Julia

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

Herein is a self-tuning database management system (DBMS) storing JavaScript object notation (JSON) documents and operating a JSON datatype as native to the DBMS. In an embodiment, a computer hosts a DBMS that executes a data definition language (DDL) statement that defines, in a database dictionary of the DBMS, a JSON document column of a database table that stores JSON documents as instances of the JSON datatype that is native in the DBMS. The DBMS may autonomously set or adjust configuration settings that control behaviors such as a default width of a JSON document column, in lining or not of the JSON document column, kind and scope and duration of indexing of the JSON document column, and/or caching of the JSON document column such as in an in memory columnar unit (IMCU). The DBMS may use the various configuration settings to control how JSON documents and the native JSON datatype are stored and/or processed.

Technique of efficiently, comprehensively and autonomously support native JSON datatype in RDBMS for both OLTP and OLAP

Growing community of inventors

Redwood City, CA, United States of America

Alfonso Colunga Sosa