In contrast to the subsequent hardware and software changes the technology mandated, the company sought stronger performance and flexibility at a lower cost.

By improving database performance and scalability, the company could create a prepaid data mart for use in processing and analyzing up to 200 GBs of summarized data and call detail records (CDRs) daily. A new solution also was required for generating reports and ad hoc analytical queries within existing run times. Company analysts also coveted a suitable development (“sandbox”) environment. Aircel selected the Vertica (now OpenText) Enterprise Analytics Platform. “We were impressed with the phenomenal POC results, especially the query execution, data loading, and backup times within Vertica (now OpenText) Enterprise,” says Sanjeev Chaudhary, Business Intelligence Head for Aircel. “Our data size will grow year by year, so we wanted a better performing system to handle the various workloads, processes, and queries faster, even if it is a larger database size. Vertica (now OpenText) satisfied our strict requirements.”

For instance, data off-loading over one month of testing was much faster compared to Aircel’s previous solution. Additionally, Aircel calculated that OpenText’s support costs were in line with its budgetary goals for a premier data analytical platform.

“Micro Focus (now OpenText) also hosted a workshop and provided best practices on how to maximize Vertica (now OpenText) Enterprise Edition, which helped tremendously in our migration and deployment,” Chaudhary notes. Additionally, Technology Services assisted the installation and supported Aircel in loading prepaid customer data into Vertica (now OpenText).

成果

While easing management tasks, the OpenText (formerly Micro Focus) solution integrates effortlessly with several custom ETL scripts that load data into Vertica (now OpenText) and the SAP BusinessObjects visualization tool. Chaudhary says, “We achieved our entire integration requirements with the Micro Focus (now OpenText) solution.”

In selecting Vertica (now OpenText), Aircel addressed both its short-term needs and long-term data growth projections. To scale the analytical environment, Aircel system administrators will simply add another server to the cluster or more storage capacity.

“We expect this solution to be capable of allocating certain storage sizes to our sandbox users so that they can use storage within their data size limits and have better archiving options,” Chaudhary says. “If we expand this in the future, it can be a single enterprise data warehouse source for other data marts having similar workloads.”

For now, business users appreciate the exceptional speed, performance, and analytical features in Vertica (now OpenText) that enable them to gather intelligence from structured data. Management information system (MIS) reporting and sandbox users access the solution concurrently for various ad hoc queries, reports, and analyses. The company’s data scientists investigate theories with the solution, enabling Aircel to explore new opportunities and monetization streams as a GSM mobile service provider.

Aircel’s goal of creating a prepaid data mart is well underway. Chaudhary explains, “Our prepaid customer base is large and growing. In a competitive market, our objective is to manage this area with the best TCO and a stable, high performing data analytical system. Vertica (now OpenText) has helped in all these aspects.”

In summation he notes, “As a result of the Vertica (now OpenText) implementation, we’re achieving our goal of being innovative in using data to solve our business problems.”

About Aircel

India’s fifth largest global system for mobile (GSM) communication service provider has over 90 million subscribers across the country. Aircel Limited, headquartered in Gurgaon, Haryana, provides voice and data services, postpaid and prepaid plans, Internet and broadband wireless access, and business communication solutions.