System and method for on-demand integrated archive repository

1. A method for creating, managing, and accessing an information repository including a source database and an archive database, said method comprising: defining said source database and said archive database to a same schema; providing to a user terminal a common user interface for accessing said source database and said archive database; a processor of a computer system selectively executing a timed archive agent, an end user archive agent, and a criteria based archive agent for archiving source data from said source database as archive data to said archive database, said criteria based archive agent selectively archiving data based on constraints comprising straight scheduled archive, archive on demand, information becoming sensitive, and soft document deletion; said processor selectively executing a criteria based restore agent and an end user restore agent to restore archive data from said archive database as source data directly to said source database, said criteria based restore agent selectively restoring archived data to said source database in response to criteria provided during execution of a scheduled agent such that a Reset button pertaining to said selectively restoring archive data is activated during said execution of said scheduled agent; and said processor executing an integrated functions agent to assemble compiled data from source data and archive data and present said compiled data to said user interface, said method further comprising: displaying a first view of information specific to the source database, said first view displaying a first tab; responsive to user selection of said first tab in the first view, adding a first table of contents to the first view to generate a modified first view followed by displaying the modified first view that displays the first tab and the first table of contents, said first table of contents being a first list of item identifiers that identify items in the source database; responsive to user selection of a first item identifier from the first list of item identifiers in the first view, displaying a first lookup view into source database data of the source database.

2. The method of claim 1 , said method further comprising: displaying a second view of information specific to the archive database, said second view displaying a second tab; responsive to user selection of said second tab in the second view, adding a second table of contents to the second view to generate a modified second view followed by displaying the modified second view that displays the second tab and the second table of contents, said second table of contents being a second list of item identifiers that identify items in the archive database, said first and second views being different views, said first and second tabs being different tabs; and responsive to user selection of a second item identifier from the second list of item identifiers in the second view, displaying a second lookup view into archive database data of the archive database.

3. The method of claim 2 , said method further comprising: compiling database data from said first and second lookup views into a common view; and presenting said common view to said user interface.

4. The method of claim 1 , said method further comprising: maintaining said archive data in said archive database integrated with said source database in a production setting which is outside of a production application; and querying said archive data in live time from said production application.

5. The method of claim 4 , said production application being a client information manager, said information repository further including a deployment database, said method further comprising: defining said deployment database to said same schema; maintaining in said deployment database for each entity of a plurality of entities an asset budget; and operating said production application responsive to said deployment database, said source database, and said archive database to schedule and deploy said assets among said entities.

6. A computer system comprising a processor and a computer readable memory unit coupled to the processor, said memory unit containing instructions configured to be executed by the processor to implement a method for creating, managing, and accessing an information repository including a source database and an archive database, said method comprising: defining said source database and said archive database to a same schema; providing to a user terminal a common user interface for accessing said source database and said archive database; selectively executing a timed archive agent, an end user archive agent, and a criteria based archive agent for archiving source data from said source database as archive data to said archive database, said criteria based archive agent selectively archiving data based on constraints comprising straight scheduled archive, archive on demand, information becoming sensitive, and soft document deletion; selectively executing a criteria based restore agent and an end user restore agent to restore archive data from said archive database as source data directly to said source database, said criteria based restore agent selectively restoring archived data to said source database in response to criteria provided during execution of a scheduled agent such that a Reset button pertaining to said selectively restoring archive data is activated during said execution of said scheduled agent; and executing an integrated functions agent to assemble compiled data from source data and archive data and present said compiled data to said user interface, said method further comprising: displaying a first view of information specific to the source database, said first view displaying a first tab; responsive to user selection of said first tab in the first view, adding a first table of contents to the first view to generate a modified first view followed by displaying the modified first view that displays the first tab and the first table of contents, said first table of contents being a first list of item identifiers that identify items in the source database; responsive to user selection of a first item identifier from the first list of item identifiers in the first view, displaying a first lookup view into source database data of the source database.

7. The computer system of claim 6 , said method further comprising: displaying a second view of information specific to the archive database, said second view displaying a second tab; responsive to user selection of said second tab in the second view, adding a second table of contents to the second view to generate a modified second view followed by displaying the modified second view that displays the second tab and the second table of contents, said second table of contents being a second list of item identifiers that identify items in the archive database, said first and second views being different views, said first and second tabs being different tabs; and responsive to user selection of a second item identifier from the second list of item identifiers in the second view, displaying a second lookup view into archive database data of the archive database.

8. The computer system of claim 7 , said method further comprising: compiling database data from said first and second lookup views into a common view; and presenting said common view to said user interface.

9. The computer system of claim 6 , said method further comprising: maintaining said archive data in said archive database integrated with said source database in a production setting which is outside of a production application; and querying said archive data in live time from said production application.

10. The computer system of claim 9 , said production application being a client information manager, said information repository further including a deployment database, said method further comprising: defining said deployment database to said same schema; maintaining in said deployment database for each entity of a plurality of entities an asset budget; and operating said production application responsive to said deployment database, said source database, and said archive database to schedule and deploy said assets among said entities.

11. A computer program product, comprising a computer readable storage medium having program code stored therein, said program code containing instructions configured to be executed by a processor of a computer system to implement a method for defining said source database and said archive database to a same schema; providing to a user terminal a common user interface for accessing said source database and said archive database; selectively executing a timed archive agent, an end user archive agent, and a criteria based archive agent for archiving source data from said source database as archive data to said archive database, said criteria based archive agent selectively archiving data based on constraints comprising straight scheduled archive, archive on demand, information becoming sensitive, and soft document deletion; selectively executing a criteria based restore agent and an end user restore agent to restore archive data from said archive database as source data directly to said source database, said criteria based restore agent selectively restoring archived data to said source database in response to criteria provided during execution of a scheduled agent such that a Reset button pertaining to said selectively restoring archive data is activated during said execution of said scheduled agent; and executing an integrated functions agent to assemble compiled data from source data and archive data and present said compiled data to said user interface, said method further comprising: displaying a first view of information specific to the source database, said first view displaying a first tab; responsive to user selection of said first tab in the first view, adding a first table of contents to the first view to generate a modified first view followed by displaying the modified first view that displays the first tab and the first table of contents, said first table of contents being a first list of item identifiers that identify items in the source database; responsive to user selection of a first item identifier from the first list of item identifiers in the first view, displaying a first lookup view into source database data of the source database.

12. The computer program product of claim 11 , said method further comprising: displaying a second view of information specific to the archive database, said second view displaying a second tab; responsive to user selection of said second tab in the second view, adding a second table of contents to the second view to generate a modified second view followed by displaying the modified second view that displays the second tab and the second table of contents, said second table of contents being a second list of item identifiers that identify items in the archive database, said first and second views being different views, said first and second tabs being different tabs; and responsive to user selection of a second item identifier from the second list of item identifiers in the second view, displaying a second lookup view into archive database data of the archive database.

13. The computer program product of claim 12 , said method further comprising: compiling database data from said first and second lookup views into a common view; and presenting said common view to said user interface.

14. The computer program product of claim 12 , said method further comprising: maintaining said archive data in said archive database integrated with said source database in a production setting which is outside of a production application; and querying said archive data in live time from said production application.

15. The computer program product of claim 14 , said production application being a client information manager, said information repository further including a deployment database, said method further comprising: defining said deployment database to said same schema; maintaining in said deployment database for each entity of a plurality of entities an asset budget; and operating said production application responsive to said deployment database, said source database, and said archive database to schedule and deploy said assets among said entities.