公开(公告)号：US09753979B2

公开(公告)日：2017-09-05

申请号：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.

公开(公告)号：US12079214B2

公开(公告)日：2024-09-03

申请号：US17192946

申请日：2021-03-05

Applicant: International Business Machines Corporation

Inventor： Shuo Li ,  Xiaobo Wang ,  Sheng Yan Sun ,  Li Cao ,  Xin Peng Liu

IPC: G06F16/2453 ,  G06F11/34 ,  G06N20/00

CPC classification number: G06F16/24542 ,  G06F11/3419 ,  G06F16/24537 ,  G06N20/00

Abstract: A computer-implemented method to estimate computing cost of database queries. The method includes receiving a query. The method also includes generating one or more access plans for the query. The method further includes dynamically generating a learning model based on each of the generated access plans. The method includes estimating, by the learning model and for each of the one or more access plans, a predicted cost to execute the query. The method includes selecting, based on the predicted cost, a first access path associated with a lowest cost of the predicted costs and executing the query according the selected access path.

公开(公告)号：US12045235B2

公开(公告)日：2024-07-23

申请号：US17121367

申请日：2020-12-14

Applicant: International Business Machines Corporation

Inventor： Shuo Li ,  Xiaobo Wang ,  Sheng Yan Sun ,  Hong Mei Zhang

IPC: G06F16/2453 ,  G06F11/34 ,  G06F16/21

CPC classification number: G06F16/24544 ,  G06F11/3419 ,  G06F16/217

Abstract: In a computer-implemented method for improving performance of a database optimizer, a processor calculates a first execution time for a database query executing through a first access path of a database system. A processor generates a second access path. A processor determines a second execution time via a simulation of the database query through the second access path. A processor determines that the second execution time is less than the first execution time. A processor, responsive to determining that the second execution time is less than the first execution time, sends the second access path to the database optimizer.

公开(公告)号：US12003542B2

公开(公告)日：2024-06-04

申请号：US17148684

申请日：2021-01-14

Applicant: International Business Machines Corporation

Inventor： Sheng Yan Sun ,  Shuo Li ,  Xiaobo Wang ,  Jun Wang ,  Hua Wang ,  Shidong Shan ,  Xing Xing Jing

IPC: H04L9/40 ,  G06F18/22 ,  G06F18/2413 ,  G06N20/00

CPC classification number: H04L63/20 ,  G06F18/22 ,  G06F18/24143 ,  G06N20/00 ,  H04L63/102

Abstract: A method, system, and computer program product for recommending an initial database security model. The method may include identifying a plurality of nodes connected to a security network. The method may also include analyzing security characteristics of each node of the plurality of nodes. The method may also include identifying, from the security characteristics, key factors for each node. The method may also include calculating similarities between each node of the plurality of nodes. The method may also include building a self-organized centerless network across the plurality of nodes by grouping nodes with high similarities based on the similarities between each node, where the self-organized centerless network is a centerless network without a central management server, and includes groups of nodes from the plurality of nodes. The method may also include generating federated security models for the groups of nodes.

公开(公告)号：US11966338B2

公开(公告)日：2024-04-23

申请号：US17813339

申请日：2022-07-19

Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION

Inventor： Sheng Yan Sun ,  Xiaobo Wang ,  Shuo Li ,  Chun Lei Xu

IPC: G06F12/0862

CPC classification number: G06F12/0862 ,  G06F2212/602 ,  G06F2212/6026

Abstract: This disclosure provides a method, a computing system, and a computer program product for managing prefetching of pages in a database system. The method comprises obtaining shared information associated with page access, wherein the shared information associated with the page access includes information associated with the page access from a plurality of computing nodes. The method further comprises determining whether to prefetch a number of pages into a global buffer pool based at least on the shared information associated with the page access using a sequential prefetching method.

公开(公告)号：US11960544B2

公开(公告)日：2024-04-16

申请号：US17452705

申请日：2021-10-28

Applicant: International Business Machines Corporation

Inventor： Sheng Yan Sun ,  Shuo Li ,  Xiaobo Wang ,  Hong Mei Zhang

IPC: G06F12/084 ,  G06F16/2458 ,  G06F16/903

CPC classification number: G06F16/90335 ,  G06F12/084 ,  G06F16/2471 ,  G06F2212/62

Abstract: A computer implemented method processes a query. A number of processor units processes the query to identify a result set in response to receiving the query from a first client. The number of processor units stores, the result set in a shared cache assigned to a group of clients, wherein result set stored in the shared cache is accessible by the group of clients. The number of processor units returns the result set to a second client in the group of clients from the shared cache in response to receiving the query from the second client in the group of clients.

公开(公告)号：US11914573B2

公开(公告)日：2024-02-27

申请号：US17656068

申请日：2022-03-23

Applicant: International Business Machines Corporation

Inventor： Shuo Li ,  Xiaobo Wang ,  Hong Mei Zhang ,  Sheng Yan Sun

IPC: G06F16/00 ,  G06F16/23 ,  G06F16/22

CPC classification number: G06F16/2343 ,  G06F16/2255 ,  G06F16/2365

Abstract: Disclosed are techniques for relational database locks based on columns. Database transactions may be targeted to specific columns of one or more records, instead of the entire row for those records, using primary keys. Column locks on specific keys are stored separately than column locks on ranges of keys, which are both checked when requesting a new column lock for either a single key or a range of keys. When a threshold number of columns for a given record, or range of records/keys, have been locked, the column locks for that record, or range of records, can be combined into a single row level lock to reduce resource costs for maintaining multiple concurrent locks.

公开(公告)号：US11886468B2

公开(公告)日：2024-01-30

申请号：US17541704

申请日：2021-12-03

Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION

Inventor： Xu Bin Cai ,  Xiaobo Wang ,  Chun Hua Sun ,  Yi Wang ,  Wei Wang

IPC: G06F16/00 ,  G06F16/28 ,  G06N20/00 ,  G06F16/22

CPC classification number: G06F16/285 ,  G06F16/221 ,  G06F16/2264 ,  G06N20/00

Abstract: Systems and methods are provided for automated classification of data using fingerprints. In embodiments, a method includes: generating, by a computing device based on predetermined rules, a fingerprint of a data column in a data set to be classified, the fingerprint comprising dimensions, wherein each of the dimension is assigned an attribute representing a characteristic of data in the data column; determining, by the computing device, that the fingerprint matches one or more target fingerprints by comparing the fingerprint to the target fingerprints, wherein each target fingerprint is associated with a class and includes dimensions, and each dimension is assigned an attribute representing a characteristic of data in the class; and assigning, by the computing device, one or more classes to the data column based on the one or more target fingerprints, thereby generating classified data.

公开(公告)号：US11822528B2

公开(公告)日：2023-11-21

申请号：US17031996

申请日：2020-09-25

Applicant: International Business Machines Corporation

Inventor： Sheng Yan Sun ,  Min Li ,  Shuo Li ,  Xiaobo Wang ,  Jian Xu

IPC: G06F16/21 ,  G06F16/28

CPC classification number: G06F16/217 ,  G06F16/285

Abstract: In an approach for database self-diagnosis and self-healing, a processor receives a problem description related to a database. A processor classifies the problem description into a natural language description portion and a database-know-who content portion. A processor processes the natural language description portion using natural language processing techniques. A processor evaluates the database-know-who content portion. A processor combines a result of processing the natural language description portion and evaluating the database-know-who content portion. A processor identifies a solution based on the problem description and the combined result. A processor solves a problem using the identified solution.

公开(公告)号：US11777519B2

公开(公告)日：2023-10-03

申请号：US17668561

申请日：2022-02-10

Applicant: International Business Machines Corporation

Inventor： Shuo Li ,  Xiaobo Wang ,  Leilei Li ,  Sheng Yan Sun

IPC: H03M7/40

CPC classification number: H03M7/4093 ,  H03M7/4062

Abstract: A system collects statistical data for a data page, divides the data page into parts, analyzes the data page and the statistical data, based on compression efficiency of one or more compression methods for each part of each page, to determine a compression method for each part of page, and compresses, based on the analyzing, the parts of the data page.