1
John G Adair, Daniel J Coyle Jr, Robert J Grafe, Bruce G Lindsay, Roger A Reinsch, Robert P Resch, Patricia G Selinger, Melvin R Zimowski: Heterogenous database communication system in which communicating systems identify themselves and convert any requests/responses into their own data format. International Business Machines Corporation, Baker Maxham Jester & Meador, May 16, 1995: US05416917 (120 worldwide citation)

The invention establishes the context in which data exchanged between dissimilar relational database management systems can be mutually understood and preserved, and data conversions can be minimized. The invention accomplishes this by establishing layers of descriptive information which isolate mac ...


2
John G Adair, Richard A Demers, Dusan Ecimovic, Robert J Grafe, Robert D Jackson, Bruce G Lindsay, Michael E Murphy, Roger A Reinsch, Robert P Resch, Richard R Sanders, Patricia G Selinger, Robert L Sunday, Melvin R Zimowski: Query language execution on heterogeneous database servers using a bind-file bridge between application and database languages. International Business Machines Corporation, Baker Maxham Jester & Meador, October 26, 1993: US05257366 (117 worldwide citation)

Application programs which are developed and scheduled within a first computing system environment are permitted to access relational data registered at a remote database management system (DBMS) operating in a second computing environment dissimilar to the first computing environment. Access to dat ...


3
Akira Shibamiya, Melvin R Zimowski: Data base optimizer using most frequency values statistics. International Business Machines Corporation, Pryor A Garnett, September 11, 1990: US04956774 (117 worldwide citation)

A method for more accurately estimating the time required to process a data base query using a selected index. A selected number of the most frequently occurring index key values (38) are collected during an index sequential scan. These most frequency occurring values are stored as percentage freque ...


4
Richard A Demers, Bruce G Lindsay, Roger A Reinsch, Melvin R Zimowski: Method and system for describing and exchanging data between heterogeneous database systems with data converted by the receiving database system. International Business Machines Corporation, Baker Maxham Jester & Meador, January 11, 1994: US05278978 (104 worldwide citation)

The invention establishes the context in which data exchanged between dissimilar relational database management systems can be mutually understood and preserved. The invention accomplishes this by establishing layers of descriptive information which isolate machine characteristics, levels of support ...


5
Robert A Gilles, Robert J Grafe, Robert D Jackson, Roger A Reinsch, Richard R Sanders, Jacob Slonim, Melvin R Zimowski: Method for synchronizing transaction processing in a distributed heterogeneous system. International Business Machines Corporation, Baker Maxham Jester & Meador, October 1, 1996: US05561797 (80 worldwide citation)

The invention provides transaction synchronization in the form of COMMIT processing in a distributed, heterogeneous database system wherein some resources are synchronized to a transaction by a single-phase commit procedures while other resources synchronize by multi-phase commit procedures. The inv ...


6
John G Adair, Daniel J Coyle Jr, Robert J Grafe, Bruce G Lindsay, Roger A Reinsch, Robert P Resch, Patricia G Selinger, Melvin R Zimowski: Method and combination for minimizing data conversions when data is transferred between a first database storing data in a first format and a second database storing data in a second format. International Business Machines Corporation, Baker Maxham Jester & Meador, October 15, 1996: US05566332 (74 worldwide citation)

The invention establishes the context in which data exchanged between dissimilar relational database management systems can be mutually understood and preserved, and data conversions can be minimized. The invention accomplishes this by establishing layers of descriptive information which isolate mac ...


7
Roger A Reinsch, Melvin R Zimowski: Method for restarting a long-running, fault-tolerant operation in a transaction-oriented data base system without burdening the system log. International Business Machines Corporation, R Bruce Brodie, September 19, 1989: US04868744 (48 worldwide citation)

A restartable load without logging method permits the restart of a LOAD operation from the last COMMIT point without requiring the writing of images of loaded records to the log. Instead, the method logs only a minimal amount of information, recording positions within the data sets to be loaded and ...


8
Melvin R Zimowski, Curt L Cotner, Peter K L Shum: Computer program product to efficiently process diverse result sets returned by a stored procedure. International Business Machines Corporation, Marilyn Smith Sterne Kessler Goldstein & Fox P L L C Dawkins Esq, May 20, 1997: US05632015 (36 worldwide citation)

A system for processing diverse and non-diverse result sets is described. The system includes a client process in a client computer system that constructs a client process execution request identifying a stored procedure and specifying constraints on the quantity of response data that the client pro ...


9
Melvin R Zimowski, Curt L Cotner, Peter K L Shum: System and method for efficiently processing diverse result sets returned by a stored procedures. International Business Machines Corporation, Marilyn Smith Dawkins Sterne Kessler Goldstein & Fox P L L C, March 25, 1997: US05615337 (23 worldwide citation)

A system for processing diverse and non-diverse result sets is described. The system includes a client process in a client computer system that constructs a client process execution request identifying a stored procedure and specifying constraints on the quantity of response data that the client pro ...