International Business Machines Corporation

Matthew Jay Bangel

James A Martin, Jr

Douglas George Murray

Robert G Madsen

Renee Christine Mullins

Scott Denison Hicks

Diane Christy Rauch

Andrew M Chang

William M Houston

Eric J Morin

Victoria Hanrahan-Locke

Victoria A Hanrahan

David M Filiberti

Doug G Murray

Gregory V Feeney

The present invention provides a method, system, and computer program product for identifying data synchronization problems between data in different databases. The method includes: providing first and second databases containing common data; generating a summary of the common data as present in the first database; generating a summary of the common data as present in the second database; determining at least one delta value for the common data between the first and second databases; and generating an analysis view displaying the summary of the common data as present in the first database, the summary of the common data as present in the second database, and the at least one delta value for the common data between the first and second databases.

Method, system, and program product for using analysis views to identify data synchronization problems between databases

Complex nested if-then statement on data objects in a digital computer are organized as a plurality of logical case statements; for each case statement, a set of binary condition arrays is provided and for each data object a condition set. Case statements are executed on the data objects for which a condition array from the set of binary condition arrays matches the condition set for the data object.

System and method for executing complex IF-THEN clauses

A system and computer program product for transferring N table instances X, X, . . . , Xof a table T from a source database S to destination databases D, D, . . . , D, respectively. The method is implemented by executing a computer code by a processor of a computer system. N is at least 1. For I=1, 2, . . . , N the method includes: determining whether the table T has been defined for destination database D, and if it is determined that the table T has not been defined for the destination database Dthen defining the table T for the destination database D; and transferring the instance Xof the N table instances from the source database S into the defined table T of the destination database D.

Transfer of table instances between databases

Maintaining and testing a software application by performing regression testing uses standard reusable test cases from change history records to generate actual test cases. A new test case template is created upon saving a change history entry. A subset of the actual and new test cases is determined, and new actual test cases generated and documented from the subset. The new actual test cases are released after successful verification.

System and method for maintaining and testing a software application

A system and program product for updating a data record of a database to cancel a deployment of a computer workstation. A deployment status is changed from a starting status to a deployed status via intermediate statuses and then the deployment is canceled. From a decision tree stored in the database, a list of identifiers that identifies an ordered list of software routines is generated. An email message is created that includes a selectable object and a hidden field. The list of identifiers is inserted into the hidden field. The email message is sent to a user. The user's selection of the selectable object is received. The list of identifiers is obtained from the hidden field and the software routines are retrieved from the database. The software routines are executed in their order to update the status from deployed to the starting status via updates to the intermediate statuses.

Remotely updating a status of a data record to cancel a workstation deployment

A method, system and computer program product for managing goals. A goal to be achieved by a goal-setter is defined. At least one action to be completed is defined. The at least one action is associated with an achievement of the goal by the goal-setter. One or more goal-setter attributes associated with the goal-setter are specified. At least one of the one or more goal-setter attributes is associated with the goal to facilitate managing the goal.

Comprehensive goal management through the use of an integrated software application

System, method and computer program product for creating, managing, and accessing an information repository including a source database and an archive database. A source database and the archive database are defined to a same schema. A user terminal presents a common user interface for accessing the source database and the archive database. A timed archive agent, an end user archive agent, and a criteria based archive agent archive source data from the source database as archive data to the archive database. A criteria based restore agent and an end user restore agent are provided to restore archive data from the archive database as source data to the source database. An integrated functions agent assembles compiled data from source data and archive data and present the compiled data to the user interface.

System and method for on-demand integrated archive repository

Under the present invention, when an error condition for the computer system is identified, settings for a series of demographical factors of the computer system are determined. These settings are compared to settings for the demographical factors during at least one previous instance of the error condition to identify a similar error scenario. Then any corrective actions that were taken to address the at least one previous instance of the error conditions are determined and possibly used to resolve the current error condition.

Method, system and program product for analyzing demographical factors of a computer system to address error conditions

A script library includes a plurality of common blocks of code including code fragments defined by IF/THEN statements. Packages of parameters forming a data type including a scope parameter are provided in agents which, responsive to being triggered by schedule or menu, issue calls including said scope parameter to functions and procedures said script library. Code fragments bounded by IF/THEN statements within each called function and procedure execute responsive to the scope parameters to operate on entries in a database responsive to other parameters included within the data type.

System and method for controlling the scope of script library code

A database is queried with on demand database query reduction A query document includes global variables selectively set off by first tags identifying a first global variable as a complete replacement variable and by second tags identifying a second global variable as a complete removal string. An agent is provided for building from the query document an expanded query by replacing any variables set off by first tags with runtime strings, setting off any unions in the query document, and selectively replacing any variables set off by second tags and removing the second tags without replacing variables set off by second tags.

System and method for database query with on demand database query reduction

A method for updating a data record of a database to cancel a deployment of a computer workstation. A status of the deployment is changed from a starting status to a deployed status via intermediate statuses and then the deployment is canceled. From a decision tree stored in the database, a list of identifiers that identifies an ordered list of software routines is generated. An Email message is created that includes a selectable object and a hidden field. The list of identifiers is inserted into the hidden field. The email message is sent to a user. The user's selection of the selectable object is received. The list of identifiers is obtained from the hidden field and the software routines are received from the database. The software routines are executed in their order to update the status from deployed to the starting status via updates to the intermediate statuses.

A method, system, and computer program product for transferring N table instances X, X, . . . , Xof a table T from a source database S to destination databases D, D, . . . , D, respectively. The method is implemented by executing a computer code by a processor of a computer system. N is at least 1. For I=1, 2, . . . , N the method includes: determining whether the table T has been defined for destination database D, and if it is determined that the table T has not been defined for the destination database D, then defining the table T for the destination database D; and transferring the instance Xof the N table instances from the source database S into the defined table T of the destination database D.

Under the present invention, index keys are generated for a set of documents. This is typically accomplished by examining the set of documents, and connecting data values extracted from the set of documents to yield the index keys. Once the index keys are generated, an index view will be generated into which the index keys are populated. Using the index keys in the index view, an agent will automatically obtain the set of documents (i.e., in the background). Then, when a user requests one of the documents, the document will already have been retrieved from storage. As such, it can readily be provided to the user. It should be understood that as used herein, the term 'document' is intended to refer to any type of electronically stored data.

Method, system and program product for providing high performance data lookup

A method for performing business control task notification is proposed. The method comprises processing a combination of one or more databases and one or more user profiles to generate a schedule template and receive a request for a schedule. A computer program product compares attributes of the request for the schedule to a user profile and a schedule template to identify one or more events of the schedule template to be accessed from one or more of a plurality of distributed databases and forms a query to be sent to the one or more distributed databases. The query is sent to a particular database among the plurality of distributed databases. The computer program product receives a positive response to the query, indicating that the particular database contains a first event for the schedule, and the event. In response to receiving the event, the schedule is created. The schedule is stored. One or more current events in the schedule requiring a notification are identified, and the notification is sent to a destination.

Growing community of inventors

Poughkeepsie, NY, United States of America

Matthew Jay Bangel