公开(公告)号：US12235886B2

公开(公告)日：2025-02-25

申请号：US17572190

申请日：2022-01-10

Applicant: International Business Machines Corporation

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

IPC: G06F16/35 ,  G06F16/358 ,  G06F40/284 ,  G06F40/30 ,  G06F40/40 ,  G06V10/44

Abstract: An embodiment includes executing a querying process that returns database documents containing text associated with a database environment. The embodiment tokenizes the database documents into a series of n-gram tokens and groups the tokens into topic classes using natural language processing (NLP). The embodiment also generates a feature map by applying a convolution layer to an image that depicts a database structure graph of the database environment. The embodiment detects an architectural element in the image by applying a region proposal network (RPN) to the feature map and classifies the architectural element into one of the plurality of topic classes using a trained neural network. The embodiment renders, responsive to a user selection of the architectural element, an overlay depicting information about the architectural element using text and other architectural elements that are in a same topic class as the user-selected architectural element.

公开(公告)号：US12086135B2

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

申请号：US17477801

申请日：2021-09-17

Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION

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

IPC: G06F16/2452 ,  G06F11/14 ,  G06F11/34 ,  G06F16/21

CPC classification number: G06F16/24524 ,  G06F11/1471 ,  G06F11/3409 ,  G06F16/21

Abstract: A method includes receiving, by a computing device, a Structured Query Language (SQL) query from a user; generating, by the computing device, execution structures from the SQL query; generating, by the computing device, test results by running the SQL query with the execution structures; building, by the computing device, logs which record information of the running of the SQL query; generating, by the computing device, a candidate execution structure using the information from the logs; normalizing, by the computing device, the SQL query using the candidate execution structure; running, by the computing device, the normalized SQL query in a database; and comparing, by the computing device, results of the normalized SQL query to the test results.

公开(公告)号：US11940998B2

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

申请号：US17806359

申请日：2022-06-10

Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION

Inventor： Ying Zhang ,  Xiaobo Wang ,  Shuo Li ,  Sheng Yan Sun

IPC: G06F16/242 ,  G06F16/22 ,  G06F16/23

CPC classification number: G06F16/244 ,  G06F16/2282 ,  G06F16/2358

Abstract: This disclosure provides a computer-implemented method, a computer system and a computer program product for database compression oriented to combinations of fields of a database record. One or more combinations of fields of a record of a database are determined that satisfy a frequency criterion indicating that access frequencies of the one or more combinations of fields are higher than an access frequency threshold. The record is reorganized based on the one or more combinations of fields to store fields of each combination of the one or more combinations of fields in a respective contiguous storage space. The reorganized record is compressed by applying a compression scheme to the one or more combinations of fields.

公开(公告)号：US20240028515A1

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

申请号：US17813339

申请日：2022-07-19

Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION

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

IPC: G06F12/1009 ,  G06F12/0862

CPC classification number: G06F12/1009 ,  G06F12/0862

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.

公开(公告)号：US11841857B2

公开(公告)日：2023-12-12

申请号：US17676965

申请日：2022-02-22

Applicant: International Business Machines Corporation

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

IPC: G06F16/2453 ,  G06F16/22 ,  G06F16/2455 ,  G06F11/34

CPC classification number: G06F16/24542 ,  G06F11/3409 ,  G06F16/221 ,  G06F16/2455

Abstract: A computer-implemented method to transform and execute queries by merging sparsely populated columns. The method includes receiving, from a host, a first query configured to perform a command on one or more target columns in a database. The method further includes analyzing a set of statistics for the database. The method also includes determining, based on the analyzing, a first column of the one or more target columns is included in a set of sparse columns. The method includes generating a plurality of access plans for the first query, including a first access plan that merges the first column with a second column. The method further includes transforming, based on the first access plan, the first query to merge the first column with the second column. The method also includes executing, in response to the transforming of the first query, the first query.

公开(公告)号：US20230370086A1

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

申请号：US18359032

申请日：2023-07-26

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.

公开(公告)号：US11797522B2

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

申请号：US17162063

申请日：2021-01-29

Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION

Inventor： Shuo Li ,  Xiaobo Wang ,  Jia Tian Zhong ,  Sheng Yan Sun

IPC: G06F16/23 ,  G06F7/08 ,  G06F9/46 ,  G06F9/50 ,  G06F7/24

CPC classification number: G06F16/2379 ,  G06F7/08 ,  G06F9/466

Abstract: Database log writing is based on log pipeline contention. A determination is made as to whether contention in writing data to a log pipeline, which is used in writing data from memory to storage, is at a prespecified level. Based on determining that the contention in writing the data to the log pipeline is at the prespecified level, a split operation is automatically performed to create a new log pipeline.

公开(公告)号：US11741101B2

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

申请号：US17122115

申请日：2020-12-15

Applicant: International Business Machines Corporation

Inventor： Xiaobo Wang ,  Shuo Li ,  Xiao Xiao Chen ,  Sheng Yan Sun

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

CPC classification number: G06F16/24544 ,  G06F11/3419 ,  G06F16/2386 ,  G06N20/00

Abstract: A computer-implemented method to estimate an execution time for large query batches. The method includes identifying a batch of queries, where the batch of queries where each query is configured to retrieve data from a database. Selecting a first query and generating an access path for the first query including one or more mini plans. Building a learning model for the one or more mini plans. Estimating an estimated execution time for each of the one or more mini plans. Adding each of the estimated execution times for each of the one or more mini plans to determine a first total estimated time for the first query. Displaying the first total estimated time.

公开(公告)号：US20230267121A1

公开(公告)日：2023-08-24

申请号：US17676965

申请日：2022-02-22

Applicant: International Business Machines Corporation

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

IPC: G06F16/2453 ,  G06F16/2455 ,  G06F16/22 ,  G06F11/34

CPC classification number: G06F16/24542 ,  G06F11/3409 ,  G06F16/221 ,  G06F16/2455

Abstract: A computer-implemented method to transform and execute queries by merging sparsely populated columns. The method includes receiving, from a host, a first query configured to perform a command on one or more target columns in a database. The method further includes analyzing a set of statistics for the database. The method also includes determining, based on the analyzing, a first column of the one or more target columns is included in a set of sparse columns. The method includes generating a plurality of access plans for the first query, including a first access plan that merges the first column with a second column. The method further includes transforming, based on the first access plan, the first query to merge the first column with the second column. The method also includes executing, in response to the transforming of the first query, the first query.

公开(公告)号：US20230062616A1

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

申请号：US18053033

申请日：2022-11-07

Applicant: International Business Machines Corporation

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

IPC: G06F16/23 ,  G06F16/14 ,  G06F16/188

Abstract: A computer-implemented method improves the performance of write ahead logging. The method includes generating a set of query data and a set of log data, where the set of log data is configured to create a write ahead log, and the set of query data is configured to make changes to data in a database. The method also includes writing the set of query data to a virtual file system. The method further includes separating the set of log data into a set of control intervals, where each control interval includes an entry. The method includes writing, each entry into a log buffer, where the writing the set of query data to the virtual file system and the writing each entry into the log buffer are performed in parallel. The method also includes combining each entry into a complete log.