Ying 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:

20210397601, Dec 23, 2021

Filed:

Sep 3, 2021

Appl. No.:

17/466717

Inventors:

- Redmond WA, US
Ying Lu - Sunnyvale CA, US
Siddharth Shah - Mountain View CA, US
Andrew Rodriguez - Sunnyvale CA, US
Scott M. Meyer - Berkeley CA, US

International Classification:

G06F 16/23
G06F 16/901
G06F 16/248
G06F 17/16
G06F 16/28
G06F 16/22

Abstract:

The disclosed embodiments provide a system for processing queries of a graph database. During operation, the system stores intermediate results of the query in a structure comprising rows in a set of tables and links between pairs of rows in different tables in the set of tables. Next, the system tracks, in the structure, representations of data, relationships, and path consistency in the query. The system then applies one or more operations to existing rows in the structure to generate a final result of the query. Finally, the system provides the final result in a response to the query.

US Patent:

20210109967, Apr 15, 2021

Filed:

Dec 21, 2020

Appl. No.:

17/129085

Inventors:

- Redwood Shores CA, US
Ying Lu - Sunnyvale CA, US
Hui Joe Chang - San Jose CA, US

International Classification:

G06F 16/835

Abstract:

Techniques are described to improve query evaluation in computer systems. In an embodiment, a system receives a full text query for evaluation against a collection of hierarchically marked data object sets. The query specifies token(s) and context(s) which indicate hierarchical location(s) to match within a queried hierarchical data structure. To evaluate the query, the system determines a) data object set(s) that contain the query specified token(s) using token list(s), and/or b) data object set(s) that contain the query specified context(s) using label list(s).