Chi U Hoang

US Patent:

8401994, Mar 19, 2013

Filed:

Sep 18, 2009

Appl. No.:

12/562928

Inventors:

Chi Hoang - Palo Alto CA, US
Tirthankar Lahiri - Palo Alto CA, US
Marie-Anne Neimat - Atherton CA, US
Chih-Ping Wang - Palo Alto CA, US
John Miller - Los Altos CA, US
Dilys Thomas - Redwood City CA, US
Nagender Bandi - Redwood City CA, US
Susan Cheng - Cupertino CA, US

Assignee:

Oracle International Corporation - Redwood Shores CA

International Classification:

G06F 17/00

US Classification:

707609

Abstract:

A plurality of mid-tier databases form a single, consistent cache grid for data in a one or more backend data sources, such as a database system. The mid-tier databases may be standard relational databases. Cache agents at each mid-tier database swap in data from the backend database as needed. Consistency in the cache grid is maintained by ownership locks. Cache agents prevent database operations that will modify cached data in a mid-tier database unless and until ownership of the cached data can be acquired for the mid-tier database. Cache groups define what backend data may be cached, as well as a general structure in which the backend data is to be cached. Metadata for cache groups is shared to ensure that data is cached in the same form throughout the entire grid. Ownership of cached data can then be tracked through a mapping of cached instances of data to particular mid-tier databases.

US Patent:

20080222111, Sep 11, 2008

Filed:

Feb 12, 2008

Appl. No.:

12/030113

Inventors:

Chi Kim Hoang - Palo Alto CA, US
Chih-Ping Wang - Palo Alto CA, US
John Ernest Miller - Los Altos CA, US
Marie-Anne Neimat - Redwood Shores CA, US
Susan Sokeng Cheung - Redwood Shores CA, US

Assignee:

Oracle International Corporation - Redwood Shores CA

International Classification:

G06F 7/06

US Classification:

707 3, 707E17014

Abstract:

A fully transactional mid-tier database system services database transactions. A cache manager dynamically loads database entries from a fully transactional backend-tier database system into the mid-tier database system according to the received database transactions. Time based aging or usage based aging can be assigned to selected tables in the mid-tier database system. Database entries contained in the selected tables are then automatically removed according to assigned aging constraints.

US Patent:

61673994, Dec 26, 2000

Filed:

May 5, 1998

Appl. No.:

9/073113

Inventors:

Chi Kim Hoang - Palo Alto CA

Assignee:

NCR Corporation - Dayton OH

International Classification:

G06F 1730

US Classification:

707 5

Abstract:

The retrieval of data from a computerized database is optimized through the use of a join index. A denormalized base table is converted into a plurality of normalized tables and the join index for the normalized tables is created by combining one or more commonly-used columns of the normalized tables. Outer joins are used to generate the join index, instead of inner joins, so that the join index satisfies queries with fewer join conditions than the ones used to generate the join index. Each row of the join index comprises a fixed part and a repeated part. The fixed part is stored only once in each row, but the repeated part is comprised of recursive levels within each row, so that each row may contain as many repeated parts as needed. In addition, each of the repeated parts comprises a fixed part and a repeated part.

US Patent:

20200379970, Dec 3, 2020

Filed:

Jun 3, 2020

Appl. No.:

16/892174

Inventors:

- Redwood City CA, US
Henning Schmiedehausen - Los Altos CA, US
Chi Lap Hoang - Belmont CA, US
Rodolfo Gentini Fernandez - San Mateo CA, US
Suryatej Mukkamalla - Petaluma CA, US

Assignee:

Zuora, Inc. - Redwood City CA

International Classification:

G06F 16/22
G06F 16/25

Abstract:

A multi-tenant system, comprises a main storage system including: a monolithic database storing global records associated with global objects, each global object including global fields common for all tenants; a monolithic application configured to process a particular global record storage request by instructing the monolithic database to store particular global field values of the particular global record for a particular tenant, and to process a particular global record fetch request by instructing the monolithic database to retrieve the one or more particular global field values; a custom object storage system including: a custom object database configured to store custom records associated with one or more custom objects, each custom object including one or more custom fields for a tenant; a custom object record service configured to process a particular custom record storage request by instructing the custom object database to store one or more particular custom field values for the tenant, and to process a particular custom record fetch request by instructing the custom object database to retrieve the one or more particular custom field values; and a query engine configured to receive a query, fetch relevant global records from the monolithic database, fetch relevant custom records from the custom object database, and generate a query response.

US Patent:

20200379973, Dec 3, 2020

Filed:

Jun 3, 2020

Appl. No.:

16/891062

Inventors:

- Redwood City CA, US
Weilei Chen - Beijing, CN
Chi Lap Hoang - Belmont CA, US
Lukasz Andrzej Weber - San Jose CA, US
Henning Schmiedehausen - Los Altos CA, US

Assignee:

Zuora, Inc. - Redwood City CA

International Classification:

G06F 16/23
G06F 9/54
G06Q 10/10
H04L 12/58

Abstract:

Systems and methods for providing tenant-defined event notifications in a multi-tenant database system are provided. The method may include receiving a first event definition from a first tenant, defining a first business event trigger based on one or more first business object changes occurring to the tenant data of the first tenant; receiving particular database change events from a change data capture service, wherein each of the particular database change events represents a particular change to the tenant data for the plurality of tenants in the database; identifying one or more particular business object changes based on the particular database change events; comparing the first event definition against the one or more particular business object changes to determine whether the first business event trigger has been satisfied; and when the first event trigger has been satisfied, emitting a first business event.