REVIEWER: John Devolites, vice president and general manager of Communications and Entertainment Solutions for TEOCO (The Employee Owned Company).

BACKGROUND:TEOCO’s communications and entertainment solutions division is a leading provider of network cost, revenue assurance and business intelligence (BI) solutions for communications service providers. The group offers software solutions and in-depth auditing expertise to help their customers find new margin opportunities.

PLATFORMS: Dell servers, EMC storage disks, Cisco InfiniBand switches, Quad-Core Intel Xeon processors, Ingres database, Linux operating system.

PROBLEM SOLVED: Communications service providers need the ability to analyze call detail records (CDRs) on a daily basis to reconcile usage invoices from other carriers, validate their own billing and identify opportunities to optimize their networks. Timely, comprehensive CDR analysis has always proved challenging due to daily volumes that exceed 1 billion CDRs per day for the largest providers. TEOCO developed the SONAR analytics service to capture, load, transform and provide insight into these large volumes of CDR events. The transformation of the data includes the application of business rules and table look-ups that add additional value to each record. DATAllegro provided a data warehouse appliance platform with enough performance and scalability to support this processing at a price point that allows TEOCO to remain competitive and provide a significant ROI for its clients.

PRODUCT FUNCTIONALITY: Three grid-enabled data warehouse appliances encompass a multitemperature, distributed data warehouse for CDR analysis. Raw data records are loaded onto a mediation appliance, which uses SONAR to enrich the call data records. After data records are enriched, they are loaded and then aggregated along various dimensions on a second production appliance, ready for the generation of reports and ad hoc query through a Web-enabled open database connectivity (ODBC)-compliant tool. Six months of enriched CDRs totaling up to 100TB of data are kept on the production appliance. Records older than six months are rolled over using direct node-to-node transfers to a third archive appliance. The archive appliance has greater capacity than the mediation and production appliances, though at a lower level of performance. It can keep records between six months and two years old online and accessible for querying through the same query and reporting tool.

STRENGTHS: The grid of appliances on which SONAR is deployed has a capacity of more than 400TB, with over 200TB of user data currently loaded. The largest table is 70TB. This does not include any indexes, mirroring or fallback, making the deployment among the largest active warehouses in the world. The backup and copy capabilities allow for significant data and schema transfer rates between appliances that average 22TB of user data per hour.

WEAKNESSES: The appliance could use a workload management capability that makes it easier to manage how much of the appliance each user can utilize.

SELECTION CRITERIA: The performance detailed in the “strengths” section came at an affordable price per terabyte, allowing TEOCO to successfully deploy SONAR to customers at a competitive cost. DATAllegro was the only solution capable of meeting price/performance requirements and scaling in excess of 400TB.

DELIVERABLES: The DATAllegro data warehouse appliances delivered the ability to load and transform more than 500 million records in a few hours. It allows the end user to ask any question of six months of CDRs. With its SQL support and ODBC, TEOCO was able to deploy an industry-standard query and reporting tool with the appliance. This production operation supplies BI to more than 50 users from multiple business units that previously could not access this volume of data.

VENDOR SUPPORT: The vendor engaged in daily status calls before and during the implementation. Roadmap conversations were always realistic and honest. DATAllegro continues to be involved in weekly support calls. It is a partnership.

DOCUMENTATION: The documentation is great for looking up how to perform most tasks; however, in areas related to the execution of complex SQL statements, the information is not as deep.

DATAllegro v3
85 Enterprise Drive, Second Floor
Aliso Viejo, CA 92656
(949) 680-3000

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