William Robert Bireley

US Patent:

7136847, Nov 14, 2006

Filed:

Aug 31, 2001

Appl. No.:

09/944939

Inventors:

Tammie Dang - Morgan Hill CA, US
William Robert Bireley - Morgan Hill CA, US
Curt Lee Cotner - Gilroy CA, US
Claire Willey McFeely - San Jose CA, US
James Willis Pickel - Gilroy CA, US
Koichi Yamaguchi - Los Gatos CA, US

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 17/30

US Classification:

707 3, 707 4

Abstract:

Aspects for dynamically changing attributes in an embedded-SQL application are described. In these aspects, an option is provided within a standard SQL statement for specifying one or more attributes of at least a declared cursor. The standard SQL statement is then processed to include the specified one or more attributes in at least the declared cursor. The provision occurs with an ATTRIBUTES option and within a PREPARE SQL statement.

US Patent:

7433950, Oct 7, 2008

Filed:

Dec 4, 2003

Appl. No.:

10/729636

Inventors:

Paul M. Bird - Markham, CA
William R. Bireley - Morgan Hill CA, US
Curt L. Cotner - Gilroy CA, US
Tammie Dang - Morgan Hill CA, US
Margaret A. Dong - San Jose CA, US
Georgia C. Fuller - San Jose CA, US
Michelle D. Lam - San Jose CA, US
James W. Pickel - Gilroy CA, US
Frankie K. Sun - North York, CA

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 15/173

US Classification:

709225, 709232, 709217, 709201, 707 10, 707202

Abstract:

In a method for avoiding section collision for application server requests over a single database connection, the database server assigns query identifiers to each instance of the same cursor opened for the same processing level within an application, allowing multiple instances of the same cursor to be processed in parallel without section collision. The application server assigns a command source identifier to each statement sent over a single database connection to uniquely identify the application source of the statement. This applies for multiples of the same statement sent by different application sources within the same application, for a single statement containing multiple application sources, and for multiple statements from different applications multiplexed over a single database connection. These statements can be processed separately from and in parallel with the each other without section collision.

US Patent:

7779047, Aug 17, 2010

Filed:

Jun 22, 2007

Appl. No.:

11/767450

Inventors:

William Robert Bireley - Morgan Hill CA, US
Delmar Eugene Blevins - Los Gatos CA, US
Stephen Andrew Brodsky - Los Gatos CA, US
Anshul Dawra - San Jose CA, US
Swaminathan Gounder - San Jose CA, US
Timo Juhani Salo - Cary NC, US
Brandon Jacob Wright Smith - Cary NC, US

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 17/30

US Classification:

707803, 707792

Abstract:

Provided are techniques for storing data. Invocation of a data access service is received, wherein the invocation identifies a data structure storing one or more data elements having a data format. An update handler to be plugged into a data access framework is identified, wherein the update handler processes data elements having the data format. Under control of the update handler, data elements are accessed in the data structure; one or more statements for storing the data elements into the data store are determined; and the one or more statements are forwarded to the data access framework.

US Patent:

7933948, Apr 26, 2011

Filed:

Jun 30, 2008

Appl. No.:

12/164920

Inventors:

Paul M. Bird - Markham, CA
William R. Bireley - Morgan Hill CA, US
Curt L. Cotner - Gilroy CA, US
Tammie Dang - Morgan Hill CA, US
Margaret A. Dong - San Jose CA, US
Georgia C. Fuller - San Jose CA, US
Michelle D. Lam - San Jose CA, US
James W. Pickel - Gilroy CA, US
Frankie K. Sun - North York, CA

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 15/16

US Classification:

709201, 709225, 709217, 709216, 709223, 709232, 707 10, 707202, 707203

Abstract:

In a system for avoiding section collision for application server requests over a single database connection, the database server assigns query identifiers to each instance of the same cursor opened for the same processing level within an application, allowing multiple instances of the same cursor to be processed in parallel without section collision. The application server assigns a command source identifier to each statement sent over a single database connection to uniquely identify the application source of the statement. This applies for multiples of the same statement sent by different application sources within the same application, for a single statement containing multiple application sources, and for multiple statements from different applications multiplexed over a single database connection. These statements can be processed separately from and in parallel with the each other without section collision.

US Patent:

8086817, Dec 27, 2011

Filed:

Dec 21, 2006

Appl. No.:

11/614662

Inventors:

William Robert Bireley - Morgan Hill CA, US
Margaret Ann Dong - San Jose CA, US
Kelvin Ho - Richmond Hill, CA
Sigitas Bigelis - San Jose CA, US

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 12/10

US Classification:

711171

Abstract:

A method and system for efficient allocation of memory in database retrieval employs a technique which allocates a memory portion of a first size which may or may not be smaller than a data item to be retrieved from the database (such as a column which may be of indeterminate length). In that circumstance, a first FETCH, for example, an SQL FETCH, is followed by a new syntactical instruction, a FETCH CONTINUE, until all of the data item is retrieved. The FETCH CONTINUE may involve allocating memory portions of similar or different sizes to accommodate additional fetched portions, and may involve varying numbers of fetches.

US Patent:

8090735, Jan 3, 2012

Filed:

Jun 22, 2007

Appl. No.:

11/767454

Inventors:

William Robert Bireley - Morgan Hill CA, US
Delmar Eugene Blevins - Los Gatos CA, US
Stephen Andrew Brodsky - Los Gatos CA, US
Curt Lee Cotner - Gilroy CA, US
Anshul Dawra - San Jose CA, US
Swaminathan Gounder - San Jose CA, US
Daya Vivek - San Jose CA, US
Maryela Evelin Weihrauch - San Jose CA, US

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 17/30

US Classification:

707759

Abstract:

Provided are techniques for generating a result set. A statement that includes at least one statement pattern is received, wherein each statement pattern is a template that indicates how a statement is to be modified for execution against a data store and wherein each statement pattern modifies program logic and control flow. Each statement pattern is expanded to generate one or more new statements, wherein each statement pattern is capable of being expanded to zero or more statement patterns. The one or more new statements are executed against a data store to obtain a result set. It is determined whether to modify the result set based on the at least one statement pattern. In response to determining that the result set is to be modified, modifying the result set.

US Patent:

8145655, Mar 27, 2012

Filed:

Jun 22, 2007

Appl. No.:

11/767451

Inventors:

William Robert Bireley - Morgan Hill CA, US
Delmar Eugene Blevins - Los Gatos CA, US
Stephen Andrew Brodsky - Los Gatos CA, US
Jaijeet Chakravorty - Union City CA, US
Anshul Dawra - San Jose CA, US
Suavi Ali Demir - San Jose CA, US
Swaminathan Gounder - San Jose CA, US

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 7/00
G06F 17/30

US Classification:

707758, 707759

Abstract:

Provided are a method, system, and article of manufacture for generating information on database queries in source code into object code compiled from the source code. Source code including query statements to perform operations with respect to a database is translated into executable object code. A statement descriptor for at least one query statement is generated into the object code, wherein the statement descriptor for the at least one query statement includes information on the query statement including the query statement in the source code. The statement descriptors in the object code are processed to output information on the query statements indicated in the statement descriptors.

US Patent:

8402436, Mar 19, 2013

Filed:

Oct 27, 2008

Appl. No.:

12/258849

Inventors:

William R. Bireley - Morgan Hill CA, US
Delmar E. Blevins - Los Gatos CA, US
Stephen A. Brodsky - Los Gatos CA, US
Jaijeet Chakravorty - Union City CA, US
Anshul Dawra - San Jose CA, US
Suavi A. Demir - San Jose CA, US
Swaminathan Gounder - San Jose CA, US
Paul Ostler - Yakima WA, US

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 9/44

US Classification:

717120, 717117, 717121

Abstract:

A method of accessing layers in a multi-layer software architecture including a first layer, a second layer, and a third layer. The method includes: at the third layer, publishing an interface; and at the first layer, before execution of a first function, registering a callback routine with the third layer using the interface.