PETER GEORGE JOHNSON, DPT
Physical Therapy at 1 St, Rochester, MN
License number
Minnesota 10673
Category
Restorative Service Providers
Type
Physical Therapist
Address
Address
200 1St St SW, Rochester, MN 55905
Phone
(507) 284-2511
Professional information
Method And Computer Program Product For Implementing Translatable Text In User Modifiable Sql Scripts
US Patent:
6374239, Apr 16, 2002
Filed:
Feb 9, 1999
Appl. No.:
09/248526
Inventors:
Mark John Anderson - Oronoco MN
David Allan Baldes - Rochester MN
Peter John Johnson - Rochester MN
Michael Donald Pfeifer - Dodge Center MN
David Allan Baldes - Rochester MN
Peter John Johnson - Rochester MN
Michael Donald Pfeifer - Dodge Center MN
Assignee:
International Business Machines Corporation - Armonk NY
International Classification:
G06F 1730
US Classification:
707 4
Abstract:
A method and computer program product are provided for implementing translatable text in user modifiable standard query language (SQL) scripts. A set of multiple queries are generated including comments and associated delimited names. The comments and associated delimited names are translated into multiple language versions. A user selected national language is identified. The user selected national language version of the translated comments and associated delimited names are utilized for generating a query. In accordance with features of the invention, the user is given the option to view the query and to make any desired modifications.
Graphical User Interface To Build Event-Based Dynamic Searches Or Queries Using Event Profiles
US Patent:
7003730, Feb 21, 2006
Filed:
Mar 8, 2002
Appl. No.:
10/094531
Inventors:
Richard Dean Dettinger - Rochester MN, US
Peter John Johnson - Rochester MN, US
Jeffrey Wayne Tenner - Rochester MN, US
Peter John Johnson - Rochester MN, US
Jeffrey Wayne Tenner - Rochester MN, US
Assignee:
International Business Machines Corporation - Armonk NY
International Classification:
G06F 3/00, G06F 17/30
US Classification:
715764, 715810, 715968, 707 3, 7071041
Abstract:
The present invention generally provides methods, systems and articles of manufacture for programmatically providing a user interface for creating queries. In one embodiment, the graphical user interface comprises (i) a region for displaying conditions of a user-defined query; and (ii) a graphical element for initiating a process of applying an event profile to a first condition of the query, whereby results returned by execution of the query are restricted to those for which the first condition and a second condition defined by the event profile are contemporaneously true.
Method To Provide Management Of Query Output
US Patent:
7370030, May 6, 2008
Filed:
Jun 17, 2004
Appl. No.:
10/870378
Inventors:
Richard D. Dettinger - Rochester MN, US
Peter J. Johnson - Rochester MN, US
Dan P. Kolz - Rochester MN, US
Shannon E. Wenzel - Colby WI, US
Peter J. Johnson - Rochester MN, US
Dan P. Kolz - Rochester MN, US
Shannon E. Wenzel - Colby WI, US
Assignee:
International Business Machines Corporation - Armonk NY
International Classification:
G06F 17/30
US Classification:
707 2, 7071041, 707 3, 707 4, 707 5
Abstract:
A method, system and article of manufacture for processing queries that are executed against a database. In one embodiment, the database environment imposes a limit on the number of columns capable of being returned for a single query. Accordingly, a single query is replicated to produce N sub-queries, each selecting a portion of the total number of result fields specified in the single query.
Application Portability And Extensibility Through Database Schema And Query Abstraction
US Patent:
8180787, May 15, 2012
Filed:
Sep 14, 2005
Appl. No.:
11/226181
Inventors:
Richard Dean Dettinger - Rochester MN, US
Peter John Johnson - Rochester MN, US
Richard Joseph Stevens - Mantorville MN, US
Eric Will - Oronoco MN, US
Peter John Johnson - Rochester MN, US
Richard Joseph Stevens - Mantorville MN, US
Eric Will - Oronoco MN, US
Assignee:
International Business Machines Corporation - Armonk NY
International Classification:
G06F 7/00, G06F 17/30
US Classification:
707760, 707802
Abstract:
The present invention generally is directed to a system, method and article of manufacture for accessing data independent of the particular manner in which the data is physically represented. In one embodiment, a data repository abstraction layer provides a logical view of the underlying data repository that is independent of the particular manner of data representation. A query abstraction layer is also provided and is based on the data repository abstraction layer. A runtime component performs translation of an abstract query into a form that can be used against a particular physical data representation.
Techniques For Identifying Mergeable Data
US Patent:
7725498, May 25, 2010
Filed:
Apr 22, 2004
Appl. No.:
10/829624
Inventors:
Eric L. Barsness - Pine Island MN, US
Peter J. Johnson - Rochester MN, US
Michael P. Koranda - Rochester MN, US
Randy W. Ruhlow - Rochester MN, US
John M. Santosuosso - Rochester MN, US
Peter J. Johnson - Rochester MN, US
Michael P. Koranda - Rochester MN, US
Randy W. Ruhlow - Rochester MN, US
John M. Santosuosso - Rochester MN, US
Assignee:
International Business Machines Corporation - Armonk NY
International Classification:
G06F 7/00, G06F 17/30
US Classification:
707803, 707809
Abstract:
A system, method and article of manufacture for identifying mergeable data in a data processing system and, more particularly, for identifying correlated columns from one or more database tables. One embodiment comprises determining correlation attributes for a first column and a second column from one or more database tables. The correlation attributes describe for each column at least one of the column and content of the column. The correlation attributes from the first and second column are compared and similarities between the first and second column are identified on the basis of the comparison. Then, on the basis of the identified similarities, it is determined whether the first and second columns are correlated. Only if the columns are determined to be correlated, the first and second columns are merged.
User-Defined Relationships For Diagramming User-Defined Database Relations
US Patent:
6915298, Jul 5, 2005
Filed:
Feb 9, 2000
Appl. No.:
09/500648
Inventors:
Michael W. Cain - Rochester MN, US
Peter John Johnson - Rochester MN, US
Kenton R. Milligan - Rochester MN, US
Michael Donald Pfeifer - Dodge Center MN, US
Peter John Johnson - Rochester MN, US
Kenton R. Milligan - Rochester MN, US
Michael Donald Pfeifer - Dodge Center MN, US
Assignee:
International Business Machines Corporation - Armonk NY
International Classification:
G06F017/00
US Classification:
707100, 7071041, 345968
Abstract:
A schema diagrammer aids a database administrator or other user in maintaining and managing a database in a computer system. The schema diagrammer allows the user to define “user-defined relationships” between objects in the database. The schema diagrammer generates a graphical schema diagram or map that indicates the objects and their relationships to one another. The relationships that are displayed include both the formal relationships defined programmatically by the database itself and the user-defined relationships.
Method To Provide Management Of Query Output
US Patent:
7844623, Nov 30, 2010
Filed:
Jan 22, 2008
Appl. No.:
12/017373
Inventors:
Richard D. Dettinger - Rochester MN, US
Peter J. Johnson - Rochester MN, US
Dan P. Kolz - Rochester MN, US
Shannon E. Wenzel - Colby WI, US
Peter J. Johnson - Rochester MN, US
Dan P. Kolz - Rochester MN, US
Shannon E. Wenzel - Colby WI, US
Assignee:
International Business Machines Corporation - Armonk NY
International Classification:
G06F 17/30
US Classification:
707770, 707764
Abstract:
System and article of manufacture for processing queries that are executed against a database. In one embodiment, the database environment imposes a limit on the number of columns capable of being returned for a single query. Accordingly, a single query is replicated to produce N sub-queries, each selecting a portion of the total number of result fields specified in the single query.
Graphical User Interface For Building Queries With Hierarchical Conditions
US Patent:
6947928, Sep 20, 2005
Filed:
Feb 26, 2002
Appl. No.:
10/083073
Inventors:
Richard Dean Dettinger - Rochester MN, US
Peter John Johnson - Rochester MN, US
Richard Joseph Stevens - Mantorville MN, US
Peter John Johnson - Rochester MN, US
Richard Joseph Stevens - Mantorville MN, US
Assignee:
International Business Machines Corporation - Armonk NY
International Classification:
G08F017/30
US Classification:
707 4, 707 1, 7071041
Abstract:
The present invention generally provides methods, systems and articles of manufacture for programmatically providing a user interface for creating queries. In one embodiment, graphical user interface content which defines a graphical user interface is provided. The graphical user interface comprises (i) a region for displaying conditions of a query; and (ii) a first graphical element for initiating a process of combining two or more conditions of the query together with logic values to form a complex condition. In another embodiment, the graphical user interface further comprises a second graphical element for initiating a process of separating two or more conditions of a complex condition.
Method To Document Relations Between Objects Using A Graphical Interface Tree Component
US Patent:
6842878, Jan 11, 2005
Filed:
Sep 29, 2000
Appl. No.:
09/672044
Inventors:
Peter John Johnson - Rochester MN, US
Michael Donald Pfeifer - Dodge Center MN, US
Michael Donald Pfeifer - Dodge Center MN, US
Assignee:
International Business Machines Corporation - Armonk NY
International Classification:
G06F 300, G06F 1730
US Classification:
715853, 715841, 715854, 715855, 715968
Abstract:
Logical relationships between objects are displayed using a graphical interface tree component. In a data base application, by selecting and expanding a table node, user can see those views and indexes which are directly related to the table, but not contained within the table, i. e. , where there is no physical connection, but there are logical connections (relations). With context menus, the user can make changes in place.
Apparatus And Method For Generating And Displaying A Schema Diagram For A Database
US Patent:
6978269, Dec 20, 2005
Filed:
Jul 13, 1999
Appl. No.:
09/351793
Inventors:
Peter John Johnson - Rochester MN, US
Michael Donald Pfeifer - Dodge Center MN, US
Michael Donald Pfeifer - Dodge Center MN, US
Assignee:
International Business Machines Corporation - Armonk NY
International Classification:
G06F017/00
US Classification:
707100
Abstract:
An apparatus and method for generating and displaying a schema diagram of a database includes a schema diagrammer that automatically queries a database to determine its objects and relationships, and generates a graphical representation of the database in the form of a schema diagram that is displayed to the user. The schema diagrammer may optionally include a search filter to potentially constrain which objects and relationships in the database are included in a diagram data file, and a display filter to potentially constrain which objects and relationships stored in the diagram data file are displayed in the schema diagram.