The Philippine Stock Exchange, Inc relies on PostgreSQL as a backend of their New Trading Platform

case_studies

Case Studies

Case Studies

PHILIPPINE STOCK EXCHANGE  – Case Studies

Philippine Stock Exchange, Inc relies on PostgreSQL as a backend of their new trading platform

ABOUT PHILIPPINE STOCK EXCHANGE

The Philippine Stock Exchange (PSE) is the only stock exchange in the Philippines. It is one of the oldest stock exchanges in Asia, having operated continuously since the establishment of the Manila Stock Exchange in 1927. It currently maintains two trading floors — one at the PSE Centre (Tektite), Ortigas Center in Pasig City, and one at its principal office at the Ayala Tower One in Makati City’s Central Business District. The PSE is composed of a 15‐person Board of Directors. Trading in the PSE is a continuous session from 9:30 am to 3:30 pm daily.

ENGAGEMENT SITUATION & CHALLENGES

The PSE selected NASDAQ as its new service provider for the Exchange’s trading engine in July 2014. NASDAQ deployed its X-Stream Trading System (XTS) to the PSE to replace the NSC trading system provided by NYSE Euronext Technologies SAS. The new trading system, called the PSETrade XTS, is being developed with enhanced trading capacity and increased risk management parameters in line with PSE’s overall strategy of introducing more products and services to the market. The backend RDBMS for PSETrade XTS was PostgreSQL, which was relatively new for PSE. With this situation, it was imperative for PSE to get their team trained on the new trading platform to make ensure efficient handling of daily chores for the production server.

Also, the client sought a trusted solution provider for its PostgreSQL support and implementation with optimal settings. Ashnik, a Master Partner to EnterpriseDB in the South East Asia region, extends its solutions, services and training services on Postgres and other EnterpriseDB products to its customers through local partners – IT Group being the preferred partner in Philippines. Ashnik has extensive consulting experience with certified PostgreSQL professionals, as well as experience in hosting numerous public and corporate batch trainings for PostgreSQL. Additionally, IT Group’s local presence in Philippines, made Ashnik the right choice of solution support and training provider for PSE. PSE thus chose to procure EnterpriseDB supported PostgreSQL subscription and engage with IT Group and Ashnik for implementation and training of PostgreSQL.

ASHNIK & ITG – SOLUTION DELIVERY

After thoroughly examining PSE’s business situation and requirement, Ashnik and ITG teams commenced implementation with a solution approach. The teams closely studied the application’s design architecture and accordingly architected PostgreSQL database to optimally power and support the application.

Key contributions to the PostgreSQL setup for NASDAQ’s X-stream Trading System Platform:
Ashnik developed a robust, resilient and highly available solution using EnterpriseDB’s Failover Manager and Backup Recovery Tool. Some of the key areas addressed were:

  • Mechanism for quick response to read request – Incorporated a crucial mechanism to enable quick response to read requests from caching service within the application. The application’s high TPS (transactions per second) requirements were handled by caching all the data on the application cache.
  • Database Tuning –
    – Tuning as per the nature of application: The application using PostgreSQL as backend does a bulk read (at start of each day). Then at end of the day, data is flushed to a persistent database. Database was tuned to optimize these bulk operations.
    – Tuning as per the setup and environment: The database is co-hosted with other application components which are memory-intensive. Database was tuned in such a way that it does not do aggressive caching and deprive application of memory.
  • Backup-Recovery & DR – Gave actionable inputs to PSE on how to design its Backup-Recovery and DR strategy using EnterpriseDB’s Backup Recovery Tool.
  • Security – Secured the Postgres database by restricting the connections with Host Based Authentication configuration of PostgreSQL. This helped in avoiding any unauthorized access.

Post-implementation Training and Support :

After the initial consulting and contributions in PostgreSQL setup for NASDAQ X-stream Trading System Platform, Ashnik ramped up the PSE team by providing the required PostgreSQL training.

With first-hand understanding of the PostgreSQL setup and environment, our trainer helped the PSE team learn Postgres with a training program customized for its environment. PSE team, having a good knowledge and understanding of other databases like Oracle and SQL Server was very efficient in picking up the new concepts and handling operational tasks as a part of the training program. Upon completing training, the PSE team was ready to handle their PostgreSQL setup and operations that would host the database for its core system.

BUSINESS BENEFITS

  • Brought business transformation to PSE’s end users by opting for a new trading platform.
  • Increased PSE’s business potential by empowering them to effectively and seamlessly offer and support additional products and services.
  • Stable deployment of PostgreSQL, tuned setup and trained staff, helped PSE to focus on its core business instead of worrying about the underlying IT infrastructure of the setup.

< Back