Hui Lin Chang

US Patent:

7644066, Jan 5, 2010

Filed:

Mar 31, 2006

Appl. No.:

11/394878

Inventors:

Muralidhar Krishnaprasad - Fremont CA, US
Zhen Hua Liu - San Mateo CA, US
Hui Joe Chang - Fremont CA, US
Vikas Arora - San Francisco CA, US
Susan M. Kotsovolos - San Carlos CA, US

Assignee:

Oracle International Corporation - Redwood Shores CA

International Classification:

G06F 17/30

US Classification:

707 3

Abstract:

XML table indexes provide a more efficient mechanism for searching data stored in aggregate form. XML table indexes are a set of tables created to project out in column form commonly sought metadata from stored XML documents. By projecting the data includes into column form, queries on the XML documents can be efficiently processed as they can leverage the enhanced functionality provided by the database tables. The XML table indexes may use aliases, partitioning, constraints and other functions to further improve query flexibility and performance.

US Patent:

7836066, Nov 16, 2010

Filed:

Jul 12, 2007

Appl. No.:

11/777132

Inventors:

Hui Joe Chang - Fremont CA, US
Zhen Hua Liu - San Mateo CA, US

Assignee:

Oracle International Corporation - Redwood Shores CA

International Classification:

G06F 17/30

US Classification:

707760, 26 3

Abstract:

XQuery queries that include functions that operate on dynamically typed XML data are rewritten into compilable SQL constructs. XML data that is dynamically typed is XML data for which a specific XML data type cannot be determined at compile time and in fact may vary. In general, XQuery queries are rewritten into SQL queries that use SQL constructs in lieu of XQuery constructs. The SQL constructs include an “SQL polymorphic function” that is defined or recognized by a database system as valid syntax for an SQL query. The rewritten query applies the XML data to the SQL polymorphic function, but the XML data has been typed as XMLType, a data type recognized by SQL standards.

US Patent:

7870121, Jan 11, 2011

Filed:

Jan 15, 2008

Appl. No.:

12/014238

Inventors:

Hui Joe Chang - Fremont CA, US
Zhen Hua Liu - San Mateo CA, US
Vikas Arora - San Francisco CA, US

Assignee:

Oracle International Corporation - Redwood Shores CA

International Classification:

G06F 17/30

US Classification:

707713

Abstract:

Techniques are provided for determining whether an XML table index may be used when executing an XML query. An XML table index is defined with a row pattern expression and one or more column pattern expressions. In one technique, an index expression is generated for each row pattern expression-column pattern expression combination. An expression included in the XML query (“query expression”) is compared against one or more of the index expressions. In another technique, even if a query expression does not exactly match a row pattern expression, it is determined whether the query expression is equivalent to the row pattern expression. In another technique, even if a query expression does not exactly match and a row pattern expression, it is determined whether the query expression is “contained by” the row pattern expression.

US Patent:

20110093485, Apr 21, 2011

Filed:

Oct 16, 2009

Appl. No.:

12/580923

Inventors:

Hui Joe Chang - San Jose CA, US
Thomas Baby - Maple Valley WA, US
Zhen Hua Liu - San Mateo CA, US

Assignee:

ORACLE INTERNATIONAL CORPORATION - REDWOOD SHORES CA

International Classification:

G06F 17/30

US Classification:

707759, 707E17014, 707E17002

Abstract:

A query may be rewritten to leverage information stored in a structured XML index. An operator in the query may be analyzed to determine an input source database object for the operator by traversing an operator tree rooted at the operator. The path expressions associated with the operator tree may be fused together to form an effective path expression for the operator. If the effective path expression directly matches a path expression derived from the index, the query may be rewritten using references to the index. Operators in a query that have effective paths that refer to data in the same index table may be grouped together. A single subquery may be written for a group of operators. Also, a structured XML index may be used as an implied schema for indexed XML data. This implied schema may be used to optimize queries that refer to the indexed XML data.

US Patent:

20220200079, Jun 23, 2022

Filed:

Dec 23, 2020

Appl. No.:

17/132369

Inventors:

- Dearborn MI, US
Di Zhu - Canton MI, US
Brent Zapczynski - Dearborn MI, US
Hui Chang - Canton MI, US
Suriyaprakash A. Janarthanam - Canton MI, US

International Classification:

H01M 10/658
B60L 50/64
H01M 50/35
H01M 50/249
H01M 50/383

Abstract:

This disclosure details exemplary traction battery pack venting systems for use in electrified vehicles. An exemplary traction battery pack system may include a venting system having one or more vent ducts for expelling battery vent byproducts from a battery pack. The vent ducts may include a thermal barrier configured to block heat emitted by the battery vent byproducts during cell venting events. In some embodiments, the thermal barrier includes a thermal barrier coating. In other embodiments, the thermal barrier includes both a thermal barrier coating and a thermal barrier layer. In still other embodiments, a second thermal barrier may be applied to vehicle components located near the battery pack for improving the thermal barrier properties.

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).

US Patent:

20200004736, Jan 2, 2020

Filed:

Jun 28, 2018

Appl. No.:

16/022465

Inventors:

- Redwood Shores CA, US
SHASANK K. CHAVAN - Menlo Park CA, US
DOUGLAS J. MCMAHON - Redwood City CA, US
VIKAS ARORA - Burlingame CA, US
HUI JOE CHANG - San Jose CA, US
SHUBHRO JYOTI ROY - Redwood City CA, US

International Classification:

G06F 16/23
G06F 16/22

Abstract:

A “hybrid derived cache” stores semi-structured data or unstructured text data in an in-memory mirrored form and columns in another form, such as column-major format. The hybrid derived cache may cache scalar type columns in column-major format. The structure of the in-memory mirrored form of semi-structured data or unstructured text data enables and/or enhances access to perform path-based and/or text based query operations. A hybrid derived cache improves cache containment for executing query operations. The in-memory mirrored form is used to compute queries in a transactionally consistent manner through the use of an invalid vector that used to determine when to retrieve the transactionally consistent persistent form of semi-structured data or unstructured text data in lieu of the in-memory form.

US Patent:

20190102450, Apr 4, 2019

Filed:

Nov 8, 2017

Appl. No.:

15/807336

Inventors:

- Redwood Shores CA, US
Geeta Arora - Union City CA, US
Hui Joe Chang - San Jose CA, US

Assignee:

Oracle International Corporation - Redwood Shores CA

International Classification:

G06F 17/30

Abstract:

An approach for improving LOB query performance via automatic inference of locator-less LOB by value semantics in a relational database system is provided. A relational database management system (RDBMS) is implemented to perform operations on LOBs based on the semantics of a statement. During statement compilation, the RDBMS identifies inline LOB column(s) that are not required to be returned to a client. During execution, the identified column(s) are accessed via a shared buffer cache and fed to an operator for evaluation. For inline LOB column(s) that must be returned to the client, during execution, the inline LOB data is copied from the shared buffer cache to a temporary buffer area. Data in the temporary buffer area is fed to an operator for evaluation and is used to create a LOB locator for the inline LOB column(s) that must be returned to the client.