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: 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: Data languages, executable programs, and user interfaces are synchronized by a database for storing data enumerations in a first language, a configuration file for mapping language neutral tags to the data enumerations, a user interface operable responsive to the language neutral tags for presenting to a user interface view selected data enumerations in the second language; the user interface responsive to user selection at the user interface view of a data enumeration in the second language corresponding to a selected language neutral tag for accessing the configuration file to retrieve a corresponding data enumeration in the first language, and for returning the corresponding data enumeration to the database.

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: 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: 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: 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: 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: 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: 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: 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 system for synchronizing M application rules across N database instances. Each database instance has a same structural design. 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: A method and system for synchronizing M application documentations across N database instances. Each database instance has a same structural design. N and M are each at least 2. A documentation synchronization agent is executed which updates N1 database instances with the M application documentations and does not update a remaining N-N1 database instances with the M application documentations 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 documentations upon initiation of the executing. The second characteristic is that the agent is unable to access the remaining database instance during the executing.

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 system, method and program product for centrally managing agents are provided. Specifically, under the present invention, master agents stored in a control database of a control system are scheduled to execute remote agents stored in remote databases of remote systems. Once executed by the master agents, the remote agents will implement functions thereto. By providing centralized management of agents in this manner, agent scheduling conflicts are prevented.

Abstract: A system and method for controlling access to an ACL list protected database. Each of one or more access control documents includes a start time or an end time, and a start access control list or an end access control list. An access control agent permits access to the database after the start time by reference to the start access control list and after the end time by reference to the end access control list.

Abstract: A method and computer system for generating and maintaining database instances. A template manager creates the template for generating the instances based on design information, stores the template in a template manager database, generates N instances (N?2) based on the template and on control information for the N instances, stores the N instances in the template manager database, and transmits the N instances to corresponding N locations. The control information includes access control information and configuration control information that includes identification of N locations corresponding to the N instances. The template manager refreshes the template based on update design information, refreshes the N instances based on the refreshed template, and transmits the N refreshed instances to the corresponding N locations. The template manager may refresh M of the N instances (M?N), based on update control information, and transmit the M refreshed instances to the corresponding M locations.

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 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: Periodically clearing databases of stored conflicting replicated documents in a regular automatic way which comprises a combination of defining a prioritized sequence of predetermined attribute values to be applied to distinguish between the stored documents in each of said replication conflicts and periodically applying said sequence of predetermined attribute values to said plurality of replication conflicts to resolve each conflict by eliminating all but one of the documents in said conflict for insufficient value of a predetermined attribute. This prioritized sequence of attribute values may be applied at regular periodic intervals.