Mailprofiler Development Accelerates Complex SQL Queries by up to 60%, Uses Engineered System to Handle Resource-Intensive OLTP Applications
 
 

Mailprofiler Development Accelerates Complex SQL Queries by up to 60%, Uses Engineered System to Handle Resource-Intensive OLTP Applications

Printer View Printer View

Mailprofiler Development s.r.o. is an associated company of Schober Group, a European leader in cross-media dialog marketing, from market entry strategy, to campaign management. The company develops and maintains XCAMPAIGN, Schober Group’s comprehensive Web-based solution for business-to-business (B2B) and business-to-consumer (B2C), cross-media campaign management.

Data volume and performance requirements for Mailprofiler Development’s growing customer base had been steadily increasing, and the company’s IT infrastructure had become very complex. The main driver for adopting Oracle Exadata Database Machine was the company’s critical requirement to proactively prepare for capacity spikes instead of solving problems as they arise.

Mailprofiler Development deployed Oracle Exadata to provide redundancy and improve performance of the company’s resource-intensive online transaction processing (OLTP) application. The application handles reactions from end-users (such as openers, clicks, registrations, cancellations of subscriptions and transactions) of e-mail marketing campaigns, online. Within just three weeks of implementation, the company was able to consolidate its workloads, run complex SQL queries 40% to 60% faster, enable parallel processing of difficult queries without a noticeable effect on the rest of the applications, and shorten backup times by 80%.

 
 

 
 

Challenges

A word from Mailprofiler Development s.r.o.

  • “As a software development company, we are familiar with a wide range of database technologies. Oracle Exadata Database Machine is the only technology available in the market today capable of processing the most complex queries, without any noticeable effect on running applications. Within three weeks of delivery, we were able to start consolidating our workloads.” – Jaromir Zid, Head of Software Development, Mailprofiler Development s.r.o.

  • Provide a single, scalable solution with the required processing power to support further growth of XCAMPAIGN—which enables the company to design and execute cross-media marketing campaigns—instead of adding more machines to the company’s complex IT infrastructure
  • Shorten backup procedures lasting four to seven hours and simplify restoration procedures
  • Enable readiness for capacity spikes instead of solving problems as they arise
  • Enable smooth processing of complex queries, which is highly critical in designing effective execution plans for business-to-business (B2B) and business-to-consumer (B2C), cross-media campaigns

Solutions

Oracle Product and Services

  • Deployed Oracle Exadata Database Machine to provide the processing power for resource-intensive online transaction processing (OLTP) applications and grow XCAMPAIGN, the company's design and cross-media marketing campaign solution
  • Established a single, integrated, redundant solution capable of achieving significantly better data throughput and improving performance for transactions required to execute the company’s cross-media campaigns
  • Increased data availability and security and substantially reduced support costs by enabling the company to limit database support to working hours instead of providing around-the-clock database support
  • Simplified backup procedures and reduced the time required to execute backups by 80%, moving archive logs of 30 gigabytes in less than two minutes without slowing the applications
  • Accelerated complex SQL queries by 40% to 60%, and enabled parallel processing of difficult queries without noticeable effect on the rest of the applications—a fundamental difference to the previous environment
  • Reduced shutdown times of XCAMPAIGN for data restructuring to only 15% of the previous value by enabling application partitioning and high-performance data transfers between large temporary tables
  • Leveraged a single support contact for hardware, software, and database instead of dealing with several vendors and avoided maintaining large inventories of hardware spare parts
  • Completed deployment with minor training and knowledge transfer costs, as the company was already familiar with Oracle Database

Why Oracle

“When we started as a software development company in 2000, we considered Interbase, Oracle, and Microsoft SQL Server, but because of our previous relationship with Oracle, we chose Oracle Database. We also previously worked with Sun servers as they provide easy integration with Oracle software. We have tested other servers and databases, but realized they were not suitable for the data volumes that we need to manage. Oracle Exadata Database Machine is the only system capable of processing and storing our growing data volumes with absolute security and high performance,” said Jaromir Zid, head of software development, Mailprofiler Development s.r.o.

Resources