April 9, 2008 - Telecom services provider NetworkIP is using the Vertica Analytic Database to charge a key business offering for its customers, enabling them to query more call detail record (CDR) data faster than before.


This performance boost is helping customers make better business decisions through analysis of CDRs and is enabling NetworkIP to differentiate and grow in a competitive marketplace.


Texas-based NetworkIP lets a broad range of customers, including telcos and distributors, offer branded telephone calling cards, audio conferencing and other prepaid services. To help customers optimize calling plan rates, analyze plan usage patterns and monitor profitability of their services, the company built a Web-based data mining solution that allowed customers to analyze up to 90 days of summarized call data.


As the data mining tools grew in popularity, customers demanded access to years of call detail history instead. Customers wanted to make intra-day changes to their calling plans and measure the impact on profitability.

To meet these customer demands, NetworkIP needed a new CDR data warehouse database. Switching to the column-oriented Vertica Analytic Database enabled NetworkIP customers to analyze up to two years of CDRs at any level, not just summarized data, within minutes of calls being made. Internally, Vertica enabled NetworkIP to slash the time to conduct a monthly cost analysis.


"Our customers were only able to focus on what happened last week and last month. Today, they also want to look at things that happened over the last 24 months or over the last 2 hours," said Stephan Broquie, director of business development applications at NetworkIP. "Vertica has helped us revolutionize data mining because it can query 10 times more data 200 times faster than our former database and its unique ability to trickle load data on a 24/7 basis lets customers quickly evaluate the affects of calling plan changes and re-adjust them accordingly several times per day."

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access