International Business Machines Corporation

Arron J Harden

Julian J Vizor

Wendi L Nusbickel

Leonard D Greenwood

Ivan Matthew Milman

Xiaoyan Pu

Jeff Jianfei Li

Alex Swain

Joseph Bangs

Brian K Caufield

Martin J Sanders

Richard K Morris

Aarti D Borkar

Provided are techniques for interactive social media access to data systems. A social media gateway interface with adapters for each of multiple social media applications is provided. An event is published from a data system to at least one of the multiple social media applications. A social media bot is created to represent the data system. The social media bot and one of the adapters are used to enable the data system to interact with at least one of the multiple social media applications.

Interactive social media access to data systems

A method for extract transform load (ETL) input suggestions for an ETL system in which a current job is being created. A method includes: determining when a new input is made in the current job in the ETL system and dynamically receiving the new input which includes a connection between stages input or a property of a stage input; updating stored information relating to the current job with the new input; accessing rules which apply to the current job; analyzing and applying the rules based on the new input and the current job stored information to generate one or more suggested next inputs in the current job; providing a weighting for the one or more suggested next inputs based on the analysis and application of the rules; and providing a prompt in the current job in the ETL system with the suggested one or more next inputs and their weightings.

Extract transform load input suggestion

According to an embodiment of the present invention, a system for generating one or more test cases for a service of a server system comprises at least one processor. The system analyzes metadata associated with the service to generate a schema definition for inputs and outputs of the service. A description of the service is generated in an application description language that refers to the schema definition. The system processes the generated description of the service to produce the one or more test cases. Embodiments of the present invention further include a method and computer program product for generating one or more test cases for a service in substantially the same manner described above.

Automatic test case generation

Embodiments relate to integrating data transform test with a data transform tool. A method and system are described for creating a data transform test for a data transform job having a data transform script, the method includes determining all data transform units available in the data transform job, determining a subset of the available data transform units for a new test, and generating a subset test execution script for the subset of data transform units from the data transform script. The method further includes determining boundary test data at each boundary of the subset of data transform units, defining a data transform test, and saving the data transform test for later testing. The data transform test includes the subset of data transform units with subset test execution script and with boundary test data.

Integrating data transform test with data transform tool

A method, system, and/or computer program product encodes diagnostic data in an error message for a computer program. In response to an error in the processing of a computer program, a predetermined set of diagnostic data associated with the error is selected. The predetermined set of diagnostic data is encoded in an image, and the image is displayed in association with an error message for the error.

Encoding diagnostic data in an error message for a computer program

Methods and systems are provided for extract transform load (ETL) input suggestion for an ETL system in which a current job is being created. A method includes: determining when a new input is made in the current job in the ETL system and dynamically receiving the new input; updating stored information relating to the current job with the new input; accessing rules which apply to the current job; analyzing and applying the rules based on the new input and the current job stored information to generate one or more suggested next inputs in the current job; providing a weighting for the one or more suggested next inputs based on the analysis and application of the rules; and providing a prompt in the current job in the ETL system with the suggested one or more next inputs and their weightings.

A controller is coupled to an Extract-Transform-Load (ETL) processor, which is connected to data storage devices. The controller comprises: a hardware storage device; a storage control component for storing, on said hardware storage device, a set of criteria for preferredness of ETL stage placements; an I/O input device detecting component for recognizing a proposed placement of a stage on a GUI canvas on the display device; an analytical component for analyzing an eventual result of the proposed placement in an ETL activity represented on the GUI canvas; a comparator for comparing the eventual result of the proposed placement in the ETL activity with the set of criteria; and an indicator control component for, responsive to an outcome of an operation of the comparator, providing to the user an indicator of a degree of preferredness of said proposed placement according to the set of criteria.

Extract-transform-load processor controller

Methods and systems for graphically emphasizing a selected path through a diagram, where the diagram includes a number of nodes and a number of lines, the methods and systems including: applying a node highlight effect to a node of the number of nodes in the selected path, where applying the node highlight effect includes applying a node shadow to the node, applying a line highlight effect to a line of the number of lines in the selected path, where applying the line highlight effect includes applying a line shadow to the line, applying a node fade effect to a node of the number of nodes not in the selected path, and applying a line fade effect to a line of the number of lines not in the selected path.

Method and system for graphically emphasizing a path through a diagram

Provided are a computer implemented method, computer program product, and system for presenting information about multiple data series. The multiple data series are obtained. A main graphing area with a graph showing one or more of the obtained data series, an active process execution metrics area with information about the one or more obtained data series shown in the graph, and an available process execution metrics area with one or more thumbnail views of one or more of the obtained data series available for selection to be shown in the graph are displayed.

Growing community of inventors

Olney, United Kingdom

Arron J Harden