Method and system for managing information technology data

• US 20060200477A1
• Filed: 03/02/2006
• Published: 09/07/2006
• Est. Priority Date: 03/02/2005
• Status: Active Grant

• Current Assignee: Computer Associates Think Inc. (Broadcom, Inc.)
• Original Assignee: Computer Associates Think Inc. (Broadcom, Inc.)
• Inventors: Barrenechea, Mark J.
• Granted Patent: US 8,037,106 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: G06Q 10/00 Administration; Management

Abstract

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 database system for storing information technology (IT) management operational data for a plurality of IT management software, wherein the database system utilizes a single schema common to the plural IT management software.

2. The database system of claim 1, 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.

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

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

10. A program storage device readable by a computer, tangibly embodying a program of instructions executable by the computer to perform the method of claim 1.

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

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

storing IT operational data from plural IT management software into the database, each IT management software using the single integrated database schema; and

accessing the database via the single integrated database schema.

6. The method of claim 5, 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.

7. The method of claim 5, wherein the stored IT operational data comprises data created and maintained by plural applications and/or products.

8. The method of claim 5, wherein the database is accessed by plural applications and/or products.

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

11. A computer data signal transmitted in one or more segments in a transmission medium which embodies instructions executable by a computer to perform the method of claim 5.

12. A computer system comprising:

a processor; and

a program storage device readable by the computer system, tangibly embodying a program of instructions executable by the processor to perform the method of claim 5.

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

a database utilizing a single integrated database schema;

storing means for storing IT operational data into the database using the single integrated database schema; and

accessing means configured to allow plural IT management software to access the database utilizing the single integrated database schema.

14. The apparatus of claim 13, 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.

15. The apparatus of claim 13, wherein the IT operational data stored by said storing means into the database using the single integrated schema comprises data created and maintained by plural applications and/or products.

16. The apparatus of claim 13, wherein the database is accessed means by plural applications and/or products.

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

18. 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 storing IT operational data into the database using the single integrated database schema; and

code for accessing the database utilizing the single integrated database schema.

19. The computer readable storage medium of claim 18, 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.

20. The computer readable storage medium of claim 18, wherein the stored IT operational data comprises data created and maintained by plural applications and/or products.

21. The computer readable storage medium of claim 18, wherein the database is accessed by plural applications and/or products.

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