Decision support system and method

• US 20020059216A1
• Filed: 04/02/2001
• Published: 05/16/2002
• Est. Priority Date: 03/31/2000
• Status: Abandoned Application

• Current Assignee: LHS Telekom GmbH & Co. KG
• Original Assignee: LHS Telekom GmbH & Co. KG
• Inventors: Gowen, Richard C., Akins, Wayne
• Application Number:
  US09/825,436
• Publication Number:
  US 20020059216A1
• Time in Patent Office: Days
• US Class Current: 707/4
• CPC Class Codes: G06Q 99/00 Subject matter not provided for in other groups of this subclass

Abstract

The present invention provides a system and method for providing decision support. In architecture, the system includes an input mechanism that acquires system data, and a transformation mechanism that transforms the system data into searchable data. A reporter then provides queries on the searchable data. The present invention can also be viewed as a method for providing decision support. The method operates by acquiring system data; transforming the system data into searchable data; and providing queries on the searchable data.

Claims

1. A system for providing a decision support system, comprising:

means for acquiring system data;

means for transforming the system data into searchable data; and

means for providing queries on the searchable data.

2. The system of claim 1, further comprising:

means for loading searchable data into a billing data mart.

3. The system of claim 2, further comprising:

means for loading searchable data into a usage data mart.

4. The system of claim 3, further comprising:

means for creating summary tables of the billing data mart and usage data mart.

5. The system of claim 4, further comprising:

means for refreshing the billing data mart and usage data mart.

6. A method for providing a decision support system, said method comprising the steps of:

acquiring system data;

transforming the system data into searchable data; and

providing queries on the searchable data.

7. The method of claim 6, further comprising the step of:

loading searchable data into a billing data mart.

8. The method of claim 7, further comprising the step of:

loading searchable data into a usage data mart.

9. The method of claim 8, further comprising the step of:

creating summary tables of the billing data mart and usage data mart.

10. The method of claim 9, further comprising the step of:

refreshing the billing data mart and usage data mart.

11. A computer readable medium for providing a decision support system, comprising:

logic for acquiring system data;

logic for transforming the system data into searchable data; and

logic for providing queries on the searchable data.

12. The computer readable medium of claim 11, further comprising:

logic for loading searchable data into a billing data mart.

13. The computer readable medium of claim 12, further comprising:

logic for loading searchable data into an usage data mart.

14. The computer readable medium of claim 13, further comprising:

logic for creating summary tables of the billing data mart and usage data mart.

15. The computer readable medium of claim 14, further comprising:

logic for refreshing the billing data mart and usage data mart.

17. The system of claim 16, wherein the input mechanism loads the searchable data into a billing data mart.

18. The system of claim 17, wherein the input mechanism loads the searchable data into an usage data mart.

19. The system of claim 18, further comprising:

a summary mechanism that creates a plurality of summary tables for the billing data mart and usage data mart.

20. The system of claim 19, wherein the input mechanism refreshes the billing data mart and usage data mart.

16. A system for providing a decision support system, comprising:

an input mechanism that acquires system data;

a transformation mechanism that transforms the system data into searchable data; and

a reporter that provides queries on the searchable data.