Method and system for partitioning data files for efficient processing

• US 8,726,077 B2
• Filed: 05/02/2012
• Issued: 05/13/2014
• Est. Priority Date: 04/07/2010
• Status: Active Grant

• Current Assignee: Verizon Patent and Licensing Incorporated (Verizon Communications Inc.)
• Original Assignee: Verizon Patent and Licensing Incorporated (Verizon Communications Inc.)
• Inventors: Gudlavenkatasiva, Bhaskar R, Mariappan, Veeravijay
• Primary Examiner(s): Iqbal, Nadeem
• Application Number:
  US13/462,464
• Publication Number:
  US 20120213354A1
• Time in Patent Office: 741 Days
• Field of Search: 714/15, 714/16, 714 25- 27, 714/37, 714/38.1, 714/39, 714 48- 50
• US Class Current: 714/15
• CPC Class Codes: G06F 11/0793 Remedial or corrective actions recovery from an exception in an instruction pipeline G06F9/3861; by retry G06F11/1402; for recovering from a failure of a protocol instance or entity H04L69/40

Abstract

An approach is provided for fast processing of data files. A plurality of records are received from a source system. The records are validated against a predetermined data source. An error notification is generated based on the validation. The validated records are partitioned based on a unique parameter. The partitioned records are transformed according to a format specified by a target system. The transformed records are selectively corrected.

Claims

1. A method comprising:

receiving a plurality of telephone records for a telephone service provider;

determining whether one or more telephone numbers associated with one or more telephone records are assigned to the telephone service provider;

excluding one or more of the telephone records from validation if the associated telephone numbers are assigned to another telephone service provider;

validating the remaining telephone records against a predetermined data format of the telephone service provider;

generating an error notification based on the validation;

identifying telephone numbers associated with the remaining telephone records that are not in current use;

generating a report of the identified telephone numbers; and

determining a telephone number utilization forecast of the telephone service provider based, at least in part, on the identified telephone numbers.

2. A method comprising:

receiving a plurality of telephone records for a telephone service provider;

determining whether one or more telephone numbers associated with one or more telephone records are assigned to the telephone service provider;

excluding one or more of the telephone records from validation if the associated telephone numbers are assigned to another telephone service provider;

validating the remaining telephone records against a predetermined data format of the telephone service provider; and

generating an error notification based on the validation,

wherein the exclusion is performed by checking whether the telephone service provider is a code holder, a block holder, or a combination thereof, of the telephone records.

3. A method comprising:

receiving a plurality of telephone records for a telephone service provider;

determining whether one or more telephone numbers associated with one or more telephone records are assigned to the telephone service provider;

excluding one or more of the telephone records from validation if the associated telephone numbers are assigned to another telephone service provider;

validating the remaining telephone records against a predetermined data format of the telephone service provider;

generating an error notification based on the validation; and

further excluding a one or more of the remaining telephone records if the remaining records fail one or more predetermined criteria relating to a geographic region, a rate center, pooling information, or a combination thereof.

4. The method according to claim 2, further comprising:

partitioning a one or more of the remaining records that are invalidated based on a unique parameter; and

transforming the partitioned records to the predetermined data format.

5. The method according to claim 4, further comprising:

selectively performing correction of the transformed records by replacing missing or invalid data with correct data.

6. An apparatus comprising:

at least one processor; and

at least one memory including computer program code,

the at least one memory and the computer program code configured to, with the at least one processor, cause the apparatus to perform at least the following, receive a plurality of telephone records for a telephone service provider;

determine whether one or more telephone numbers associated with one or more telephone records are assigned to the telephone service provider;

exclude one or more of the telephone records from validation if the associated telephone numbers are assigned to another telephone service provider;

validate the remaining telephone records against a predetermined data format of the telephone service provider;

generate an error notification based on the validation;

identify telephone numbers associated with the remaining telephone records that are not in current use;

generate a report of the identified telephone numbers; and

determine a telephone number utilization forecast of the telephone service provider based, at least in part, on the identified telephone numbers.

7. An apparatus comprising:

at least one processor; and

at least one memory including computer program code,

the at least one memory and the computer program code configured to, with the at least one processor, cause the apparatus to perform at least the following,

receive a plurality of telephone records for a telephone service provider;

determine whether one or more telephone numbers associated with one or more telephone records are assigned to the telephone service provider;

exclude one or more of the telephone records from validation if the associated telephone numbers are assigned to another telephone service provider;

validate the remaining telephone records against a predetermined data format of the telephone service provider; and

generate an error notification based on the validation,

wherein the exclusion is performed by checking whether the telephone service provider is a code holder, a block holder, or a combination thereof, of the telephone records.

8. An apparatus comprising:

at least one processor; and

at least one memory including computer program code,

the at least one memory and the computer program code configured to, with the at least one processor, cause the apparatus to perform at least the following,

receive a plurality of telephone records for a telephone service provider;

determine whether one or more telephone numbers associated with one or more telephone records are assigned to the telephone service provider;

exclude one or more of the telephone records from validation if the associated telephone numbers are assigned to another telephone service provider;

validate the remaining telephone records against a predetermined data format of the telephone service provider;

generate an error notification based on the validation; and

further exclude a one or more of the remaining telephone records if the remaining records fail one or more predetermined criteria relating to a geographic region, a rate center, pooling information, or a combination thereof.

9. The apparatus according to claim 7, wherein the processor is further configured to:

partition a one or more of the remaining records that are invalidated based on a unique parameter; and

transform the partitioned records to the predetermined data format.

10. The apparatus according to claim 9, wherein the processor is further configured to:

selectively perform correction of the transformed records by replacing missing or invalid data with correct data.

11. A method comprising:

extracting a plurality of telephone records for a target system;

comparing the telephone records with a predetermined data format associated with the target system;

if a portion of the telephone records do not conform with the predetermined data format, selectively converting the portion of the telephone records by combining data in a local exchange routing guide into the portion of the telephone records;

partitioning the portion of the telephone records into a plurality of groups according to one or more telephone criteria including a network equipment identifier; and

validating the groups to identify errors.

12. The method according to claim 11, wherein the predetermined format relates to geographic region, a rate center, pooling information, or a combination thereof.

13. The method according to claim 11, wherein the equipment identifier specifies a switch corresponding to a telephone number.

14. The method according to claim 11, further comprising:

correcting the errors within each of the groups.

15. The method according to claim 14, further comprising:

initiating transmission of the portion of the telephone records to the target system after the correction.