Solved

ISP billing software?

Posted on 2012-03-27
5
427 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 79

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 79

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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When it comes to security, there are always trade-offs between security and convenience/ease of administration. This article examines some of the main pros and cons of using key authentication vs password authentication for hosting an SFTP server.
This article will inform Clients about common and important expectations from the freelancers (Experts) who are looking at your Gig.
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…

785 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