| Business
Automation: UNIBill (Data Processing Automation System for Mobile Communications Lines Network Provider) The Client: MOBILENET Inc., Kharkov, Ukraine, large mobile communication provider The Problem: Having a large number of clients and employees, the customer required a tool for administration and maintenance of a growing load of a process. A new system was expected to replace existing inefficient steps of a process to enable centralized data collection and management in a performance. Beyond this, it was wanted to create an ability for the system to be easy replenished with new functions, connecting with planned new kinds of service implementation. The Solution: Our ISPBill packet was chosen as the prototype. But UNIBill was developed as a more powerful version. Its flexible structure is practically universal and may be modified and replenished with accounting of new kinds of service, saving the same database organization. At this stage, UNIBill includes a non-standard module for lease accounting, what is especially important not only for this customer but for Internet providers, Internet cafe and game-center owners, as well. The rating mechanism of the module features several types of discounts and provides selecting a client's category for payment processing. The development of other modules is now in a process. Next page are shown a main block-scheme of the System The Application's flexibility is determined with the well-considered system of modules (see. Fig.1)
The core of the system is a relative database on RDBMS Oracle 8.0.5, developed by our best Analytic Group memebers. Logic processing is wholly located into that part of the structure as stored procedures and triggers. 2.I/O Server is another main block of the system. It is developed with a help of ProC language. The Server is dedicated to accepting sensor connections and Oracle interpretation of the received data then on. Several elementary modules are concentrated in groups to the proper channels of a certain kind of service, and a Service Structure may be combined from 1 to n groups for a number of service branches. The term "Service" into the frame of this System ( see Figure 2) includes: A proper "service" or resource, to which one an access is provided; A Sensor , which one receives a data concerning a service or resource usage load for every client and forms packets for Input-Output Server, then periodically connects with Server and transfer a data by TCP/IP; A Control Unit swithes On/Off a certain client service/resource provided by a System Administrator, user or Core of the System command.
Configuration and Tools Hardware: IBM PC; Operating System: Linux;. Programming Languages: PHP, C, ProC, Shell; Database: Oracle 8.0.5 |
|||||||||