International Business Machines Corporation

Leilei Li

Shuo Li

Xiaobo Wang

Sheng Yan Sun

Jack Chiu-Chiu Yuan

Akiko Hoshikawa

Ping Wang

Jing Wang

Shyh-Mei Fang Ho

Khiet Quang Nguyen

Dorothy Ching-Hui Lin

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.

Partitional data compression

A computer-implemented method masks shard operations in a distributed database. The method includes performing a shard operation on a first table with a first column and a second column, where the shard operation divides the first table into a first shard with the first column and a second shard with the second column. The method also includes receiving a query, where the query is configured to perform at least a first command. The method further includes determining the first command is directed to the first column. The method includes updating the query to access the first shard in place of the first table. The method also includes executing the query and returning a set of results for the query to a source of the query.

Masking shard operations in distributed database systems

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.

Query efficiency using merged columns

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.

Data-analysis-based facility for adjusting trace fields of a database trace

An improved database-management system determines that a near-capacity leaf page of its database index must be split into multiple pages in order to store newly added index entries. The system determines whether the page should be 'multi-split' into more than two pages, the total number of new pages to be added, and the range of indexed values assigned to each new page. These determinations are made as functions of the frequency with which the index page, and other index pages for the same index, have been split in the past, of the data distribution of values indexed by the leaf page, and of the degree of sequentiality of entries added to the leaf page. Leaf pages approaching capacity may also be scheduled for 'pre-split' splitting during a period of lower utilization. These multi-split and pre-split operations reduce the numbers of index splits and of corresponding synchronous database-log writes.

Multi-page splitting of a database index

A method for handling asynchronous database transactions in a web based environment is disclosed. The method comprise providing a first ID from a device via a dedicated persistent connection and generating a second ID in an application server upon receipt of the first ID. The method also include utilizing the first ID and second ID to obtain the appropriate data from a database system and to send the appropriate data to the device. A method in accordance with the present invention uses a database resource adapter, which runs inside an application server, to generate a socket ID internally for every input transaction running with the dedicated persistent socket connection and also saves the customer-specified client ID for database queue creation and legacy application. This operation is transparent to the customers' client application.

Method for handling asynchronous database transactions in a web based environment

An apparatus, system, and method are disclosed for enabling a conversational transaction in a service oriented architecture. The apparatus, system and method include receiving at an IMS Connect a first conversational transaction ('CT') request comprising a conversation option flag from a Java client over a TCP/IP connection to a first socket of the IMS Connect and transmitting the first CT request to an IMS. The apparatus, system, and method include receiving from the IMS a first response to the first CT request and a conversational transaction identifier ('CTID'), and returning the first response along with the CTID to the Java client in response to the conversation option flag being set. The first response and CTID are transmitted using TCP/IP. The response is a portion of the conversational transaction and the CTID is configured to identify to the IMS subsequent CT requests from the Java client as part of the CT.

Growing community of inventors

San Jose, CA, United States of America

Leilei Li