公开(公告)号：US20170344454A1

公开(公告)日：2017-11-30

申请号：US15658429

申请日：2017-07-25

Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION

Inventor： Xiao Di Deng ,  Shuo Li ,  Shu Hua Liu ,  Wei Liu ,  Meng Wan ,  Xiaobo Wang ,  Xin Ying Yang ,  Chen Xin Yu ,  Xiong Wei Zhao

IPC: G06F11/34 ,  G06F17/30

CPC classification number: G06F11/3452 ,  G06F17/30306 ,  G06F17/30315 ,  G06F17/30353 ,  G06F17/30377 ,  G06F17/30592

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.

公开(公告)号：US20170228430A1

公开(公告)日：2017-08-10

申请号：US15366712

申请日：2016-12-01

Applicant: International Business Machines Corporation

Inventor： Shuo Li ,  Meng Wan ,  Xiaobo Wang ,  Xin Ying Yang

IPC: G06F17/30

CPC classification number: G06F17/30474 ,  G06F17/30451 ,  G06F17/30457 ,  G06F17/3046 ,  G06F17/30469 ,  G06F17/30492

Abstract: A tool for combining common processes shared by at least two or more sub-queries within a query is provided. The tool determines the query with the at least two or more sub-queries. The tool determines whether one or more sub set relationships are shared between the at least two or more sub-queries. Responsive to a determination that one or more sub set relationships are shared between the at least two or more sub-queries, the tool determines an order class for the at least two or more sub-queries based on the one or more sub set relationships. The tool determines an access path for the query. The tool executes the access path during run-time for data accessing.

公开(公告)号：US20170228420A1

公开(公告)日：2017-08-10

申请号：US15016763

申请日：2016-02-05

Applicant: International Business Machines Corporation

Inventor： Shuo Li ,  Meng Wan ,  Xiaobo Wang ,  Xin Ying Yang

IPC: G06F17/30

CPC classification number: G06F17/30433 ,  G06F17/30451 ,  G06F17/30457 ,  G06F17/3046 ,  G06F17/30469 ,  G06F17/30474 ,  G06F17/30492

Abstract: A tool for combining common processes shared by at least two or more sub-queries within a query is provided. The tool determines the query with the at least two or more sub-queries. The tool determines whether one or more sub set relationships are shared between the at least two or more sub-queries. Responsive to a determination that one or more sub set relationships are shared between the at least two or more sub-queries, the tool determines an order class for the at least two or more sub-queries based on the one or more sub set relationships. The tool determines an access path for the query. The tool executes the access path during run-time for data accessing.