Database Integration Tool

• US 20110055291A1
• Filed: 08/31/2009
• Published: 03/03/2011
• Est. Priority Date: 08/31/2009
• Status: Abandoned Application

• Current Assignee: AT&T Intellectual Property I LP (AT&T, Inc.)
• Original Assignee: AT&T Intellectual Property I LP (AT&T, Inc.)
• Inventors: Bullard, Walter G., Larrow, Lynn D., Henderson, Bryn
• Application Number:
  US12/551,099
• Publication Number:
  US 20110055291A1
• Time in Patent Office: Days
• US Class Current: 707/808
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application

Abstract

A first data set is gathered from a first server computer, and second data set is gathered from a second server computer. The first server computer may include a first database storing first aspects of subscriber data and a first interface configured to access the first database. The second server computer may include a second database storing second aspects of subscriber data and a second interface configured to access the second database. The first data set and the second data set are transformed into an integrated data set by merging the first data set and the second data set into the integrated data set. A central interface configured to access the integrated data set and bypass the first interface and the second interface is provided. The central interface may be configured to concurrently display the first aspects of subscriber data and the second aspects of subscriber data through a computer.

Claims

1. A computer-implemented method for displaying data from multiple server computers, the method comprising computer-implemented operations for:

gathering a first data set from a first server computer from the multiple server computers, the first server computer including a first database storing first aspects of subscriber data and a first interface configured to access the first database;

gathering a second data set from a second server computer from the multiple server computers, the second server computer including a second database storing second aspects of subscriber data and a second interface configured to access the second database;

transforming the first data set from the first server computer and the second data set from the second server computer into an integrated data set by merging the first data set and the second data set into the integrated data set; and

providing a central interface configured to access the integrated data set and bypass the first interface and the second interface, the central interface configured to concurrently display the first aspects of subscriber data and the second aspects of subscriber data through a computer.

2. The computer-implemented method of claim 1, wherein the subscriber data comprises digital subscriber line (DSL) subscriber data.

3. The computer-implemented method of claim 1, wherein the first interface is configured to access the first database and is not configured to access the second database;

and wherein the second interface is configured to access the second database and is not configured to access the second database.

4. The computer-implemented method of claim 1, wherein the integrated data set includes a conversion data set and a fallout data set, the conversion data set comprises subscribers having matching data across multiple previous databases, the fallout data set comprises subscribers having non-matching data across the multiple previous databases.

5. The computer-implemented method of claim 1, wherein the central interface displays the integrated data set as a grid comprising a plurality of rows, a plurality of columns, and a plurality of entries, each of the rows corresponding to a different aspect of subscriber data, each of the columns corresponding to one of the multiple server computers, each of the entries displaying a value corresponding to one of the rows and one of the entries.

6. The computer-implemented method of claim 5, wherein the entries display values to digital subscriber line (DSL) equipment;

and wherein at least one of the values comprises a hyperlink to real-time or near real-time data from the DSL equipment.

7. The computer-implemented method of claim 1, wherein the central interface enables searching of subscriber data in the integrated data set by subscriber telephone number.

8. A system for displaying data from multiple server computers, comprising:

a memory for storing a program containing code for displaying data from multiple server computers;

a processor functionally coupled to the memory, the processor being responsive to computer-executable instructions contained in the program and configured to

gather a first data set from a first server computer from the multiple server computers, the first server computer including a first database storing first aspects of subscriber data and a first interface configured to access the first database,

gather a second data set from a second server computer from the multiple server computers, the second server computer including a second database storing second aspects of subscriber data and a second interface configured to access the second database,

transform the first data set from the first server computer and the second data set from the second server computer into an integrated data set by merging the first data set and the second data set into the integrated data set, and

provide a central interface configured to access the integrated data set and bypass the first interface and the second interface, the central interface configured to concurrently display the first aspects of subscriber data and the second aspects of subscriber data through a computer.

9. The system of claim 8, wherein the subscriber data comprises digital subscriber line (DSL) subscriber data.

10. The system of claim 8, wherein the first interface is configured to access the first database and is not configured to access the second database;

and wherein the second interface is configured to access the second database and is not configured to access the second database.

11. The system of claim 8, wherein the integrated data set includes a conversion data set and a fallout data set, the conversion data set comprises subscribers having matching data across multiple previous databases, the fallout data set comprises subscribers having non-matching data across the multiple previous databases.

12. The system of claim 8, wherein the central interface displays the integrated data set as a grid comprising a plurality of rows, a plurality of columns, and a plurality of entries, each of the rows corresponding to a different aspect of subscriber data, each of the columns corresponding to one of the multiple server computers, each of the entries displaying a value corresponding to one of the rows and one of the entries.

13. The system of claim 12, wherein the entries display values to digital subscriber line (DSL) equipment;

and wherein at least one of the values comprises a hyperlink to real-time or near real-time data from the DSL equipment.

14. A computer-readable medium having instructions stored thereon for execution by a processor to provide a method for displaying data from multiple server computers, the method comprising:

gathering a first data set from a first server computer from the multiple server computers, the first server computer including a first database storing first aspects of subscriber data and a first interface configured to access the first database;

gathering a second data set from a second server computer from the multiple server computers, the second server computer including a second database storing second aspects of subscriber data and a second interface configured to access the second database;

transforming the first data set from the first server computer and the second data set from the second server computer into an integrated data set by merging the first data set and the second data set into the integrated data set; and

providing a central interface configured to access the integrated data set and bypass the first interface and the second interface, the central interface configured to concurrently display the first aspects of subscriber data and the second aspects of subscriber data through a computer.

15. The computer-readable medium of claim 14, wherein the subscriber data comprises digital subscriber line (DSL) subscriber data.

16. The computer-readable medium of claim 14, wherein the first interface is configured to access the first database and is not configured to access the second database;

and wherein the second interface is configured to access the second database and is not configured to access the second database.

17. The computer-readable medium of claim 14, wherein the integrated data set includes a conversion data set and a fallout data set, the conversion data set comprises subscribers having matching data across multiple previous databases, the fallout data set comprises subscribers having non-matching data across the multiple previous databases.

18. The computer-readable medium of claim 14, wherein the central interface displays the integrated data set as a grid comprising a plurality of rows, a plurality of columns, and a plurality of entries, each of the rows corresponding to a different aspect of subscriber data, each of the columns corresponding to one of the multiple server computers, each of the entries displaying a value corresponding to one of the rows and one of the entries.

19. The computer-readable medium of claim 18, wherein the entries display values to digital subscriber line (DSL) equipment;

and wherein at least one of the values comprises a hyperlink to real-time or near real-time data from the DSL equipment.

20. The computer-readable medium of claim 14, wherein the central interface enables searching of subscriber data in the integrated data set by subscriber telephone number.