Zhiqi O Qiu from New Haven, CT, age 49

view source

Techniques For Managing What-If Analysis Of Data Managed By A Relational Database System
view source
US Patent:

20030204534, Oct 30, 2003
Filed:

Apr 16, 2003
Appl. No.:

10/417732
Inventors:

A. Hopeman - Arlington MA, US
James Carey - Brookline MA, US
Ekrem Soylemez - Arlington MA, US
Bruce Golbus - Waban MA, US
Igor Lubashev - Cambridge MA, US
Zhiqi Qiu - Waltham MA, US
Assignee:

ORACLE INTERNATIONAL CORPORATION - Redwood Shores CA
International Classification:

G06F012/00
G06F017/30
US Classification:

707/200000
Abstract:

An analytical workspace includes a set of data on which what-if analysis is performed, which is stored persistently and managed in a relational database system. The data may be stored as a binary large object in relational tables, and may comprise a portion of a multidimensional cube. A series of commands on the analytical workspace is received by a database server. In response to the commands, changes are made to the data in temporary storage. Redo information is not generated at this time in association with such changes. Hence, these changes are not made permanent at this time. At some point, the server may receive an update command to make the changes permanent. In response to the update command, redo information is generated for the changes reflected in the temporary storage and the changes are made permanent, in accordance with relational database properties.

Multiple Writer Support In An Olap Environment
view source
US Patent:

20060004885, Jan 5, 2006
Filed:

Jun 30, 2004
Appl. No.:

10/881174
Inventors:

Igor Lubashev - Cambridge MA, US
James Carey - Brookline MA, US
Albert Hopeman - Arlington MA, US
Bruce Golbus - Waban MA, US
Ekrem Soylemez - Arlington MA, US
Zhiqi Qiu - Waltham MA, US
Assignee:

ORACLE INTERNATIONAL CORPORATION - REDWOOD SHORES CA
International Classification:

G06F 17/30
US Classification:

707203000
Abstract:

Multiple writers can make permanent changes to data objects, while the performance is improved and data consistency is ensured. A database management system comprises a database containing a plurality of objects, and, possibly, a plurality of analytic workspaces, each analytic workspace containing at least some of the plurality of objects in the database, wherein changes made to a an object in a database private view are not written to a corresponding object in the database unless write access on the object has been given to the database private view, and wherein the database management system is operable to give write access on each of the plurality of objects in the database to database private views individually.

Zhiqi O Qiu