公开(公告)号：US11573960B2

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

申请号：US17205044

申请日：2021-03-18

Applicant: International Business Machines Corporation

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

IPC: G06F11/34 ,  G06F16/2453 ,  G06F16/2455 ,  G06F16/248 ,  G06F16/28

Abstract: A computer-implemented method provides application-based query transformations. The method includes determining an application is initiated. The method includes identifying a set of execution units included in the application. The execution units are based on of a set of queries in the application and a set of actions in the application. The method also includes building a query dependency graph (QDG) comprising a plurality of nodes, wherein each node of the plurality of nodes is correlated to an execution unit, and each node is linked to at least one additional node, the link indicating a relative execution order and a common attribute each node and the additional node. The method includes merging, based on a performance architecture, two or more of the set of execution units into a section. The method includes processing the application according to the QDG.

公开(公告)号：US11573823B2

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

申请号：US16686243

申请日：2019-11-18

Applicant: International Business Machines Corporation

Inventor： Shuo Li ,  ShengYan Sun ,  Xiaobo Wang ,  Hong Mei Zhang

IPC: G06F9/46 ,  G06F9/48

Abstract: In an approach, a processor, responsive to requesting to perform a plurality of applications including a first application and a second application, determines that the first application and the second application have been performed sequentially during a previous time period. A processor, responsive to determining that the first and second applications have been performed in sequence during the previous time period, obtains, a first set of database operations associated with the first application and a second set of database operations associated with the second application. A processors, responsive to determining that the first set of database operations and the second set of database operations are free of conflict, generates an execution schedule indicating that the first application and the second application are to be performed in parallel. A processors performs the plurality of applications based on the execution schedule.

公开(公告)号：US11526490B1

公开(公告)日：2022-12-13

申请号：US17348832

申请日：2021-06-16

Applicant: International Business Machines Corporation

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

IPC: G06F15/16 ,  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.

公开(公告)号：US20220343075A1

公开(公告)日：2022-10-27

申请号：US17238515

申请日：2021-04-23

Applicant: International Business Machines Corporation

Inventor： Shuo Li ,  June-Ray Lin ,  Sheng Yan Sun ,  Xiaobo Wang

IPC: G06F40/284 ,  G06N7/00

Abstract: An approach is provided in which a method, system, and program product build a time series prediction model based on one or more relationships between a first set of keywords in a set of first news articles and a second set of keywords in a set of second news articles. The time series prediction model includes a time-based interest level adjustment corresponding to a publication time between the set of first news articles and the set second of news articles. The method, system, and program product use the time series prediction model to compute an inherited initial interest level of a third news article that includes a set of new keywords based on the set of new keywords and the time-based interest level adjustment. The method, system, and program product assign the inherited initial interest level to the third news article.

公开(公告)号：US20220300507A1

公开(公告)日：2022-09-22

申请号：US17205044

申请日：2021-03-18

Applicant: International Business Machines Corporation

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

IPC: G06F16/2453 ,  G06F16/2455 ,  G06F16/248 ,  G06F16/28 ,  G06F11/34

Abstract: A computer-implemented method provides application-based query transformations. The method includes determining an application is initiated. The method includes identifying a set of execution units included in the application. The execution units are based on of a set of queries in the application and a set of actions in the application. The method also includes building a query dependency graph (QDG) comprising a plurality of nodes, wherein each node of the plurality of nodes is correlated to an execution unit, and each node is linked to at least one additional node, the link indicating a relative execution order and a common attribute each node and the additional node. The method includes merging, based on a performance architecture, two or more of the set of execution units into a section. The method includes processing the application according to the QDG.

公开(公告)号：US20220245130A1

公开(公告)日：2022-08-04

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

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.

公开(公告)号：US11379478B2

公开(公告)日：2022-07-05

申请号：US16838162

申请日：2020-04-02

Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION

Inventor： ShengYan Sun ,  Peng Hui Jiang ,  Shuo Li ,  Xiaobo Wang

IPC: G06F16/24 ,  G06F16/2453 ,  G06F16/22 ,  G06F16/28

Abstract: An approach is provided for optimizing a join operation that includes receiving, by one or more processors of a computer system, a join request associated with a fact table and a plurality of related dimension tables; identifying, by the one or more processors of the computer system, a join relationship from the fact table and the plurality of related dimension tables; matching, by the one or more processors of the computer system, different tables of the fact table and the plurality of related dimension tables; filtering, by the one or more processors of the computer system using data parallelism, the fact table and the plurality of related dimension tables, wherein the filtering occurs prior to performing the join request; and performing, by the one or more processors of the computer system, the join operation pursuant to the join request.

公开(公告)号：US11379444B1

公开(公告)日：2022-07-05

申请号：US17160497

申请日：2021-01-28

Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION

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

IPC: G06F16/21 ,  G06F16/23

Abstract: Trace processing in a database system is facilitated by obtaining database trace data collected from database tracing a database system, and data analyzing, by one or more processors, the database trace data to determine one or more field-related rules to, in part, reduce impact on system performance of database tracing in the database system. Trace processing is further facilitated by applying the one or more field-related rules to a database trace in the database system to adjust trace fields of the database trace according to the one or more field-related rules, thereby reducing impact on system performance of the database trace in the database system.

公开(公告)号：US20220197903A1

公开(公告)日：2022-06-23

申请号：US17129987

申请日：2020-12-22

Applicant: International Business Machines Corporation

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

IPC: G06F16/2455 ,  G06F16/28 ,  G06F16/242 ,  G06F1/3206

Abstract: Leveraging the competence of a computing cluster and a storage cluster by dynamically adjusting an SQL (structured query language) execution path to optimize system performance with fast response time under a distributed relational database on a data storage platform. Also, endpoint devices are divided into groups for the purpose of responding to queries and/or query blocks. The most suitable group of endpoint devices is chosen to respond to a given query or query block.

公开(公告)号：US20220188314A1

公开(公告)日：2022-06-16

申请号：US17121367

申请日：2020-12-14

Applicant: International Business Machines Corporation

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

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

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.