Patents by Inventor Claire W. McFeely
Claire W. McFeely 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: 10970262Abstract: In managing multiple versions of triggers, a database system creates a first version of a trigger to apply a first set of actions in response to a first triggering event. The database system also creates a second version of the trigger to apply a second set of actions to the database object in response to a second triggering event. Upon receiving a command to set the current version of the trigger to the second version, the database system sets the second version as the current version of the trigger. When the triggering event of the trigger occurs, the database system determines that the second version is the current version of the trigger, retrieves the second set of actions in the second version, and executes the second set of actions.Type: GrantFiled: November 27, 2018Date of Patent: April 6, 2021Assignee: International Business Machines CorporationInventors: Tammie Dang, Illong A. Huang, David J. Kuang, Fen-Ling Lin, Claire W. McFeely, Maryela E. Weihrauch, Binghui Zhong
-
Patent number: 10901854Abstract: In supporting temporal logical transactions, a database management system (DBMS) determines that a temporal logical transaction time (T) is set for a temporal logical transaction. The DBMS receives a change request for a current row in a current table. A history row for a history table corresponding to the current table is created. The values in the history row are set to the values in the current row, where a begin time in the history row has same value as a begin time in the current row, and an end time in the history row is set to T. When the begin time equals the end time in the history row, the DBMS does not store the history row in the history table. The values in the current row are changed according to the change request, and the begin time in the current row is set to T.Type: GrantFiled: September 8, 2017Date of Patent: January 26, 2021Assignee: International Business Machines CorporationInventors: Yao-Ching S. Chen, Xiaohong Fu, Fung Lee, Claire W. McFeely, Maryela E. Weihrauch
-
Patent number: 10896096Abstract: In supporting temporal logical transactions, a database management system (DBMS) determines that a temporal logical transaction time (T) is set for a temporal logical transaction. The DBMS receives a change request for a current row in a current table. A history row for a history table corresponding to the current table is created. The values in the history row are set to the values in the current row, where a begin time in the history row has same value as a begin time in the current row, and an end time in the history row is set to T. When the begin time equals the end time in the history row, the DBMS does not store the history row in the history table. The values in the current row are changed according to the change request, and the begin time in the current row is set to T.Type: GrantFiled: April 21, 2016Date of Patent: January 19, 2021Assignee: International Business Machines CorporationInventors: Yao-Ching S. Chen, Xiaohong Fu, Fung Lee, Claire W. McFeely, Maryela E. Weihrauch
-
Publication number: 20190095386Abstract: In managing multiple versions of triggers, a database system creates a first version of a trigger to apply a first set of actions in response to a first triggering event. The database system also creates a second version of the trigger to apply a second set of actions to the database object in response to a second triggering event. Upon receiving a command to set the current version of the trigger to the second version, the database system sets the second version as the current version of the trigger. When the triggering event of the trigger occurs, the database system determines that the second version is the current version of the trigger, retrieves the second set of actions in the second version, and executes the second set of actions.Type: ApplicationFiled: November 27, 2018Publication date: March 28, 2019Inventors: Tammie DANG, Illong A. HUANG, David J. KUANG, Fen-Ling LIN, Claire W. MCFEELY, Maryela E. WEIHRAUCH, Binghui ZHONG
-
Patent number: 10216774Abstract: In managing multiple versions of triggers, a database system creates a first version of a trigger to apply a first set of actions in response to a first triggering event, which includes: creating a first package for the first version of the trigger to include the first set of actions; linking the first package to the database object; and setting the first package as a current version of the trigger. The database system creates a second version of the trigger to apply a second set of actions to the database object in response to a second triggering event, which includes: creating a second package for the second version of the trigger to include the second set of actions; and linking the second package to the database object. In response to a command, the database system sets the current version of the trigger to the second package.Type: GrantFiled: June 24, 2016Date of Patent: February 26, 2019Assignee: International Business Machines CorporationInventors: Tammie Dang, Illong A. Huang, David J. Kuang, Fen-Ling Lin, Claire W. McFeely, Maryela E. Weihrauch, Binghui Zhong
-
Publication number: 20170371905Abstract: In managing multiple versions of triggers, a database system creates a first version of a trigger to apply a first set of actions in response to a first triggering event, which includes: creating a first package for the first version of the trigger to include the first set of actions; linking the first package to the database object; and setting the first package as a current version of the trigger. The database system creates a second version of the trigger to apply a second set of actions to the database object in response to a second triggering event, which includes: creating a second package for the second version of the trigger to include the second set of actions; and linking the second package to the database object. In response to a command, the database system sets the current version of the trigger to the second package.Type: ApplicationFiled: June 24, 2016Publication date: December 28, 2017Inventors: Tammie DANG, Illong A. HUANG, David J. KUANG, Fen-Ling LIN, Claire W. MCFEELY, Maryela E. WEIHRAUCH, Binghui ZHONG
-
Publication number: 20170371911Abstract: In supporting temporal logical transactions, a database management system (DBMS) determines that a temporal logical transaction time (T) is set for a temporal logical transaction. The DBMS receives a change request for a current row in a current table. A history row for a history table corresponding to the current table is created. The values in the history row are set to the values in the current row, where a begin time in the history row has same value as a begin time in the current row, and an end time in the history row is set to T. When the begin time equals the end time in the history row, the DBMS does not store the history row in the history table. The values in the current row are changed according to the change request, and the begin time in the current row is set to T.Type: ApplicationFiled: September 8, 2017Publication date: December 28, 2017Inventors: Yao-Ching S. CHEN, Xiaohong FU, Fung LEE, Claire W. MCFEELY, Maryela E. WEIHRAUCH
-
Publication number: 20170308563Abstract: In supporting temporal logical transactions, a database management system (DBMS) determines that a temporal logical transaction time (T) is set for a temporal logical transaction. The DBMS receives a change request for a current row in a current table. A history row for a history table corresponding to the current table is created. The values in the history row are set to the values in the current row, where a begin time in the history row has same value as a begin time in the current row, and an end time in the history row is set to T. When the begin time equals the end time in the history row, the DBMS does not store the history row in the history table. The values in the current row are changed according to the change request, and the begin time in the current row is set to T.Type: ApplicationFiled: April 21, 2016Publication date: October 26, 2017Inventors: Yao-Ching S. CHEN, Xiaohong FU, Fung LEE, Claire W. MCFEELY, Maryela E. WEIHRAUCH
-
Patent number: 8983985Abstract: Access to a data element stored within a database object is controlled. A request is received from a user to perform an operation in relation to the database object, the operation including retrieval of information from the data element of the database object. Prior to retrieving information from the data element, a determination is made whether at least a portion of the information from the data element is subject to masking in accordance with an access policy. In response to determining that information from the data element is subject to masking, the request is modified to require that information from the data element be retrieved in a masked condition.Type: GrantFiled: January 28, 2011Date of Patent: March 17, 2015Assignee: International Business Machines CorporationInventors: Stephen Yao Ching Chen, Curt L. Cotner, Gerald G. Kiernan, Irene Ching-Hua Liu, Claire W. McFeely, Walid Rjaibi, Timothy J. Vincent
-
Publication number: 20120197919Abstract: Access to a data element stored within a database object is controlled. A request is received from a user to perform an operation in relation to the database object, the operation including retrieval of information from the data element of the database object. Prior to retrieving information from the data element, a determination is made whether at least a portion of the information from the data element is subject to masking in accordance with an access policy. In response to determining that information from the data element is subject to masking, the request is modified to require that information from the data element be retrieved in a masked condition.Type: ApplicationFiled: January 28, 2011Publication date: August 2, 2012Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Stephen Yao Ching Chen, Curt L. Cotner, Gerald G. Kiernan, Irene Ching-Hua Liu, Claire W. McFeely, Walid Rjaibi, Timothy J. Vincent
-
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