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:
The present invention provides a configurable field definition document as well as a method, system and program product for configuring a field definition document. Specifically, under the present invention, fields of the field definition document are configured to store values of data elements used by a computer application. The computer application is then mapped to the fields. As needed, values of data elements for the computer application are accessed from the field definition document based on the mapping and at least one selection criterion. The at least one selection criterion can include, for example, a customer identity, a location, a language, a project type, etc.
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:
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:
The present invention provides a method, system, and computer program product for demographic reporting of billable project activity. A method in accordance with an embodiment of the present invention includes: capturing all billable project activity data associated with an information technology (IT) migration project in a database; organizing the billable project activity data into a plurality of billable project activity reports, based on selected demographic criteria; and selecting and displaying a billable project activity report in a user interface (UI).
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:
An improved solution for verifying access to a data object. In particular, the invention automatically determines when access to the data object requires verification and provides an owner of the data object a set of current users for verification. The set of current users can include all or a subset of the users/user groups that have access to the data object. Additionally, an indication of one or more attributes of each user can be provided to the owner to assist in verification. Access information can be updated based on a response from the owner.
Abstract:
A method and system for synchronizing M application rules across N database instances. N and M are each at least 2. A rule synchronization agent is executed which updates N1 database instances with the M application rules and does not update a remaining N-N1 database instances with the M application rules if N1 is equal to N. N1 is at least 1. If N1 is less than N, then each of the remaining N-N1 database instances include a first and/or second characteristic. The first characteristic is that the remaining database instances include the M application rules upon initiation of the executing. The second characteristic is that the agent is unable to access the remaining database instance during the executing.
Abstract:
Aspects of the present invention provide a solution for managing database agents. Specifically, an embodiment of the present invention produces a predetermined number of replica databases for running the agents. Agent scheduling documents are produced and parsed to determine on which database the agent should be run and on which database the agent should run if the first choice of databases is not functioning. The agent scheduling documents also specify whether running of a specific agent has certain prerequisites, such as a time constraint and/or whether its running is dependent upon successful completion of another agent.