Telecom DBMS

Data Base Management System

An Overview: The Customer

The customer is a leading provider of voice, video, and data services across America and the world. The customer provides services to a large variety of customers and its billing application is the backbone of its operation.

Key Challenges

The customer is running a billing-management warehouse system that was developed several years ago using PowerBuilder. The customer required a Java application, working as a Web J2EE application. This architecture would eliminate the need for client software installation and improve the end-user daily data-retrieval and manipulation experience. The system is online transaction oriented, but also includes reporting. Any project to enhance the system must cause no service disruptions, which could have grave consequences for the customer.

The main reasons that led to this modernization are:

  • Lack of available PowerBuilder programmers
  • The need for a Web-based application
  • Consolidation of the development environment in the organization

The application was developed in PowerBuilder 9 with over a hundred Data Windows and windows. The application included calls to external functions as well. The data was stored in Oracle version 8i, and part of the migration required upgrading to Oracle 10g. Oracle stored procedures are used in the application to execute some of the business logic and reports

The Solution

The Mann Technologies Language migrate tool offered a clean, quick, and cost-effective solution to migrate the application from PowerBuilder to Java. Using automated tools, the application was converted to a pure Java application. Mann Technologies provides a comprehensive framework to enable the out-of-the-box functionality of PowerBuilder. The migrated application "look and feel" is similar to the original application, thus avoiding the need to retrain the end users, which brings considerable saving in the cost and time of going to production.

Within several months the application was transformed from a windows-based application to a Web-based application that includes:

  • Data layer – responsible for the backend activity and manipulation of the data
  • Business rule layer – based on EJBs, this layer handles the business logic issues of the application
  • Presentation layer – based on JSP, the end user screens are presented in a modern web browser
Figure : Converted Web Application Architecture Business Benefits
  • Increase transparency among customers and telecom service providers.
  • Scalable architecture capable to scale up with increasing users and geography
  • Ability to grow to support increased volumes of users and data
  • Flow of information among different functions of an enterprise, while also permitting information sharing across organizational units and geographical locations.