Case Studies

Pythian Delivers Indy 500 Performance to Rakuten LinkShare’s Fortune 500 Clients

To address growth and expanding service offerings, Rakuten LinkShare wanted to deploy a data infrastructure that could provide global access to data quickly with a user-friendly interface, while being able to scale easily for future growth.

Rakuten LinkShare provides Fortune 500 businesses with a wide range of online marketing services, including search engine marketing, lead generation and affiliate marketing. Rakuten LinkShare has significantly enhanced the performance and availability of its reporting and analysis services for hundreds of thousands of advertisers and publishers in its network. Rakuten Linkshare provides Fortune 500 businesses with a range of online marketing services, including search engine marketing, lead generation, and affiliate marketing.

Problem
Rakuten Linkshare required the ability to easily manage huge volumes of historical e-commerce data in a consolidated database that could be scaled for future growth. Rakuten Linkshare also needed to meet the needs of its advertisers and publishers as it continued to expand globally and as online advertising and e-commerce grew. Another requirement was to deploy flexible reporting and analysis tools, including a sophisticated dashboard functionality for its business users.

Solution
Rakuten Linkshare and Pythian developed a comprehensive implementation and deployment plan. The database infrastructure comprised Oracle Exadata machines with Oracle Database and Real Application Clusters (RAC) to deliver the best performance-to-dollar value. They adopted Oracle Enterprise Manager to keep their transactional databases running smoothly, identify trouble spots, and isolate bad queries.

To provide easy access to the data, including an in-depth set of query and analysis tools, Oracle Business Intelligence Suite Enterprise Edition was employed with a user-friendly interface built on top. A post-deployment management plan was developed to leverage Rakuten Linkshare employees’ existing Oracle transactional environment experience to streamline database and systems management teams and improve operational efficiency.

Results
Pythian delivered performance, usability, and scalability that exceeded the client’s demands. Processing efficiency and database query speed were increased by 8 times, while data center floor space and power requirements were reduced by 400%. As a result, response times for customer queries were cut in half.

By using an application built on top of Oracle Business Intelligence Suite Enterprise Edition, advertisers and publishers had direct access to data through a user-friendly interface, enabling them to assess trends, analyze historical data, and view the performance of their campaigns in near real-time.

Thanks to Pythian, Rakuten Linkshare was able to significantly enhance the performance and availability of its reporting and analysis services for hundreds of thousands of advertisers and publishers in its network.

Download a copy of the case study