Solved

ISP billing software?

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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Read-only SNMP string example ? 7 76
Installation of Nessus Professional 5 84
SOFS cluser offline 3 44
Filter IP range with PowerShell 1 29
Data center, now-a-days, is referred as the home of all the advanced technologies. In-fact, most of the businesses are now establishing their entire organizational structure around the IT capabilities.
When you try to share a printer , you may receive one of the following error messages. Error message when you use the Add Printer Wizard to share a printer: Windows could not share your printer. Operation could not be completed (Error 0x000006…
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…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

863 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

28 Experts available now in Live!

Get 1:1 Help Now