The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Sep. 18, 2018
Filed:
May. 26, 2016
International Business Machines Corporation, Armonk, NY (US);
Xiao Di Deng, Beijing, CN;
Shuo Li, Beijing, CN;
Shu Hua Liu, Beijing, CN;
Wei Liu, Beijing, CN;
Meng Wan, Beijing, CN;
Xiaobo Wang, Beijing, CN;
Xin Ying Yang, Beijing, CN;
Chen Xin Yu, Beijing, CN;
Xiong Wei Zhao, Beijing, CN;
International Business Machines Corporation, Armonk, NY (US);
Abstract
A method for dynamically updating database statistics and a plurality of access paths associated with at least one database table is provided. The method may include identifying at least one dynamically changing column associated with the at least one database table. The method may further include determining at least one predicate pattern associated with the identified at least one dynamically changing column. Additionally, the method may include dynamically detecting at least one range change associated with the determined at least one predicate pattern based on at least one record insert. The method may also include updating the plurality of database statistics associated with the identified at least one dynamically changing column based on the dynamically detected at least one range change. The method may further include determining at least one filter factor based on the updated plurality of database statistics associated with the identified at least one dynamically changing column.