Method and system of restating telecommunications data by a batch-driven integrated rules module

• US 7,552,145 B1
• Filed: 02/28/2006
• Issued: 06/23/2009
• Est. Priority Date: 02/28/2006
• Status: Expired due to Fees

• Current Assignee: Sprint Communications Company LP (Deutsche Telekom AG)
• Original Assignee: Sprint Communications Company LP (Deutsche Telekom AG)
• Inventors: Pence, Steven Eugene, Errigo, Robin Ranee
• Primary Examiner(s): Breene; John E
• Assistant Examiner(s): Kerzhner; Aleksandr
• Application Number:
  US11/364,430
• Time in Patent Office: 1,211 Days
• Field of Search: None
• US Class Current: 1/1
• CPC Class Codes: G06Q 10/00 Administration; Management

Abstract

One exemplary method of restating telecommunications data by a batch-driven integrated rules module can include receiving batched client data for transforming and loading into a database warehouse to create legacy client data. The method may also include selecting criteria for restating data from a GUI, communicating the criteria to the batch-driven integrated rules module, generating a script based on the communicated criteria for extracting data from the data warehouse that generally includes the legacy client data, extracting the legacy client data from the data warehouse, queuing the legacy client data into a batch, transforming the batched data based on the script, and loading the transformed data in the data warehouse. Additionally, the batch-driven integrated rules module generally includes a rules database, a rules engine, a script generator and a batch tool, and communicates with at least one other database for creating the script.

Claims

1. A method of restating telecommunications data by a batch-driven integrated rules module that receives batched client data, comprising:

selecting a set of criteria for restating data from a Graphic User Interface (GUI), the set of criteria includes attributes of a business rule to be applied for restating the data;

communicating the set of criteria to the batch-driven integrated rules module wherein the batch-driven integrated rules module comprises a rules database and a script generator;

mapping the attributes of the business rule in the communicated set of criteria to rules in the rules database by iteratively utilizing a collection of look-up tables and conditional logic in the rules database;

automatically generating a script by the script generator of the batch-driven integrated rules module by communicating with the rules database and compiling the rules in the rules database that were mapped to the attributes of the business rule;

extracting data from a data warehouse based on the generated script, the data comprises legacy client data;

queuing the legacy client data into a batch;

transforming the batched legacy client data based on the generated script; and

loading the transformed legacy client data in the data warehouse.

2. The method according to claim 1, wherein the data warehouse comprises at least a gigabyte of data.

3. The method according to claim 1, wherein the data warehouse comprises at least a terabyte of data.

4. The method according to claim 1, wherein the extracted data comprises at least a gigabyte of data.

5. The method according to claim 1, wherein the extracted data comprises at least a terabyte of data.

6. The method according to claim 1, wherein the telecommunications data comprises customer billing data.

7. The method according to claim 1, wherein the batch-driven integrated rules module further comprises a batch tool, and wherein the batch tool comprises a first extractor, the first extractor extracts data in amount of no more than 300 gigabyte and a second extractor, the second extractor extracts data in amount of more than 300 gigabyte.

8. The method according to claim 1, further comprising testing the script and loading the script in the rules database before extracting data from the data warehouse.

15. The method according to claim 1, wherein the criteria includes default attributes of the business rule.

9. A system for storing telecommunications data, comprising:

a computer system that implements a Graphic User Interface (GUI), the GUI provides selection of a set of criteria, the selected set of criteria includes attributes of a business rule;

a computer-readable storage medium that stores a data warehouse, the data warehouse including client data; and

a computer-readable storage medium that stores a batch-driven integrated rules module, the batch-driven integrated rules module communicates with the GUI and receives the selected set of criteria, the batch-driven integrated rules module comprises;

a rules database that maps the attributes of the selected set of criteria to rules in the rules database, the rules database iteratively utilizes a collection of look-up tables and conditional logic to map the attributes of the selected set of criteria to the rules in the rules database;

a script generator that communicates with the rules database and compiles code from the rules in the rules database that were mapped to by the rules database to automatically generate a script for the business rule, and the generated script is loaded in the rules database;

a batch tool that extracts the client data from the data warehouse into a batch; and

a rules engine that applies the script to the batch to transform the client data according to the business rule, the rules engine further saves the transformed client data into the data warehouse.

10. The system according to claim 9, wherein the data warehouse comprises at least a terabyte of data.

11. The system according to claim 9, wherein the extracted data comprises at least a gigabyte of data.

12. The system according to claim 9, wherein the extracted data comprises at least a terabyte of data.

13. The system according to claim 9, wherein the batch tool comprises a first extractor, the first extractor extracts data in amount of no more than 300 gigabyte and a second extractor, the second extractor extracts data in amount of more than 300 gigabyte.

14. The method system according to claim 9, wherein the rules engine transforms both client data from a business group and the client data from the data warehouse.

16. The system according to claim 9, wherein the criteria includes default attributes of the business rule.