Patents by Inventor Fu Fei Xu
Fu Fei Xu 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: 20230409570Abstract: Machine-learning-based, adaptive updating of quantitative data in a database system is provided, which includes training one or more machine learning models to facilitate adaptively updating quantitative data in the database system, and ascertaining an update urgency index for updating the quantitative data for one or more data structures of the database system. The update urgency index is representative of an urgency for updating the quantitative data for the data structure(s) and is based, at least in part, on real-time query metrics. The machine learning model(s) is used to adaptively update the quantitative data, where the adaptively updating is based, at least in part, on the ascertained update urgency index. Processing of a database query is optimized in the database system using the adaptively updated quantitative data.Type: ApplicationFiled: August 23, 2023Publication date: December 21, 2023Inventors: Ling QIN, Fu Fei XU, Jie ZHANG, Guo Dong WAN, Yi Lei WANG, Wen Jing SHI, Yuan CAO
-
Patent number: 11775516Abstract: Machine-learning-based, adaptive updating of quantitative data in a database system is provided, which includes training one or more machine learning models to facilitate adaptively updating quantitative data in the database system, and ascertaining an update urgency index for updating the quantitative data for one or more data structures of the database system. The update urgency index is representative of an urgency for updating the quantitative data for the data structure(s) and is based, at least in part, on real-time query metrics. The machine learning model(s) is used to adaptively update the quantitative data, where the adaptively updating is based, at least in part, on the ascertained update urgency index. Processing of a database query is optimized in the database system using the adaptively updated quantitative data.Type: GrantFiled: February 9, 2022Date of Patent: October 3, 2023Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Ling Qin, Fu Fei Xu, Jie Zhang, Guo Dong Wan, Yi Lei Wang, Wen Jing Shi, Yuan Cao
-
Publication number: 20230281199Abstract: Computer technology for use in a computer system including a database system including a database management sub-system, a primary database and a secondary database, with the secondary database being maintained at least approximately in synchronization with the primary database over time as changes are made to data of the primary database (for example, a database system that includes disaster recovery (DR) features). A statistics update is performed first on a standby database to determine whether query efficiency and/or query optimization really will be substantially improved by performance of the statistics update. If not, then statistics update on the primary database is postponed until a future time.Type: ApplicationFiled: March 7, 2022Publication date: September 7, 2023Inventors: Jie Zhang, Fu Fei Xu, Peng Hui Jiang, Yi Lei Wang, Wen Jing Shi, Ling Qin, Guo Dong Wan
-
Publication number: 20230252024Abstract: Machine-learning-based, adaptive updating of quantitative data in a database system is provided, which includes training one or more machine learning models to facilitate adaptively updating quantitative data in the database system, and ascertaining an update urgency index for updating the quantitative data for one or more data structures of the database system. The update urgency index is representative of an urgency for updating the quantitative data for the data structure(s) and is based, at least in part, on real-time query metrics. The machine learning model(s) is used to adaptively update the quantitative data, where the adaptively updating is based, at least in part, on the ascertained update urgency index. Processing of a database query is optimized in the database system using the adaptively updated quantitative data.Type: ApplicationFiled: February 9, 2022Publication date: August 10, 2023Inventors: Ling QIN, Fu Fei XU, Jie ZHANG, Guo Dong WAN, Yi Lei WANG, Wen Jing SHI, Yuan CAO
-
Patent number: 11055287Abstract: Embodiments relate to an eigenvalue-based data query. An aspect includes receiving a query request that includes a query statement. Another aspect includes calculating eigenvalues of key component elements in the query statement. Another aspect includes matching eigenvalues of nodes in an execution plan of a historical query statement to the eigenvalues of the key component elements. Yet another aspect includes based on determining success of matching the eigenvalues of the key component elements to the eigenvalues of the nodes in an execution plan of the historical query statement, generating an execution plan of the query statement.Type: GrantFiled: September 17, 2018Date of Patent: July 6, 2021Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Jing Jing Liu, Lei Qiu, Chen Wang, Fu Fei Xu, Guang Zhou Zhang, Sheng Zhao, Zan Zhou
-
Publication number: 20190018879Abstract: Embodiments relate to an eigenvalue-based data query. An aspect includes receiving a query request that includes a query statement. Another aspect includes calculating eigenvalues of key component elements in the query statement. Another aspect includes matching eigenvalues of nodes in an execution plan of a historical query statement to the eigenvalues of the key component elements. Yet another aspect includes based on determining success of matching the eigenvalues of the key component elements to the eigenvalues of the nodes in an execution plan of the historical query statement, generating an execution plan of the query statement.Type: ApplicationFiled: September 17, 2018Publication date: January 17, 2019Inventors: Jing Jing Liu, Lei Qiu, Chen Wang, Fu Fei Xu, Guang Zhou Zhang, Sheng Zhao, Zan Zhou
-
Patent number: 10127279Abstract: Embodiments relate to an eigenvalue-based data query. An aspect includes receiving a query request that includes a query statement. Another aspect includes calculating eigenvalues of key component elements in the query statement. Another aspect includes matching eigenvalues of nodes in an execution plan of a historical query statement to the eigenvalues of the key component elements. Yet another aspect includes based on determining success of matching the eigenvalues of the key component elements to the eigenvalues of the nodes in an execution plan of the historical query statement, generating an execution plan of the query statement.Type: GrantFiled: August 11, 2016Date of Patent: November 13, 2018Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Jing Jing Liu, Lei Qiu, Chen Wang, Fu Fei Xu, Guang Zhou Zhang, Sheng Zhao, Zan Zhou
-
Publication number: 20160350372Abstract: Embodiments relate to an eigenvalue-based data query. An aspect includes receiving a query request that includes a query statement. Another aspect includes calculating eigenvalues of key component elements in the query statement. Another aspect includes matching eigenvalues of nodes in an execution plan of a historical query statement to the eigenvalues of the key component elements. Yet another aspect includes based on determining success of matching the eigenvalues of the key component elements to the eigenvalues of the nodes in an execution plan of the historical query statement, generating an execution plan of the query statement.Type: ApplicationFiled: August 11, 2016Publication date: December 1, 2016Inventors: Jing Jing Liu, Lei Qiu, Chen Wang, Fu Fei Xu, Guang Zhou Zhang, Sheng Zhao, Zan Zhou
-
Patent number: 9471633Abstract: Embodiments relate to an eigenvalue-based data query. An aspect includes receiving a query request that includes a query statement. Another aspect includes calculating eigenvalues of key component elements in the query statement. Another aspect includes matching eigenvalues of nodes in an execution plan of a historical query statement to the eigenvalues of the key component elements. Yet another aspect includes based on determining success of matching the eigenvalues of the key component elements to the eigenvalues of the nodes in an execution plan of the historical query statement, generating an execution plan of the query statement.Type: GrantFiled: March 4, 2014Date of Patent: October 18, 2016Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Jing Jing Liu, Lei Qiu, Chen Wang, Fu Fei Xu, Guang Zhou Zhang, Sheng Zhao, Zan Zhou
-
Publication number: 20140358895Abstract: Embodiments relate to an eigenvalue-based data query. An aspect includes receiving a query request that includes a query statement. Another aspect includes calculating eigenvalues of key component elements in the query statement. Another aspect includes matching eigenvalues of nodes in an execution plan of a historical query statement to the eigenvalues of the key component elements. Yet another aspect includes based on determining success of matching the eigenvalues of the key component elements to the eigenvalues of the nodes in an execution plan of the historical query statement, generating an execution plan of the query statement.Type: ApplicationFiled: March 4, 2014Publication date: December 4, 2014Applicant: International Business Machines CorporationInventors: Jing Jing Liu, Lei Qiu, Chen Wang, Fu Fei Xu, Guang Zhou Zhang, Sheng Zhao, Zan Zhou