International Business Machines Corporation

Venkatesh S Gopal

Venkannababu Tammisetti

Paul-John A To

James L Finnerty

Ravindra D Aute

Nadiya Kochura

Vinod P Chirayath

Salvador Ledezma

Brajesh Pandey

Zackery M England

Method and apparatus for optimized data partition selection for related queries. A query to be executed over a plurality of data records is received. The plurality of data records comprises a first set of data records stored in a first database distributed across a plurality of partitions and a second set of data records stored in a second database. An input vector is generated based on the query, the first and second databases. The input vector is processed using a machine learning (ML) model to predict a cost for executing the query if one or more data records in the second set of data records are loaded to a first partition of the first database. A plan is selected for loading the one or more data records from the second set of data records to the first partition based on the predicted cost for executing the query.

System and method for efficient query processing

Provided are techniques for estimating most frequent values. A sample of values made up of rows is received from each of multiple nodes. The sample of values from each of the multiple nodes are aggregated to generate a sample table storing the rows. A descending list of most frequent values and associated frequencies is obtained using the sample table. Most frequent values are pruned from the descending list whose associated frequencies are below a minimum absolute frequency. The remaining most frequent values are extrapolated to reflect a data set.

Estimating most frequent values for a data set

Some embodiments include a method for searching a hierarchical database structure of a database management system. In some embodiments, the method comprises detecting text input in a database search field, wherein the text input defines a search for data in the hierarchical database structure, wherein the hierarchical database structure includes items, and wherein the items include one or more of actions to be performed on data in the hierarchical database structure, indexes for looking up data in the hierarchical database structure, and database schemas defining databases in the hierarchical database structure. The method can also comprise selecting items in the hierarchical database structure based on the text input; presenting selectable options, wherein the selectable options are associated with the items in the hierarchical database structure; detecting selection of one of the selectable options, and presenting data associated with the one of the items.

Accessing data and functionality in database systems

According to one embodiment of the present invention, a system for processing queries analyzes statistical information of input data records in relation to a first operation for a query. The system applies the first operation to a plurality of groups of input data records to produce corresponding groups of output data records, and coalesces the sets of output data records to form larger sets of data records for input to a subsequent second operation for the query based on the analysis. Embodiments of the present invention further include a method and computer program product for processing queries in substantially the same manners described above.

Growing community of inventors

Overland Park, KS, United States of America

Venkatesh S Gopal