Case Study
SK Telecom: Revenue Assurance DW
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. SK Telecom: Revenue Assurance DW Exadata X2-2 Qtr Rack (2010) • Spam Filtering Business Objectives • Ensure billing accuracy • Enhance customer service • Predict data traffic trends Solution • 2009: Create new DW on Exadata • 2010: Move to full-rack Exadata V2 • 2011: Add full-rack Exadata X2-2 • 2012: Clustered 3 full racks 2010 2012 Exadata V2+ two X2-2 Data Warehouse • Raw Data 1800 TB • Compressed to 180 TB • DB size: 350 TB with indices • 24-node RAC, 42 Exadata Cells Exadata V2 Data Warehouse • Billing Analysis System • Usage & Roaming Inquiries Exadata V1 Data Warehouse (2009) • Billing Analysis System Benefits Storage Savings 1620 TB 1800 TB to 180 TB $ Millions Capture Lost