Solved

ISP billing software?

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

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 80

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

The New “Normal” in Modern Enterprise Operations

DevOps for the modern enterprise offers many benefits — increased agility, productivity, and more, but digital transformation isn’t easy, especially if you’re not addressing the right issues. Register for the webinar to dive into the “new normal” for enterprise modern ops.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Setting up a VPN 60 183
Use of vpn-filter value  in S2S VPN 2 49
Powerline adapter slow Mbps? 38 171
assignment of laptops - risks 6 53
#Citrix #Citrix Netscaler #HTTP Compression #Load Balance
Use of TCL script on Cisco devices:  - create file and merge it with running configuration to apply configuration changes
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…
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.

830 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