> Vertica > Revolutionizing Data Warehousing in Telecom with the Vertica Analytic Database

Revolutionizing Data Warehousing in Telecom with the Vertica Analytic Database

White Paper Published By: Vertica
Published:  Mar 15, 2010
Type:  White Paper
Length:  11 pages

Revenue assurance analysts at a top-tier US-based carrier studied this every day. Primarily focused on detecting fraud, revenue sharing contract violations and incomplete revenue collections, they had the need to query and analyze call detail record (CDR) databases that grow by millions of new CDRs every day. The problem was their aging CDR data warehouse: •Queries took tens of minutes or even hours to answer •They only had access to a few months of CDR history •They could not perform ad-hoc analysis •Annual costs were very high (DBMS maintenance fees, 4 DBAs, data center costs for the SMP server and SAN on which it ran) •The data warehouse could not be changed easily to support new requirements from legal, regulatory, and engineering or to support wireless or IP data

Tags : 
vertica, ec2, cdr, elastic, saas, dbms, sql, acid transactions, jdbc, odbc, etl, cloud computing, data management, ad-hoc, business intelligence, cloud, cloudbased applications, analytic, saas, dbms

We use technologies such as cookies to understand how you use our site and to provide a better user experience. This includes personalizing content, using analytics and improving site operations. We may share your information about your use of our site with third parties in accordance with our Privacy Policy. You can change your cookie settings as described here at any time, but parts of our site may not function correctly without them. By continuing to use our site, you agree that we can save cookies on your device, unless you have disabled cookies.
I Accept