Telephone Number Normalization for Calling Line Identification
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Non-standardized formats of telephone numbers in databases hinder efficient querying for calling line identification resolution, leading to inefficiencies in retrieving contact information for notification purposes.
Innovation Solution
A computing device is programmed with a normalization module to standardize telephone numbers, a calling line manipulation module to format the calling line identification number, and a resource query module to query databases for contact information, ensuring efficient retrieval and inclusion in notifications.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Ease of operation
If telephone numbers are stored in non-standardized formats in databases, then ease of data entry is improved, but querying efficiency for calling line identification resolution deteriorates
Solution Approach 1:
The system performs preliminary normalization of telephone numbers during data entry, automatically converting them to a standardized format (e.g., E.164 format) and storing both the original and normalized versions. This preliminary action ensures that when querying is needed, the data is already in a searchable standardized format, resolving the contradiction between ease of entry and querying efficiency
Solution Approach 2:
The invention introduces a normalization module as an intermediary component that sits between the database and the querying system. This module automatically standardizes telephone numbers during queries by comparing them against stored contact information, enabling efficient resolution without requiring all data to be pre-processed, thus maintaining both ease of entry and querying efficiency
2Productivity
If telephone numbers are standardized during data entry, then querying efficiency is improved, but processing time and system complexity increase
Solution Approach 1:
The system applies partial normalization by only standardizing telephone numbers that are actually needed for querying. The normalization module processes telephone numbers on-demand during call identification resolution rather than pre-processing all stored numbers, reducing unnecessary processing time while maintaining querying efficiency for relevant contacts
Solution Approach 2:
The invention changes the parameter of telephone number format dynamically based on the querying context. The system stores telephone numbers in their original formats and applies format transformation only when needed for specific queries, using parameter changes to balance processing time requirements with querying efficiency needs
3Stability of the object's composition
If telephone numbers are standardized during data entry, then data consistency is improved, but device complexity increases
Solution Approach 1:
The invention extracts the normalization function into a separate, dedicated module that handles telephone number standardization independently from the main database operations. This extraction reduces complexity in the core data entry system while maintaining data consistency through the specialized normalization module, resolving the contradiction between consistency and simplicity
Data Source
AI summary
A computing device includes a processing unit and a system memory. The processing unit creates a normalization module programmed to modify a plurality of telephone numbers so that the telephone numbers conform to a specified format, creates a calling line manipulation module programmed to manipulate a calling line identification number to form a number for querying one or more databases including contact information, and creates a resource query module programmed to query the databases including the contacting information using the number, receive one or more query results from the databases, and select one of the query results for inclusion in a notification of a telephonic message.