SYSTEM FOR MULTIDIMENSIONAL DATABASE ADMINISTRATION

摘要

The present invention provides for multidimensional automated database administration, such that, multiple database scripts can be deployed and executed across multiple database servers and the multiple databases stored therein. In addition, the present invention manages the sequence/order in which the scripts are automatically deployed/executed and provides for automated tracking of execution results including error tracking on a per script basis. Additionally, the invention can be deployed in a distributed network allowing for cross domain connectivity to the database servers for the purpose of executing the database scripts without requiring deployment of server-side script deployment agents.

主权项

1. A system for automated administration of databases, the system comprising:
a plurality of database servers, each database server storing one or more databases; a computing platform having a memory and at least processor in communication with the memory; and a database administration module stored in the memory, executable by the processor and configured to be accessible to a user within a distributed network to:
receive a first user-selection of one or more database scripts,receive a second user-selection of one or more of the database servers on which the selected one or more database scripts are to be deployed,receive a third user-selection of one or more databases stored in the one or more selected database servers on which the selected one or more database scripts are to be executed, andin response to receiving the first, second and third user-selections, automatically connect to the selected databases servers to execute the selected one or more database scripts on the selected databases, wherein the database administration module is configured to execute the database scripts absent a server-side script deployment agent.