Surveillance and table driven reporting tool
First Claim
1. A system for reporting performance of a telecommunication network or portion thereof, comprising:
- at least one user interface device for requesting a telecommunication network performance report and selection of a configuration of the report, the user interface device providing a first user option for requesting a first input parameter to base the report at least in part upon common data and a second input parameter to base the report at least in part upon performance data, wherein common data defines fixed properties of a set of one or more telecommunication network elements and performance data defines operational performance of a set of one or more telecommunication network elements;
a call statement module programmed to receive and convert said first and second input parameters into a database procedure call statement;
a database report module programmed to;
(i) receive said procedure call statement;
(ii) query meta-data tables comprising telecommunication network data so as to determine location of information for data responsive to said call statement;
(iii) receive from said meta-data tables the location information, and;
(iv) use the location information to retrieve data responsive to said call statement; and
,a report presentation module programmed to;
(i) receive the responsive data; and
(ii) convert and output the responsive data into the requested telecommunication network performance report having the selected configuration.
5 Assignments
0 Petitions
Accused Products
Abstract
A surveillance and reporting system (SRS) is provided that enables a user to monitor and generate reports from multiple related sources pertaining to events associated with each of these sources. The SRS is internet based, thereby providing access to remote users. The SRS also provides for identification of the sources by combining multiple databases related to each source in a tabular form in order to enable generation of complete reports and in order to enable sorting and filtering based upon more extensive source identification criteria. The SRS also accommodates changes in the underlying identification data by revising or generating up to date tables containing current identifying data for each of the multiple sources in a tabular form, thereby avoiding the need to reprogram the report procedures as a result of changes in the underlying data. The internet user may configure reports from a control panel that allows the user to select and to group multiple sources and to filter and sort data relating to the statistical performance of those sources with the most recent up to date information generated from each of the multiple sources. The reports may be in the form of tables, graphs or charts. The user also may select to receive reports by electronic mail or some other medium for convenient reference.
91 Citations
24 Claims
-
1. A system for reporting performance of a telecommunication network or portion thereof, comprising:
-
at least one user interface device for requesting a telecommunication network performance report and selection of a configuration of the report, the user interface device providing a first user option for requesting a first input parameter to base the report at least in part upon common data and a second input parameter to base the report at least in part upon performance data, wherein common data defines fixed properties of a set of one or more telecommunication network elements and performance data defines operational performance of a set of one or more telecommunication network elements; a call statement module programmed to receive and convert said first and second input parameters into a database procedure call statement; a database report module programmed to; (i) receive said procedure call statement; (ii) query meta-data tables comprising telecommunication network data so as to determine location of information for data responsive to said call statement; (iii) receive from said meta-data tables the location information, and; (iv) use the location information to retrieve data responsive to said call statement; and
,a report presentation module programmed to; (i) receive the responsive data; and (ii) convert and output the responsive data into the requested telecommunication network performance report having the selected configuration. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9)
-
-
10. A method for reporting performance of a telecommunication network or portion thereof, comprising the steps of:
-
retrieving common data defining fixed properties of telecommunication network elements from a common data source; retrieving performance data defining operational performance of telecommunication network elements from a performance data source; storing said common data in a common data table; storing said performance data in a performance data table; prompting via a user interface for a report request to provide a telecommunication network performance report, the report request including a configuration request for a report configuration, a common data request to base the report at least in part upon common data, and a performance data request to base the report at least in part upon performance data; creating a procedure call statement in response to the report request; querying a meta-data table for location information regarding data identified by said call statement; using said location information to create a query statement; executing said query statement so as to select data from said data tables; using the data selected to produce the report having said requested configuration; and outputting the produced report. - View Dependent Claims (11, 12, 13, 14, 15, 16, 17, 18)
-
-
19. A computer-readable medium comprising computer readable instructions for reporting performance of a telecommunication network or portion thereof, said instructions, when executed, perform the steps of:
-
retrieving common data defining fixed properties of telecommunication network elements from a common data source; retrieving performance data defining operational performance of telecommunication network elements from a performance data source; storing said common data in a common data table; storing said performance data in a performance data table; prompting via a user interface for a report request to provide a telecommunication network performance report, the report request including a configuration request for a report configuration, a common data request to base the report at least in part upon common data, and a performance data request to base the report at least in part upon performance data; creating a procedure call statement in response to the report request; querying a meta-data table for location information regarding data identified by said call statement; using said location information to create a query statement; executing said query statement so as to select data from said data tables; using the data selected to produce the report having said requested configuration; and outputting the produced report. - View Dependent Claims (20, 21, 22, 23, 24)
-
Specification