Data warehouse computing system

• US 7,003,560 B1
• Filed: 11/03/2000
• Issued: 02/21/2006
• Est. Priority Date: 11/03/1999
• Status: Expired due to Term

• Current Assignee: Accenture Global Services Limited (Accenture PLC)
• Original Assignee: Accenture LLP (Accenture PLC)
• Inventors: Green, Michael J., Mullen, Nancy K.
• Primary Examiner(s): Follansbee, John
• Assistant Examiner(s): LIN, KENNY S
• Application Number:
  US09/705,576
• Time in Patent Office: 1,936 Days
• Field of Search: 709/226, 709/219, 709/224, 713/201, 713/187, 702/184, 719/519, 370/229
• US Class Current: 709/223
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
• CPC Class Codes: H04L 67/02 based on web technology, e.g. hypertext transfer protocol [HTTP]
• CPC Class Codes: H04L 67/125 involving control of end-device applications over a network
• CPC Class Codes: H04L 67/34 involving the movement of software or configuration parameters network booting or remote initial program loading [RIPL] G06F9/4416

Abstract

A data warehouse computing system including a server connected to a client, a data warehouse architecture, metadata management, a population architecture, an end-user access architecture, an operations architecture, and a development architecture. The operations architecture includes a server connected with a client, a software distribution tool, a configuration and asset management tool, a fault management and recovery management tool, a capacity planning tool, a performance management tool, a license management tool, a remote management tool, an event management tool, a systems monitoring and tuning tool, a security tool, a user administration tool, a production control application set, and a help desk tool. The development architecture includes a process management tool, a personal productivity tool, a quality management tool, a system building tool, an environment management tool, a program and project management tool, a personal productivity tool and an information management tool.

Claims

1. An operations architecture for a data warehouse computing system, the operations architecture being used to design, build and enhance the data warehouse computing system, the operations architecture comprising:

a web server connected through a firewall with a client, the web server providing a plurality of tools accessible via a common user interface, the plurality of tools including;

a software distribution tool, a configuration and asset management tool, a fault management and recovery management tool, a capacity planning tool, a performance management tool, a license management tool, a remote management tool, a event management tool, a systems monitoring and tuning tool, a security tool, a user administration tool, a production control application set and a help desk tool supporting said web server and said client in said data warehouse computing system; and

wherein said common user interface is configured to present an interactive graphical user interface to said client that provides access to all of said tools and enables design, building and enhancement of the data warehouse computing system with said tools, wherein all of said tools of are presented by the common user interface in a single view.

2. The operations architecture of claim 1, wherein said software distribution tool provides automated delivery to, and installation of, applications on said web server and said client.

3. The operations architecture of claim 1, wherein said configuration and asset management tool that manages a plurality of predetermined assets connected with said data warehouse computing system.

4. The operations architecture of claim 3, wherein said predetermined assets may be selected from the group consisting of said web server, said client, a product license information file, a warranty information file, a vendor name file, a logical device information file and a physical device information file.

5. The operations architecture of claim 1, wherein said fault management and recovery management tool assists in the diagnosis and correction of a plurality of system faults in said data warehouse computing system.

6. The operations architecture of claim 1, wherein said capacity planning tool monitors a plurality of predetermined system usage levels in said data warehouse computing system.

7. The operations architecture of claim 6, wherein said system usage levels may be selected from the group consisting of web server processing usage, web server bandwidth usage, web server storage usage and client usage.

8. The operations architecture of claim 1, wherein said performance management tool monitors the performance of applications running on said data warehouse computing system.

9. The operations architecture of claim 1, wherein said license management tool manages and controls license information for applications running on said data warehouse computing system.

10. The operations architecture of claim 1, wherein said remote management tool allows support personnel from said data warehouse computing system to take control of said client.

11. The operations architecture of claim 1, wherein said event management tool is responsible for handling a plurality of predetermined events in said data warehouse computing system.

12. The operations architecture of claim 11, wherein said predetermined events may be selected from the group consisting of disk space indications, central processing unit utilization indications, database error indications, network error indications and file and print service indications.

13. The operations architecture of claim 1, wherein said systems monitoring and tuning tool monitors applications, middleware, databases, networks, clients and web servers on said data warehouse computing system.

14. The operations architecture of claim 1, wherein said security tool includes applications that provide security to said data warehouse computing system.

15. The operations architecture of claim 1, wherein said user administration tool is used for administering users of said data warehouse computing system.

16. The operations architecture of claim 1, wherein said production control application set is used for scheduling and processing a plurality of production processes on said data warehouse computing system.

17. The operations architecture of claim 16, wherein said production control application set may be selected from the group consisting of a print management tool, a file transfer and control tool, a mass storage management tool, a backup and restore tool, a archiving tool and a system startup and recovery tool.

18. The operations architecture of claim 1, wherein said help desk tool provides a help application for assisting users of applications on said data warehouse computing system.

19. An operations architecture for a data warehouse computing system, the operations architecture being used to design, build and enhance the data warehouse computing system, the operations architecture comprising:

a web server connected through a firewall with a client, the web server providing a plurality of tools accessible via a common user interface, the plurality of tools including;

a software distribution tool for providing automated delivery to, and installation of, an application on said web server or said client;

a configuration and asset management tool for managing a plurality of predetermined assets connected with said data warehouse computing system;

a fault management and recovery management tool for assisting in the diagnosis and correction of a plurality of system faults in said data warehouse computing system;

a capacity planning tool for monitoring a plurality of predetermined system usage levels in said data warehouse computing system;

a performance management tool for monitoring the performance of applications running on said data warehouse computing system;

a license management tool for managing and controlling license information for applications running on said data warehouse computing system;

a remote management tool allowing support personnel from said data warehouse computing system to take control of said client;

a event management tool for handling a plurality of predetermined events in said data warehouse computing system;

a systems monitoring and tuning tool for monitoring applications, middleware, databases, networks, clients and web servers;

a security tool that includes a security application that provides security to said data warehouse computing system;

a user administration tool for administering users of said data warehouse computing system;

a production control application set for scheduling and handling a plurality of production processes on said data warehouse computing system;

and a help desk tool including a help application that provides users of applications on said data warehouse computing system with assistance,

wherein said common user interface is configured to present an interactive graphical user interface to said client that provides access to all of said tools and enables design, building and enhancement of the data warehouse computing system with said tools, wherein all of said tools of are presented by the common user interface in a single view.

20. The operations architecture of claim 19, wherein said predetermined assets may be selected from the group consisting of said web server, said client, a product license information file, a warranty information file, a vendor name file, a logical device information file and a physical device information file.

21. The operations architecture of claim 19, wherein said system usage levels may be selected from the group consisting of web server processing usage, web server bandwidth usage, web server storage usage and client usage.

22. The operations architecture of claim 19, wherein said predetermined events that said event management tool handles may be selected from the group consisting of disk space indications, central processing unit utilization, database error indications, network error indications and file and print web server indications.

23. The operations architecture of claim 19, wherein said production control application set may be selected from the group consisting of a print management tool, a file transfer and control tool, a mass storage management tool, a backup and restore tool, a archiving tool and a system startup and recovery tool.

24. A method of providing an operations architecture for a data warehouse computing system including a client connected through a firewall with a web server, comprising the steps of:

providing a plurality of tools accessible via a common user interface, said tools including;

using a software distribution tool for providing automated delivery to, and installation of, a predetermined application on said web server or said client;

managing a plurality of predetermined assets connected with said data warehouse computing system with a configuration and asset management tool;

assisting in the diagnosis and correction of a plurality of system faults in said data warehouse computing system with a fault management and recovery management tool;

monitoring a plurality of predetermined system usage levels in said data warehouse computing system with a capacity planning tool;

monitoring the performance of applications running on said data warehouse computing system with a performance management tool;

managing and controlling license information for applications running on said data warehouse computing system with a license management tool;

allowing support personnel to take control of said client with a remote management tool;

handling a plurality of predetermined events in said data warehouse computing system with a event management tool;

monitoring a plurality of computing devices connected with said data warehouse computing system with a systems monitoring and tuning tool;

securing said data warehouse computing system with a security tool;

administering users of said data warehouse computing system with a user administration tool;

scheduling and handling a plurality of production processes on said data warehouse computing system with a production control application set; and

helping users encountering problems with applications on said data warehouse computing system with a help desk tool;

wherein said common user interface is configured to present an interactive graphical user interface to said client that provides access to all of said tools and enables design, building and enhancement of the data warehouse computing system with said tools, wherein all of said tools of are presented by the common user interface in a single view.

25. The method of claim 24, wherein said predetermined assets may be selected from the group consisting of said web server, said client, a product license information file, a warranty information file, a vendor name file, a logical device information file and a physical device information file.

26. The method of claim 24, wherein said system usage levels may be selected from the group consisting of web server processing usage, web server bandwidth usage, web server storage usage and client usage.

27. The method of claim 24, wherein said predetermined events that said event management tool handles may be selected from the group consisting of disk space indications, central processing unit utilization, database error indications, network error indications, application error indications and file and printer service indications.

28. The method of claim 24, wherein said production control application set may be selected from the group consisting of a print management tool, a file transfer and control tool, a mass storage management tool, a backup and restore tool, a archiving tool and a system startup and recovery tool.

29. A data warehouse computing system, comprising:

a web server connected through a firewall with a client, the web server providing a plurality of tools accessible via a common user interface;

an operations architecture located on one of said web server and said client, said operations architecture being used to design, build and enhance the data warehouse computing system, said plurality of tools for said operations architecture comprising a software distribution tool, a configuration and asset management tool, a fault management and recovery management tool, a capacity planning tool, a performance management tool, a license management tool, a remote management tool, an event management tool, a systems monitoring and tuning tool, a security tool, a user administration tool, a production control application set, and a help desk tool supporting said data warehouse computing system; and

a development architecture located on one of said web server and said client, said development architecture being used to design, build and enhance the data warehouse computing system, said plurality of tools for said development architecture comprising a common user interface between said web server and said client, a process management tool, a personal productivity tool, a quality management tool, a system building tool, an environment management tool, a program and project management tool, and an information management tool;

wherein said common user interface is configured to present an interactive graphical user interface to said client that provides access to all of said tools and enables design, building and enhancement of the data warehouse computing system with said tools, wherein all of said tools of are presented by the common user interface in a single view.

30. A data warehouse computing system, comprising:

a web server connected through a firewall with a client, the web server providing a plurality of tools accessible via a common user interface, the plurality of tools being used for a plurality of architectures, the plurality of architectures including;

a data warehouse architecture, located on at least one of the web server and the client, for distributing data from a data source to an end-user;

a development architecture, located on at least one of the web server and the client, for reducing the effort and costs involved with designing, implementing, and maintaining the data warehouse computing system; and

an operations architecture, located on one of the web server and the client, for supporting the data warehouse architecture and the development architecture;

wherein said common user interface is configured to present an interactive graphical user interface to said client that provides access to all of said tools and enables design, building and enhancement of the data warehouse computing system with said tools, wherein all of said tools of are presented by the common user interface in a single view.