Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: Discloses are a method of and system for allocating resources in an enterprise. The method comprises the steps of identifying a number of areas of the enterprise that need resources, and determining an initial allocation of resources to each of said areas. The method comprises the further steps of establishing an algorithm to assign weights to said initial allocations, using said algorithm to determine weighted allocations of resources for each of said areas, and keeping said weighted allocations for a given time period. As resources become available during said defined time period, said available resources are assigned to said areas based on said weighted allocations.

Abstract: The schema of a database may be modified by selectively entering original data to an original database having an original schema; opening the original schema in a user interface; operating the user interface to make changes to the original schema; responsive to the changes being saved, creating a new schema with the changes, creating a backup table with the original schema and copying original data entered to the original database to the backup table, testing the original data with respect to the new schema to identify cases requiring modification of the data to conform to the new schema; and copying the original data as selectively modified from the backup table to the a new database having the new schema.

Abstract: 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.

Abstract: 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.

Abstract: A method and system for updating, from a client computing unit, a data record of a database. Initial and target statuses of the data record are obtained. A list of identifiers is automatically determined to identify actions in a sequence that, when executed, updates the data record from the initial status to the target status. Each action is pre-programmed in and executable by a database management system managing the database. The client computing unit receives an e-mail that includes a selectable object and the list of identifiers. The selectable object is selected at the client computing unit without utilizing a database view. In response to selecting the object, the identifiers are retrieved to identify the actions in the sequence, and the actions are automatically executed in the sequence to update the data record from the initial status to the target status.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: Under the present invention, a set of files (e.g., two ASCII files) is imported. The files identify the users that are being re-assigned, as well as the business units involved with the reassignment. Information is extracted from the set of files and used to locate affected documents in a set of databases. Once located, the documents are automatically updated to reflect the reassignment of the users.

Abstract: 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.

Abstract: 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.

Abstract: A method, system, and computer program product for transferring N table instances X1, X2, . . . , XN of a table T from a source database S to destination databases D1, D2, . . . , DN, 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 DI, and if it is determined that the table T has not been defined for the destination database DI, then defining the table T for the destination database DI; and transferring the instance XI of the N table instances from the source database S into the defined table T of the destination database DI.

Abstract: 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.

Abstract: 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.