Network Circuit Stranded Recovery via Database Query

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Current network management systems fail to identify and recover stranded or access-no-revenue network circuits, leading to unused resources and unnecessary charges, as they do not adequately review the status of circuits post-service initiation or changes.

Innovation Solution

A method involving database queries to determine the status of network circuits, issuing disconnect or termination instructions when circuits are found to be stranded or not generating sufficient revenue, utilizing a rules-based algorithm to classify circuits and interface with network maintenance and LEC systems for disconnection or service termination.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Device complexity

If network management systems do not review circuit status post-service initiation, then system complexity is reduced, but stranded circuits are not identified and resources are wasted

Engineering Contradiction:
Improvesystem complexityVSAvoidresource waste
Core Design Contradiction:
Device complexityVSLoss of energy

Solution Approach 1:

The system performs preliminary actions by establishing criteria and rules before service initiation to predict which circuits may become stranded. The system proactively identifies potential stranded circuits by checking whether circuits are listed in inventory databases and comparing against service order databases before disconnection occurs, preventing resource waste without requiring complex continuous monitoring of all circuits.

Inventive Principle:
Principle #10Preliminary action

2Measurement precision

If network management systems continuously monitor all circuits, then stranded circuits are identified accurately, but system complexity and operational burden increase

Engineering Contradiction:
Improvecircuit status identification accuracyVSAvoidsystem complexity
Core Design Contradiction:
Measurement precisionVSDevice complexity

Solution Approach 1:

The system segments the monitoring task by dividing circuits into different categories based on their status and risk of becoming stranded. It focuses monitoring efforts on specific high-risk circuits identified through established criteria, such as circuits that are not actively generating revenue or those associated with discontinued services, rather than uniformly monitoring all circuits. This segmented approach maintains identification accuracy while reducing system complexity.

Inventive Principle:
Principle #1Segmentation

Solution Approach 2:

The system applies different monitoring intensities and methods to different circuits based on their local characteristics. High-priority circuits that meet specific criteria receive detailed scrutiny through multiple database checks, while low-risk circuits receive minimal or no monitoring. This localized quality approach ensures accurate identification of stranded circuits where needed without overwhelming system complexity.

Inventive Principle:
Principle #3Local quality

3Reliability

If manual review of circuit status is performed, then false disconnections are avoided, but time consumption and operational burden increase

Engineering Contradiction:
Improvedisconnection reliabilityVSAvoidtime consumption
Core Design Contradiction:
ReliabilityVSLoss of time

Solution Approach 1:

The system enables self-service by automatically performing circuit status verification through predefined rules and database queries. The system autonomously checks whether circuits should be disconnected by comparing inventory database listings against service order database records, and can automatically initiate disconnection for circuits meeting stranded criteria. This eliminates time-consuming manual reviews while maintaining high disconnection reliability through systematic automated verification.

Inventive Principle:
Principle #25Self-service

4Productivity

If automated disconnection rules are implemented, then processing speed increases, but risk of false disconnections increases

Engineering Contradiction:
Improvecircuit processing speedVSAvoiddisconnection accuracy
Core Design Contradiction:
ProductivityVSReliability

Solution Approach 1:

The system implements feedback mechanisms by continuously verifying circuit status against multiple data sources before and during the disconnection process. Automated rules check whether circuits are listed in inventory databases and cross-reference with service order databases to confirm stranded status. The system provides feedback loops that allow verification of disconnection decisions and can prevent false disconnections by detecting inconsistencies across different database records, thereby maintaining both speed and accuracy.

Inventive Principle:
Principle #23Feedback

Data Source

PatentUS7779098B1Methods for identifying and recovering stranded and access-no-revenue network circuits
Publication Date: 2010.08.17 AT&T CORP
  • US7779098B1 patent drawing
  • US7779098B1 patent drawing
  • US7779098B1 patent drawing

AI summary

A method includes issuing a retrieval instruction, such as a database query, to retrieve from a database system a datum associated with a network circuit. Upon receiving the datum from the database system, it is determined, based on the datum received, whether the network circuit is stranded or whether the network circuit is incurring a charge but is not generating sufficient revenue. When the network circuit is stranded, a disconnect instruction to disconnect the network circuit is issued. When the network circuit is incurring a charge but the amount of revenue generated by the network circuit is below a predetermined threshold, a termination instruction to terminate a service associated with the network circuit is issued.