International Business Machines Corporation

Kapish Kumar

Azad Khan

Gaurav Mehrotra

Praveen R Sogalad

Sheshnarayan Agrawal

Rulesh F Rebello

Juilee A Joshi

Abhinav Radke

Hemlata Bhatt

Gaurav Saxena

Rohit Kumar Pandey

Apoorv Kapse

Rohit Raut

Prabhu S Padashetty

Shobhit Shukla

Jain Sachinkumar

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

Enabling drag and drop operations between disparate file formats is provided. An indication that a user dragged and dropped a source information item having a particular file format into a local application of a data processing system is received by an operating system of the data processing system. The local application utilizes a different file format from the particular file format of the source information item. Relevant content that corresponds to the local application is identified by the operating system in the source information item. The relevant content corresponding to the local application is extracted by the operating system from the source information item. The relevant content extracted from the source information item having the particular file format is incorporated by the operating system into the local application that utilizes the different file format from the particular file format of the source information item for use by the local application.

Artificial intelligence-based operating system for drag and drop operations

The indication of a database backup process starting is received. A plurality of buffer manipulator threads are marked as active. A determination is made whether any of the plurality of buffer manipulator threads marked as active in the database backup process become idle. In response to determining that at least one buffer manipulator thread in the database backup process becomes idle, the at least one idle buffer manipulator thread is reassigned to a first largest tablespace in the database that has not completed the database backup process. The first largest tablespace has a largest storage capacity relative to other tablespaces in the database.

Database backup performance

Real-time summarization of an online meeting is accomplished using a cognitive system that analyzes meeting content and generates a mini-presentation, i.e., a small number of slides that condense more extensive details. The summary allows an attendee to easily and quickly review portions of the meeting that were missed, while the meeting is still ongoing. The cognitive system can customize the summary for the attendee based on the attendee's role or information in the meeting content which has previously been presented to the attendee. A user interface has a special scrollbar divided into multiple sections corresponding to different topics of the summary. The presentation window can switch from current content to previous content when the attendee selects a particular section. A feedback mechanism may also be used to assist the presenter with future presentations, based on subjects raised in audience interaction that were topics of the meeting.

Enhancing online remote meeting/training experience using machine learning

A video player that can launch a program from the video player while a video relating to the program (for example, a tutorial video) is being played. Also, a video player that can start a video location at a time location that is determined by a program location currently being executed by a computer program being run by the user. In order to do these things, a mapping is maintained between time ranges in the video and program locations to which the time ranges of the video respectively relate.

Video integration using video indexing

A method, computer program product, and a system where a processor(s) monitors communications between one or more clients to a query engine, to identify requests to execute queries on the database resource. Based on identifying a requested query, the processor(s) applies cognitive analysis algorithms to parse components of the requested query, to identify components in the requested query that indicate an execution success measure for the requested query. The processor(s) determines the execution success measure for the requested query and assigns an execution action to the requested query: pre-empting the requested query or executing the requested query. The processor(s) facilitates this action on the requested query.

Machine-learning to alarm or pre-empt query execution

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 method, system and computer readable media are provided to generate short video notes (v-notes) from one or more videos. A series of inputs including playback commands from a user is received. By utilizing a machine learning system, the received inputs can be analyzed for video content to identify which portions are of importance. A customized v-note, smaller in size than the one or more videos, may be generated by aggregating the identified portions of video content from the one or more videos, wherein the v-note is customized to the user, based upon received inputs from the user.

Generating video-notes from videos using machine learning

Disclosed aspects relate to automated query modification in a database management system (DBMS). A triggering event related to an execution of a query may be detected by an automated query modification engine. A query modification operation may be determined by the automated query modification engine based on a nature of the triggering event. The query modification operation may be determined to debug the triggering event related to the execution of the query. The query modification operation may be carried-out by the automated query modification engine. The query modification operation may be carried-out to modify the query to debug the triggering event related to the execution of the query.

Growing community of inventors

Bengaluru, India

Kapish Kumar