Patents by Inventor James Pickel
James Pickel has filed for patents to protect the following inventions. This listing includes patent applications that are pending as well as patents that have already been granted by the United States Patent and Trademark Office (USPTO).
-
Publication number: 20070288491Abstract: A method and apparatus for configuring a plurality of server systems. In one implementation, the method includes configuring the plurality of server systems as a first database having a group name and a group port, and configuring a subset of the plurality of server systems as a second database having a subset name and a subset port. The first database is accessible by a client application via the group name and the group port for storage of data in the first database, and the second database is accessible by a client application via the subset name and the subset group for storage of data in the second database.Type: ApplicationFiled: June 29, 2007Publication date: December 13, 2007Applicant: International Business Machines CorporationInventors: Brian HOWELL, James Pickel, Hugh Smith
-
Publication number: 20070239719Abstract: A shared memory device called the Coupling Facility (CF) is used to record the indoubt transaction entries for each member of the database cluster, avoiding the CPU cost and elapsed time impact of persisting this information to disk (either via a log write or a relational table I/O). The CF provides full read/write access and data coherency for concurrent access by all the members in the database cluster. At any given point in time, the CF will contain the full list of indoubt transactions for the entire database cluster. CF duplexing is used to guarantee the integrity of the CF structure used for the indoubt list. In the event of complete loss of both CF structures (which will not happen except in major disaster situations), data sharing group restart processing can reconstruct the CF structures from the individual member logs.Type: ApplicationFiled: June 19, 2007Publication date: October 11, 2007Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Curt Cotner, Brian Howell, Jeffrey Josten, James Pickel
-
Publication number: 20070198482Abstract: A method, apparatus and program storage device is provided for dynamic data formatting during transmittal of generalized byte string data across a computer network. Remote server dynamically changes format of each column string data value from the result set separately, according to actual size of the string data value, and returns it to a client. Small-size data value is returned in a single network return message as varchar type, in-line with the rest of the query data. Medium-sized data value is retrieved without locators and streamed in multiple return network messages in a separate data object following the query data and in the same response. Large-size data value is retrieved using locators and returned as a progressive reference in pieces of specified size, where each piece of data value is separately transferred under client's control when needed, thus eliminating the need to buffer large amount of data.Type: ApplicationFiled: February 21, 2006Publication date: August 23, 2007Applicant: International Business Machines CorporationInventors: Terry Allen, Toby Haynes, Kelvin Ho, James Pickel, Michael Springgay, Frankie Sun, Maryela Weihrauch
-
Publication number: 20070143249Abstract: An SQL procedure deployment system deploys a query procedure comprising a procedural logic component and a database request component from a source system to a target system. At generation of the query procedure, the system generates a query procedure source code, a symbol table, and an encapsulated optimization results to regenerate run-time instructions for query statements of the database request component and make the query statements function with a deployed procedural logic component. The system maintains an association between the procedural logic component and the database request component during deployment. The system copies an internal representation of the procedural logic component to the target system without regeneration. The system regenerates the database request component to recreate the query procedure on the target system and to maintain a consistent interface between the procedural logic component and database request component.Type: ApplicationFiled: December 17, 2005Publication date: June 21, 2007Inventors: Margaret Bernal, Yao-Ching Chen, Ding-Wei Chieh, Curt Cotner, Baoqiu Cui, Tammie Dang, Marion Farber, Georgia Fuller, Joe Huang, Hui-An Lee, Claire McFeely, Chunfeng Pei, James Pickel, Yumi Tsuji, Jay Yothers, Margaret Zagelow, Liyan Zhou
-
Publication number: 20070130118Abstract: An embodiment of the present invention enables manipulation of data on a remote server and ensures uniqueness of data identifiers in a multi-tier environment, where a database client communicates through one or more intermediate servers to reach the target server containing the remote database. In particular, a client system transmits a query to the target server via a gateway system and receives a handle or data reference and a query identification for subsequent manipulation of data residing on that target server. A new query identification is generated by the gateway system and mapped with the query identification of the intended target server. When the client system transmits a query with the gateway query identification, the gateway system performs a lookup operation to identify the corresponding target server and subsequently forwards the query and target server query identification to the identified target server for processing.Type: ApplicationFiled: December 1, 2005Publication date: June 7, 2007Applicant: International Business Machines CorporationInventors: Shivram Ganduri, James Pickel
-
Patent number: 7120704Abstract: A method and system for connecting a client to a database managed by a network of computer systems having a plurality of database management system (DBMS) members includes providing a shared network address for the plurality of DBMS members, which is used by the client to connect to an active DBMS member of the plurality of DBMS members. Through the aspects of the present invention, the shared network address allows the client to connect, via a network router, to any one of the plurality of DBMS members so long as one member is active. Once the client is connected to one member, the member sends to the client a list of all active members and their respective workloads. The list also includes member-specific network addresses corresponding to each member so that the client can distribute work evenly across the active members and also perform a resynchronization process with a DBMS member after a first connection with the DBMS member has been interrupted.Type: GrantFiled: January 31, 2002Date of Patent: October 10, 2006Assignee: International Business Machines CorporationInventors: James Pickel, Shivram Ganduri
-
Publication number: 20060210071Abstract: Techniques are provided for processing data. It is determined that a portion of a data stream to be transmitted includes a security-sensitive portion. The security-sensitive portion of the data stream is encrypted. The data stream with the encrypted security-sensitive portion is transmitted.Type: ApplicationFiled: March 16, 2005Publication date: September 21, 2006Inventors: Gayathiri Chandran, James Pickel, Michael Springgay
-
Publication number: 20060143436Abstract: A method and system for establishing a connection between a data server and a middleware server is disclosed. The method and system include defining a plurality of trust attributes corresponding to a trusted context between the middleware server and the data server and validating the plurality of trust attributes against a plurality of attributes corresponding to the middleware server. The plurality of attributes provided in a connection request. The method and system also include establishing the trusted context based on the validating the plurality of trust attributes.Type: ApplicationFiled: December 27, 2004Publication date: June 29, 2006Inventors: Paul Bird, Gayathiri Chandran, Curt Cotner, Adrian Lobo, James Pickel, Walid Rjaibi
-
Publication number: 20060026177Abstract: A method and system of subsetting a group of server systems configures a server system with a group name and a group port, and with at least one subset name and subset port. The server system, when activated, reads its configuration and registers with a system routing entity as being part of the group name and the group port, and as being part of the subset name and the subset port. In this manner, server systems can be targeted via its subset name and subset port, while also accessible via the common name and port for the group. If the group includes a workload balancer, the server system also registers with the workload balancer using the group name and the subset name, such that workload balancing is provided for the subset.Type: ApplicationFiled: July 29, 2004Publication date: February 2, 2006Inventors: Brian Howell, James Pickel, Hugh Smith
-
Publication number: 20050144276Abstract: In a method and system for avoiding section collision for application server requests over a single database connection, the database server assigns query identifiers to each instance of the same cursor opened for the same processing level within an application, allowing multiple instances of the same cursor to be processed in parallel without section collision. The application server assigns a command source identifier to each statement sent over a single database connection to uniquely identify the application source of the statement. This applies for multiples of the same statement sent by different application sources within the same application, for a single statement containing multiple application sources, and for multiple statements from different applications multiplexed over a single database connection. These statements can be processed separately from and in parallel with the each other without section collision.Type: ApplicationFiled: December 4, 2003Publication date: June 30, 2005Inventors: Paul Bird, William Bireley, Curt Cotner, Tammie Dang, Margaret Dong, Georgia Fuller, Michelle Lam, James Pickel, Frankie Sun
-
Publication number: 20050144299Abstract: Indoubt transaction entries are recorded for each member of a database cluster, thereby avoiding the CPU cost and elapsed-time impact of persisting this information to a disk (either via a log write or a relational table I/O). This implementation allows for full read/write access and data coherency for concurrent access by all the members in the database cluster. At any given point in time, a full list of indoubt transactions is maintained for the entire database cluster in a relational table (e.g., an SQL table).Type: ApplicationFiled: December 4, 2003Publication date: June 30, 2005Inventors: Delmar Blevins, Curt Cotner, Stephen Kinder, James Pickel, Matthew Sykes, Hong Tie
-
Publication number: 20050138010Abstract: A method for generating an execution plan for updating and retrieving data from a database in a single process includes: receiving a statement by a server to update a database with a first set of data and to retrieve a second set of data from the database; building a first execution plan to update the database with the first set of data; building a second execution plan to retrieve the second set of data from the database; and building a single execution plan including a combination of the first and second execution plans. The single execution plan allows for the updating and retrieval of data with a single crossing of an interface between a client and the database. By performing both functions in this manner, the efficiency of performing such tasks on the database is significantly increased.Type: ApplicationFiled: December 22, 2003Publication date: June 23, 2005Inventors: Margaret Bernal, Karelle Cornwell, Hsuiying Cheng, Yao-Ching Chen, Christopher Crone, Fen-Ling Lin, James Pickel, Yumi Tsuji, Julie Watts
-
Publication number: 20050125410Abstract: A method and system for providing package resolution in a database system is disclosed. The method and system comprise providing a statement within a server which allows an application to identify a list of package collections. The method and system further includes executing the statement to obtain the appropriate package. A system and method in accordance with the present invention provides a new current package path value, which is set via a statement referred to as Set Current Package Path. The SET CURRENT PACKAGE PATH statement allows the application to supply a precedence list of qualified package collections during execution time, therefore the scheme for resolving packages can be changed at any point during execution. The SET CURRENT PACKAGE PATH statement improves application development by making the package resolution mechanism less error prone and less tedious for the application developer, while providing an optimal-performance solution in the client-server environment.Type: ApplicationFiled: December 4, 2003Publication date: June 9, 2005Inventors: Curt Cotner, Tammie Dang, Brian Howell, Fung Lee, Hui-An Lee, Charles Lin, Claire McFeely, Jennifer Ou, James Pickel, Jay Yothers
-
Publication number: 20050125445Abstract: A shared memory device called the Coupling Facility (CF) is used to record the indoubt transaction entries for each member of the database cluster, avoiding the CPU cost and elapsed time impact of persisting this information to disk (either via a log write or a relational table I/O). The CF provides full read/write access and data coherency for concurrent access by all the members in the database cluster. At any given point in time, the CF will contain the full list of indoubt transactions for the entire database cluster. CF duplexing is used to guarantee the integrity of the CF structure used for the indoubt list. In the event of complete loss of both CF structures (which will not happen except in major disaster situations), data sharing group restart processing can reconstruct the CF structures from the individual member logs.Type: ApplicationFiled: December 4, 2003Publication date: June 9, 2005Inventors: Curt Cotner, Brian Howell, Jeffrey Josten, James Pickel
-
Publication number: 20030145113Abstract: The present invention is directed to a method and system for connecting a client to a database managed by a network of computer systems having a plurality of database management system (DBMS) members. The method and system includes providing a shared network address for the plurality of DBMS members, which is used by the client to connect to an active DBMS member of the plurality of DBMS members.Type: ApplicationFiled: January 31, 2002Publication date: July 31, 2003Inventors: James Pickel, Shivram Ganduri
-
Patent number: D270203Type: GrantFiled: August 28, 1981Date of Patent: August 16, 1983Assignee: Liberty National Bank & Trust Co.Inventors: Randall L. Elliott, James A. Pickel
-
Patent number: D270583Type: GrantFiled: August 28, 1981Date of Patent: September 13, 1983Assignee: Liberty National Bank & Trust Co.Inventors: Randall L. Elliott, James A. Pickel