Carol Louise Pearson

US Patent:

20090037462, Feb 5, 2009

Filed:

Jul 30, 2007

Appl. No.:

11/830541

Inventors:

Carol Jean Pearson - Portland OR, US
David W. Birdsall - Santa Clara CA, US
Roberta S. Marton - Fremont CA, US
Emile Roth - Campbell CA, US
John M. Hausman - San Luis Obispo CA, US
Kenneth K. Luu - Cupertino CA, US

International Classification:

G06F 17/30

US Classification:

707103 Y, 707E17005

Abstract:

A method for modifying an original data object in a database using a single command is disclosed. The single command is first validated. Once the command has been validated a ghost data object is created using the new definition. The ghost data object is populated with data from the original object. The transaction log records from the original data object are applied to the ghost data object. The original data object is then locked for exclusive access. The final transaction log records from the original data object are applied to the ghost data object. In the final step the database switches to the new data object. Dependent objects are automatically transformed as part of the same operation.

US Patent:

20110093511, Apr 21, 2011

Filed:

Oct 21, 2009

Appl. No.:

12/603020

Inventors:

Gunnar D. Tapper - Florissant CO, US
David W. Birdsall - Santa Clara CA, US
Carol Jean Pearson - Portland OR, US
Paul E. Denzinger - Aurora OH, US
Chantal Tremblay - Notre-Dame-De-La-Merci, CA

International Classification:

G06F 17/30
G06F 7/00

US Classification:

707803, 707E17044, 707E17136

Abstract:

There is provided a computer-implemented method of aggregating data. An exemplary method comprises receiving an aggregation scheme and generating numerous first aggregations by aggregating data at a first level of granularity. The data may be associated with a time and stored in a first table. Further, generating the numerous first aggregations may be based on the time and the aggregation scheme. The exemplary method further comprises generating a second aggregation by aggregating the first aggregations at a second level of granularity based on the aggregation scheme. The second level of granularity may comprise the first level of granularity.