公开(公告)号：US20170177668A1

公开(公告)日：2017-06-22

申请号：US14970599

申请日：2015-12-16

Applicant: International Business Machines Corporation

Inventor： Shuo Li ,  Ping Liang ,  Ke Wei Wei ,  Xin Ying Yang ,  Chen Xin Yu

IPC: G06F17/30

CPC classification number: G06F17/30474 ,  G06F17/30327 ,  G06F17/30463 ,  G06F17/30471

Abstract: Optimization of a multi-index database access at runtime. A processor receives a query. A processor determines a plan and an RID results threshold for the plan, wherein the plan includes an access to the index. A processor determines a static risk threshold, a static risk for the access, and whether the static risk exceeds the static risk threshold. Responsive to the static risk exceeding the static risk threshold, a processor determines a risk bound for the access, and links the access to the risk bound. A processor accesses the index with the key. Responsive to the access being linked to a risk bound, a processor determines a dynamic risk for the access. A processor receives one or more RID results during the execution of the plan. A processor aborts the execution of the plan if a quantity of the RID results is less than the RID results threshold.

公开(公告)号：US20180373501A1

公开(公告)日：2018-12-27

申请号：US15630029

申请日：2017-06-22

Applicant: International Business Machines Corporation

Inventor： Shuo Li ,  Xin Peng Liu ,  Meng M. Wan ,  Chen Xin Yu

IPC: G06F9/44 ,  G06F17/30

Abstract: A processor within a networked distributed drafting platform generates a public key-value context file that includes initial default key-value mappings between keywords and values for use in a distributed drafting project. Refined project-level key-value mappings are elected by considering differences between the initial default key-value mappings and personal key-value mappings within a set of distributed personal key-value context files each maintained by different drafters of the distributed drafting project. The initial default key-value mappings of the public key-value context file are updated with the elected refined project-level key-value mappings within the networked distributed drafting platform.

公开(公告)号：US10067849B2

公开(公告)日：2018-09-04

申请号：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: G06F17/30 ,  G06F11/34

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.

公开(公告)号：US20170344453A1

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

申请号：US15165368

申请日：2016-05-26

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.

公开(公告)号：US09747338B2

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

申请号：US14970599

申请日：2015-12-16

Applicant: International Business Machines Corporation

Inventor： Shuo Li ,  Ping Liang ,  Ke Wei Wei ,  Xin Ying Yang ,  Chen Xin Yu

IPC: G06F17/30

CPC classification number: G06F17/30474 ,  G06F17/30327 ,  G06F17/30463 ,  G06F17/30471

Abstract: Optimization of a multi-index database access at runtime. A processor receives a query. A processor determines a plan and an RID results threshold for the plan, wherein the plan includes an access to the index. A processor determines a static risk threshold, a static risk for the access, and whether the static risk exceeds the static risk threshold. Responsive to the static risk exceeding the static risk threshold, a processor determines a risk bound for the access, and links the access to the risk bound. A processor accesses the index with the key. Responsive to the access being linked to a risk bound, a processor determines a dynamic risk for the access. A processor receives one or more RID results during the execution of the plan. A processor aborts the execution of the plan if a quantity of the RID results is less than the RID results threshold.

公开(公告)号：US09720968B2

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

申请号：US15259462

申请日：2016-09-08

Applicant: International Business Machines Corporation

Inventor： Shuo Li ,  Ping Liang ,  Ke Wei Wei ,  Xin Ying Yang ,  Chen Xin Yu

IPC: G06F17/30

CPC classification number: G06F17/30474 ,  G06F17/30327 ,  G06F17/30463 ,  G06F17/30471

Abstract: Optimization of a multi-index database access at runtime. A processor receives a query. A processor determines a plan and a record identifier (RID) results threshold for the plan, wherein the plan includes an access to the index. A processor determines a static risk threshold, a static risk for the access, and whether the static risk exceeds the static risk threshold. Responsive to the static risk exceeding the static risk threshold, a processor determines a risk bound for the access, and links the access to the risk bound. A processor accesses the index with the key. Responsive to the access being linked to a risk bound, a processor determines a dynamic risk for the access. A processor receives one or more RID results during the execution of the plan. A processor aborts the execution of the plan if a quantity of the RID results is less than the RID results threshold.

公开(公告)号：US20190179619A1

公开(公告)日：2019-06-13

申请号：US16279604

申请日：2019-02-19

Applicant: International Business Machines Corporation

Inventor： Shuo Li ,  Xin Peng Liu ,  Meng M. Wan ,  Chen Xin Yu

IPC: G06F8/20 ,  G06F16/25

Abstract: A processor within a networked distributed drafting platform generates a public key-value context file that includes initial default key-value mappings between keywords and values for use in a distributed drafting project. Refined project-level key-value mappings are elected by considering differences between the initial default key-value mappings and personal key-value mappings within a set of distributed personal key-value context files each maintained by different drafters of the distributed drafting project. The initial default key-value mappings of the public key-value context file are updated with the elected refined project-level key-value mappings within the networked distributed drafting platform.

公开(公告)号：US10275223B2

公开(公告)日：2019-04-30

申请号：US15630029

申请日：2017-06-22

Applicant: International Business Machines Corporation

Inventor： Shuo Li ,  Xin Peng Liu ,  Meng M. Wan ,  Chen Xin Yu

IPC: G06F9/44 ,  G06F8/20 ,  G06F17/30

Abstract: A processor within a networked distributed drafting platform generates a public key-value context file that includes initial default key-value mappings between keywords and values for use in a distributed drafting project. Refined project-level key-value mappings are elected by considering differences between the initial default key-value mappings and personal key-value mappings within a set of distributed personal key-value context files each maintained by different drafters of the distributed drafting project. The initial default key-value mappings of the public key-value context file are updated with the elected refined project-level key-value mappings within the networked distributed drafting platform.

公开(公告)号：US20180121507A1

公开(公告)日：2018-05-03

申请号：US15335724

申请日：2016-10-27

Applicant: International Business Machines Corporation

Inventor： Shuo Li ,  Ke Wei Wei ,  Xin Ying Yang ,  Chen Xin Yu

IPC: G06F17/30

Abstract: Aspects of the present disclosure relate to an approach for generating query execution plans for a database query. A computer-implemented method comprises determining whether a size of a file to be generated during execution of a database query is variable in response to obtaining the database query. The method further comprises determining a plurality of ranges for the size of the file in response to determining that the size of the file is variable. The method further comprises generating a plurality of query execution plans corresponding to the plurality of ranges. Accordingly, a plurality of query execution plans corresponding to different file sizes can be generated for the database query, and an efficient and cost effective query execution plan may be selected based on the actual file size during the execution of the database query.

公开(公告)号：US09898506B2

公开(公告)日：2018-02-20

申请号：US15581013

申请日：2017-04-28

Applicant: International Business Machines Corporation

Inventor： Shuo Li ,  Ping Liang ,  Ke Wei Wei ,  Xin Ying Yang ,  Chen Xin Yu

IPC: G06F17/30

CPC classification number: G06F17/30474 ,  G06F17/30327 ,  G06F17/30463 ,  G06F17/30471

Abstract: Optimization of a multi-index database access at runtime. A processor receives a query. A processor determines a plan and a record identifier (RID) results threshold for the plan, wherein the plan includes an access to the index. A processor determines a static risk threshold, a static risk for the access, and whether the static risk exceeds the static risk threshold. Responsive to the static risk exceeding the static risk threshold, a processor determines a risk bound for the access, and links the access to the risk bound. A processor accesses the index with the key. Responsive to the access being linked to a risk bound, a processor determines a dynamic risk for the access. A processor receives one or more RID results during the execution of the plan. A processor aborts the execution of the plan if a quantity of the RID results is less than the RID results threshold.