Record Breaking Reporting Speed via CROME Wireless Performance Management
05.Sep.03-- Quantum Systems Integrators, Inc., aka QuantumSI, has completed and deployed a set of new performance optimizations to QuantumSI's CROME product line, this Wireline and Wireless Performance Management (PM) Suite, now updated with major performance improvements (in some types of queries by as much as 1800% e.g. 18X) for existing iDEN, GSM and CDMA deployments.
For example a full ad-hoc report displaying four (4) formulas for across 365 days (i.e. a full year) for any arbitrary site now completes in CROME in a just 3.1 seconds (5.6 seconds across the Internet between different cities), a task that previously took 101.8 seconds, utilizing standard full ad-hoc CROME reports.(taking into account both BSC migrations and name changes). When excluding weekends from this example report the completion time drops to just 2.6 seconds and a "Friday's Only" report across a full year takes a mere 1.4 seconds.
This scheduled performance enhancement was implemented by Quantum's software engineering staff, seven months ahead of scheduled completion date.
A complex example long term to short term analysis
Running a multi-formula report across multiple tables at multiple levels levels (at the channel level and above) across all items in a switch (in this case 710 sectors) across three (3) years for only weekdays by every week, at a standard busy hour - takes only 2.7 seconds, shown below are the first two formulas, 'minutes of use' and 'transmission drop rate' (the 'radio count' and 'MOU per radio' formulas are currently hidden).
Remember that all CROME reports are live report items and can be manipulated as such, we can easily switch to a view of the formula 'MOU per radio' with a simple menu selection to get the following information on the average contribution of each radio:
The above graph leads immediately to the question which sectors (and thus BR sets) are not currently contributing to the bottom line, CROME can answer this question by running the same report on a given day by element (i.e. a slightly different filter is applied to the report e.g. date selection and aggregation settings). The resulting report is sorted ascending and set to display only the top first twenty (20) items.
As can be seen we quickly identified low usage sectors (and thus base radios that are not being fully utilized) in a report that took just 2.6 seconds to run (note there are three other formulas hidden - if we just made a new ad-hoc report to show the above it would only take 2.3 seconds to complete). The above report was run for a service window i.e. 6 am to 11 pm on a recent day to find all sectors that do not contribute to the system wide avg_mou_per_br metric.
The report used for all the the above graphs took only 50 seconds to write via CROME's built report and formula editors. It should be obvious that CROME provides the flexibility and power to run traditional reports quickly - but also any desired ad-hoc report in just a few seconds.
Total System Flexibility
Most tool suites are designed for one particular task, in contrast to the traditional software design philosophy, QuantumSI values generic extensible code from which our customers gain enormous benefit.
With this in mind QuantumSI challenges potential customers to ask themselves (and other venders) some serious questions about regarding the flexibility of their Performance Management (PM) solutions :
- Can your PM tool analyze different technologies such as iDEN, GSM, wireless and wireline data from different
switches and vendors in the same application - is it flexible enough to quickly add support for new data sets (i.e.
new elements for new services ) ?
- Can your PM tool process thousands of sectors (or trunks, etc.) per second in a full ad-hoc reporting mode?
- Can your PM tool support anyone in the enterprise using only a common web browser like IE and Netscape on platforms
ranging from PCs to Unix/Linux workstations?
- Can your PM tool run with different software revisions and mismatched data sets coming from the myriad of network
elements in a national infrastructure?
- Can your PM tool scale from a market to a nation without losing performance and becoming sluggish?
- Was your PM solution designed from the ground up to be fault tolerant?
- Is your PM tool flexible enough to analyze other data for example billing data i.e. mining CDR records and
even drive test data i.e. taking a single mobile phone across time and displaying statistical information in an
interactive GIS display as it moved?
- Can your PM tool match CROME's proven near-term and long-term capabilities, CROME not only processes data in real-time but also stores enough data online to perform historical trend analysis via ad-hoc reporting across 5, 10 and even 15 years.
QuantumSI's CROME solution easily meet the challenges set forth above. It is no small wonder that our competitors have been attempting to copy QuantumSI products for years (using our product as the "gold" standard) in an attempt to emulate CROME's technology, feature sets, high level of integration, and ease of use.
The CROME software suite is a best in its class decision support system that allows both land-line and wireless service providers to quickly analyze capacity, trends and faults for any network. This allows wireless providers to proactively tune, adjust, reassign, or increase capacity to meet exacting quality of service levels at the lowest possible equipment expenditure rate.
CROME is a generic full ad-hoc reporting system which is implemented in the JAVA programming language, there is no need for end users to write code or develop additional modules to enhance or expand the system.
Statistical data flows are captured in real-time from a multitude of network elements and the data is immediately presented to end-users via a 100% pure Java(tm) reporting tool that runs on both standard PCs and Sun Workstations.
The use of integrated GIS features and multidimensional reporting along with built in high Erlang-B and Erlang-C functions has proven to be invaluable to Quantum's customers.
In addition since Quantum's CROME product is a national multi-vendor and multi-switch PM solution, thus with any revision for any vendor's switch or equipment the CROME system transparently combines data from multiple switch types across multiple vendor revisions (i.e. input data) into a single unified regional or national report for any combination of switches and/or sub-elements across any time range or focus via lightning fast full on demand ad-hoc reporting.