Discovery of database and related services

Patent metadata

Field	Value
Publication number	US-11645309-B2
Application number	US-202017081641-A
Country	US
Kind code	B2
Filing date	Oct 27, 2020
Priority date	Dec 20, 2018
Publication date	May 9, 2023
Grant date	May 9, 2023

Abstract

A computing system includes a database and a discovery application. The discovery application obtains credentials for accessing a server hosting a software bus application which connects a plurality of applications within a managed network. The discovery application selects, based on a pattern corresponding to the software bus application, one or more files to access, transmits, to the server, instructions to access the one or more files, and receives therefrom data identifying a plurality of attributes of the software bus application. Based on this data, the discovery application transmits, to the server, instructions to identify communicative connections established between the plurality of software applications by way of the software bus application and receives therefrom data identifying the communicative connections. Based on (i) the plurality of attributes and (ii) the communicative connections, the discovery application generates a mapping that represents the communicative connections and stores the mapping in the database.

First claim

What is claimed is:

1. A system comprising:
a processor; and
a memory, accessible by the processor, and storing instructions that, when executed by the processor, cause the processor to perform operations comprising:
transmitting, to a server device disposed within a managed network, a request to identify a type of database manager executing on the server device and respective database catalogs of one or more secondary databases managed by the database manager;
receiving, from the server device, data identifying the type of the database manager executing on the server device and the respective database catalogs of the one or more secondary databases managed by the database manager, wherein each of the respective database catalogs comprises a set of transactions associated with a corresponding secondary database of the one or more secondary databases;
transmitting, to the server device, a request to monitor characteristics of network traffic between the one or more secondary databases and one or more software applications running within the managed network;
generating, based on the set of transactions and the characteristics of the network traffic, a mapping between the one or more secondary databases and the one or more software applications; and
storing the mapping in a configuration management database (CMDB) for the managed network.

2. The system of claim 1 , wherein the one or more secondary databases are configured to store data for the one or more software applications running within the managed network.

3. The system of claim 1 , wherein the type of the database manager indicates a provider of the database manager, a name of the database manager, or a release version of the database manager, or any combination thereof.

4. The system of claim 1 , wherein the respective database catalog of a particular secondary database of the one or more secondary databases comprises metadata indicating one or more data types stored in the particular secondary database.

5. The system of claim 1 , wherein the respective database catalog of a particular secondary database of the one or more secondary databases comprises metadata indicating one or more database queries associated with the particular secondary database.

6. The system of claim 1 , wherein the respective database catalog of a particular secondary database of the one or more secondary databases comprises metadata identifying tables that make up the particular secondary database, or columns that make up the particular secondary database, or a combination thereof.

7. The system of claim 1 , wherein the mapping indicates a database model for a particular secondary database of the one or more secondary databases.

8. The system of claim 1 , wherein the operations comprise:
selecting one or more commands based on the type of the database manager; and
transmitting, to the server device, the one or more selected commands, wherein the server device is configured to execute the one or more selected commands.

9. The system of claim 1 , wherein the operations comprise identifying, based on the characteristics of the network traffic, communicative connections between the one or more secondary databases and the one or more software applications running within the managed network.

10. The system of claim 1 , wherein the operations comprise:
transmitting, to the server device, a request to identify a directory containing files associated with the database manager;
selecting, based on the type of the database manager, one or more files to access within the directory;
transmitting, to the server device, a request to access the one or more files; and
receiving, from the server device, additional data identifying a plurality of network connection parameters associated with the database manager.

11. The system of claim 1 , wherein the characteristics of the network traffic comprises a plurality of network packets, each network packet transmitted along at least a portion of a network path between a respective software application of the one or more software applications and a respective secondary database of the one or more secondary databases.

12. The system of claim 11 , wherein the operations comprise:
determining a correlation between a first network packet of the plurality of network packets and a first transaction of the set of transactions; and
based on the correlation, identifying a communicative connection between the respective secondary database and the respective software application.

13. A method comprising:
transmitting, to a server device disposed within a managed network, a request to identify a type of database manager executing on the server device and respective database catalogs of one or more secondary databases managed by the database manager;
receiving, from the server device, data identifying the type of the database manager executing on the server device and the respective database catalogs of the one or more secondary databases managed by the database manager, wherein each of the respective database catalogs comprises a set of transactions associated with a corresponding secondary database of the one or more secondary databases;
transmitting, to the server device, a request to monitor network communications between the one or more secondary databases and one or more software applications running within the managed network;
generating, based on the set of transactions and the network communications, a mapping between the one or more secondary databases and the one or more software applications; and
storing the mapping in a configuration management database (CMDB) for the managed network.

14. The method of claim 13 , wherein the respective database catalog of a particular secondary database of the one or more secondary databases comprises metadata identifying transactions between the particular secondary database and the one or more software applications running within the managed network.

15. The method of claim 13 , wherein a first database catalog of a particular secondary database of the one or more secondary databases indicates the particular secondary database stores data according to a relational database model or an object-relational database model.

16. The method of claim 13 , comprising:
transmitting, to the server device, a request to establish a connection based on access credentials for the server device; and
in response to establishing the connection, transmitting the request to identify the type of database manager.

17. An article of manufacture including a non-transitory computer-readable medium, having stored thereon program instructions that, upon execution by a computing system, cause the computing system to perform operations comprising:
transmitting, to a server device disposed within a managed network, a request to identify a type of database manager executing on the server device and respective database catalogs of one or more secondary databases managed by the database manager;
receiving, from the server device, data identifying the type of the database manager executing on the server device and the respective database catalogs of the one or more secondary databases managed by the database manager, wherein each of the respective database catalogs comprises a set of transactions associated with a corresponding secondary database of the one or more secondary databases;
transmitting, to the server device, a request to monitor network communications between the one or more secondary databases and one or more software applications running within the managed network;
generating, b

Assignees

• Servicenow Inc

Inventors

• Bar Oz Tom
• Biran Noam
• Tal Hail
• Aron Aviya
• Bitterfeld Robert
• Erblat Boris
• Solomon Bary

Classifications

• H04L41/122

  of virtualised topologies, e.g. software-defined networks [SDN] or network function virtualisation [NFV] · CPC title

• H04L41/0895

  Configuration of virtualised networks or elements, e.g. virtualised network function or OpenFlow elements · CPC title

• H04L41/40

  using virtualisation of network functions or resources, e.g. SDN or NFV entities · CPC title

• G06F16/285 Primary

  Clustering or classification · CPC title

• G06F16/25 Primary

  Integrating or interfacing systems involving database management systems · CPC title