- SG: +65 64383504
- IN: 022 25771219
- IN: 022 25792714
- IN: +91 9987536436
The Philippine Stock Exchange (PSE) is one of the oldest stock exchanges in Asia, having operated continuously since the establishment of the Manila Stock Exchange in 1927. 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, was 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.
After examining PSE’s business situation and requirement, Ashnik and its local partner IT Group, commenced the process of implementation with a solution-approach. The teams studied the application’s design architecture and 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 EDB Postgres’ Failover Manager and Backup Recovery Tool. Some of the key areas addressed were:
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.