Solved

ISP billing software?

Posted on 2012-03-27
5
417 Views
Last Modified: 2012-04-07
IN general, what software do ISPs use for billing purposes, ie when you make a phone call, download some data and all those charges that come up on your bill?

im trying to develop some simple "theorical" app that should link to the ISP billing system, and since i have no idea of what do they use to track and bill our data/voice/services usage i'd like to find out.

can anyone shed some light on this?

thank you.
0
Comment
Question by:celtician
  • 2
  • 2
5 Comments
 
LVL 78

Expert Comment

by:David Johnson, CD, MVP
ID: 37774892
Simply they monitor all of your usage on a realtime basis and store this information in a database. And they probably monitor a lot more than what they report to you. i.e. your location, call quality, cell site 2 site transfers, etc. On their billing cycle they extract the items needed for the billing and then create your invoice.
0
 
LVL 17

Accepted Solution

by:
pergr earned 500 total points
ID: 37775406
It is a staged process.

First, they collect records of your usage, using for example RADIUS. The usage can be from both data (BNG/BRAS equipment) and voice equipment.

Next there may be a stage where they correlate records. For example, if they have two voice switches which they get records from, and your phone call went through both voice switches, then they put these to records into one single one for your phone call.

The final record is typically called a CDR; a Call Detail Record.

The next stage is to "rate" the CDR, effectivaely is to apply the charges, or calculate the price that should charged for that phone call.

At the end of the billing period (typically at the end of the month) the "billing" is done. This stage put together all your rated CDR events, in order to create a bill. At this stage various discounts, packages, etc, are applied. Perhaps you get a discount if you make calls of 500 minutes and also have a data package, etc. The output is the bill.


Next step is to print that bill, but also to import it into the Financial/Accounting software of the ISP, and any other place that keep track of collections - that is the payments received from customers.
0
 

Author Comment

by:celtician
ID: 37816844
Thanks for the answer, and do you know (in general) what database or software they use for that log and for the billing purposes?thats what im most interested in finding out

than you.
0
 
LVL 78

Expert Comment

by:David Johnson, CD, MVP
ID: 37816910
Ask them, if they don't tell you then you know that it is a 'company' secret.
0
 
LVL 17

Assisted Solution

by:pergr
pergr earned 500 total points
ID: 37819918
Most commercial billing systems use Oracle database in the bottom.

A lot of of cheaper, low end solutions, and also in house developed billing systems, use MySQL.
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

This is an article about my experiences with remote access to my clients (so that I may serve them) and eventually to my home office system via Radmin Remote Control. I have been using remote access for over 10 years and have been improving my metho…
Meet the world's only “Transparent Cloud™” from Superb Internet Corporation. Now, you can experience firsthand a cloud platform that consistently outperforms Amazon Web Services (AWS), IBM’s Softlayer, and Microsoft’s Azure when it comes to CPU and …
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now