Capture, aggregation and/or visualization of structural data of architectures

• US 7,664,729 B2
• Filed: 08/30/2004
• Issued: 02/16/2010
• Est. Priority Date: 08/28/2003
• Status: Active Grant

• Current Assignee: Accenture Global Services Limited (Accenture PLC)
• Original Assignee: Accenture Global Services GmbH (Accenture PLC)
• Inventors: Stolz, Eckehard, Klein, Frederic M., Rebentisch, Rupert
• Primary Examiner(s): BOCCIO, VINCENT F
• Application Number:
  US10/930,716
• Publication Number:
  US 20050138160A1
• Time in Patent Office: 1,996 Days
• Field of Search: 707/10, 707/2, 707/101, 717/105, 715/234
• US Class Current: 707/791
• CPC Class Codes: H04L 41/024 using relational databases for representation of network management data, e.g. managing via structured query language [SQL]
• CPC Class Codes: H04L 41/044 comprising hierarchical management structures
• CPC Class Codes: H04L 41/22 comprising specially adapted graphical user interfaces [GUI]

Abstract

Computerized techniques, systems, and computer program products for a structured, hierarchical model for capturing, aggregating, and/or visualizing structural data of architectures of technical equipment (e.g., IT architectures). The techniques, systems and/or computer program products may include at least one data capture engine adapted to capture and aggregate data based on a structured, hierarchical model; a display engine to generate a plurality of different displays of the captured data in dependency of the structured hierarchical model, where the data capture engine includes at least one database to store the data according to the structured, hierarchical model.

Claims

1. A computerized information system for capturing, aggregating, and visualizing model structural data representing an information technology architecture, the system comprising:

storage medium

at least one abstracted data model;

a graphical user interface generation engine;

a visualization engine;

a scenario management engine configured to simulate, visualize and evaluate changes in the architecture;

at least one data capture engine configured to capture and aggregate data stored on the storage medium according to a structured, hierarchical model which is adapted to provide a structured, hierarchical view of a model structure and to build a basic frame for analysis and visualization, the model being either a standardized model or a customer specific model; and

a display engine configured to generate a plurality of different displays of the captured data according to the structured hierarchical model;

wherein the structured, hierarchical model comprises tables of related records, which are associated by either strong links or loose links,

wherein the strong links make use of Row-IDs, and are adapted to provide for every record having a foreign key relationship to a primary key of a record in another table, and

wherein the loose links make use of a row'"'"'s Row-ID, and are adapted to provide for establishing a foreign key relationship to another table,

wherein the models and their components are strongly coupled together by at least one strong link, and relationships between models are loosely coupled by one or more loose links adapted to allow that end points of the respective relationship are moveable within a model or are removable without forcing the relationship to be removed as well,

wherein a generic representation of a model is represented by strong links between core model tables and graphical representation tables.

2. The system of claim 1, wherein the data capture engine comprises at least one database configured to store the data according to the structured, hierarchical model.

3. The system of claim 1, wherein the hierarchical model comprises one or more types of nodes and the tables that correspond to the structure of the hierarchical model comprise:

a model table configured to comprise one or more attributes of the hierarchical model;

a Node_Class table configured to comprise information related to the types of nodes in the hierarchical model; and

a Node table configured to comprise a definition of each node within the hierarchical model and hierarchy information for each node corresponding to the relationship of each node to the hierarchical model.

4. The system of claim 3, wherein the model table, the Node_Class table and the Node table are linked to each other by a plurality of strong links, each strong link defining one or more dependencies of data in a first set of one or more tables to data in a second set of one or more tables, each strong link defining the underlying structure of the hierarchical model.

5. The system of claim 3, wherein the hierarchical model further comprises:

an Nclass_Group table configured to comprise information defining a group of the types of nodes in the hierarchical model within the Node_Class table that build a pool of nodes within a mapping;

a Domain table configured to comprise information defining data element types that belong to a node, data element types that belong to a mapping, and data structures stored within the hierarchical model;

an Attribute table configured to comprise operational data associated with a node and operational data associated with a mapping;

a Display table configured to comprise information defining a graphical representation of a specific view of the hierarchical model;

a Shape table configured to comprise one or more graphical parameters defining how node information is displayed, wherein the node information comprises the specification of a position, a size, a shape, and a background;

a Range table configured to comprise color information corresponding to shapes for displaying a shape as part of a query result;

a Query table configured to comprise display information defining how a result of an SQL statement executed on the hierarchical model is displayed;

a Widget table configured to comprise layout information defining a layout of the nodes;

and a Tree table configured to comprise information defining how to build a tree page based on the Widget table.

6. The system of claim 1, wherein the system further comprises a graphical user interface engine configured to generate graphical user interface screens based on the hierarchical model, the graphical user interface screens comprising:

one or more data attributes from the hierarchical model; and

operational data from the hierarchical model.

7. The system of claim 6, wherein the graphical user interface engine is configured to generate the graphical user interface screens based on the information contained in at least one of a Display table, a Shape table, a Range table and a Query table, the hierarchical model further comprising:

an Nclass_Group table configured to comprise information defining a group of node_classes within a Node_Class table that build a pool of nodes within a mapping;

a Domain table configured to comprise information defining data element types that belong to a node, data element types that belong to a mapping, and data structures stored within the hierarchical model;

an Attribute table configured to comprise operational data associated with a node and operational data associated with a mapping;

the Display table configured to comprise information defining a graphical representation of a specific view of the hierarchical model;

the Shape table configured to comprise one or more graphical parameters defining how node information is displayed, wherein the node information comprises the specification of a position, a size, a shape, and a background;

the Range table configured to comprise color information corresponding to shapes for displaying a shape as part of a query result; and

the Query table configured to comprise display information defining how a result of an SQL statement executed on the hierarchical model is displayed.

8. The system of claim 7, wherein the system further comprises a scenario engine configured to generate a visual representation of the structured, hierarchical model into a database and/or for generating a plurality of scenarios or ongoing variations of the structured, hierarchical model.

9. The system of claim 8, wherein the display engine comprises a visualization engine for creating a visualization of the structured, hierarchical model, executing user queries, merging the query results for display and/or controlling the dynamic scaling of visual output.

10. The system of claim 9, wherein the visualization engine is further configured to:

read one or more shapes associated with the hierarchical model from the Shape table;

read one or more shape attributes associated with the read shape from the Attribute table;

generate shape data from the read shape; and

write the shape data and the shape attributes to an output XML file.

11. A machine-implemented method of capturing, aggregating, and visualizing model structural data representing an information technology architecture, the method comprising:

capturing and aggregating data according to a structured, hierarchical model which is adapted to provide a structured, hierarchical view of a model structure and to build a basic frame for analysis and visualization, the model being either a standardized model or a customer specific model;

defining the structured hierarchical model to comprise tables of related records, which are associated by either strong links or loose links, wherein the strong links make use of Row-IDs, and are adapted to provide for every record having a foreign key relationship to a primary key of a record in another table, wherein the loose links make use of a row'"'"'s Row-ID, and are adapted to provide for establishing a foreign key relationship to another table, wherein the models and their components are strongly coupled together by at least one strong link, and relationships between models are loosely coupled by one or more loose links adapted to allow that end points of the respective relationship are moveable within a model or are removable without forcing the relationship to be removed as well, wherein a generic representation of a model is represented by strong links between core model tables and graphical representation tables; and

generating a plurality of different displays of the captured data according to the structured, hierarchical model.

12. The method of claim 11 farther comprising storing the data according to the hierarchical model in at least one database, wherein the data is stored in a plurality of database tables corresponding to the structure of the hierarchical model.

13. The method of claim 11, wherein the hierarchical model is defined to comprise:

a model table configured to comprise one or more attributes of the hierarchical model;

a Node_Class table configured to comprise information related to types of nodes in the hierarchical model; and

a Node table configured to comprise the definition of each node within the hierarchical model and corresponding hierarchy information.

14. The method of claim 13, wherein the model table, the Node_Class table and the Node table are linked to each other by a plurality of strong links which make use of the Row-ID of the respective table, each strong link defining one or more dependencies of data in a first set of one or more tables to data in a second set of one or more tables, each strong link defining the underlying structure of the hierarchical model.

15. A computer storage medium encoded with a computer program for capturing, aggregating, and visualizing model structural data representing an information technology architecture, the program comprising instructions that when executed by data processing apparatus cause the data processing apparatus to perform operations comprising:

capturing and aggregating data according to a structured, hierarchical model which is adapted to provide a structured, hierarchical view of a model structure and to build a basic frame for analysis and visualization, the model being either a standardized model or a customer specific model;

defining the structured, hierarchical model to comprise tables of related records, which are associated by either strong links or loose links, wherein the strong links make use of Row-IDs, and are adapted to provide for every record having a foreign key relationship to a primary key of a record in another table, wherein the loose links make use of a row'"'"'s Row-ID, and are adapted to provide for establishing a foreign key relationship to another table, wherein the models and their components are strongly coupled together by at least one strong link, and relationships between models are loosely coupled by one or more loose links adapted to allow that end points of the respective relationship are moveable within a model or are removable without forcing the relationship to be removed as well, wherein a generic representation of a model is represented by strong links between core model tables and graphical representation tables; and

generating a plurality of different displays of the captured data according to the structured, hierarchical model.

16. The computer storage medium of claim 15, wherein the operations further comprise storing the data according to the hierarchical model in at least one database, wherein the data is stored in a plurality of database tables corresponding to the structure of the hierarchical model.

17. The computer storage medium of claim 15, wherein the hierarchical model is defined to comprise:

a model table configured to comprise one or more attributes of the hierarchical model;

a Node_Class table configured to comprise information related to types of nodes in the hierarchical model; and

a Node table configured to comprise the definition of each node within the hierarchical model and corresponding hierarchy information.

18. The computer storage medium of claim 17, wherein the model table, the Node_Class table and the Node table are linked to each other by a plurality of strong links which make use of the Row-ID of the respective table, each strong link defining one or more dependencies of data in a first set of one or more tables to data in a second set of one or more tables, each strong link defining the underlying structure of the hierarchical model.

19. The computer storage medium of claim 18,

wherein one or more of the different displays further comprises:

two or more first level rectangular regions associated with each information technology organizational group represented in a highest level hierarchy of the model structure,

one or more second level rectangular regions associated with specific functional areas, represented in a middle level hierarchy of the model structure, for which each respective information technology organization group is responsible, and

one or more third level rectangular regions associated with specific applications, represented in a lowest level hierarchy of the model structure, that have been deployed in each respective functional area, and

wherein at least one of the third level rectangular regions, and at least one of the second level rectangular regions associated with the one third level rectangular region, are visually allocated to two or more adjacent first level rectangular regions.