Patents by Inventor Tammie Dang
Tammie Dang 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: 10380104Abstract: A database system searches for any statements that satisfy one or more of a set of filtering criteria. When a given dynamic query statement fully satisfies the set of filtering criteria, the given statement is stabilized by persistently storing a bound form of the given dynamic query statement. When the given dynamic query statement partly satisfies the set of filtering criteria, a monitoring request is created with the set of filtering criteria to begin monitoring subsequent executions of the statement, and the statement is linked to the monitoring request. When the given dynamic query statement subsequently fully satisfies the set of filtering criteria, the statement is stabilized by persistently storing the bound form of the statement. When the given dynamic query is re-executed, the stabilized statement is loaded, and the PREPARE process is bypassed.Type: GrantFiled: August 9, 2016Date of Patent: August 13, 2019Assignee: International Business Machines CorporationInventors: Patrick D. Bossman, Frank D. Bower, Tammie Dang, Peter Kuang, Euna Park, 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: 20180046677Abstract: A database system searches for any statements that satisfy one or more of a set of filtering criteria. When a given dynamic query statement fully satisfies the set of filtering criteria, the given statement is stabilized by persistently storing a bound form of the given dynamic query statement. When the given dynamic query statement partly satisfies the set of filtering criteria, a monitoring request is created with the set of filtering criteria to begin monitoring subsequent executions of the statement, and the statement is linked to the monitoring request. When the given dynamic query statement subsequently fully satisfies the set of filtering criteria, the statement is stabilized by persistently storing the bound form of the statement. When the given dynamic query is re-executed, the stabilized statement is loaded, and the PREPARE process is bypassed.Type: ApplicationFiled: August 9, 2016Publication date: February 15, 2018Inventors: Patrick D. BOSSMAN, Frank D. BOWER, Tammie DANG, Peter KUANG, Euna PARK, Maryela E. WEIHRAUCH
-
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
-
Patent number: 9348867Abstract: An approach for using multiple plans in a database management system to access current data and history data is provided. The approach provides a first access plan for a query, stores the first plan as a first section in an application package. The first access plan is capable of accessing the current data. The approach determines whether a bind option for the query is detected. In response to determining that the bind option is detected, the approach provides a second access plan for the query and stores the second access plan as a second section in the application package. The second access plan is capable of accessing the current data and the history data.Type: GrantFiled: February 13, 2014Date of Patent: May 24, 2016Assignee: International Business Machines CorporationInventors: Frank Chan, Yao-Ching S. Chen, Tammie Dang, Xiaohong Fu
-
Publication number: 20150227560Abstract: An approach for using multiple plans in a database management system to access current data and history data is provided. The approach provides a first access plan for a query, stores the first plan as a first section in an application package. The first access plan is capable of accessing the current data. The approach determines whether a bind option for the query is detected. In response to determining that the bind option is detected, the approach provides a second access plan for the query and stores the second access plan as a second section in the application package. The second access plan is capable of accessing the current data and the history data.Type: ApplicationFiled: February 13, 2014Publication date: August 13, 2015Applicant: International Business Machines CorporationInventors: Frank Chan, Yao-Ching S. Chen, Tammie Dang, Xiaohong Fu
-
Patent number: 7933948Abstract: In a 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: GrantFiled: June 30, 2008Date of Patent: April 26, 2011Assignee: International Business Machines CorporationInventors: Paul M. Bird, William R. Bireley, Curt L. Cotner, Tammie Dang, Margaret A. Dong, Georgia C. Fuller, Michelle D. Lam, James W. Pickel, Frankie K. Sun
-
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
-
Publication number: 20080270609Abstract: In a 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: June 30, 2008Publication date: October 30, 2008Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Paul M. Bird, William R. Bireley, Curt L. Cotner, Tammie Dang, Margaret A. Dong, Georgia C. Fuller, Michelle D. Lam, James W. Pickel, Frankie K. Sun
-
Patent number: 7433950Abstract: In a method 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: GrantFiled: December 4, 2003Date of Patent: October 7, 2008Assignee: International Business Machines CorporationInventors: Paul M. Bird, William R. Bireley, Curt L. Cotner, Tammie Dang, Margaret A. Dong, Georgia C. Fuller, Michelle D. Lam, James W. Pickel, Frankie K. Sun
-
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: 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
-
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
-
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: 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: 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