Tom R Christopher

US Patent:

7120638, Oct 10, 2006

Filed:

Sep 21, 1999

Appl. No.:

09/399694

Inventors:

Mark Anthony Cesare - San Francisco CA, US
Tom Robert Christopher - Morgan Hill CA, US
Julie Ann Jerves - Saratoga CA, US

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 7/00

US Classification:

707101, 707 4, 707 6, 7071041

Abstract:

Disclosed is a method, system, program, and data structure for performing a clean operation on an input table. The input table to clean is indicated in an input data table name. At least one rule definition is processed to clean the input table. Each rule definition indicates a find criteria, a replacement value, and an input data column in the input table. For each rule definition, the input data column is searched for any fields that match the find criteria. The replacement value for the particular rule definition is inserted in the fields in the input data column that match the find criteria. Subsequent applications of additional rule definitions applied to the same input data column operate on replacement values inserted in the input data column during previously applied rule definitions.

US Patent:

7249151, Jul 24, 2007

Filed:

Jul 26, 2005

Appl. No.:

11/190250

Inventors:

Mark Anthony Cesare - San Francisco CA, US
Tom Robert Christopher - Morgan Hill CA, US
Julie Ann Jerves - Saratoga CA, US

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 17/00

US Classification:

707200, 707 4, 707 6, 707101, 707102, 7071041

Abstract:

Disclosed is a method, system, program, and data structure for performing a clean operation on an input table. The input table to clean is indicated in an input data table name. At least one rule definition is processed to clean the input table. Each rule definition indicates a find criteria, a replacement value, and an input data column in the input table. For each rule definition, the input data column is searched for any fields that match the find criteria. The replacement value for the particular rule definition is inserted in the fields in the input data column that match the find criteria. Subsequent applications of additional rule definitions applied to the same input data column operate on replacement values inserted in the input data column during previously applied rule definitions.

US Patent:

7406679, Jul 29, 2008

Filed:

May 10, 2002

Appl. No.:

10/144049

Inventors:

Constance J. Nelin - Austin TX, US
Tanya Couch - San Jose CA, US
Abdul H. Al-Azzawe - San Jose CA, US
Frederick T. Sharp - Menlo Park CA, US
Tom R. Christopher - Morgan Hill CA, US

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 9/44

US Classification:

717130, 717124

Abstract:

A method for providing a test environment for database server-side objects persistently stores a profile for a plurality of test runs for database server-side objects, where the profile comprises persistently stored test parameter values, pre-execution scripts, and/or post-execution scripts. Once the profile is created, it can be selected for subsequent test runs for one or more objects. A plurality of profiles for the objects may also be created. The method eliminates the need for a manual set up or destruction of the test environment for each test run, improving efficiency in the development of database server-side objects significantly.

US Patent:

7975258, Jul 5, 2011

Filed:

May 20, 2008

Appl. No.:

12/124029

Inventors:

Constance J. Nelin - Austin TX, US
Tanya Couch - San Jose CA, US
Abdul H. Al-Azzawe - San Jose CA, US
Frederick T. Sharp - Menlo Park CA, US
Tom R. Christopher - Morgan Hill CA, US

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 9/44
G06F 7/00

US Classification:

717124, 717103, 717115, 707702

Abstract:

A system for providing a test environment for database server-side objects persistently stores a profile for a plurality of test runs for database server-side objects, where the profile comprises persistently stored test parameter values, pre-execution scripts, and/or post-execution scripts. Once the profile is created, it can be selected for subsequent test runs for one or more objects. A plurality of profiles for the objects may also be created. The system eliminates the need for a manual set up or destruction of the test environment for each test run, improving efficiency in the development of database server-side objects significantly.

US Patent:

20060195488, Aug 31, 2006

Filed:

May 11, 2006

Appl. No.:

11/382889

Inventors:

Mark Cesare - San Francisco CA, US
Tom Christopher - Morgan Hill CA, US
Julie Jerves - Saratoga CA, US
Richard Mandel - San Jose CA, US

International Classification:

G06F 17/30

US Classification:

707200000

Abstract:

Disclosed is a method, system, program, and data structure for performing a clean operation on an input table. The input table to clean is indicated in an input data table name. At least one rule definition is processed to clean the input table. Each rule definition indicates a find criteria, a replacement value, and an input data column in the input table. For each rule definition, the input data column is searched for any fields that match the find criteria. The replacement value for the particular rule definition is inserted in the fields in the input data column that match the find criteria. Subsequent applications of additional rule definitions applied to the same input data column operate on replacement values inserted in the input data column during previously applied rule definitions. At least one of said rule definition includes multiple find criteria and a corresponding replacement value for each find criteria.

US Patent:

20060195489, Aug 31, 2006

Filed:

May 11, 2006

Appl. No.:

11/382894

Inventors:

Mark Cesare - San Francisco CA, US
Tom Christopher - Morgan Hill CA, US
Julie Jerves - Saratoga CA, US
Richard Mandel - San Jose CA, US

International Classification:

G06F 17/30

US Classification:

707200000

Abstract:

Disclosed is a method, system, program, and data structure for performing a clean operation on an input table. The input table to clean is indicated in an input data table name. At least one rule definition is processed to clean the input table. Each rule definition indicates a find criteria, a replacement value, and an input data column in the input table. The rule definition comprises a type of rule that is a member of the set of rules consisting of: find and replace, discretization, and numeric clip, and at least two rule definitions are comprised of different rule types. For each rule definition, the input data column is searched for any fields that match the find criteria. The replacement value for the particular rule definition is inserted in the fields in the input data column that match the find criteria. Subsequent applications of additional rule definitions applied to the same input data column operate on replacement values inserted in the input data column during previously applied rule definitions.

US Patent:

6920443, Jul 19, 2005

Filed:

Sep 21, 1999

Appl. No.:

09/400507

Inventors:

Mark Anthony Cesare - San Francisco CA, US
Tom Robert Christopher - Morgan Hill CA, US
Julie Ann Jerves - Saratoga CA, US

Assignee:

International Business Machines, Corporation - Armonk NY

International Classification:

G06F017/30

US Classification:

707 1, 707 4, 707104, 709219

Abstract:

Disclosed is a method, system, program, and data structure for transforming data in an input table in a database in a server in communication with a client. A transform command is received from the client indicating an input data table name in the database and at least one rule indicating at least one cell in the input table to transform and a transform operation to perform with respect to the at least one cell. The transform command is executed in the server including the database by accessing a copy of the input table from the database and transforming data in the accessed input table according to each rule specified in the transform command.