StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>Although you could probably build a CDR solution with any database backend, one challenge will be in how you approach your data modelling and querying. NoSQL data modelling requires a significantly different approach compared to relational data, and is more akin to a denormalized data warehouse (which should be a good fit for your use case!).</p> <p>There are a number of open source CDR projects which may also be worth investigating depending on your requirements.</p> <p>For a specific example that may help with your investigation, I would have a look at <a href="http://www.cdr-stats.org/" rel="nofollow">CDR-Stats</a>:</p> <ul> <li><a href="http://www.cdr-stats.org/documentation/how-it-works/" rel="nofollow">How it works</a> includes a high level overview of the product architecture</li> <li><a href="http://www.cdr-stats.org/docs/en/latest/html/mongodb-architecture.html" rel="nofollow">Datastore architecture</a> describes their approach to data modelling and pre-aggregation using MongoDB</li> </ul> <p>Further viewing:</p> <ul> <li><a href="http://www.slideshare.net/areski/cdrstats-voip-analytics-solution-for-asterisk-and-freeswitch-with-mongodb" rel="nofollow">CDR-Stats call data analysis for Asterisk & Freeswitch</a></li> <li><a href="http://datamgmt.com/building-a-data-warehouse-of-call-data-records-cdr-solution-considerations/" rel="nofollow">Building a data warehouse of CDR records: Solution Considerations</a></li> <li><a href="http://vimeo.com/7671465" rel="nofollow">Hadoop-based data mining platform for the telecom industry</a></li> </ul>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload