Case Study: Samsung Securities

CASE STUDY FOR FINANCIAL SERVICE

￭ Overview￭ Problems￭ Solutions￭ Results￭ Technical Details

AGENDA

In-Memory Database Solution

CASE STUDY FOR FINANCIAL SERVICE

+ Overview

AltibaseAltibase is provider of In-Memory data solutions for real-time access, analysis and distribution of high volumes of data in mission-critical environments.

Samsung Securities Samsung Securities is the largest investment bank in Korea.

SummaryAltibase provided Samsung Securities with the ability to increase their trading system performance – by 27 times

In-Memory Database Solution

+ ProblemsSamsung Securities had three critical areas that suffered from inadequate DBMS performance and reliability.￭ Customer Retention: Samsung Securities had pinpointed significant decreasing

revenue as well as lost opportunity stemming directly from inadequate retention of global institutional investors. The problems were simply uncovered by identifying customer complaints indicating that they had lost transactions, thus profit, due to insufficient speed in their futures/options trading.

￭ Customer Acquisition: Concurrently, Samsung Securities realized that new client acquisitions were facing hurdles that originated from the very same problems with speed.

￭ Growth: Samsung Securities was not able to keep up with the increasing trading volumes in the futures/options market. Simply put, Samsung Securities was being limited by its speed. Korea had 3.75 billion contracts of futures/options trading volume in 2010.

In-Memory Database Solution

+ Solution Since 2006, Samsung Securities has utilized the ALTIBASE HDB

in-memory DBMS. The decision to switch was simple, as they quickly realized that using a traditional on-disk DBMS, with its endemic limitations, was the root cause of their problems.

Replacing their on-disk DBMS with ALTIBASE HDB in-memory DBMS rapidly solved Samsung Securities’ problems.

Their trading system became a highly available and best of class, performing service. Because Altibase is a standards-based DBMS, it took only 2 months with 4 engineers to develop and deploy the new system.

In-Memory Database Solution

+ Results As Samsung Securities prioritized their DBMS’ speed, high-

availability and reliability at the top of their list, their trading is now at the pinnacle of efficiency and profitability. Their DBMS runs non-stop thanks to the superior features of Altibase HDB in-memory DBMS.

Samsung Securities is now servicing their customers with a trading system which is 27 times faster than their old system.

Samsung Securities has turned attrition to growth by adding 8 additional key, institutional customers.

Samsung Securities has grown to owning 15% total market share of all global institutional investors’ futures/options trading in Korea.

In-Memory Database Solution

+ Technical Details Samsung Securities achieved exceptional results by leveraging key features of

ALTIBASE HDB, specifically in the areas of high-performance, high-availability and migration.

ALTIBASE HDB ALTIBASE HDBReplication

OptionsFutures

Active - Standby

In-Memory Database Solution

Price

+ ALTIBASE HDB Performance Samsung Securities, prior to switching to ALTIBASE HDB, was utilizing a Sybase

conventional on-disk DBMS. Growing trading volumes resulted in a significant increase in the number of database transactions.

This increase put a big burden on the abilities of their existing conventional on-disk DBMS which quickly became a bottleneck. Even attempts to use caching to improve performance did not help, and Samsung Securities could only process 750 trading orders per minute with an average execution time of 80 milliseconds per order.

In addition, the burden on system resources grew rapidly resulting in up to 60% CPU consumption to handle database transactions.

In-Memory Database Solution

+ ALTIBASE HDB Performance After Samsung Securities deployed ALTIBASE HDB in in-memory only mode to

replace the Sybase DBMS, there was a dramatic improvement in system performance.

ALTIBASE HDB in-memory DBMS enabled Samsung Securities to process 20,000 trading orders per minute with an average execution time of 3 milliseconds per order. While delivering extreme speed, ALTIBASE HDB utilized less than 20% of CPU, resulting in significantly low resource consumption.

In-Memory Database Solution

+ High Availability (HA)￭ In addition to the performance issues, with the increased volumes of transactions,

Samsung Securities’ conventional on-disk database had reliability and stability issues resulting in data losses and system outages.

￭ ALTIBASE HDB’s built-in Replication feature was the perfect fit for quickly resolving these issues without requiring Samsung Securities to invest in additional hardware or software resources.

￭ Using the replication feature, Samsung Securities implemented ALTIBASE HDB based on Active-Standby HA architecture. In this architecture, ALTIBASE HDB replication feature maintains an up-to-date backup of the database on a second system. If the master server unexpectedly becomes unavailable, service immediately resumes from an identical database on an alternate server. This provides a non-stop operating environment with improved reliability and fault-tolerance. This architecture ensures that Samsung Securities’ mission-critical data remains uncompromised. Unplanned downtimes (system crash), malfunctions or planned downtimes are issue-free - due to patches or upgrades to its DBMS.

In-Memory Database Solution

+ Migration￭ ALTIBASE HDB as a full-featured and standards-compliant DBMS has

made it easy for Samsung Securities to migrate existing database objects and data to the new system.

￭ All existing Sybase tables and stored-procedures were converted to ALTIBASE HDB by four technical staff within two months using familiar programming languages and standard SQL.

In-Memory Database Solution

In-Memory Database Solution

Altibase Solution OverviewTelecommunication Financial Service Manufacturing

• SK Telecom (Real Time Rating System)

• China Telecom (Account Balance Management System)

• China Unicom (Online Charging System)

• E*TRADE• Solomon Investment & S

ecurities (FOREX trading platform)

• Leading Global Investment Bank (Foreign Exchange Margin Trading)

• LG Display (Quality control DBMS)

• Top Japanese Medical Supplier (Global MRI/CT Manufacturing Company)

• BISTel (Equipment Engineering System)

Solution Service Government

• HP (Hewlett-Packard) OpenMCM

• HOA Soft (System for Proprietary Trading Desks – Prop Desk)

• Leading Global Utility Company (Call Center)

• Sportstoto (Sports Betting Industry)

• EBS (Educational Broad Casting System) – Single Sign-On

• KAIST (Course Enrollment System)

Read More Case Studies>>

MORE REFERENCES:

Website: www.altibase.comEmail: Info@altibase.com

Facebook: facebook.com/altibaseincLinkedIn: linkedin.com/company/Altibase

Twitter: @altibase