1
Jeffrey D Aman, Curt L Cotner, Donna N T Dillenberger, David B Emmes: System of assigning work requests based on classifying into an eligible class where the criteria is goal oriented and capacity information is available. International Business Machines Corporation, William A Kinnaman Jr, Peter L Michaelson & Wallace Michaelson, February 11, 1997: US05603029 (148 worldwide citation)

Apparatus and accompanying methods for use preferably in a multi-system shared data (sysplex) environment (100), wherein each system (110) provides one or more servers (115), for dynamically and adaptively assigning and balancing new work and for new session requests, among the servers in the sysple ...


2
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 ...


3
Curt L Cotner, Laurence E England, Howard J Glaser, Howard M Hess: Method of, system for, and computer program product for providing automatic identification of a computer program code candidate for web deployment or a stored procedure. International Business Machines Corporation, Prentiss W Johnson, August 16, 2005: US06931630 (27 worldwide citation)

Computer program code which is a candidate for Web enablement or stored procedures is identified. Source code corresponding to computer program code is scanned and parsed to determine static information concerning the computer program code. The static information is stored in a database. Dynamic inf ...


4
Curt L Cotner, Robert J Heaps, Wendy L Koontz, Benjamin R Little, Thomas J Toomire: Computer program product and program storage device for including stored procedure user defined function or trigger processing within a unit of work. International Business Machines Corporation, Stern Kessler Goldstein & Fox P L L C, November 18, 1997: US05689633 (23 worldwide citation)

A computer program product and program storage device for incorporating an external predefined procedure into an existing unit of work. The existing unit of work is part of a client application process, wherein the client application process is not able to execute external programs. A logical repres ...


5
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 ...


6
Curt L Cotner, James W Pickel, Julie A Watts: Method for managing distributed savepoints across multiple DBMS's within a distributed transaction. International Business Machines Corporation, Richard M Goldman, Ingrid Foerster, November 9, 2004: US06816873 (23 worldwide citation)

System, method, and program product for managing transactions on a plurality of Database Management Systems residing on separate participant servers and a coordinator server. A single transaction proceeds by multiple steps across more then one of the plurality of Database Management Systems as parti ...


7
Curt L Cotner, Robert J Heaps, Wendy L Koontz, Benjamin R Little, Thomas J Toomire: System and method for including stored procedures, user-defined functions, and trigger processing in an existing unit of work. International Business Machines Corporation, Marilyn Smith Dawkins, Sterne Kessler Goldstein & Fox P L L C, September 3, 1996: US05553234 (15 worldwide citation)

A system and method for incorporating an external predefined procedure into an existing unit of work. The existing unit of work is part of a client application process, wherein the client application process is not able to execute external programs. A logical representation of the client application ...


8
Curt L Cotner, Wendy Lynne Koontz, Gerald H Roth, Frederick Thomas Sharp, Shu Huar Joseph Yeh: Storing P-code in a database. International Business Machines Corporation, Gates & Cooper, July 23, 2002: US06424974 (14 worldwide citation)

A method, apparatus, and article of manufacture for providing a programming development environment that supports the development of portable server routines. More specifically, the present invention discloses a method for storing and retrieving server routines within the database independent of any ...


9
Paul M Bird, Timothy J Vincent, Curt L Cotner: Unique identification of SQL cursor occurrences in a repetitive, nested environment. International Business Machines Corporation, John L Rogitz, October 25, 2005: US06959305 (12 worldwide citation)

A cursor query identifier is defined to uniquely identify cursors in a relational database system that supports nested routine invocation. The identifier includes a cursor nesting level value that corresponds to the nested level at which the cursor is opened. The identifier also includes a invocatio ...


10
Yao Ching S Chen, Curt L Cotner, Gerald G Kiernan, David J Kuang, Irene C Liu, Regina J Liu, Walid Rjaibi, Timothy J Vincent: Managing materialized query tables (MQTS) over fine-grained access control (FGAC) protected tables. International Business Machines Corporation, Janaki K Davda, Konrad Raynes Davda & Victor, August 20, 2013: US08515948 (6 worldwide citation)

Provided are techniques for creating one or more fine-grained access control rules that are associated with a base table. A materialized query table is created from the base table without applying the one or more fine-grained access control rules associated with the base table when obtaining data fr ...