System for multidimensional database administration

Patent metadata

Field	Value
Publication number	US-2017103100-A1
Application number	US-201514881623-A
Country	US
Kind code	A1
Filing date	Oct 13, 2015
Priority date	Oct 13, 2015
Publication date	Apr 13, 2017
Grant date	—

Abstract

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.

First claim

What is claimed is:

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, and
in 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.

2 . The system of claim 1 , wherein the database administration module is further configured to automatically validate a plurality of database scripts prior to execution of the database scripts, wherein validation of the database scripts includes checking for syntactical errors and non-approved commands within the database scripts for each of the plurality of databases servers and for each of the databases stored on the database servers.

3 . The system of claim 2 , wherein the database administration module is further configured to, in response to the validation resulting in failure of one or more database scripts, automatically generate a report that includes one or more non-approved commands within the one or more scripts that failed validation.

4 . The system of claim 1 , wherein the database administration module is further configured to automatically validate one or more database backups prior to execution of the database scripts, wherein validation of the database backups includes checking an integrity of the database backup file and generating a corresponding report.

5 . The system of claim 1 , wherein the database administration module further comprises a sequence manager configured to automatically manage database script deployment sequence for more than one database script, wherein computer-script deployment sequence is dependent on at least one of the database server and the database on which the more than one database script is to be executed.

6 . The system of claim 1 , wherein the database administration module is further configured to receive a fourth user-selection, prior to executing the one or more database scripts, that provides for one of (1) execution of the computing scripts to be interrupted in response to detection of an error, or (2) execution of the computing scripts to be uninterrupted in response to detection of an error.

7 . The system of claim 1 , wherein the database administration module is further configured to automatically track the execution of the selected one or more database scripts on the selected databases of the selected database servers, wherein tracking the execution includes logging (1) the database servers on which the one or more database scripts are executed, (2) the databases on which the one or more database scripts are executed, and (3) sequence in which the one or more database scripts are executed.

8 . The system of claim 1 , wherein the database administration module is further configured to automatically track the execution of the selected one or more database scripts on the selected databases of the selected database servers, wherein tracking the execution includes identifying database scripts that executed successfully, identifying database scripts that failed to execute successfully and identifying errors occurring on database scripts that failed to execute successfully.

9 . The system of claim 1 , wherein the database administration module is further configured to, in response completion of the execution of the selected one or more database scripts, generate a report that includes one or more of (i) results of the execution of the selected one or more database scripts, (ii) failure causes for each database script that failed to execute successfully, (iii) segmentation of errors occurring on each database script, and (iv) time of execution for each of the computing scripts.

10 . A computer-implemented method for database administration, the method comprising:
receiving, by a computing device processor, a first user-selection of one or more database scripts; receiving, by a computing device processor, 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; receiving, by a computing device processor, 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, and in response to receiving the first, second and third user-selections, automatically connecting, by a computing device processor, to the selected database servers to execute the selected one or more database scripts on the selected databases, wherein the database scripts are configured to execute absent a server-side script deployment agent.

11 . The method of claim 10 , further comprising automatically validating, by a computing device processor, a plurality of database scripts prior to execution of the database scripts, wherein validation of the database scripts includes checking for (i) syntactical errors and (ii) non-approved commands within the database scripts for each of the plurality of databases servers and for each of the databases stored on the database servers.

12 . The method of claim 10 , further comprising to automatically validating, by a computing device processor, one or more database backups prior to execution of the database scripts, wherein validation of the database backups includes checking an integrity of the database backup file and generating a corresponding report.

13 . The method of claim 10 , further comprising automatically managing, by a computing device processor, database script deployment sequence for more than one database script, wherein computer-script deployment sequence is dependent on at least one of the database server and the database on which the more than one database script is to be executed.

14 . The method of claim 10 , further comprising receiving, by a computing device processor, a fourth user-selection, prior to executing the one or more database scripts, that provides for one of (1) execution of the computing scripts to be interrupted in response to detection of an error, or (2) execution of the computing scripts to be uninterrupted in response to detection of an error.

15 . The method of claim 10 , further comprising automatically tracking, by a computing device processor, the execution of the selected one or more database scripts on the selected databases of the selected database servers, wherein tracking the execution includes logging (1) the database servers on which the one or more database scripts are executed, (2) the databases on which the one or more database scripts are executed, and (3) sequence in which the one or more database scripts are executed.

16 . The method of claim 10 , further comprising automatically tracking, by a computing device processor, the ex

Assignees

• Bank Of America

Inventors

• Sharma Anant Bondalapati
• Neti Kodanda Rama Krishna
• Yadav Badelal Rameshwar Prasad

Classifications

• G06F16/2365 Primary

  Ensuring data consistency and integrity · CPC title

• H04L67/10

  in which an application is distributed across nodes in the network (software deployment G06F8/60; multiprogramming arrangements G06F9/46) · CPC title

• G06F16/2455

  Query execution · CPC title

• G06F11/0709

  in a distributed system consisting of a plurality of standalone computer nodes, e.g. clusters, client-server systems · CPC title

• G06F11/079

  Root cause analysis, i.e. error or fault diagnosis (in a hardware test environment G06F11/22; in a software test environment G06F11/36) · CPC title