Michael Timothy Cross

US Patent:

7254583, Aug 7, 2007

Filed:

Dec 19, 2003

Appl. No.:

10/740700

Inventors:

Michael W. Cross - Portsmouth NH, US
Joseph T. Wissmann - Chelmsford MA, US

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 17/30

US Classification:

707102

Abstract:

The present invention is a method, system and apparatus for generating parameterized installation scripts to accommodate the installation of multiple databases sharing similar physical constructs. The method of the invention can include the step of creating a database which can achieve the foregoing stated advantages of the present invention, a parameterized description of a physical data model can be first combined with a set of database specific properties to produce a physical database. A parameterized description of a logical data model can be second combined with the set of database specific properties to generate a logical model for the physical database. The first combining step can include the step of creating at least one bufferpool in the physical database as specified by the properties. Also, the first combining step can include the step of creating at least one tablespace in the physical database as specified by the properties.

US Patent:

8359277, Jan 22, 2013

Filed:

Dec 23, 2007

Appl. No.:

11/963842

Inventors:

Bilikiss O. Adebiyi - Boston MA, US
James C. Boyd - Kennebunk ME, US
David A. Brooks - Providence RI, US
Michael W. Cross - Portsmouth NH, US
Patrick Y. Lin - Lexington MA, US
David E. Wilson - Lowell MA, US

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06Q 99/00

US Classification:

705319, 715745, 707783, 707E17109, 707785, 707784, 707758, 726 1, 726 2, 726 9, 726 17, 726 18, 726 27, 726 30, 726 8, 709203, 709219, 709229

Abstract:

A computer-implemented method of implementing information security. The method can include receiving a user input comprising a first user identifier and at least a second user identifier, determining whether the first user identifier corresponds to at least one of a plurality of existing user profiles, and determining whether the second user identifier corresponds to at least one of the plurality of existing user profiles. When it is determined that the first user identifier does not correspond to at least one of the plurality of existing user profiles, but that the second user identifier does correspond to at least one of the plurality of existing user profiles, the method can include selecting the user profile to which the second user identifier corresponds, automatically generating a unique user identifier, and associating the unique user identifier with the selected user profile.

US Patent:

20050149582, Jul 7, 2005

Filed:

Dec 29, 2003

Appl. No.:

10/748127

Inventors:

Joseph Wissmann - Chelmsford MA, US
Michael Cross - Portsmouth NH, US

International Classification:

G06F017/30

US Classification:

707201000

Abstract:

Disclosed is a lightweight database migration framework that allows schema definitions and incremental migrations to be pushed out to target local computers. The framework facilitates complex migrations by using either SQL script or programmatic migration methods to target local computers. Developers can download migration scripts from messages that are pushed to them, by electronic mail or otherwise, to synchronize their local database without the need to visit a central server. A base schema may be maintained via a set of incremental migration scripts, which generally correspond to milestone releases. In some embodiments, the scripts are specified via an XML document. The framework deduces a target database's schema version and automatically applies the necessary migration path to reach a target schema version. There is no need to visit a central server. Thus, there is no need to manage and maintain centralized server. Also, the migration scripts can be SQL scripts or code that executes complex data manipulation. The system encodes version histories by storing the migration scripts in a history folder, and facilitates the creation and migration to an earlier arbitrary schema version by reversing the operations performed using migration scripts executed after the arbitrary schema was created.

US Patent:

20080162427, Jul 3, 2008

Filed:

Dec 28, 2006

Appl. No.:

11/617558

Inventors:

Colleen S. Connearney - Arlington MA, US
Michael W. Cross - Portsmouth NH, US
John R. McGarvey - Apex NC, US
Christopher R. Seekamp - Boca Raton FL, US
Ajamu Wesley - Marlborough MA, US

Assignee:

INTERNATIONAL BUSINESS MACHINES CORPORATION - Armonk NY

International Classification:

G06F 17/30
G06F 7/00

US Classification:

707 3, 707 2, 707E17045

Abstract:

A method of data storage and retrieval using a relational database can include defining a first table in a relational database including a plurality of entries having a first value for a first field. A second table in the relational database including a plurality of entries can be defined. Each of the plurality of entries in the second table can specify an additional value for the first field of a corresponding entry in the first table. Responsive to a query, a data item selected from at least one of the plurality of entries in the first table can be presented.