Cookie policy: This site uses cookies (small files stored on your computer) to simplify and improve your experience of this website. Cookies are small text files stored on the device you are using to access this website. For more information on how we use and manage cookies please take a look at our privacy and cookie policies. Some parts of the site may not work properly if you choose not to accept cookies.

sections
Home > 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
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