John Xiao

US Patent:

8069146, Nov 29, 2011

Filed:

Jun 18, 2009

Appl. No.:

12/486979

Inventors:

Anurag Gupta - Atherton CA, US
Kumar Ramaiyer - Cupertino CA, US
Matthew Shore - San Mateo CA, US
John Xiao - Cupertino CA, US

Assignee:

Oracle International Corporation - Redwood Shores CA

International Classification:

G06F 7/00
G06F 17/00

US Classification:

707638, 707600, 707610, 707624

Abstract:

Methods and apparatus for updating a database using a multi-dimensional data model in which data corresponding to the database are organized in multi-dimensional data blocks. Each data block has summary information associated therewith corresponding to a current state of evolution of the associated data block. Dependency information is maintained in the data model which identifies data dependencies within and among the data blocks. A list of change entries identifies changes made to the data blocks and times at which the changes were made. A request to apply a change entry to a data block is received. The change entry is applied to the data block, including generating a dependency list of data blocks whose data depends directly or indirectly from the updated data block. The data blocks in the dependency list are processed in accordance with a dependency update algorithm to update the data blocks in the dependency list.

US Patent:

20060288046, Dec 21, 2006

Filed:

Jun 15, 2005

Appl. No.:

11/154259

Inventors:

Anurag Gupta - Atherton CA, US
Kumar Ramaiyer - Cupertino CA, US
Matthew Shore - San Mateo CA, US
John Xiao - Cupertino CA, US

Assignee:

Interlace Systems, Inc. - San Mateo CA

International Classification:

G06F 17/30

US Classification:

707200000

Abstract:

Methods and apparatus for updating a database using a multi-dimensional data model in which data corresponding to the database are organized in multi-dimensional data blocks. Each data block has summary information associated therewith corresponding to a current state of evolution of the associated data block. Dependency information is maintained in the data model which identifies data dependencies within and among the data blocks. A list of change entries identifies changes made to the data blocks and times at which the changes were made. A request to apply a change entry to a data block is received. The change entry is applied to the data block, including generating a dependency list of data blocks whose data depends directly or indirectly from the updated data block. The data blocks in the dependency list are processed in accordance with a dependency update algorithm to update the data blocks in the dependency list.

US Patent:

20210141800, May 13, 2021

Filed:

Jan 20, 2021

Appl. No.:

17/153386

Inventors:

- Redwood Shores CA, US
JOHN XIAO - Cupertino CA, US

International Classification:

G06F 16/25
H04L 29/06
G06F 17/11
G06F 16/28
G06F 40/18

Abstract:

In accordance with an embodiment, described herein are systems and methods that enable client-side calculation with data provided at a multidimensional or other database server. Data provided at the server in accordance with a server-side model, can be transformed/prepared into a grid, for use with a client-side application, for example a client spreadsheet application. During preparation of the grid, one or more portions of the grid that are identified as client-side dynamic parameters, can be represented as dynamic formulas that are modifiable within the client-side application; while parameters of the server-side model that are outside of the grid can be represented as constant values. The grid provided to the client can be used to perform client-side calculations that allow for rapid calculations in response to changes in the client-side model, without introducing a round-trip performance lag between the client-side and server-side.