Method and system for managing information technology data

• US 8,037,106 B2
• Filed: 03/02/2006
• Issued: 10/11/2011
• Est. Priority Date: 03/02/2005
• Status: Expired due to Fees

• Current Assignee: Computer Associates Think Inc. (Broadcom, Inc.)
• Original Assignee: Computer Associates Think Inc. (Broadcom, Inc.)
• Inventors: Barrenechea, Mark J.
• Primary Examiner(s): Robinson; Greta
• Assistant Examiner(s): Weinrich; Brian E.
• Application Number:
  US11/366,146
• Publication Number:
  US 20060200477A1
• Time in Patent Office: 2,049 Days
• Field of Search: 707/803, 707/736
• US Class Current: 707/803
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: G06Q 10/00 Administration; Management

Abstract

A database system for storing information technology (IT) management operational data and a method and apparatus for managing IT data are provided. The database utilizes an integrated database schema. IT operational data is stored into the database using the integrated database schema and the database is accessed by plural applications and/or products using the integrated database schema.

Claims

1. A method for managing information technology (IT) data, comprising:

creating and maintaining a database utilizing a single integrated database schema;

using the single integrated database schema to configure at least one configurable software setting, for each of a plurality of IT management software products associated with a plurality of platforms, each of the at least one configurable software settings comprising a parameter that specifies how a particular one of the plurality of IT management software products operates, and wherein configuring the parameter causes each of the plurality of IT management software products to direct the operation of the plurality of IT management software products associated with the plurality of platforms in accordance with the single integrated database schema such that IT operational data is stored in the database using the single integrated database schema when created by each of the plurality of IT management software products;

upon creation of the IT operational data by each of the plurality of IT management software products, storing the IT operational data from the plurality of IT management software products associated with the plurality of platforms in the database, wherein the database is maintained in a single location and stores the IT operational data for the plurality of IT management software products in the single location, each piece of IT management software products associated with the plurality of platforms using the single integrated database schema common to the plurality of IT management software; and

accessing the database via the single integrated database schema common to a plurality of IT management software products associated with the plurality of platforms.

2. The method of claim 1, wherein the stored IT operational data comprises one or more of asset data, event data, service data, business process data, schedule and workflow data, software configuration data, security data, storage data, meta data and policy data.

3. The method of claim 1, wherein the stored IT operational data comprises data created and maintained by the plurality of IT management software products offered by a plurality of vendors.

4. The method of claim 1, wherein the database is accessed by the plurality of IT management software products offered by a plurality of vendors.

5. The method of claim 1, wherein the single integrated database schema comprises one or more tables.

6. An apparatus for managing information technology (IT) data, comprising:

a plurality of IT management software products associated with a plurality of platforms for accessing and storing IT operational data, each of the plurality of IT management software products associated with the plurality of platforms including at least one configurable software setting directing the operation of the plurality of IT management software products associated with the plurality of platforms, each of the at least one configurable software settings comprising a parameter that specifies how a particular one of the plurality of IT management software products operates, and wherein configuring the parameter causes each of the plurality of IT management software products to operate in accordance with a single integrated database schema such that the IT operational data is stored using the single integrated database schema when created by each of the plurality of IT management software products;

a database utilizing the single integrated database schema that is common to the plurality of IT management software products associated with the plurality of platforms, wherein the database is maintained in a single location and stores the IT operational data for the plurality of IT management software products in the single location; and

a central processing unit in communication with the database, the central processing unit comprising;

a storing means for storing IT operational data into the database using the single integrated database schema that is common to the plurality of IT management software products associated with the plurality of platforms, the IT operational data stored in the database when created by each of the plurality of IT management software products; and

an accessing means allowing the plurality of IT management software products associated with the plurality of platforms to access the database utilizing the single integrated database schema that is common to the plurality of IT management software products associated with the plurality of platforms.

7. The apparatus of claim 6, wherein the IT operational data stored by said storing means into the database using the single integrated schema comprises one or more of asset data, event data, service data, business process data, schedule and workflow data, software configuration data, security data, storage data, meta data and policy data.

8. The apparatus of claim 6, wherein the IT operational data stored by said storing means into the database using the single integrated schema comprises data created and maintained by the plurality of IT management software products, the plurality of IT management software products offered by a plurality of vendors.

9. The apparatus of claim 6, wherein the database is accessed by the plurality of IT management software products, the plurality of IT management software products offered by a plurality of vendors.

10. The apparatus of claim 6, wherein the single integrated database schema comprises one or more tables.

11. A computer readable storage medium including computer executable code for managing information technology (IT) data, comprising:

code for creating a database which utilizes a single integrated database schema;

code for using the single integrated database schema to configure at least one software setting, for each of a plurality of IT management software products associated with a plurality of platforms, each of the at least one configurable software settings comprising a parameter that specifies how a particular one of the plurality of IT management software products operates, and wherein configuring the parameter causes each of the plurality of IT management software products to direct the operation of the plurality of IT management software products associated with the plurality of platforms in accordance with the single integrated database schema such that IT operational data is stored in the database using the single integrated database schema upon creation by each of the plurality of IT management software products;

code for storing the IT operational data in the database using the single integrated database schema that is common to the plurality of IT management software products associated with the plurality of platforms, the database maintained in a single location and storing the IT operational data for the plurality of IT management software products in the single location, the IT operational data stored in the database when created by each of the plurality of IT management software products; and

code for accessing the database utilizing the single integrated database schema that is common to the plurality of IT management software products associated with the plurality of platforms.

12. The computer readable storage medium of claim 11, wherein the stored IT operational data comprises one or more of asset data, event data, service data, business process data, schedule and workflow data, software configuration data, security data, storage data, meta data and policy data.

13. The computer readable storage medium of claim 11, wherein the database is accessed by the plurality of IT management software products, the plurality of IT management software products offered by a plurality of vendors.

14. The computer readable storage medium of claim 11, wherein the single integrated database schema comprises one or more tables.

15. A computer readable storage medium including computer executable code for managing information technology (IT) data, comprising:

code for creating a database which utilizes a single integrated database schema;

code for using the single integrated database schema to configure at least one configurable software setting, for each of a plurality of IT management software products associated with a plurality of platforms, each of the at least one configurable software settings comprising a parameter that specifies how a particular one of the plurality of IT management software products operates, and wherein configuring the parameter causes each of the plurality of IT management software products to direct the operation of the plurality of IT management software products associated with the plurality of platforms in accordance with the single integrated database schema such that IT operational data is stored in the database using the single integrated database schema when created by each of the plurality of IT management software products;

code for storing the IT operational data in the database using the single integrated database schema that is common to the plurality of IT management software products associated with the plurality of platforms, the database maintained in a single location and storing the IT operational data for the plurality of IT management software products in the single location, the IT operational data stored in the database when created by each of the plurality of IT management software products; and

code for accessing the database utilizing the single integrated database schema; and

wherein the stored IT operational data comprises data created and maintained by the plurality of IT management software products associated with the plurality of platforms.

16. A system comprising:

a database utilizing a single integrated database schema; and

a central processing unit in communication with the database, the central processing unit operating to;

maintain the database utilizing the single integrated database schema;

use the single integrated database schema to configure at least one configurable software setting, for each of a plurality of IT management software applications associated with a plurality of platforms, each of the at least one configurable software settings comprising a parameter that specifies how a particular one of the plurality of IT management software products operates, and wherein configuring the parameter causes each of the plurality of IT management software products to direct the operation of the plurality of IT management software products associated with the plurality of platforms in accordance with the single integrated database schema such that IT operational data is stored in the database using the single integrated database schema when created by each of the plurality of IT management software products;

communicate with the plurality of information technology (IT) management software applications associated with the plurality of platforms;

upon creation of the IT operational data by each of the plurality of IT management software products, receive the IT operational data from the plurality of IT management software applications associated with the plurality of platforms; and

access and store the IT operational data from the plurality of IT management software applications associated with the plurality of platforms in the database using the single integrated database schema that is common to the plurality of IT management software applications associated with the plurality of platforms, the database being maintained in a single location and storing the IT operational data for the plurality of IT management software products in the single location.

17. The system of claim 16, wherein the IT management operational data includes data for two or more of the following domains:

storage;

security;

operations;

service;

job;

server and desktop;

applications and databases;

lifecycle;

assets and inventory;

organizations and people;

policies and rules;

schedules and workflows;

events; and

metadata.

18. The system of claim 16, wherein the single schema is represented by one or more of tables, columns and views.

19. The system of claim 16, wherein the database utilizes a relational database management system to store data.

20. A program storage device readable by a computer, the program storage device embodying a program of instructions executable by the computer to:

create and maintain a database utilizing a single integrated database schema;

use the single integrated database schema to configure at least one configurable software setting, for each of a plurality of IT management software products associated with a plurality of platforms, each of the at least one configurable software settings comprising a parameter that specifies how a particular one of the plurality of IT management software products operates, and wherein configuring the parameter causes each of the plurality of IT management software products to direct the operation of the plurality of IT management software products associated with the plurality of platforms in accordance with the single integrated database schema such that IT operational data is stored in the database using the single integrated database schema when created by each of the plurality of IT management software products;

upon creation of the IT operational data by each of the plurality of IT management software products, store IT operational data from the plurality of IT management software products associated with the plurality of platforms in the database, the database maintained in a single location and storing the IT operational data for the plurality of IT management software products in the single location, each piece of IT management software using the single integrated database schema that is common to the plurality of IT management software products associated with the plurality of platforms; and

access the database via the single integrated database schema that is common to the plurality of IT management software products associated with the plurality of platforms.

21. A computer system comprising:

a processor; and

a program storage device readable by the computer system, the program storage device tangibly embodying a program of instructions executable by the processor to;

create and maintain a database utilizing a single integrated database schema;

use the single integrated database schema to configure at least one configurable software setting, for each of a plurality of IT management software products associated with a plurality of platforms, each of the at least one configurable software settings comprising a parameter that specifies how a particular one of the plurality of IT management software products operates, and wherein configuring the parameter causes each of the plurality of IT management software products to direct the operation of the plurality of IT management software products associated with the plurality of platforms in accordance with the single integrated database schema such that IT operational data is stored in the database using the single integrated database schema when created by each of the plurality of IT management software products;

upon creation of the IT operational data by each of the plurality of IT management software products, store IT operational data from plural IT management software products associated with the plurality of platforms in the database, the database maintained in a single location and storing the IT operational data for the plurality of IT management software products in the single location, each piece of IT management software using the single integrated database schema that is common to the plurality of IT management software products associated with the plurality of platforms; and

access the database via the single integrated database schema that is common to the plurality of IT management software products associated with the plurality of platforms.