Rakuten Linkshare

Thanks to Pythian, advertisers and publishers now have 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.

Overview

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. It needed to meet the needs of advertisers and publishers as it expanded globally, and as online advertising and e-commerce grew. Rakuten LinkShare turned to Pythian’s Oracle experts who delivered performance, usability, and scalability that exceeded their expectations by cutting query response times in half while providing customers with direct access to campaign data through a user-friendly interface.

PYTHIAN® DELIVERS INDY 500 PERFORMANCE TO RAKUTEN LINKSHARE’S FORTUNE 500 CLIENTS

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.

 

Critical Issues

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.
 

We Provided

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. Rakuten Linkshare 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.
 

Result

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. 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
 

Technologies

Oracle® Exadata
Oracle Database
Oracle Real Application Clusters
Oracle Enterprise Manager
Oracle Business Intelligence Suite Enterprise Edition
Share: