Patents by Inventor James Willis Pickel
James Willis 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).
-
Patent number: 11475020Abstract: One embodiment provides a method, including: receiving, from a user, a dataset for encryption before its storage at a data storage location, wherein the dataset comprises a plurality of portions; identifying (i) attributes of the dataset and (ii) dataset dependencies; generating a recommendation for an encryption scheme to be used for the dataset, wherein the generating comprises (i) generating, based upon the attributes and the dataset dependencies, a recommendation of an encryption scheme for each portion of the dataset and (ii) identifying, based upon the dataset dependencies, a key label for each portion of the dataset, wherein the key label identified for a portion of the dataset that is dependent on another portion of the dataset is the same as the key label identified for said another portion of the dataset; and providing, to the user, (i) the generated recommendation and (ii) a description identifying reasons for the generated recommendation.Type: GrantFiled: June 6, 2019Date of Patent: October 18, 2022Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Manish Kesarwani, Akshar Kaul, Gagandeep Singh, Sameep Mehta, Hong Min, James Willis Pickel
-
Publication number: 20200387518Abstract: One embodiment provides a method, including: receiving, from a user, a dataset for encryption before its storage at a data storage location, wherein the dataset comprises a plurality of portions; identifying (i) attributes of the dataset and (ii) dataset dependencies; generating a recommendation for an encryption scheme to be used for the dataset, wherein the generating comprises (i) generating, based upon the attributes and the dataset dependencies, a recommendation of an encryption scheme for each portion of the dataset and (ii) identifying, based upon the dataset dependencies, a key label for each portion of the dataset, wherein the key label identified for a portion of the dataset that is dependent on another portion of the dataset is the same as the key label identified for said another portion of the dataset; and providing, to the user, (i) the generated recommendation and (ii) a description identifying reasons for the generated recommendation.Type: ApplicationFiled: June 6, 2019Publication date: December 10, 2020Inventors: Manish Kesarwani, Akshar Kaul, Gagandeep Singh, Sameep Mehta, Hong Min, James Willis Pickel
-
Patent number: 7743036Abstract: 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: GrantFiled: June 19, 2007Date of Patent: June 22, 2010Assignee: International Business Machines CorporationInventors: Curt Lee Cotner, Brian K. Howell, Jeffrey William Josten, James Willis Pickel
-
Patent number: 7711746Abstract: 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: GrantFiled: December 17, 2005Date of Patent: May 4, 2010Assignee: International Business Machines CorporationInventors: Margaret Ann Bernal, Yao-Ching Stephen Chen, Ding-Wei Chieh, Curt Lee Cotner, Baoqiu Cui, Tammie Dang, Marion B. Farber, Georgia Carroll Fuller, Joe Cheng-yu Huang, Hui-An Lee, Claire Willey McFeely, Chunfeng Pei, James Willis Pickel, Yumi Kimura Tsuji, Jay A. Yothers, Margaret Alice Zagelow, Liyan Zhou
-
Patent number: 7260589Abstract: 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: GrantFiled: December 4, 2003Date of Patent: August 21, 2007Assignee: International Business Machines CorporationInventors: Curt Lee Cotner, Brian K. Howell, Jeffrey William Josten, James Willis Pickel
-
Patent number: 7136847Abstract: Aspects for dynamically changing attributes in an embedded-SQL application are described. In these aspects, an option is provided within a standard SQL statement for specifying one or more attributes of at least a declared cursor. The standard SQL statement is then processed to include the specified one or more attributes in at least the declared cursor. The provision occurs with an ATTRIBUTES option and within a PREPARE SQL statement.Type: GrantFiled: August 31, 2001Date of Patent: November 14, 2006Assignee: International Business Machines CorporationInventors: Tammie Dang, William Robert Bireley, Curt Lee Cotner, Claire Willey McFeely, James Willis Pickel, Koichi Yamaguchi
-
Publication number: 20030055821Abstract: Aspects for dynamically changing attributes in an embedded-SQL application are described. In these aspects, an option is provided within a standard SQL statement for specifying one or more attributes of at least a declared cursor. The standard SQL statement is then processed to include the specified one or more attributes in at least the declared cursor. The provision occurs with an ATTRIBUTES option and within a PREPARE SQL statement.Type: ApplicationFiled: August 31, 2001Publication date: March 20, 2003Inventors: Tammie Dang, William Robert Bireley, Curt Lee Cotner, Claire Willey McFeely, James Willis Pickel, Koichi Yamaguchi
-
Patent number: 6247055Abstract: A client connected to a multi-server system, (e.g., a parallel database management system) can locate a server product that may have moved to a different network address within the multi-server system. For example, a client is able to perform two-phase commit and automatic resynchronization with a same DBMS server that may have moved to a new network address before a transaction was committed. A unique resync port number is assigned to each server member when the server member is started up. The server's physical IP address and resync number are stored in a list in a global area accessible by each server member. When a client establishes a connection to a server member, the client will receive the server member's resync number or the global list. The client records the server's unique resync number in the client's dataset.Type: GrantFiled: July 2, 1998Date of Patent: June 12, 2001Assignee: International Business Machines CorporationInventors: Curt Lee Cotner, James Willis Pickel
-
Patent number: 6031978Abstract: The system, method and program of this invention provides a technique that enables a client, connected by a network, such as TCP/IP, to a multi-server system, such as a parallel database management system, to locate a server product that may have moved to a different network address within the multi-server system. More specifically, the client is able to perform two-phase commit and automatic resynchronization with a same DBMS server that may have moved to a new network address before a transaction with the client was committed. In order to complete the two-phase resynchronization process for uncompleted units of work, the client system has to reestablish connection to the previously connected DBMS member.Type: GrantFiled: June 28, 1996Date of Patent: February 29, 2000Assignee: International Business Machines CorporationInventors: Curt Lee Cotner, James Willis Pickel
-
Patent number: 5884327Abstract: The system, method, and program of this invention allows a two-phase commit protocol to work properly, even when the client acting as the coordinator does not have a log to record two-phase state information. In a preferred embodiment, the client in a client/server distributed transaction processing system is a personal computer. The client, without a recovery log, acts as a coordinator of a commit process. The coordinator migrates, i.e., passes, responsibility for resynchronization, and any associated logging requirement, to a server, e.g., to any of the connected relational database management system (RDBMS) servers, which is a participant in the transaction. The server uses its own recovery log for use in satisfying the logging requirement.Type: GrantFiled: September 25, 1996Date of Patent: March 16, 1999Assignee: International Business Machines CorporationInventors: Curt Lee Cotner, Richard Anthony Crus, Brian Keith Howell, James Willis Pickel, David Joseph Wisneski