公开(公告)号：US20210357419A1

公开(公告)日：2021-11-18

申请号：US16876391

申请日：2020-05-18

Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION

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

IPC: G06F16/25 ,  G06F16/22 ,  G06F16/23 ,  G06F16/18 ,  G06F16/17 ,  G06F16/16 ,  G06F16/901

Abstract: A DBMS receives a database-access request that includes an instruction to non-destructively read a database table row. The DBMS assigns the request a TSN identifier and creates a TSN image that identifies all TSNs assigned to transactions that are not yet committed. The DBMS traverses a linked list of log entries that identifies a chronological history of transactions performed on the same row. The DBMS infers that the table row currently contains data stored by the most recently logged transaction that is not contained in the TSN image and that has thus been committed. The DBMS then continues to process statements of the transaction based on the assumption that the row contains the inferred value. The DBMS performs this procedure without acquiring a shared lock on the data page or on the index leaf page that points to the table row.

公开(公告)号：US20210303577A1

公开(公告)日：2021-09-30

申请号：US16834369

申请日：2020-03-30

Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION

Inventor： Xin Peng Liu ,  Meng Wan ,  Shuo Li ,  Xiaobo Wang

IPC: G06F16/2453 ,  G06N20/00 ,  G06N5/04

Abstract: A lightweight database-management system (DBMS) is based on a dynamic microservices architecture that implements each granular DBMS feature or function as a distinct, independently executable microservice. The DBMS's Parser front-end responds to each incoming query by selecting the first bind-time database feature needed to process the query. The Parser forwards its selection through a Channel-Binding subsystem to an Event Services Activation subsystem that activates a corresponding microservice to perform the selected feature. The first feature then selects the next required bind-time feature for activation, and this process continues sequentially until all required bind-time microservices have been identified, activated, and run. Runtime query-processing features are then sequentially selected in a similar manner. However, each selected runtime microservice is preloaded but not run. Only when all runtime functions have been identified does the Parser send an asynchronous message to the Channel-Binding subsystem directing the DBMS engine to run the preloaded runtime microservices.

公开(公告)号：US20210133195A1

公开(公告)日：2021-05-06

申请号：US16671424

申请日：2019-11-01

Applicant: International Business Machines Corporation

Inventor： Peng Hui Jiang ,  Xiao Xiao Chen ,  SHUO LI ,  ShengYan Sun ,  Xiaobo Wang

IPC: G06F16/2453 ,  G06F16/2458 ,  G06N20/00

Abstract: Embodiments are disclosed for a method for dynamic access paths. The method includes generating real-time statistics (RTS) estimates based on a log of a database. Further, the method includes generating access paths based on a structured query language command and the RTS estimates. The method also includes training a machine learning model to map the RTS estimates to the access paths.

公开(公告)号：US10949197B1

公开(公告)日：2021-03-16

申请号：US16674509

申请日：2019-11-05

Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION

Inventor： Xiaobo Wang ,  Shuo Li ,  Shengyan Sun ,  Xiao Xiao Chen

IPC: G06F8/656 ,  G06F16/21

Abstract: A method, system and computer program for analysis of patch impact. The method comprises obtaining first data manipulating statement (DMS) from description of a patch to be installed to a database system; extracting first parse tree and first access path of first DMS; obtaining second DMS from an running database application; extracting second parse tree of second DMS; comparing first parse tree with second parse tree and first access path with second access path; and installing the patch to a database system in response to a determination that first parse tree is a subset of second parse tree and first access path is a subset of second access path.

公开(公告)号：US20210064591A1

公开(公告)日：2021-03-04

申请号：US16550465

申请日：2019-08-26

Applicant: International Business Machines Corporation

Inventor： ShengYan Sun ,  Ke Wei Wei ,  Meng Wan ,  Shuo Li ,  Xiaobo Wang

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

Abstract: Database configuration tuning is provided. A set of database nodes having similar data factors is selected in a centerless network of database nodes. Configuration models corresponding to the set of database nodes are trained using data parallelism. Trained configuration models corresponding to the set of database nodes are combined to form a federated configuration model. It is determined whether performance indicators corresponding to the set of database nodes are greater than a performance threshold level. In response to determining that the performance indicators corresponding to the set of database nodes are greater than the performance threshold level, a database configuration corresponding to the federated configuration model is recommended to a new database node. The new database node is joined to the centerless network.

公开(公告)号：US10885052B2

公开(公告)日：2021-01-05

申请号：US15815229

申请日：2017-11-16

Applicant: International Business Machines Corporation

Inventor： Shuo Li ,  Xin Peng Liu ,  Xiaobo Wang ,  Chong Yuan Yin ,  Chen Xin Yu

IPC: G06F16/00 ,  G06F16/25 ,  G06F16/2455

Abstract: A database processing system includes a coordinator agent controller and a virtual node data base. The coordinator agent controller detects a request to access a database by an application program and to extracts database objects from a database protocol stream based on a requirement requested by the application program. The virtual node database is generated according to the extracted database objects. The virtual node database includes memory dump storage that stores the database objects extracted from the database protocol stream, and based on the database objects the virtual node database generates virtual database objects corresponding to the database protocol stream. The extraction of database objects is performed directly on the database protocol stream without communicating with a target real database.

公开(公告)号：US10210207B2

公开(公告)日：2019-02-19

申请号：US14985791

申请日：2015-12-31

Applicant: International Business Machines Corporation

Inventor： Shuo Li ,  Ping Liang ,  Bing Qing Sun ,  Xiaobo Wang ,  Xin Ying Yang

IPC: G06F17/30

Abstract: Aspects include a method that includes receiving a structured query language (SQL) database command at a processing device configured to manage a table space of a relational database, the database command including a merge statement. The method also includes identifying a group of target records from the database command, and associating each target record with one of a plurality of portions of the table space, and in response to determining that the group of target records is associated with more than one portion of the table space, sorting the target records into a plurality of sub-groups, each sub-group associated with a different portion of the table space. The method further includes generating a sub-task associated with each sub-group, the sub-task prescribing aspects of performing the merge operation using an associated sub-group respective sub-group, and performing all of the sub-tasks on the memory space in parallel.

公开(公告)号：US20180173773A1

公开(公告)日：2018-06-21

申请号：US15385501

申请日：2016-12-20

Applicant: International Business Machines Corporation

Inventor： Shuo Li ,  Xin Peng Liu ,  Xiaobo Wang ,  Chong Yuan Yin ,  Chen Xin Yu

IPC: G06F17/30

Abstract: A database processing system includes a coordinator agent controller and a virtual node data base. The coordinator agent controller detects a request to access a database by an application program and to extracts database objects from a database protocol stream based on a requirement requested by the application program. The virtual node database is generated according to the extracted database objects. The virtual node database includes memory dump storage that stores the database objects extracted from the database protocol stream, and based on the database objects the virtual node database generates virtual database objects corresponding to the database protocol stream. The extraction of database objects is performed directly on the database protocol stream without communicating with a target real database.

公开(公告)号：US20180129708A1

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

申请号：US15344431

申请日：2016-11-04

Applicant: International Business Machines Corporation

Inventor： Thomas A. Beavin ,  Zhang Hao ,  Shuo Li ,  Xiaobo Wang ,  Ke Wei Wei

IPC: G06F17/30

CPC classification number: G06F16/24552 ,  G06F16/2453

Abstract: Disclosed aspects relate to query processing management in a database management system (DBMS). The DBMS may detect that a query has a set of subqueries. The DBMS may detect that the set of subqueries indicates a set of data structures. A lead data structure may be selected from the set of data structures using a selection criterion. A set of input columns may be identified from the lead data structure of the set of data structures. A set of output columns may be identified from the set of data structures other than the lead data structure. A hash data structure may be constructed using the set of input columns and the set of output columns. A cache may be built based on the hash data structure.

公开(公告)号：US20170351594A1

公开(公告)日：2017-12-07

申请号：US15171072

申请日：2016-06-02

Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION

Inventor： Shuo Li ,  Xin Peng Liu ,  Xiaobo Wang ,  Xiong Wei Zhao

IPC: G06F11/36

CPC classification number: G06F11/362

Abstract: This disclosure provides a computer-implemented method for debugging a program including a SQL statement. The method comprises indicating one or more first positions of source code of the program. Each of the one or more first positions corresponds to a fragment of the SQL statement at which a breakpoint can be set. The method further comprises receiving an input of setting breakpoint at one of the one or more first positions. The method further comprises presenting an execution context generated in response to execution of the program reaching a breakpoint set based on the input.