Abstract: A solution for managing data received from multiple sources is provided. In particular, when conflicting data values are received from multiple sources for a data element, a conflict rule is used to determine the main data value for the data element, which is subsequently stored for use. The conflict rule can define any automatic, semi-automatic, or manual procedure for resolving the conflict. The conflict rule, or an identifier thereof, can be stored with each data value and the main data value for the data element.

Abstract: A system and method for determining earned values (EVs) of progress of a project. At least one EV calculation rule is defined for calculating EVs in terms of components to be combined into the EVs, locations in which the components are located, and formulae required to combine the components. The defined at least one EV calculation rule is used to calculate the Evs. The at least one EV calculation rule, which includes the components, the locations, and the formulae, is stored. Defining the at least one EV calculation rule includes: identifying the components used to calculate the Evs; identifying the locations in which the components are located; and identifying the formulae specifying how the components are combined to create the EVs.

Abstract: A method and system for uniformly displaying and reporting uniform project completion information, such as uniform earned value measurements (EV), of a large-scale project having a number of individual subprojects. A set of EV Calculation Rules are defined and used as a guide in creating the uniform EVs. The uniform EVs are calculated, then reported. The EV Calculation Rules used to calculate the uniform EVs include an identification of components of the databases required, the locations of these components and the mathematical formulae used to combine these components. On-demand, scheduled and/or event agents implement the rules to create the EV reports.

Abstract: A system, method and program product for decommissioning database instances. A computer system is disclosed that includes an agent processing system that deactivates agents associated with a database instance; an access processing system that restricts further access to the database instance; and a mailer processing system that deactivates mailing transactions associated with the database instance.

Abstract: A method and system for managing temporary processing agents. Second executable code is selectively loaded into an empty routine which converts the empty routine to a populated routine in a first space. A super agent includes first agent code that includes first executable code, third agent code that includes third executable code and is located contiguous to the first agent code within a contiguous space within the super agent, and the empty routine consisting of non-executable code in the first space within the super agent external to the contiguous space.

Abstract: A system, method and program product for decommissioning database instances. A computer system is disclosed that includes an agent processing system that deactivates agents associated with a database instance; an access processing system that restricts further access to the database instance; and a mailer processing system that deactivates mailing transactions associated with the database instance.

Abstract: A system for managing temporary processing agents. A first code routine is provided as an empty routine in an agent including first executable code, the empty routine consisting of non-executable code. A programming component selectively loads second executable code to the first routine for converting the empty routine to a populated routine. A code element issues a call to the first routine. An agent execution component is responsive to the first routine being a populated routine for executing the second executable code.

Abstract: A system, method and program product for synchronizing spreadsheet data. A system is provided having: a scheduling system for scheduling a first import time, a second import time, a first export time and a second export time; an import system for obtaining a first spreadsheet from a first entity at the first import time, and for obtaining a second spreadsheet from a second entity at the second import time; a synchronization system for synchronizing the first spreadsheet and the second spreadsheet to obtain a first revised spreadsheet and a second revised spreadsheet; and an export system for providing the first revised spreadsheet to the first entity at the first export time, and for providing the second revised spreadsheet to the second entity at the second export time.

Abstract: A method and system is provided to demographically represent and implement one or more projects associated with an entity such as a corporation in a database so that the views into the database reflect a defined hierarchy of the demographics of the project or entity. The views may be created to reflect various aspects such as technological components, physical attributes of the entity, processes, or other attributes. The processes reflected by the views may also provide action based data elements for supporting the activities necessary to accomplish the processes over time. The project and associate views may also be organized by language or geographic requirements. In use, the invention may provide for management and control for large scale projects such as a migration from one organizational state to another.

Abstract: A method and system for displaying and reporting project completion information of a large-scale project having a number of individual subprojects. A rollup agent is employed for acquiring project completion information from a number of subproject databases to provide overall project-wide display and reporting capabilities. The rollup agent collects and organizes the information, and stores it on a rollup database. The rollup agent also interacts with a user to select aspects of any subprojects to report or display. The rollup agent then creates and stores reports of the selected information, or displays the report interactively as a pop-up summary report or a spreadsheet format report to a user. A number of scheduled agents provide scheduled reporting at the subproject level. A number of on demand agents provides the interactive database view, pop-up reporting and spreadsheet reporting for each of the individual subprojects.

Abstract: A method and system is provided to demographically represent and implement one or more projects associated with an entity such as a corporation in a database so that the views into the database reflect a defined hierarchy of the demographics of the project or entity. The views may be created to reflect various aspects such as technological components, physical attributes of the entity, processes, or other attributes. The processes reflected by the views may also provide action based data elements for supporting the activities necessary to accomplish the processes over time. The project and associate views may also be organized by language or geographic requirements. In use, the invention may provide for management and control for large scale projects such as a migration from one organizational state to another.

Abstract: Under the present invention, a distribution list of message recipients within an organization undergoing the IT migration is generated by analyzing the infrastructure of the organization. Once the message recipients are known, they can be grouped into a set of mailing groups. Thereafter, specific message templates can be assigned to each group, and a schedule for sending messages to the message recipients can be set. Messages will then be generated and sent to the message recipients using the message templates assigned to their respective mailing group(s) and the schedule. Responses to the messages will be tracked and processed, and records associated with the message recipients will be updated based thereon. Follow-up messages containing additional questions and/or instructions can be generated and sent using any data that is contained in the responses. Also, “non-responses” can be tracked so that reminder messages can be sent.

Abstract: Under the present invention, a configurable dictionary is provided. The configurable dictionary includes a set of objects that identify: (1) attribute conditions of the computer system to be checked; (2) associated locations within the computer system for checking the attribute conditions; and (3) actions to be taken based on results of the checks for the computer system. The health of the computer system is checked by processing the set of objects in the configurable dictionary. Specifically, the attribute conditions identified in the configurable dictionary are checked at their associated locations, and any necessary action are implemented.

Abstract: A method and system for updating a database structure. The database structure includes a dynamically changing list of control documents. A control document specifies tasks to be performed on the database structure. An agent finds an approved control document on the list such as by looking into a view of control documents. Processing the approved control document includes causing an execution of at least one task on the approved control document. Execution of a such task includes updating of the database structure, and may be implemented by the agent that found the control document or by another agent called by the agent.

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 and computer system for transforming a portion (e.g., a view) of a database into a custom spreadsheet. The transforming includes determining whether to omit in the custom spreadsheet a column that is in the view, determining whether to add to the custom spreadsheet a column that is not in the view, or both. The transforming may also include implementation of rules that control how various portions of the custom spreadsheet are configured.

Abstract: A 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 system, method, and computer program product are provided for synchronizing configuration values between a database and a remote input utility by configuring the database for remote input and loading the configuration values to a control file at the server, and copying the configuration values to a control file at remote system including the input utility, executing the input utility at a remote system using configuration values from the control file at the remote system to prepare data for input to the database, and responsive to the configuration values at the control file of the server, updating the configuration values in the control file at the remote system before migrating the new data from the input utility to the database.

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: A method and system for coordinating a Voice Over Internet Protocol (VoIP) teleconference. A teleconference operator drags the name of invited attendees into a hot window, which connects the invited attendees to a channel for the teleconference. Each invited attendee's name has a status icon associated with it, indicating if the invited attendee is active in the teleconference. Each invited attendee has access to a Graphical User Interface (GUI) that permits the attendee to toggle back and forth between different teleconferences.