William G Mckenna

US Patent:

6374263, Apr 16, 2002

Filed:

Jul 19, 1999

Appl. No.:

09/356486

Inventors:

Craig J. Bunger - San Francisco CA
Latha S. Colby - Mountain View CA
Richard L. Cole - Los Gatos CA
Galt Johnson - San Francisco CA
William J. McKenna - Santa Cruz CA
Gopal B. Mulagund - San Jose CA

Assignee:

International Business Machines Corp. - Armonk NY

International Classification:

G06F 1730

US Classification:

707201, 707 2, 707 3, 707 8, 707 10, 707203, 709203, 709219

Abstract:

A system and a method maintain a precomputed view corresponding to detail data in a database server by: determining a maintenance plan to refresh the precomputed view when detail data is changed; integrating the maintenance plan with a query execution plan in the database server; and executing the query execution plan.

US Patent:

7213012, May 1, 2007

Filed:

May 9, 2003

Appl. No.:

10/435228

Inventors:

Hakan Jakobsson - San Francisco CA, US
William McKenna - Santa Cruz CA, US
Mohamed Ziauddin - Pleasanton CA, US

Assignee:

Oracle International Corporation - Redwood Shores CA

International Classification:

G06F 17/30

US Classification:

707 2, 707 3

Abstract:

Described herein are approaches to implementing dynamic sampling in a way that lessens or eliminates the additional overhead incurred to perform dynamic sampling. Also described are techniques for determining characteristics about predicates not previously determined by conventional techniques for dynamic sampling. Dynamic sampling is used by a query optimizer to dynamically estimate predicate selectivities and statistics. When a database statement is received by a database server, an initial analysis of the database statement is made to determine the efficacy of dynamic sampling, that is, to determine whether optimization of the query would benefit from dynamic sampling and whether performance is not excessively impacted by the dynamic sampling process. If this analysis determines dynamic sampling should be used, then dynamic sampling is undertaken.

US Patent:

20070259045, Nov 8, 2007

Filed:

Jan 27, 2006

Appl. No.:

11/574778

Inventors:

Richard Mannion - Furlong PA, US
William Mckenna - Yonkers NY, US
Edward O'Donnell - Basking Ridge NJ, US
Helen Danagher - Cambridge, GB
Geoffrey Hayes - Saffron Walden, GB
Hassan Mohammad - Littleport Ely, GB
Derek Prater - Cambridge, GB
Harjit Tamber - Hitchin, GB
Walden Malcolm - Cambridge, GB
Steve Whitelock - Cambridge, GB
Wolfgang Fleischer - Ingelheim, DE
Udo Hahn - Nentershausen, DE
Christof Spitzley - Elbgrund, DE
Christian Leuner - Frankfurt, DE

Assignee:

EURO-CELTIQUE S.A. - Luxembourg

International Classification:

A61K 9/00
A61K 31/44
A61P 29/00
C07D 471/00

US Classification:

424487000, 424484000, 424486000, 424488000, 514282000, 546045000

Abstract:

Disclosed in certain embodiments is a controlled release dosage form comprising a matrix comprising a pharmaceutically acceptable salt of an opioid analgesic in a controlled release material; wherein less than 25% of the opioid salt is released after 1 hour of in-vitro dissolution of the dosage form in 900 ml of Simulated Gastric Fluid with 20% ethanol using a USP Apparatus I (basket) apparatus at 100 rpm at 37 degrees C..