Patents by Inventor Yongfeng Yao
Yongfeng Yao 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: 11963534Abstract: An application of fengycin family lipopeptides in pest control is provided, and Fengycin family lipopeptides are used for pest control, with especially strong killing effects on Homoptera and Coleoptera pests. A method is provided for treating seeds with fengycin to protect seeds and plant organs formed later from pests, so as to protect seeds from pests by coating the fengycin family lipopeptides on the surface of seeds.Type: GrantFiled: November 18, 2022Date of Patent: April 23, 2024Assignee: INSTITUTE OF BIOLOGY, HEBEI ACADEMY OF SCIENCESInventors: Hongwei Liu, Caimiao Yao, Yongfeng Liu, Liping Zhang, Yana Wang, Wenya Zhao
-
Patent number: 11360998Abstract: A computer-implemented method for operating a database management system which includes a source database and a target database. A database management system is configured for asynchronously replicating data changes of the source database to the target database. The database management system receiving a request to perform a database statement. The method can identify the most recently committed one of a plurality of transactions having been committed in the source database before the receiving of the request. Identifying repeatedly the one of the plurality of transactions having been replicated most recently to the target database. Execution of the requested statement in the target database is delayed until an evaluation of the repeatedly identified most recently replicated transaction returns that the identified most recently committed transaction has been replicated to the target database. After the delaying execution, the method executes the requested statement in the target database.Type: GrantFiled: March 26, 2019Date of Patent: June 14, 2022Assignee: International Business Machines CorporationInventors: Namik Hrle, Daniel Martin, Chandrasekaran Mohan, James D. Spyker, Yongfeng Yao
-
Patent number: 11263235Abstract: A computer-implemented method for operating a database management system which includes a source database and a target database. A database management system is configured for asynchronously replicating data changes of the source database to the target database. The database management system receiving a request to perform a database statement. The method can identify the most recently committed one of a plurality of transactions having been committed in the source database before the receiving of the request. Identifying repeatedly the one of the plurality of transactions having been replicated most recently to the target database. Execution of the requested statement in the target database is delayed until an evaluation of the repeatedly identified most recently replicated transaction returns that the identified most recently committed transaction has been replicated to the target database. After the delaying execution, the method executes the requested statement in the target database.Type: GrantFiled: March 26, 2019Date of Patent: March 1, 2022Assignee: International Business Machines CorporationInventors: Namik Hrle, Daniel Martin, Chandrasekaran Mohan, James D. Spyker, Yongfeng Yao
-
Patent number: 10366105Abstract: A processor-implemented method for replicating structured query language (SQL) in a heterogeneous replication environment is provided. The method includes receiving a first statement for a multi-row operation, whereby the multi-row operation is directed to one or more tables of a database, and whereby the first statement includes a text of a SQL statement in a DBMS transaction log. The method also provides for evaluating whether to create a source tree structure from the received first statement. In response to creating the source tree structure, the method evaluates whether the source tree structure is transformable. The method transforms the source tree structure to a target tree structure in response to evaluating that the source tree structure is transformable.Type: GrantFiled: May 5, 2017Date of Patent: July 30, 2019Assignee: International Business Machines CorporationInventors: James D. Spyker, Victor L. Szabo, Yongfeng Yao
-
Patent number: 10360236Abstract: A processor-implemented method for replicating structured query language (SQL) in a heterogeneous replication environment is provided. The method includes receiving a first statement for a multi-row operation, whereby the multi-row operation is directed to one or more tables of a database, and whereby the first statement includes a text of a SQL statement in a DBMS transaction log. The method also provides for evaluating whether to create a source tree structure from the received first statement. In response to creating the source tree structure, the method evaluates whether the source tree structure is transformable. The method transforms the source tree structure to a target tree structure in response to evaluating that the source tree structure is transformable.Type: GrantFiled: September 25, 2015Date of Patent: July 23, 2019Assignee: International Business Machines CorporationInventors: James D. Spyker, Victor L. Szabo, Yongfeng Yao
-
Publication number: 20190220468Abstract: A computer-implemented method for operating a database management system which includes a source database and a target database. A database management system is configured for asynchronously replicating data changes of the source database to the target database. The database management system receiving a request to perform a database statement. The method can identify the most recently committed one of a plurality of transactions having been committed in the source database before the receiving of the request. Identifying repeatedly the one of the plurality of transactions having been replicated most recently to the target database. Execution of the requested statement in the target database is delayed until an evaluation of the repeatedly identified most recently replicated transaction returns that the identified most recently committed transaction has been replicated to the target database. After the delaying execution, the method executes the requested statement in the target database.Type: ApplicationFiled: March 26, 2019Publication date: July 18, 2019Inventors: Namik Hrle, Daniel Martin, Chandrasekaran Mohan, James D. Spyker, Yongfeng Yao
-
Publication number: 20190220467Abstract: A computer-implemented method for operating a database management system which includes a source database and a target database. A database management system is configured for asynchronously replicating data changes of the source database to the target database. The database management system receiving a request to perform a database statement. The method can identify the most recently committed one of a plurality of transactions having been committed in the source database before the receiving of the request. Identifying repeatedly the one of the plurality of transactions having been replicated most recently to the target database. Execution of the requested statement in the target database is delayed until an evaluation of the repeatedly identified most recently replicated transaction returns that the identified most recently committed transaction has been replicated to the target database. After the delaying execution, the method executes the requested statement in the target database.Type: ApplicationFiled: March 26, 2019Publication date: July 18, 2019Inventors: Namik Hrle, Daniel Martin, Chandrasekaran Mohan, James D. Spyker, Yongfeng Yao
-
Patent number: 10282363Abstract: A computer-implemented method for operating a database management system which includes a source database and a target database. A database management system is configured for asynchronously replicating data changes of the source database to the target database. The database management system receiving a request to perform a database statement. The method can identify the most recently committed one of a plurality of transactions having been committed in the source database before the receiving of the request. Identifying repeatedly the one of the plurality of transactions having been replicated most recently to the target database. Execution of the requested statement in the target database is delayed until an evaluation of the repeatedly identified most recently replicated transaction returns that the identified most recently committed transaction has been replicated to the target database. After the delaying execution, the method executes the requested statement in the target database.Type: GrantFiled: September 18, 2015Date of Patent: May 7, 2019Assignee: International Business Machines CorporationInventors: Namik Hrle, Daniel Martin, Chandrasekaran Mohan, James D. Spyker, Yongfeng Yao
-
Patent number: 10261862Abstract: According to an aspect, a database management system (DBMS) is operated to perform data replication. The DBMS includes a source database and a target database. The source database includes a plurality of first tables respectively comprising one or more first columns, and the target database includes a plurality of second tables respectively comprising one or more second columns. Each of multiple ones of the first columns is mapped to one of the second columns, and each one of the second columns is adapted to store replicated data changes of the first column mapped to the second column. Each of the second columns has an assigned update time, the update time being a moment in time when the second column most recently received incremental data changes from its mapped first column. The DBMS operates to process requested database statements while providing data replication.Type: GrantFiled: November 22, 2017Date of Patent: April 16, 2019Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Namik Hrle, Daniel Martin, Chandrasekaran Mohan, Sunil K. Sarin, James D. Spyker, Yongfeng Yao
-
Publication number: 20180095829Abstract: According to an aspect, a database management system (DBMS) is operated to perform data replication. The DBMS includes a source database and a target database. The source database includes a plurality of first tables respectively comprising one or more first columns, and the target database includes a plurality of second tables respectively comprising one or more second columns. Each of multiple ones of the first columns is mapped to one of the second columns, and each one of the second columns is adapted to store replicated data changes of the first column mapped to the second column. Each of the second columns has an assigned update time, the update time being a moment in time when the second column most recently received incremental data changes from its mapped first column. The DBMS operates to process requested database statements while providing data replication.Type: ApplicationFiled: November 22, 2017Publication date: April 5, 2018Inventors: Namik Hrle, Daniel Martin, Chandrasekaran Mohan, Sunil K. Sarin, James D. Spyker, Yongfeng Yao
-
Patent number: 9886347Abstract: According to an aspect, a database management system (DBMS) is operated to perform data replication. The DBMS includes a source database and a target database. The source database includes a plurality of first tables respectively comprising one or more first columns, and the target database includes a plurality of second tables respectively comprising one or more second columns. Each of multiple ones of the first columns is mapped to one of the second columns, and each one of the second columns is adapted to store replicated data changes of the first column mapped to the second column. Each of the second columns has an assigned update time, the update time being a moment in time when the second column most recently received incremental data changes from its mapped first column. The DBMS operates to process requested database statements while providing data replication.Type: GrantFiled: January 8, 2015Date of Patent: February 6, 2018Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Namik Hrle, Daniel Martin, Chandrasekaran Mohan, Sunil K. Sarin, James D. Spyker, Yongfeng Yao
-
Patent number: 9817879Abstract: Embodiments of the present invention provide, systems, methods, and computer program products for asynchronously replicating data from source tables of a source computer system to target tables of a target computer system. Embodiments of the present invention implement an external buffer table (EBT) from which changed data statements can be selectively applied to target tables, which can reduce the number of statements applied to the target tables of the target computer system.Type: GrantFiled: December 18, 2014Date of Patent: November 14, 2017Assignee: International Business Machines CorporationInventors: Daniel Martin, Christopher R. G. O'Quinn, James D. Spyker, Yongfeng Yao
-
Patent number: 9811577Abstract: Embodiments of the present invention provide, systems, methods, and computer program products for asynchronously replicating data from source tables of a source computer system to target tables of a target computer system. Embodiments of the present invention implement an external buffer table (EBT) from which changed data statements can be selectively applied to target tables, which can reduce the number of statements applied to the target tables of the target computer system.Type: GrantFiled: June 2, 2015Date of Patent: November 7, 2017Assignee: International Business Machines CorporationInventors: Daniel Martin, Christopher R. G. O'Quinn, James D. Spyker, Yongfeng Yao
-
Publication number: 20170242905Abstract: A processor-implemented method for replicating structured query language (SQL) in a heterogeneous replication environment is provided. The method includes receiving a first statement for a multi-row operation, whereby the multi-row operation is directed to one or more tables of a database, and whereby the first statement includes a text of a SQL statement in a DBMS transaction log. The method also provides for evaluating whether to create a source tree structure from the received first statement. In response to creating the source tree structure, the method evaluates whether the source tree structure is transformable. The method transforms the source tree structure to a target tree structure in response to evaluating that the source tree structure is transformable.Type: ApplicationFiled: May 5, 2017Publication date: August 24, 2017Inventors: James D. Spyker, Victor L. Szabo, Yongfeng Yao
-
Publication number: 20170091298Abstract: A processor-implemented method for replicating structured query language (SQL) in a heterogeneous replication environment is provided. The method includes receiving a first statement for a multi-row operation, whereby the multi-row operation is directed to one or more tables of a database, and whereby the first statement includes a text of a SQL statement in a DBMS transaction log. The method also provides for evaluating whether to create a source tree structure from the received first statement. In response to creating the source tree structure, the method evaluates whether the source tree structure is transformable. The method transforms the source tree structure to a target tree structure in response to evaluating that the source tree structure is transformable.Type: ApplicationFiled: September 25, 2015Publication date: March 30, 2017Inventors: James D. Spyker, Victor L. Szabo, Yongfeng Yao
-
Publication number: 20160203050Abstract: According to an aspect, a database management system (DBMS) is operated to perform data replication. The DBMS includes a source database and a target database. The source database includes a plurality of first tables respectively comprising one or more first columns, and the target database includes a plurality of second tables respectively comprising one or more second columns. Each of multiple ones of the first columns is mapped to one of the second columns, and each one of the second columns is adapted to store replicated data changes of the first column mapped to the second column. Each of the second columns has an assigned update time, the update time being a moment in time when the second column most recently received incremental data changes from its mapped first column. The DBMS operates to process requested database statements while providing data replication.Type: ApplicationFiled: January 8, 2015Publication date: July 14, 2016Inventors: Namik Hrle, Daniel Martin, Chandrasekaran Mohan, Sunil K. Sarin, James D. Spyker, Yongfeng Yao
-
Publication number: 20160179918Abstract: Embodiments of the present invention provide, systems, methods, and computer program products for asynchronously replicating data from source tables of a source computer system to target tables of a target computer system. Embodiments of the present invention implement an external buffer table (EBT) from which changed data statements can be selectively applied to target tables, which can reduce the number of statements applied to the target tables of the target computer system.Type: ApplicationFiled: December 18, 2014Publication date: June 23, 2016Inventors: Daniel Martin, Christopher R. G. O'Quinn, James D. Spyker, Yongfeng Yao
-
Publication number: 20160179919Abstract: Embodiments of the present invention provide, systems, methods, and computer program products for asynchronously replicating data from source tables of a source computer system to target tables of a target computer system. Embodiments of the present invention implement an external buffer table (EBT) from which changed data statements can be selectively applied to target tables, which can reduce the number of statements applied to the target tables of the target computer system.Type: ApplicationFiled: June 2, 2015Publication date: June 23, 2016Inventors: Daniel Martin, Christopher R. G. O'Quinn, James D. Spyker, Yongfeng Yao
-
Publication number: 20160110439Abstract: A computer-implemented method for operating a database management system which includes a source database and a target database. A database management system is configured for asynchronously replicating data changes of the source database to the target database. The database management system receiving a request to perform a database statement. The method can identify the most recently committed one of a plurality of transactions having been committed in the source database before the receiving of the request. Identifying repeatedly the one of the plurality of transactions having been replicated most recently to the target database. Execution of the requested statement in the target database is delayed until an evaluation of the repeatedly identified most recently replicated transaction returns that the identified most recently committed transaction has been replicated to the target database. After the delaying execution, the method executes the requested statement in the target database.Type: ApplicationFiled: September 18, 2015Publication date: April 21, 2016Inventors: Namik Hrle, Daniel Martin, Chandrasekaran Mohan, James D. Spyker, Yongfeng Yao