International Business Machines Corporation

Gaurav Mehrotra

Abhinay Ravinder Nagpal

Sandeep R Patil

Rulesh F Rebello

Pratik P Paingankar

Nishant Kumar Sinha

Nirmal Kumar

Kapish Kumar

Yan Wang Stein

Laurent Sebastien Mignet

Hrishikesh Sujaya Kumar

Praveen R Sogalad

Pravin Kailashnath Kedia

Harjindersingh G Mistry

Rohit Raut

Jain Sachinkumar

Madlen Niekammer

Jagadisha Bhat

Computer implemented methods, systems, and computer program products include program code executing on a processor(s) that obtains a user query. The program code selects just in time (JIT) statistics relevant for use by a cost optimizer to generate a plan file for executing the user query by determining, based on JIT metadata in a JIT statistics cache, if JIT statistics generated responsive to an earlier event are these JIT statistics, and based on determining that the JIT statistics generated responsive to the earlier event are these JIT statistics, selects these JIT statistics to generate the plan file. The program code utilizes the cost optimizer to generate the plan file based on these JIT statistics. The program code executes the user query in the target database based on the plan file.

Query optimization for planner statistics for databases

A computer-implemented method includes writing a plurality of change records to a first set of redo records in a first transaction log file. The computer-implemented method further includes determining, while writing a change record to a redo record, that the change record includes changes made to data associated with an in-scope table. The computer-implemented method further includes updating the first transaction log file with information indicating that the redo record includes changes made to data associated with the in-scope table. The computer-implemented method further includes accessing the first transaction log file from storage in response to receiving a request for replicating changes made to data associated with in-scope tables. The computer-implemented method further includes scraping a first redo record in the first transaction log file in response to determining that the first redo record includes at least one change record associated with the in-scope table.

Asynchronous replication of in-scope table data

A dynamically self-indexing database-management system selects database indexes associated with table columns that are most frequently accessed by user queries, deleting all other indexes. The system periodically reviews database-performance figures and data-usage patterns for each table of its database and revises its selection of indexes in order to ensure that only the most frequently accessed columns continue to be indexed and that the omission of other indexes does not degrade performance. The total number of selected indexes, the overall percent of selected indexes, or the selection itself is optimized over time through continued monitoring of database transaction logs. Optimization may comprise cognitive analytics or other methods of artificial intelligence by which the system learns over time how to best determine whether its current selection of indexes is likely to provide the best overall performance.

Dynamically self-indexing database-management system

In an approach for database log management and log access performance improvement, a processor receives an access request for an optimal control file to minimize a database access performance impact. A processor determines the optimal control file based on usage of a plurality of control files for a database. A processor outputs the optimal control file to a user to access the database. A processor provides an incremental sub-control file of the optimal control file to the user. The incremental sub-control file is an incremental view of the optimal control file to query the incremental log data in the database.

Database access performance improvement

A system receives one or more messages including information related to one or more issues associated with a software application installed on a user device. In response to receiving the message, a processor in the system identifies a user context associated with the user device, wherein the user context comprises usage information related to the software application. The processor further analyzes the received information and the user context associated with the user device to determine one or more errors associated with the software application. One or more software updates that are available and associated with the one or more errors are determined. The system automatically installs one or more of the determined software updates on the user device. Embodiments of the present invention further include a method and computer program product for managing and installing one or more software updates in substantially the same manner as is described above.

Cognitive installation of software updates based on user context

A means for assigning database objects to a backup storage group proceeds by collecting information related to a plurality of backup devices. The information collected includes speed of recovery, time to backup, and a recovery rank for each device. A backup pool is defined, using a database configuration parameter, to contain one or more of the plurality of backup devices. A determination is made to store a backup of a data object in a first device of the plurality of backup devices based on the collected information and a priority rank associated with the data object.

Backup optimization in hybrid storage environment

Disclosed aspects relate to database object management for a shared pool of configurable computing resources. A set of database object profile data is collected. The set of database object profile data is for a set of database objects. Based on the set of database object profile data, a set of database object priority values is determined. The set of database object priority values is for the set of database objects. Based on the set of database object priority values, a management action is performed. The management action is performed with respect to the set of database objects.

Database object management for a shared pool of configurable computing resources

The present invention includes a computer-implemented method including, classifying a data set in response to metadata corresponding to one or more data files located on a single database; and creating a data file topology comprising a data file identifier, a data file location and a data file type. The method may also include receiving a predetermined rule directory comprising a set of features corresponding to one or more file systems; and in response to the data file topology and the predetermined rule directory, reorganizing the data set such that at least a portion of the data set is moved to one of a set of new file systems having a predetermined optimized characteristic.

Intelligent redistribution of data in a database

A method of operating a cooling system for a hardware component is disclosed. The cooling system comprises one or more cooling devices and the method comprising the steps of monitoring commands that result in one or more operations for the hardware component, detecting a command that will result in a processing intensive operation for the hardware component, and operating a cooling device to cool the hardware component, in response to the detected operation. In a preferred embodiment, following the detection of a command that will result in a processing intensive operation for the hardware component, a predefined profile for the specific operation is accessed, and the operation of the cooling device to cool the hardware component, in response to the detected operation, comprises operating the cooling device according to predefined profile. The profile can be created automatically following previous operations.

Cooling system

A method and system for automatically and transparently managing a directory in a database system to preferentially use of objects in an in-memory database instead of copies of the objects in disk-based databases, in order to speed up application response times. The methods and systems selectively add or update LDAP entries to leverage advantage of the database objects in the in-memory database, so that the LDAP entries point to the in-memory database instead of disk-based databases.

System and method for managing directories for a database system having an in-memory database

Provided are techniques for selecting a first group of indexes to form a current generation of indexes, selecting indexes from the first group biased to indexes with higher fitness values from the current generation of indexes, forming sub-groups of indexes using the selected indexes, determining fitness values of each of the sub-groups based on the fitness value of each of the indexes, selecting a subset of the sub-groups; and placing the indexes in the selected sub-groups into a new generation of indexes.

Enhancing data store backup times

A data query instruction for execution is received, wherein execution of the data query instruction is to cause a data transfer into or from a data warehouse. The data warehouse includes data servers that are communicatively coupled for data transfer through a link aggregation group having at least two data links. Responsive to receiving the data query instruction and prior to or at least partially overlapping with execution of the data query instruction to cause the data transfer, which of the number of data servers are to receive or transmit data as part of the data transfer is identified; for each of the identified data servers, a minimum number of the at least two data links that are needed for the data transfer are identified; and if inactive, the minimum number of the at least two data links for each of the identified data servers are activated.

Growing community of inventors

Pune, India

Gaurav Mehrotra