 |
Case - Regional Bell Operating Company
|
|
Q. How can we integrate our legacy databases into a web interface that allows us to react to regulatory requirements and necessary operation repairs? We have several legacy databases in a variety of formats and our average table size is over 1.5 Million records.
A. Design a data warehouse with supporting processing marts that allow users to visualize and search pre-processed data, off loading processing to distributed nodes. Create distributed processing nodes that are enabled with XML and agent processing technology.
|
Background
As a leader in the telecommunications industry, this Regional Bell Operating Company (RBOC) had the inherited infrastructure of a company that has been operating for over 75 years. As a result it has to operate with a legacy and structure that many young companies never experience. Implementing technology in this environment has far reaching and significant implications.
This RBOC had built and inherited their systems under federal regulations and through many mergers and separations. Data in these systems was diverse and often unstructured, incomplete or in accurate. If the data tracked by these systems, was not acted on service outages or other catastrophic failures could occur. With regulatory constraints governing the maintenance of equipment tracked in these diverse database systems, the RBOC needed a way to not only manage the data, but also reduce and manage the cost of the processes that use the information.
Solution
Symplicity Networks helped this RBOC to apply a user-centric approach toward its development of a solution. Through the use of an innovative architecture, and effective eXtreme Programming techniques, Symplicity Networks data consulting and software engineering services was able to deliver not only an architecture but also as system that would allow the RBOC to automate the management of these processes.
The system architecture included an N-Tiered platform that included several databases and processing nodes. The reporting and presentation is handled by an ASP / .Net application that allows ad hoc querying of several database for interactive use by the RBOC personnel. Behind the scenes, processing nodes pre-process and analyze data providing information to the reporting interface and validating the external data sources.
Results
The complete architecture provide a method for the RBOC exceeded every goal established for it. The system:
-
Provided fast, user-friendly access to several databases
-
Created the means to track system changes an their associated notifications
-
Helped manage the workflow process for tracking the system changes
Benefits were gained beyond the original purpose of the system, in allowing the RBOC to do additional resource and capacity planning. Additional benefits were gained as a by-product of the system development, that allowed the RBOC to “cleanse” its existing data sources as well.
|
|
 |
|
|
Printer-friendly page
Send this page to a friend