Ying Y Lu

US Patent:

7908286, Mar 15, 2011

Filed:

Dec 8, 2004

Appl. No.:

11/007894

Inventors:

Muralidhar Krishnaprasad - Fremont CA, US
Zhen Hua Liu - San Mateo CA, US
Karuna Muthiah - Redwood City CA, US
Ying Lu - Sunnyvale CA, US
James W. Warner - Mountain View CA, US
Rohan Angrish - Redwood City CA, US
Vikas Arora - San Francisco CA, US
Anand Manikutty - Foster City CA, US

Assignee:

Oracle International Corporation - Redwood Shores CA

International Classification:

G06F 17/30

US Classification:

707759, 717159

Abstract:

An XQuery access API is described, for providing access to XML data from a data source, using the XQuery language. A requestor can request, from a server, performance of an operation on XML data, wherein request messages and response messages conform to the Simple Object Access Protocol (SOAP). Request and response messages can be transmitted using Hypertext Transfer Protocol (HTTP) or Hypertext Transfer Protocol over Secure Socket Layer (HTTPS). The format of the request and response messages is specified in a definition of a Web service, where the definition conforms to the Web Service Description Language (WSDL).

US Patent:

8375043, Feb 12, 2013

Filed:

Jan 19, 2011

Appl. No.:

13/009712

Inventors:

Muralidhar Krishnaprasad - Fremont CA, US
Zhen Hua Liu - San Mateo CA, US
Karuna Muthiah - Redwood City CA, US
Ying Lu - Sunnyvale CA, US
James W. Warner - Mountain View CA, US
Rohan Angrish - Redwood City CA, US
Vikas Arora - San Francisco CA, US
Anand Manikutty - Foster City CA, US

Assignee:

Oracle International Corporation - Redwood Shores CA

International Classification:

G06F 17/30

US Classification:

707759, 717159

Abstract:

An XQuery access API is described, for providing access to XML data from a data source, using the XQuery language. A requestor can request, from a server, performance of an operation on XML data, wherein request messages and response messages conform to the Simple Object Access Protocol (SOAP). Request and response messages can be transmitted using Hypertext Transfer Protocol (HTTP) or Hypertext Transfer Protocol over Secure Socket Layer (HTTPS). The format of the request and response messages is specified in a definition of a Web service, where the definition conforms to the Web Service Description Language (WSDL).

US Patent:

20060031204, Feb 9, 2006

Filed:

Sep 22, 2004

Appl. No.:

10/948536

Inventors:

Zhen Liu - San Mateo CA, US
Muralidhar Krishnaprasad - Fremont CA, US
Anand Manikutty - Foster City CA, US
James Warner - Mountain View CA, US
Qin Yu - Belmont CA, US
Hui Zhang - Fremont CA, US
Karuna Muthiah - Redwood City CA, US
Ying Lu - Sunnyvale CA, US
Vikas Arora - San Francisco CA, US
Susan Kotsovolos - San Carlos CA, US

Assignee:

ORACLE INTERNATIONAL CORPORATION - REDWOOD SHORES CA

International Classification:

G06F 17/30

US Classification:

707003000

Abstract:

Techniques are provided for processing a query, including receiving the query, where the query specifies certain operations to be performed, including (a) a first set of one or more operations that are to be performed on a markup language data source and (b) a second set of one or more operations that are to be performed on a second data source. Then it is determined that a first server that manages the markup language data source is capable of performing the first set of operations. A request is sent to the first server to perform the first set of operations. A response is received, where the response contains results of performing the first set of operations on the markup language data source. Finally, results are generated for the query based at least in part on the results of performing the first set of operations.

US Patent:

20220342864, Oct 27, 2022

Filed:

Jul 8, 2022

Appl. No.:

17/860187

Inventors:

- Redwood Shores CA, US
Sriram Krishnamurthy - San Francisco CA, US
Beda C. Hammerschmidt - Los Gatos CA, US
Douglas J. McMahon - Redwood City CA, US
Hui Joe Chang - San Jose CA, US
Ying Lu - Sunnyvale CA, US
Joshua Spiegel - St. Louis MO, US
Srikrishnan Suresh - Belmont CA, US
Vikas Arora - Burlingame CA, US
Geeta Arora - Union City CA, US
Sundeep Abraham - Redwood City CA, US
Hui Zhang - San Ramon CA, US
Alfonso Colunga Sosa - Redwood City CA, US

International Classification:

G06F 16/22
G06F 16/2455
G06F 16/248
G06F 11/34
G06F 16/242

Abstract:

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.

US Patent:

20220342865, Oct 27, 2022

Filed:

Jul 8, 2022

Appl. No.:

17/860192

Inventors:

- Redwood Shores CA, US
Sriram Krishnamurthy - San Francisco CA, US
Beda C. Hammerschmidt - Los Gatos CA, US
Douglas J. McMahon - Redwood City CA, US
Hui Joe Chang - San Jose CA, US
Ying Lu - Sunnyvale CA, US
Joshua Spiegel - St. Louis MO, US
Srikrishnan Suresh - Belmont CA, US
Vikas Arora - Burlingame CA, US
Geeta Arora - Union City CA, US
Sundeep Abraham - Redwood City CA, US
Hui Zhang - San Ramon CA, US
Alfonso Colunga Sosa - Redwood City CA, US

International Classification:

G06F 16/22
G06F 16/2455
G06F 16/248
G06F 11/34
G06F 16/242

Abstract:

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.

US Patent:

20220292067, Sep 15, 2022

Filed:

Mar 10, 2021

Appl. No.:

17/198159

Inventors:

- Redwood Shores CA, US
ZHEN HUA LIU - San Mateo CA, US
YING LU - Sunnyvale CA, US
BEDA CHRISTOPH HAMMERSCHMIDT - Los Gatos CA, US
DOUGLAS JAMES MCMAHON - Redwood City CA, US
DENIS B. MUKHIN - Burlington MA, US

International Classification:

G06F 16/22

Abstract:

Herein is acceleration for JavaScript object notation (JSON) documents in a relational database based on multilevel, multifield, multivalued indexing and querying. In an embodiment, into a table in a relational database, a computer stores many hierarchical data objects that respectively contain multiple levels that respectively contain one or more fields. An index is generated for indexed values in fields in at least two of the multiple levels. Based on the index, a database statement that references the table in the relational database and at least one of the indexed fields is executed. Indices herein provide matching to more fields in more levels of hierarchical data objects thereby decreasing or eliminating further filtering by brute force after index access. Matching ordinal positions within an array field needs no further filtration after index access. A single index provides increased spatial locality of index entries for acceleration. Index maintenance is minimized for acceleration.

US Patent:

20210081389, Mar 18, 2021

Filed:

Jun 17, 2020

Appl. No.:

16/904417

Inventors:

- Redwood Shores CA, US
Sriram Krishnamurthy - San Francisco CA, US
Beda C. Hammerschmidt - Los Gatos CA, US
Douglas J. McMahon - Redwood City CA, US
Hui Joe Chang - San Jose CA, US
Ying Lu - Sunnyvale CA, US
Joshua Spiegel - St. Louis MO, US
Srikrishnan Suresh - Belmont CA, US
Vikas Arora - Burlingame CA, US
Geeta Arora - Union City CA, US
Sundeep Abraham - Redwood City CA, US
Hui Zhang - San Ramon CA, US
Alfonso Colunga Sosa - Redwood City CA, US

International Classification:

G06F 16/22
G06F 16/2455
G06F 16/248
G06F 16/242
G06F 11/34

Abstract:

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.

US Patent:

20200210398, Jul 2, 2020

Filed:

Nov 21, 2019

Appl. No.:

16/690817

Inventors:

- Redwood Shores CA, US
Vikas Arora - Burlingame CA, US
Ying Lu - Sunnyvale CA, US
Sriram Krishnamurthy - San Francisco CA, US
Hui Joe Chang - San Jose CA, US
Beda Christoph Hammerschmidt - Los Gatos CA, US
Joshua Jeffrey Spiegel - St. Louis MO, US

International Classification:

G06F 16/22
G06F 16/2455
G06F 16/28

Abstract:

The present invention relates to autonomous tuning of a data grid of documents in a database. Herein are techniques for storage cells to autonomously maintain local indices and other optimization metadata and algorithms to accelerate selective access into a distributed collection of documents. In an embodiment, each storage cell persists a respective subset of documents. Each storage cell stores, in memory, respective index(s) that map each item to location(s), in one or more documents of the respective subset of documents, where the item occurs. One or more computers execute, based on at least a subset of the indices of the storage cells, a data access request from a database management system. In an embodiment, a cloud of JSON document services provides an easy-to-use, fully autonomous JSON document database that horizontally and elastically scales to deliver fast execution of document transactions and queries without needing tuning by a database administrator.