Automated dependency graph builder system and network management

Abstract

An automated dependency graph builder system builds a dependency graph for managing a network. The automated dependency graph builder system and network management can utilize networks (e.g., telecommunication networks) and/or systems for providing, and/or being communicatively connected with, the telecommunication networks. The automated dependency graph builder system and network management can execute a script orchestration engine to sort database scripts, and execute database scripts according to script execution orchestrator information.

What is claimed is: 
     
       1. A method comprising:
 retrieving, by a central server and from a telecommunication network, network data associated with at least one network device in the telecommunication network; 
 storing, by the central server, the network data in a first database communicatively coupled to the central server; 
 obtaining, by an automation server and from the first database, the network data; 
 executing, by the automation server, an automated script orchestration engine; 
 analyzing, by the automation server and via execution of the automated script orchestration engine, a plurality of database management scripts including a first database management script, a second database management script, and a third database management script; 
 generating, by the automation server, script execution order information associated with the plurality of database management scripts, wherein the generating is based on priority information of each of the plurality of database management scripts, wherein the script execution order information indicates a dependency of the second database management script and the third database management script on the first database management script and respective priority information of the second database management script and the third database management script indicates that the second database management script and the third database management script have an equal priority, with a result that the first database management script is executed first and the second database management script and the third database management script are executed second, in parallel; 
 executing, by the automation server and according to the script execution order information, the first database management script, the second database management script, and the third database management script, the network data being extracted, transformed, and loaded, as curated data, in a second database based at least in part on execution of the first database management script, the second database management script, and the third database management script; 
 transmitting, by the automation server and to a user device accessing the second database, first report data associated with the curated data; 
 displaying, by the user device, the first report data; 
 transmitting, by the user device and to the telecommunication network, network management data, based at least in part on at least one user selection received via user input to the user device; 
 at least one of maintaining, modifying, or deactivating a network device of the at least one network device being identified via the network management data; 
 receiving, by the automation server and from the user device, a fourth database management script, the fourth database management script being received as an updated database management script to replace the second database management script; 
 dynamically executing, by the automation server and according to the script execution order information, the first database management script and the fourth database management script, wherein additional data is extracted, transformed, and loaded as additional report data in the second database to replace the first report data based at least in part on execution of the first database management script and the fourth database management script, and the execution of the first database management script and the fourth database management script is triggered by the automation server after identifying that the fourth database management script is received; and 
 modifying the displaying of the first report data by displaying, by the user device, the additional report data. 
 
     
     
       2. The method of  claim 1 , wherein the script execution order information includes dependency information, and the execution includes automated execution of the first database management script and the second database management script based at least in part on the dependency information, the dependency information including a first priority value associated with the first database management script and a second priority value associated with the second database management script, the first database management script being executed prior to the second database management script based at least in part on the first priority value being greater than or equal to the second priority value. 
     
     
       3. The method of  claim 1 , wherein the script execution order information includes dependency information indicating that at least one log value generated by the first database management script is accessed by the second database management script. 
     
     
       4. The method of  claim 1  wherein the script execution order information is associated with log data that is generated by the first database management script and that is at least one of obtained or modified by the second database management script. 
     
     
       5. The method of  claim 1 , further comprising:
 causing, by the user device being communicatively connected to the automation server, the at least one network device in the telecommunication network to be managed based at least in part on the at least one user selection identified via the user input to the user device, the at least one user selection being identified based at least in part on the first report data being received by the user device. 
 
     
     
       6. The method of  claim 1 , wherein:
 the user device identifies the at least one user selection via user input to the user device based at least in part on the first report data, and 
 the user device transmits to the at least one network device, a control signal including the network management data, based at least in part on the at least one user selection, the control signal being utilized to at least one of modify or deactivate the at least one network device based at least in part on the first report data indicating the at least one network device is defective. 
 
     
     
       7. The method of  claim 1 , wherein the user device automatically generates an error signal, based at least in part on the first report data, the error signal being transmitted to the automation server, and the method further comprises:
 automatically generating, by the automation server, a request signal for additional raw data based at least in part on the error signal, the request signal by transmitted by the automation server and to the central server, the additional raw data being retrieved by the central server and from the telecommunication network, the central server storing the additional raw data in the first database. 
 
     
     
       8. The method of  claim 1 , wherein the first report data being displayed includes the first report data being presented by a display of the user device, the first report data being presented as updated report data to replace previous report data, the previous report data being previously presented by the display. 
     
     
       9. A first server comprising:
 one or more processors; and 
 non-transitory memory storing computer-executable instructions that, when executed by the one or more processors, cause the one or more processors to perform operations comprising:
 receiving data from a second server; 
 receiving, from a first operator device, a first database management script; 
 receiving, from a second operator device, a second database management script; 
 receiving, from a third operator device, a third database management script; 
 generating first script execution order information by analyzing a plurality of database management scripts including the first database management script, the second database management script, and the third database management script, wherein the generating is based on priority information of each of the database management scripts, the first script execution order information indicates a dependency of the second database management script and the third database management script on the first database management script respective priority information of the second database management script and the third database management script indicates that the second database management script and the third database management script have an equal priority, with a result that the first database management script is executed first and the second database management script and the third database management script are executed second, in parallel; 
 executing, according to the first script execution order information, the plurality of database management scripts, the data being at least one of extracted, transformed, or loaded as updated data in a database based on execution of the plurality of database management scripts; 
 transmitting, to an administrator device accessing the database, first report data associated with the updated data, to display the report data by the administrator device; 
 receiving, from the second operator device, a fourth database management script, the fourth database management script being received as an updated database management script to replace the second database management script; 
 dynamically executing according to additional script execution order information, the first database management script and the fourth database management script, wherein additional data is extracted, transformed, and loaded as additional report data in the database to replace the first report data based at least in part on execution of the first database management script and the fourth database management script after identifying the fourth database management script being received; and 
 transmitting, to the administrator device, the additional report data to modify the displaying of the first report data by displaying the additional report data. 
 
 
     
     
       10. The first server of  claim 9 , wherein:
 generating the first script execution order information further comprises:
 identifying, based on predetermined keyword and syntax information, a portion of the second database management script on which the first database management script depends for successful execution of the first database management script; and 
 identifying dependency information of the first script execution order information based on the portion of the second database management script, wherein executing the plurality of database management scripts comprises executing the first database management script prior to the second database management script, based on the dependency information; and 
 
 the operations further comprise:
 causing presentation by the administrator device of the first report data, by transmitting software application data utilized by a program being executed by the administrator device to display the first report data. 
 
 
     
     
       11. The first server of  claim 9 , the operations further comprising:
 transmitting an error signal to the second operator device, the second operator device presenting an error notification via a display of the second operator device, wherein the fourth database management script is received as the updated database management script based on at least one user selection received via user input to a user interface (UI) of the second operator device. 
 
     
     
       12. The first server of  claim 9 , the operations further comprising:
 identifying an error value associated with the generating of the first script execution order information, the error value being associated with an absence, in the plurality of database management scripts, of a fifth database management script, based on the fifth database management script being identified in a list of database management scripts scheduled for execution; and 
 transmitting an error signal to a fourth operator device, the fourth operator device presenting an error notification via a display of the fourth operator device. 
 
     
     
       13. The first server of  claim 9 , the operations further comprising:
 identifying, based on language pattern and syntax dependency information, that successful execution of the second database management script and the third database management script relies on prior execution of the first database management script; 
 identifying an error value indicating an absence of the first database management script; 
 transmitting an automated message to the first operator device to request the first database management script; and 
 receiving, from the first operator device, the first database management script. 
 
     
     
       14. The first server of  claim 9 , wherein:
 the first script execution order information includes a first priority value associated with the first database management script, and a second priority value associated with the second database management script, the first priority value being generated based on execution of the first database management script being utilized to write at least one data value into a table, the second priority value being generated based on execution of the second database management script being utilized to at least one of identify or modify the at least one data value in the table, and 
 the first script execution order information is used to control the first database management script to be executed prior to the second database management script, based on the first priority value being greater than or equal to the second priority value. 
 
     
     
       15. The first server of  claim 9 , the operations further comprising:
 transmitting, by the administrator device and to a user device, the first report data associated with the updated data; 
 identifying, by the user device, at least one user selection via user input to the user device based at least in part on the first report data; and 
 transmitting, by the user device and to at least one network node, a control signal, based at least in part on the first report data, the control signal being utilized to at least one of modify or deactivate the at least one network node based at least in part on the first report data indicating the at least one network node is defective. 
 
     
     
       16. A system comprising:
 one or more processors; and 
 non-transitory memory storing computer-executable instructions that, when executed by the one or more processors, cause the one or more processors to perform operations comprising:
 storing data in a first database; 
 generating script execution order information utilized to execute a plurality of database management scripts including a first database management script, a second database management script, and a third database management script, wherein the generating is based on priority information of each of the plurality of database management scripts, wherein the script execution order information indicates a dependency of the second database management script and the third database management script on the first database management script and respective priority information of the second database management script and the third database management script indicates that the second database management script and the third database management script have an equal priority, with a result that the first database management script is executed first and the second database management script and the third database management script are executed second, in parallel; 
 executing, according to the script execution order information, the first database management script, the second database management script, and the third database management script to at least one of extract, transform, or load the data, as updated data, in a second database; 
 transmitting, to a user device, first report data associated with the updated data, the first report data being presented by a display of the user device based on the user device identifying reception of the first report data; 
 
 receiving a fourth database management script, the fourth database management script being received as an updated database management script to replace the second database management script; 
 dynamically executing according to the script execution order information, the first database management script and the fourth database management script, wherein additional data is extracted, transformed, and loaded as additional report data in the second database to replace the first report data based at least in part on execution of the first database management script and the fourth database management script after identifying the fourth database management script being received; and 
 transmitting, to the user device, the additional report data to modify the displaying of the first report data by displaying the additional report data. 
 
     
     
       17. The system of  claim 16 , the operations further comprising:
 identifying that execution of the first database management script is utilized to generate a table and write at least one data value into the table, and that execution of the second database management script is utilized to at least one of identify or modify the at least one data value, wherein: 
 the script execution order information includes dependency information, the dependency information including a first priority value associated with the first database management script, and a second priority value associated with the second database management script, and 
 the first priority value is set to be greater than or equal to the second priority value, based on the execution of the first database management script being utilized to generate the table and write the at least one data value into the table, and the execution of the second database management script being utilized to at least one of identify or modify the at least one data value. 
 
     
     
       18. The system of  claim 16 , wherein the script execution order information includes a first priority value associated with the first database management script, and a second priority value associated with the second database management script, and
 the first priority value is set to be greater than or equal to the second priority value, based on successful execution of the second database management script requiring prior execution of the first database management script. 
 
     
     
       19. The system of  claim 16 , wherein the script execution order information includes a first priority value associated with the first database management script, and a second priority value associated with the second database management script, and
 the first priority value is set to be greater than or equal to the second priority value, based on execution of the first database management script being utilized to access at least one parameter value, and execution of the second database management script being utilized to access the at least one parameter value, the at least one parameter value being associated with at least one site in a cellular network and at least one cell in the cellular network.