Patents by Inventor Shuanglin Guo
Shuanglin Guo 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).
-
Publication number: 20240118157Abstract: An ambient pressure compensation structure for an ultraviolet difference spectrum gas sensor includes a closed box, an ultraviolet difference spectrum gas sensor, a digital pressure sensor, a thermostatic controller, an industrial control computer, a pressure regulating assembly and a limiting partition; the pressure regulating assembly and the limiting partition are arranged inside the closed box, the pressure regulating assembly comprises a piston, a regulating rod and a driving motor, the left side of the piston is connected with the regulating rod, the front end of the regulating rod penetrates out of the closed box and is connected with the driving motor, and the piston divides the interior of the closed box into a pressure regulating air chamber and a working air chamber. Also disclosed is an ambient pressure compensation method for an ultraviolet difference spectrum gas sensor.Type: ApplicationFiled: December 19, 2023Publication date: April 11, 2024Inventors: Fuchao TIAN, Yuntao LIANG, Shuanglin SONG, Xing AI, Yazhou XU, Weiwei SU, Baolong GUO, Zhenrong LI
-
Publication number: 20230401207Abstract: According to an aspect, a computer-implemented method for improving query performance in a databased management system (DBMS) includes receiving, by a query optimizer of the DMBS, a query for execution. The method also includes creating, by the query optimizer, an initial access path for the query based on state and executing the query based on the initial access path. The method further includes observing, by a query agent of the DBMS, the execution of the query and modifying at least one of the state based on a determination by the query agent that a change to the initial access path would improve the execution of the query.Type: ApplicationFiled: September 13, 2022Publication date: December 14, 2023Inventors: Thomas A. Beavin, Shuanglin Guo, Brandon Jabr, Terence P. Purcell
-
Patent number: 11604101Abstract: A temperature measuring circuit, measuring apparatus and a measuring method thereof relating to the field of electronic circuits. The temperature measuring circuit includes control unit, wherein the control unit includes a first current output interface, a second current output interface, a first input/output interface, a second input/output interface, and a third input/output interface. Further, the first current output interface and the first input/output interface of the control unit are respectively electrically connected to a first interface of a temperature sensor; the second current output interface and the second input/output interface of the control unit are respectively electrically connected to a second interface of the temperature sensor; and the third input/output interface of the control unit is electrically connected to a third interface of the temperature sensor.Type: GrantFiled: December 27, 2017Date of Patent: March 14, 2023Assignees: Gree Electric Appliances (Wuhan) Co., Ltd., Gree Electric Appliances, Inc. of ZhuhaiInventors: Pei Qian, Xiantao Zhu, Wenbo Liu, Baolin Zhou, Wanxing Chen, Shuanglin Guo, Haibin Liu, Zifeng Liang, Guohui Hu, Luping Zhong, Yanjun Peng
-
Patent number: 11222015Abstract: A method, system and computer program product are provided. A first index scan of records of a database table is performed. A first index used by the first index scan is specified in a DBMS query statement as being ordered by one or more field values of one or more fields of the first index. A second scan of the database table is performed to determine whether each respective record of the second scan is qualified based on one or more fields of the each respective record of the second scan and a predicate. A lookup data structure is built indicating whether each of the respective records of the second scan is qualified. The lookup data structure is used to determine whether a record of the first index scan is qualified when the lookup data structure becomes available.Type: GrantFiled: May 6, 2019Date of Patent: January 11, 2022Assignee: International Business Machines CorporationInventors: Brian L. Baggett, Thomas A. Beavin, Oliver Draese, Shuanglin Guo, Andrei F. Lurie, Terence P. Purcell, Shengxi Suo
-
Publication number: 20200355561Abstract: A temperature measuring circuit, measuring apparatus and a measuring method thereof relating to the field of electronic circuits. The temperature measuring circuit includes control unit, wherein the control unit includes a first current output interface, a second current output interface, a first input/output interface, a second input/output interface, and a third input/output interface. Further, the first current output interface and the first input/output interface of the control unit are respectively electrically connected to a first interface of a temperature sensor; the second current output interface and the second input/output interface of the control unit are respectively electrically connected to a second interface of the temperature sensor; and the third input/output interface of the control unit is electrically connected to a third interface of the temperature sensor.Type: ApplicationFiled: December 27, 2017Publication date: November 12, 2020Inventors: Pei Qian, Xiantao Zhu, Wenbo Liu, Baolin Zhou, Wanxing Chen, Shuanglin Guo, Haibin Liu, Zifeng Liang, Guohui Hu, Luping Zhong, Yanjun Peng
-
Patent number: 10754858Abstract: An access plan including multiple indexes is selected for accessing data of a database system. A filtering status of each index within the selected access plan is determined based on information available at execution of the selected access plan. The order of the indexes within the selected access plan is modified based on the filtering status of the indexes, and the selected access plan is executed with the modified order of the indexes. The execution of the selected access plan is interrupted in response to accessing a threshold amount of data and the filtering of the indexes of the selected access plan is estimated. A processing order for the indexes is determined based on the estimated filtering. The execution of the selected access plan resumes based on the determined processing order.Type: GrantFiled: January 6, 2017Date of Patent: August 25, 2020Assignee: International Business Machines CorporationInventors: Brian L. Baggett, Patrick D. Bossman, Shuanglin Guo, Andrei F. Lurie, Terence P. Purcell, Martina Simova
-
Patent number: 10691690Abstract: A method, system and computer program product are provided. A first index scan of records of a database table is performed. A first index used by the first index scan is specified in a DBMS query statement as being ordered by one or more field values of one or more fields of the first index. A second scan of the database table is performed to determine whether each respective record of the second scan is qualified based on one or more fields of the each respective record of the second scan and a predicate. A lookup data structure is built indicating whether each of the respective records of the second scan is qualified. The lookup data structure is used to determine whether a record of the first index scan is qualified when the lookup data structure becomes available.Type: GrantFiled: October 31, 2017Date of Patent: June 23, 2020Assignee: International Business Machines CorporationInventors: Brian L. Baggett, Thomas A. Beavin, Oliver Draese, Shuanglin Guo, Andrei F. Lurie, Terence P. Purcell, Shengxi Suo
-
Patent number: 10620085Abstract: The present invention discloses a bridge inspection and evaluation method based on impact vibration. The method includes backward analysis of the bridge based on impact on blocks without reference points and forward analysis of the bridge based on progressive impact loading, where the backward analysis of the bridge based on impact on blocks without reference points is used to rapidly inspect the medium and small bridges from the road network to find the ones with serious shortage of bearing capacity, and the forward analysis of the bridge based on progressive impact loading is used to evaluate the actual bearing capacity of the bridges, which may have good safety condition in the backward analysis. The present invention realizes low-cost and highly efficient inspection and evaluation of the medium and small bridges in the road network.Type: GrantFiled: August 26, 2016Date of Patent: April 14, 2020Assignee: SOUTHEAST UNIVERSITYInventors: Jian Zhang, Qi Xia, Bo Zhang, Shuanglin Guo
-
Publication number: 20190258633Abstract: A method, system and computer program product are provided. A first index scan of records of a database table is performed. A first index used by the first index scan is specified in a DBMS query statement as being ordered by one or more field values of one or more fields of the first index. A second scan of the database table is performed to determine whether each respective record of the second scan is qualified based on one or more fields of the each respective record of the second scan and a predicate. A lookup data structure is built indicating whether each of the respective records of the second scan is qualified. The lookup data structure is used to determine whether a record of the first index scan is qualified when the lookup data structure becomes available.Type: ApplicationFiled: May 6, 2019Publication date: August 22, 2019Inventors: Brian L. Baggett, Thomas A. Beavin, Oliver Draese, Shuanglin Guo, Andrei F. Lurie, Terence P. Purcell, Shengxi Suo
-
Publication number: 20190129999Abstract: A method, system and computer program product are provided. A first index scan of records of a database table is performed. A first index used by the first index scan is specified in a DBMS query statement as being ordered by one or more field values of one or more fields of the first index. A second scan of the database table is performed to determine whether each respective record of the second scan is qualified based on one or more fields of the each respective record of the second scan and a predicate. A lookup data structure is built indicating whether each of the respective records of the second scan is qualified. The lookup data structure is used to determine whether a record of the first index scan is qualified when the lookup data structure becomes available.Type: ApplicationFiled: October 31, 2017Publication date: May 2, 2019Inventors: Brian L. Baggett, Thomas A. Beavin, Oliver Draese, Shuanglin Guo, Andrei F. Lurie, Terence P. Purcell, Shengxi Suo
-
Patent number: 10210210Abstract: An access plan including multiple indexes is selected for accessing data of a database system. A filtering status of each index within the selected access plan is determined based on information available at execution of the selected access plan. The order of the indexes within the selected access plan is modified based on the filtering status of the indexes, and the selected access plan is executed with the modified order of the indexes. The execution of the selected access plan is interrupted in response to accessing a threshold amount of data and the filtering of the indexes of the selected access plan is estimated. A processing order for the indexes is determined based on the estimated filtering. The execution of the selected access plan resumes based on the determined processing order.Type: GrantFiled: October 21, 2015Date of Patent: February 19, 2019Assignee: International Business Machines CorporationInventors: Brian L. Baggett, Patrick D. Bossman, Shuanglin Guo, Andrei F. Lurie, Terence P. Purcell, Martina Simova
-
Publication number: 20180224352Abstract: The present invention discloses a bridge inspection and evaluation method based on impact vibration. The method includes backward analysis of the bridge based on impact on blocks without reference points and forward analysis of the bridge based on progressive impact loading, where the backward analysis of the bridge based on impact on blocks without reference points is used to rapidly inspect the medium and small bridges from the road network to find the ones with serious shortage of bearing capacity, and the forward analysis of the bridge based on progressive impact loading is used to evaluate the actual bearing capacity of the bridges, which may have good safety condition in the backward analysis. The present invention realizes low-cost and highly efficient inspection and evaluation of the medium and small bridges in the road network.Type: ApplicationFiled: August 26, 2016Publication date: August 9, 2018Applicant: SOUTHEAST UNIVERSITYInventors: Jian ZHANG, Qi XIA, Bo ZHANG, Shuanglin GUO
-
Patent number: 9940359Abstract: Provided are techniques for a Data-Partitioned Secondary Index (DPSI) partition level join. While using a Data-Partitioned Secondary Index (DPSI) to perform a join of an outer table and an inner table, a different task from multiple tasks is assigned to each partition of the inner table. With each task, a join is performed of the outer table and the assigned partition of the inner table using the DPSI to generate results. The results from each different task are merged.Type: GrantFiled: May 23, 2014Date of Patent: April 10, 2018Assignee: International Business Machines CorporationInventors: Brian L. Baggett, Michael A. Chang, Shuanglin Guo, Ou Jin, Terence P. Purcell
-
Publication number: 20170116275Abstract: An access plan including multiple indexes is selected for accessing data of a database system. A filtering status of each index within the selected access plan is determined based on information available at execution of the selected access plan. The order of the indexes within the selected access plan is modified based on the filtering status of the indexes, and the selected access plan is executed with the modified order of the indexes. The execution of the selected access plan is interrupted in response to accessing a threshold amount of data and the filtering of the indexes of the selected access plan is estimated. A processing order for the indexes is determined based on the estimated filtering. The execution of the selected access plan resumes based on the determined processing order.Type: ApplicationFiled: October 21, 2015Publication date: April 27, 2017Inventors: Brian L. Baggett, Patrick D. Bossman, Shuanglin Guo, Andrei F. Lurie, Terence P. Purcell, Martina Simova
-
Publication number: 20170116264Abstract: An access plan including multiple indexes is selected for accessing data of a database system. A filtering status of each index within the selected access plan is determined based on information available at execution of the selected access plan. The order of the indexes within the selected access plan is modified based on the filtering status of the indexes, and the selected access plan is executed with the modified order of the indexes. The execution of the selected access plan is interrupted in response to accessing a threshold amount of data and the filtering of the indexes of the selected access plan is estimated. A processing order for the indexes is determined based on the estimated filtering. The execution of the selected access plan resumes based on the determined processing order.Type: ApplicationFiled: January 6, 2017Publication date: April 27, 2017Inventors: Brian L. Baggett, Patrick D. Bossman, Shuanglin Guo, Andrei F. Lurie, Terence P. Purcell, Martina Simova
-
Patent number: 9256643Abstract: A technique for factoring uncertainty into cost-based query optimization includes: determining the degree of uncertainty involved in the cost estimates for the query, determining the degree of sensitivity the query has to that uncertainty, and determining if there is an access path that performs well across the range of possible conditions that could occur at execution time, reducing the risk of performance spikes and performance volatility. If such an access path exists, select that access path; if not, perform parametric query optimization or query re-optimization.Type: GrantFiled: March 27, 2014Date of Patent: February 9, 2016Assignee: International Business Machines CorporationInventors: Jason L. Alpers, Thomas A. Beavin, Patrick D. Bossman, Shuanglin Guo, Terence P. Purcell
-
Patent number: 9208198Abstract: A technique for factoring uncertainty into cost-based query optimization includes: determining the degree of uncertainty involved in the cost estimates for the query, determining the degree of sensitivity the query has to that uncertainty, and determining if there is an access path that performs well across the range of possible conditions that could occur at execution time, reducing the risk of performance spikes and performance volatility. If such an access path exists, select that access path; if not, perform parametric query optimization or query re-optimization.Type: GrantFiled: October 17, 2012Date of Patent: December 8, 2015Assignee: International Business Machines CorporationInventors: Jason L. Alpers, Thomas A. Beavin, Patrick D. Bossman, Shuanglin Guo, Terence P. Purcell
-
Publication number: 20150339350Abstract: Provided are techniques for a Data-Partitioned Secondary Index (DPSI) partition level join. While using a Data-Partitioned Secondary Index (DPSI) to perform a join of an outer table and an inner table, a different task from multiple tasks is assigned to each partition of the inner table. With each task, a join is performed of the outer table and the assigned partition of the inner table using the DPSI to generate results. The results from each different task are merged.Type: ApplicationFiled: May 23, 2014Publication date: November 26, 2015Applicant: International Business Machines CorporationInventors: Brian L. Baggett, Michael A. Chang, Shuanglin Guo, Ou Jin, Terence P. Purcell
-
Publication number: 20140214797Abstract: A technique for factoring uncertainty into cost-based query optimization includes: determining the degree of uncertainty involved in the cost estimates for the query, determining the degree of sensitivity the query has to that uncertainty, and determining if there is an access path that performs well across the range of possible conditions that could occur at execution time, reducing the risk of performance spikes and performance volatility. If such an access path exists, select that access path; if not, perform parametric query optimization or query re-optimization.Type: ApplicationFiled: March 27, 2014Publication date: July 31, 2014Applicant: International Business Machines CorporationInventors: Jason L. Alpers, Thomas A. Beavin, Patrick D. Bossman, Shuanglin Guo, Terence P. Purcell
-
Publication number: 20140108378Abstract: A technique for factoring uncertainty into cost-based query optimization includes: determining the degree of uncertainty involved in the cost estimates for the query, determining the degree of sensitivity the query has to that uncertainty, and determining if there is an access path that performs well across the range of possible conditions that could occur at execution time, reducing the risk of performance spikes and performance volatility. If such an access path exists, select that access path; if not, perform parametric query optimization or query re-optimization.Type: ApplicationFiled: October 17, 2012Publication date: April 17, 2014Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Jason L. Alpers, Thomas A. Beavin, Patrick D. Bossman, Shuanglin Guo, Terence P. Purcell