Telecom Number Resource Forecasting Automation

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Telecommunications carriers face significant time and resource challenges in determining current and projected telephone number resources, leading to inefficiencies in completing the Months to Exhaust and Utilization Certification Worksheet, which can result in wasted efforts and reluctance to request additional numbering resources due to uncertainty in approval.

Innovation Solution

A system and method that utilizes databases to quickly determine current and projected telephone number resources, including a first database operated by the carrier and a second database with network-accessible information, allowing for automated querying and reporting of telephone number usage and forecasting, thereby reducing the time required to complete resource determination tasks.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Measurement precision

If manual calculations and data collection methods are used to determine telephone number resources, then accuracy can be maintained through careful verification, but the time required increases to several weeks

Engineering Contradiction:
Improveforecasting accuracyVSAvoidtime to complete resource determination
Core Design Contradiction:
Measurement precisionVSLoss of time

Solution Approach 1:

The patent replaces manual mechanical calculations with automated computer-based systems. The software automatically queries databases, retrieves telephone number usage data, performs calculations, and generates forecasts without manual intervention. This substitution maintains accuracy through systematic data processing while reducing time from several weeks to minutes.

Inventive Principle:
Principle #28Mechanics substitution (Replace mechanical system)

Solution Approach 2:

The patent creates automated copies of manual processes through software that replicates the data collection, calculation, and analysis functions. The system copies the essential logic of manual forecasting into executable code, allowing rapid reproduction of accurate results without repeating manual steps.

Inventive Principle:
Principle #26Copying

2Measurement precision

If comprehensive data collection from multiple sources is performed to ensure accurate forecasting, then measurement precision improves, but device complexity and operational difficulty increase

Engineering Contradiction:
Improveresource utilization accuracyVSAvoidsystem complexity
Core Design Contradiction:
Measurement precisionVSDevice complexity

Solution Approach 1:

The patent implements a universal software system that handles multiple functions: querying internal databases, accessing external databases, retrieving usage data, performing calculations, and generating forecasts. This multi-functional system consolidates what would otherwise require multiple separate tools and processes, maintaining comprehensive data collection while managing complexity through integration.

Inventive Principle:
Principle #6Universality (Multi-functionality)

Solution Approach 2:

The patent introduces a software intermediary that manages the complexity of data collection from multiple sources. The software acts as a mediator between various databases and the forecasting process, automatically handling data retrieval, validation, and integration. This intermediary shields users from complexity while ensuring comprehensive data collection for accurate forecasts.

Inventive Principle:
Principle #24Intermediary (Mediator)

3Adaptability or versatility

If manual completion of the Months to Exhaust Worksheet is performed, then flexibility in analysis can be maintained, but productivity decreases due to the time-consuming nature of the process

Engineering Contradiction:
Improveanalysis flexibilityVSAvoidresource determination speed
Core Design Contradiction:
Adaptability or versatilityVSProductivity

Solution Approach 1:

The patent implements a dynamic software system that can adapt to different analysis requirements. The system allows users to modify parameters, adjust forecasting assumptions, and explore different scenarios without restarting the entire process. This dynamic capability maintains analytical flexibility while executing calculations rapidly, significantly improving productivity over static manual methods.

Inventive Principle:
Principle #15Dynamics

4Measurement precision

If extensive calculations are performed to determine months to exhaust and utilization metrics, then measurement precision improves, but loss of time increases significantly

Engineering Contradiction:
Improvemonths to exhaust calculation accuracyVSAvoidcalculation time
Core Design Contradiction:
Measurement precisionVSLoss of time

Solution Approach 1:

The patent replaces manual calculation mechanics with automated computer-based calculation systems. The software performs complex mathematical operations for determining months to exhaust and utilization metrics instantaneously, maintaining precision through systematic algorithms while reducing calculation time from days to seconds.

Inventive Principle:
Principle #28Mechanics substitution (Replace mechanical system)

Data Source

PatentUS8045692B2System and method for determining whether to request additional telephone numbering resources by a telecommunications carrier
Publication Date: 2011.10.25 CENTURYLINK INTELLECTUAL PROPERTY LLC
  • US8045692B2 patent drawing
  • US8045692B2 patent drawing
  • US8045692B2 patent drawing

AI summary

A system for determining whether to request additional telephone number resources for a telecommunications carrier. The system may include a first database operated by a telecommunications carrier and configured to store data indicative of telephone number usage of telephone numbers assigned to the telecommunications carrier. A computing device may be in communication with a second database via a network, the second database may contain telephone number usage information associated with multiple telecommunications carriers. The computing device may execute software to query the first and second databases to retrieve information associated with the telecommunications carrier (i) to determine current utilization of telephone numbers of a rate center and (ii) to determine months to exhaust of telephone numbers.