Allegro Group Ensures Enterprise Scalability with Flexible, Integrated Data Warehouse Solution
 
 

Allegro Group Ensures Enterprise Scalability with Flexible, Integrated Data Warehouse Solution

  • Oracle Customer:  Allegro Group
    Location:  Poznań, Poland
    Industry:  Retail
    Employees:  1,500

Printer View Printer View

Allegro Group is the leading e-commerce company in Eastern Europe and the second-largest online auction business in the world. The company is a property of Naspers, an international media group. Operating e-commerce Web sites across 14 countries in Eastern Europe, Allegro Group enables its 20 million registered users to bid on items ranging from clothes to cars. The company hosts more than 18 million new auctions per day, and its business is growing by more than 20% annually.

 
 

 
 

Challenges

A word from Allegro Group

  • “Oracle’s data warehouse solution has accelerated system performance by up to 100 times. In addition, this implementation has greatly improved the user experience with vast new analytical capabilities, such as generating dynamic reports on-the-fly and real-time data updates.” – Rafał Kudliński, Data Warehouse Manager, Allegro Group

  • Build a scalable enterprise data warehouse that meets business users’ expectations for performance and quality of service
  • Optimize transactional data storing and processing, such as processes originating from the user activity tracking system that generate approximately 500 million operations per day
  • Create a central location to store data from all Allegro Group sites—located throughout 14 countries—including advertisements, auction sites, the online payment system, and the price comparison engines
  • Enable the company to efficiently manage more than 15 terabytes of data in a consolidated database that can scale to support a 50% annual increase in data volume

Solutions

Oracle Product and Services

  • Deployed Oracle Exadata Database Machine, with implementation help from Oracle Consulting, to accelerate the time it takes to analyze data and load it into the data warehouse
  • Installed Oracle Business Intelligence Enterprise Edition to effectively report and analyze data
  • Enabled Allegro to complete the extract, transform, and load process for all data from Allegro Group sites overnight
  • Ensured that 400 business reports can be accessed by 100 concurrent users in less than five seconds
  • Reduced report generation time from an average of several hours to 45 minutes, and less than a minute in some cases
  • Accelerated average data warehouse query processing by 50 times, with a 100 times increase in some cases
  • Enabled Allegro to track user activity history and detect abnormal behavior to improve fraud detection related to its e-commerce and auction sites, saving the company thousands of dollars annually

Partner

  • Oracle Partner
    ISE GMBH Germany