Patents by Inventor Jay Yothers
Jay Yothers 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: 9910869Abstract: Dropping of columns from a table with data availability, where the columns in the table are each associated with a column number, includes: executing a statement to drop a given column in the table and deferring an application of the statement until a reorganization of a current data set including the table. When the reorganization of the current data set is performed, the reorganization includes: updating column numbers for columns in each row of the table using a mapping data structure to remove the given column; loading the plurality of data rows with the updated column numbers into a shadow data set; applying to the shadow data set any changes to the table that are concurrent with the reorganization; updating a schema definition of the table with the updated column numbers; and switching the current data set to the shadow data set.Type: GrantFiled: November 28, 2014Date of Patent: March 6, 2018Assignee: International Business Machines CorporationInventors: Craig A. Friske, Charles H. Lin, Regina J. Liu, Jerry Mukai, Kalpana Shyam, Cherri Vidmar, Julie A. Watts, Jay A. Yothers, Binghui Zhong
-
Patent number: 9317543Abstract: Dropping of columns from a table with data availability, where the columns in the table are each associated with a column number, includes: executing a statement to drop a given column in the table and deferring an application of the statement until a reorganization of a current data set including the table. When the reorganization of the current data set is performed, the reorganization includes: updating column numbers for columns in each row of the table using a mapping data structure to remove the given column; loading the plurality of data rows with the updated column numbers into a shadow data set; applying to the shadow data set any changes to the table that are concurrent with the reorganization; updating a schema definition of the table with the updated column numbers; and switching the current data set to the shadow data set.Type: GrantFiled: January 13, 2014Date of Patent: April 19, 2016Assignee: International Business Machines CorporationInventors: Craig A. Friske, Charles H. Lin, Regina J. Liu, Jerry Mukai, Kalpana Shyam, Cherri Vidmar, Julie A. Watts, Jay A. Yothers, Binghui Zhong
-
Publication number: 20150199325Abstract: Dropping of columns from a table with data availability, where the columns in the table are each associated with a column number, includes: executing a statement to drop a given column in the table and deferring an application of the statement until a reorganization of a current data set including the table. When the reorganization of the current data set is performed, the reorganization includes: updating column numbers for columns in each row of the table using a mapping data structure to remove the given column; loading the plurality of data rows with the updated column numbers into a shadow data set; applying to the shadow data set any changes to the table that are concurrent with the reorganization; updating a schema definition of the table with the updated column numbers; and switching the current data set to the shadow data set.Type: ApplicationFiled: November 28, 2014Publication date: July 16, 2015Inventors: Craig A. FRISKE, Charles H. LIN, Regina J. LIU, Jerry MUKAI, Kalpana SHYAM, Cherri VIDMAR, Julie A. WATTS, Jay A. YOTHERS, Binghui ZHONG
-
Publication number: 20150199393Abstract: Dropping of columns from a table with data availability, where the columns in the table are each associated with a column number, includes: executing a statement to drop a given column in the table and deferring an application of the statement until a reorganization of a current data set including the table. When the reorganization of the current data set is performed, the reorganization includes: updating column numbers for columns in each row of the table using a mapping data structure to remove the given column; loading the plurality of data rows with the updated column numbers into a shadow data set; applying to the shadow data set any changes to the table that are concurrent with the reorganization; updating a schema definition of the table with the updated column numbers; and switching the current data set to the shadow data set.Type: ApplicationFiled: January 13, 2014Publication date: July 16, 2015Applicant: International Business Machines CorporationInventors: Craig A. FRISKE, Charles H. LIN, Regina J. LIU, Jerry MUKAI, Kalpana SHYAM, Cherri VIDMAR, Julie A. WATTS, Jay A. YOTHERS, Binghui ZHONG
-
Patent number: 8306978Abstract: Provided is a method for online reorganization and increasing the page size of a DB2 object. A base table and related auxiliary table spaces are reorganized concurrently via a database utility, DB2 REORG utility. The database utility determines which auxiliary tables are related to the base table and automatically includes their respective auxiliary table in the same invocation of the utility. The reorganization is performed via allocated shadow data sets; page size of the allocated shadow data sets is dynamically updated during reorganization. The original data sets are switched with the newly built shadow data sets, and DB2 catalog values and control blocks are updated with new page size values.Type: GrantFiled: July 11, 2008Date of Patent: November 6, 2012Assignee: International Business Machines CorporationInventors: Frank Darl Bower, Roy J. Comford, Karelle Lynne Cornwell, William James Franklin, Saiyin Leung, John Richard Lyle, James Zu-Chia Teng, Jay A Yothers
-
Patent number: 7899797Abstract: 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: GrantFiled: December 4, 2003Date of Patent: March 1, 2011Assignee: International Business Machines CorporationInventors: Curt L. Cotner, Tammie Dang, Brian K. Howell, Fung Lee, Hui-An Lee, Charles H. Lin, Claire W. McFeely, Jennifer W. Ou, James W. Pickel, Jay A. Yothers
-
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: 7580958Abstract: Techniques are provided for supporting versions of a routine. A first version of the routine is created. A second version of the routine is generated in response to receiving an alter statement including an add version clause. The second version of the routine is activated in response to receiving an alter statement including an activate version clause.Type: GrantFiled: June 17, 2005Date of Patent: August 25, 2009Assignee: International Business Machines CorporationInventors: Yao-Ching Stephen Chen, Curt Lee Cotner, Baoqiu Cui, Tammie Dang, Joe Cheng-yu Huang, Claire Willey McFeely, Robert Thomas Miller, Manogari Nogi Simanjuntak, Yumi Kimura Tsuji, Xiaoyu Yang, Jay A. Yothers, Margaret Alice Zagelow
-
Patent number: 7447717Abstract: Provided is a method for online reorganization and increasing the page size of a DB2 object. A base table and related auxiliary table spaces are reorganized concurrently via a database utility, DB2 REORG utility. The database utility determines which auxiliary tables are related to the base table and automatically includes their respective auxiliary table in the same invocation of the utility. The reorganization is performed via allocated shadow data sets; page size of the allocated shadow data sets is dynamically updated during reorganization. The original data sets are switched with the newly built shadow data sets, and DB2 catalog values and control blocks are updated with new page size values.Type: GrantFiled: October 7, 2004Date of Patent: November 4, 2008Assignee: International Business Machines CorporationInventors: Frank Darl Bower, Roy James Cornford, Karelle Lynne Cornwell, William James Franklin, Saiyin Leung, John Richard Lyle, James Zu-Chia Teng, Jay A. Yothers
-
Publication number: 20080270492Abstract: Provided is a method for online reorganization and increasing the page size of a DB2 object. A base table and related auxiliary table spaces are reorganized concurrently via a database utility, DB2 REORG utility. The database utility determines which auxiliary tables are related to the base table and automatically includes their respective auxiliary table in the same invocation of the utility. The reorganization is performed via allocated shadow data sets; page size of the allocated shadow data sets is dynamically updated during reorganization. The original data sets are switched with the newly built shadow data sets, and DB2 catalog values and control blocks are updated with new page size values.Type: ApplicationFiled: July 11, 2008Publication date: October 30, 2008Applicant: International Business Machines CorporationInventors: FRANK DARL BOWER, Roy J. Cornford, Karelle Lynne Cornwell, William James Franklin, Saiyin Leung, John Richard Lyle, James Zu-Chia Teng, Jay A. Yothers
-
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: 20070118574Abstract: Provided are a techniques for reorganizing data. Data is retrieved from an original data set and inserted into a shadow data set. A log record is read from an update log, wherein the log record includes a unique key identifying a data object and an indication of an activity associated with that data object. The activity associated with the data object is performed by determining whether the unique key is found in a shadow index for the shadow data set.Type: ApplicationFiled: November 22, 2005Publication date: May 24, 2007Inventors: William Franklin, Haakon Roberts, James Teng, Jay Yothers
-
Publication number: 20070055644Abstract: A method and system for using a procedure residing and executed entirely within a database system is disclosed. The procedure utilizes at least one variable, which has a plurality of attributes. The method and system include defining the at least one variable as at least one global variable prior to calling of the procedure. Defining the global variable(s) includes informing the database system of the plurality of attributes of the variable(s) and allowing the database system access to the at least one variable. The method and system also include tracking the global variable(s).Type: ApplicationFiled: September 8, 2005Publication date: March 8, 2007Applicant: International Business Machines CorporationInventors: Margaret Bernal, Yao-Ching Chen, Ding-Wei Chieh, Christopher Crone, Baoqiu Cui, Tammie Dang, Marion Farber, Fen-Ling Lin, Chunfeng Pei, Yumi Tsuji, Jay Yothers, Liyan Zhou
-
Patent number: 7181481Abstract: A base table and related auxiliary table spaces are reorganized concurrently via a database utility. The database utility determines which auxiliary tables are related to the base table and automatically includes their respective auxiliary table in the same invocation of the utility. The reorganization is performed via allocated shadow data sets. The original data sets are switched with the newly built shadow data sets including the LOB shadows.Type: GrantFiled: October 20, 2003Date of Patent: February 20, 2007Assignee: International Business Machines CorporationInventors: Julie Chen, William James Franklin, John Marland Garth, Li-Mey Lee, John Richard Lyle, Frances Hwa Villafuerte, Jay A. Yothers
-
Publication number: 20060288052Abstract: Techniques are provided for supporting versions of a routine. A first version of the routine is created. A second version of the routine is generated in response to receiving an alter statement including an add version clause. The second version of the routine is activated in response to receiving an alter statement including an activate version clause.Type: ApplicationFiled: June 17, 2005Publication date: December 21, 2006Inventors: Yao-Ching Chen, Curt Cotner, Baoqiu Cui, Tammie Dang, Joe Huang, Claire McFeely, Robert Miller, Manogari Simanjuntak, Yumi Tsuji, Xiaoyu Yang, Jay Yothers, Margaret Zagelow
-
Publication number: 20060080324Abstract: Provided is a method for online reorganization and increasing the page size of a DB2 object. A base table and related auxiliary table spaces are reorganized concurrently via a database utility, DB2 REORG utility. The database utility determines which auxiliary tables are related to the base table and automatically includes their respective auxiliary table in the same invocation of the utility. The reorganization is performed via allocated shadow data sets; page size of the allocated shadow data sets is dynamically updated during reorganization. The original data sets are switched with the newly built shadow data sets, and DB2 catalog values and control blocks are updated with new page size values.Type: ApplicationFiled: October 7, 2004Publication date: April 13, 2006Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Frank Bower, Roy Cornford, Karelle Cornwell, William Franklin, Saiyin Leung, John Lyle, James Teng, Jay Yothers
-
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
-
Patent number: 6886012Abstract: Traditional update semantics are provided when updates change the location of records in a database. The system detects that an update to a record will cause the record to change locations in a database from an original location to an updated location. The system selectively prevents activity in the database between the original location and update location until the updated record has changed locations in the database from the original location to the updated location.Type: GrantFiled: November 18, 1998Date of Patent: April 26, 2005Assignee: International Business Machines CorporationInventors: San Yu Phoenix, Kalpana Shyam, James Zu-Chia Teng, Julie Ann Watts, Jay A. Yothers
-
Publication number: 20050086269Abstract: A base table and related auxiliary table spaces are reorganized concurrently via a database utility. The database utility determines which auxiliary tables are related to the base table and automatically includes their respective auxiliary table in the same invocation of the utility. The reorganization is performed via allocated shadow data sets. The original data sets are switched with the newly built shadow data sets including the LOB shadows.Type: ApplicationFiled: October 20, 2003Publication date: April 21, 2005Inventors: Julie Chen, William Franklin, John Garth, Li-Mey Lee, John Lyle, Frances Villafuerte, Jay Yothers
-
Patent number: 6694340Abstract: A method, apparatus, and article of manufacture for identifying read claims in a database. In accordance with the present invention, the database is stored on at least one data storage device connected to a computer. A read identifier is stored for each reading transaction. The read identifier reflects a time at which the reading transaction first accesses an object stored in the database. The read identifiers are used to determine an age of an oldest active transaction.Type: GrantFiled: May 28, 1999Date of Patent: February 17, 2004Assignee: International Business Machines CorporationInventors: Robert William Lyle, James Zu-Chia Teng, Jay A. Yothers