-
公开(公告)号:US10229149B2
公开(公告)日:2019-03-12
申请号:US15597555
申请日:2017-05-17
Applicant: International Business Machines Corporation
Inventor: Ke Wei Wei , Maryela E. Weihrauch , Hao Wu , Xin Ying Yang , Miao Zheng
IPC: G06F17/30
Abstract: A computer maps a literal in a database query to a digital representation, wherein the database query comprises a predicate, the literal is a part of the predicate, and the digital representation is predetermined based at least in part on external statistical data. The computer estimates a filter factor for the predicate based at least in part on the digital representation and compressed statistical data, wherein the compressed statistical data are prepared at least in part from the external statistical data.
-
公开(公告)号:US20170249346A1
公开(公告)日:2017-08-31
申请号:US15597555
申请日:2017-05-17
Applicant: International Business Machines Corporation
Inventor: Ke Wei Wei , Maryela E. Weihrauch , Hao Wu , Xin Ying Yang , Miao Zheng
CPC classification number: G06F17/30345 , G06F17/30153 , G06F17/30469 , G06F17/30699 , G06F17/30914
Abstract: A computer maps a literal in a database query to a digital representation, wherein the database query comprises a predicate, the literal is a part of the predicate, and the digital representation is predetermined based at least in part on external statistical data. The computer estimates a filter factor for the predicate based at least in part on the digital representation and compressed statistical data, wherein the compressed statistical data are prepared at least in part from the external statistical data.
-
公开(公告)号:US20240193151A1
公开(公告)日:2024-06-13
申请号:US18062842
申请日:2022-12-07
Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION
Inventor: Yuan Gao , Xiao Min Zhao , Shuang Li , Hao Wu
IPC: G06F16/23 , G06F16/2453
CPC classification number: G06F16/2379 , G06F16/24542
Abstract: Method, computer program product, and computer system are provided. A plurality of query activities are captured from one or more monitored databases. The query activities are persisted into a graph-enabled database repository. The plurality of query activities are classified into a plurality of workload rules based on there being a correlations between the plurality of query activities. A plurality of components of a total execution time of each query in a workload rule is analyzed. One or more problematic queries is identified based on the analyzing.
-
公开(公告)号:US12182559B2
公开(公告)日:2024-12-31
申请号:US18062266
申请日:2022-12-06
Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION
Inventor: Xiao Ling Chen , Si Yu Chen , Juliet Candee , Yan Fei Qin , Hao Wu , Wen Bin Han
Abstract: Computer implemented method, systems, and computer program products include program code executing on a processor(s) obtain a first container comprising image layers, wherein the image layers include a base image layer and one or more image layers. The program code determines dependencies between the image layers. The program code obtains a request for an application where at least one image layer of the one or more image layers comprises features of the application. The program code identifies, based on the dependencies, at least one additional image layer related to the at least one image layer. The program code generates and deploys a second container, where image layers of the second container consist of the at least one image layer, the at least one additional image layer related to the at least one image layer, and the base layer.
-
公开(公告)号:US10223399B2
公开(公告)日:2019-03-05
申请号:US14930736
申请日:2015-11-03
Applicant: International Business Machines Corporation
Inventor: Ke Wei Wei , Maryela E. Weihrauch , Hao Wu , Xin Ying Yang , Miao Zheng
IPC: G06F17/30
Abstract: A computer maps a literal in a database query to a digital representation, wherein the database query comprises a predicate, the literal is a part of the predicate, and the digital representation is predetermined based at least in part on external statistical data. The computer estimates a filter factor for the predicate based at least in part on the digital representation and compressed statistical data, wherein the compressed statistical data are prepared at least in part from the external statistical data.
-
公开(公告)号:US20170124134A1
公开(公告)日:2017-05-04
申请号:US14930736
申请日:2015-11-03
Applicant: International Business Machines Corporation
Inventor: Ke Wei Wei , Maryela E. Weihrauch , Hao Wu , Xin Ying Yang , Miao Zheng
IPC: G06F17/30
CPC classification number: G06F17/30345 , G06F17/30153 , G06F17/30469 , G06F17/30699 , G06F17/30914
Abstract: A computer maps a literal in a database query to a digital representation, wherein the database query comprises a predicate, the literal is a part of the predicate, and the digital representation is predetermined based at least in part on external statistical data. The computer estimates a filter factor for the predicate based at least in part on the digital representation and compressed statistical data, wherein the compressed statistical data are prepared at least in part from the external statistical data.
-
-
-
-
-