Graph databases for storing multidimensional models of software offerings

Patent metadata

Field	Value
Publication number	US-10528897-B2
Application number	US-201113096866-A
Country	US
Kind code	B2
Filing date	Apr 28, 2011
Priority date	Apr 28, 2011
Publication date	Jan 7, 2020
Grant date	Jan 7, 2020

Abstract

The disclosed embodiments provide a system that facilitates the maintenance and execution of a software offering. During operation, the system obtains model data associated with a multidimensional model of the software offering. Next, the system stores the model data in a graph database. Finally, the system uses the graph database to facilitate management of the software offering.

First claim

What is claimed is:

1. A computer-implemented method for facilitating maintenance and execution of a software offering, comprising:
obtaining model data associated with a multidimensional model of the software offering;
storing the model data in a graph database by:
storing, within each node in a set of nodes of the graph database, a set of attributes for the node, wherein the set of nodes represents service components and resources used by the software offering, and wherein, for a given node in the set of nodes, the set of attributes for the given node specifies operating system or processor information for a respective service component or a respective resource represented by the given node; and
connecting at least two nodes in the set of nodes, wherein the connecting comprises storing, within the graph database, relationship information that identifies a name of a type of dependency between the service components and the resources represented by the at least two nodes, wherein the set of nodes, each set of attributes, and the relationship information are stored in a single graph within the graph database, and wherein the set of nodes, each set of attributes, and the relationship information are accessible by traversing the single graph; and
using the graph database to facilitate management of the software offering by:
traversing the single graph of the graph database to identify the set of nodes, each set of attributes, and the relationship information;
automatically deploying one or more service components using one or more resources based on the traversing;
determining a fault in the software offering; and
automatically identifying a service component related to the fault based on the relationship information.

2. The computer-implemented method of claim 1 , wherein storing the model data in the graph database involves: creating the set of nodes.

3. The computer-implemented method of claim 2 , wherein storing the model data in the graph database further involves: creating the set of attributes.

4. The computer-implemented method of claim 3 , wherein each attribute of the set of attributes comprises an attribute value and an attribute type.

5. The computer-implemented method of claim 1 , wherein using the graph database to facilitate management of the software offering further comprises:
facilitating display of information related to the fault within a graphical user interface (GUI).

6. The computer-implemented method of claim 1 ,
wherein the graph database comprises a hierarchy for the set of nodes, wherein the software offering executes in a cloud computing system that comprises the service components and the resources, and
wherein the method further comprises:
diagnosing at least one of a fault in the cloud computing system and an outage in the cloud computing system, wherein the diagnosing comprises determining one or more affected resources from the resources by traversing the graph database from a lower node in the hierarchy which represents a resource that is affected by a condition for the software offering to one or more higher nodes in the hierarchy that correspond to the one or more affected,
resource, wherein the one or more affected resources are affected by the condition, and wherein the condition comprises the at least one of the fault and the outage; and
indicating the one or more affected resources in a view of at least some of the model data in the graph database at a graphical user interface for the management of the software offering.

7. The computer-implemented method of claim 1 , wherein the type of dependency is used to identify groupings for the set of nodes.

8. The computer-implemented method of claim 1 , wherein the set of attributes for the given node specifies at least one of a name of an operating system and a version of the operating system.

9. The computer-implemented method of claim 1 , wherein the set of attributes for the given node specifies a number of processors available at the given node.

10. The computer-implemented method of claim 1 , wherein the set of attributes for the given node specifies an amount of memory that is available at given node.

11. The computer-implemented method of claim 1 , further comprising:
receiving an update for the multidimensional model in a relational database for the multidimensional model that is separate from the graph database; and
propagating the update from the relational database to the graph database.

12. The computer-implemented method of claim 1 , wherein using the graph database to facilitate management of the software offering comprises:
analyzing the relationship information and at least some of the sets of attributes for the set of nodes of the graph database to generate a first view of the model data;
presenting the first view at a graphical user interface for the management of the software offering by displaying the graphical user interface at a display coupled to the computer; and
responsive to a request to update the first view:
analyzing the relationship information and at least a subset of the sets of attributes for the set of nodes of the graph database to generate a second view of the model data that is different from the first view; and
updating the graphical user interface by replacing the first view with the second view.

13. The computer-implemented method of claim 12 , wherein the computer presents the first view and the second view in real-time, and wherein using the graph database facilitates transitioning between the first view and the second view.

14. The computer-implemented method of claim 12 , further comprising:
receiving an update for the multidimensional model in a relational database for the multidimensional model that is separate from the graph database; and
propagating the update from the relational database to the graph database,
wherein using the graph database to facilitate management of the software offering comprises retrieving a first set of the model data and a second set of the model data from the graph database, wherein the first view of the model data comprises the first set of the model data, and wherein the second view of the model data comprises the second set of the model data, and
wherein retrieving the first set of the model data and the second set of the model data from the graph database improves response time for the graphical user interface by facilitating the computer replacing the first view with the second view faster than the computer replacing the first view with the second view by retrieving the first set of the model data and the second set of the model data from the relational database without using the graph database.

15. A system for facilitating maintenance and execution of a software offering, comprising:
one or more processors; and
memory storing instructions which, when executed by the one or more processors, cause the one or more processors to perform a method for facilitating maintenance and execution of a software offering, the methods comprising:
obtaining model data associated with a multidimensional model of the software offering; and
storing the model data in a graph database, wherein, while storing the model data in the graph database, the method further comprises:
storing, within each node in a set of nodes of the graph database, a set of attributes for the node, wherein the set of nodes represents service components and resources used by the software offering, and wherein, for a given node in the set of nodes, the set of attributes for the given node specifies operating system or processor information for a respective service co

Assignees

• Labat Jerome
• Venkataraman Ramkumar
• Edward John Eugene
• Varadharajan Ramachandran
• Intuit Inc

Inventors

• Labat Jerome
• Venkataraman Ramkumar
• Edward John Eugene
• Varadharajan Ramachandran

Classifications

• G06Q10/06 Primary

  Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling · CPC title

• G06F8/70 Primary

  Software maintenance or management · CPC title

• G06F16/9024

  Graphs; Linked lists (G06F16/9027 takes precedence) · CPC title