Client Description

TD Ameritrade Holding Corporation provides online brokerage services. The Company, through its private client and institutional client divisions, provides tiered levels of brokerage products and services tailored to meet the varying investing, trading, and execution needs of self-directed individual investors, financial institutions, and corporations. TD Ameritrade holds more than $773 billion in client assets across 6.9 million funded client accounts.

Challenge

TD Ameritrade needed to identify, outline and implement performance tuning measures against existing IBM Netezza Servers (Twinfin 24).

Solution

iOLAP implemented best-practice architecture to achieve efficient query retrieval on existing, high-usage installations, including Skimmer IBM Netezza Servers (Development), Twinfin24 IBM Netezza Server, and a new Striper (N2001). The iOLAP team defined and implemented a new ‘Statistics and Groom Strategy’, to increase performance lift and lessen the impact on users. This included a proof of concept to change data types from numeric to appropriate integer size. The team also reviewed current security implementation and worked with DBA to implement improvements to take advantage of GRA.

Benefit

TD Ameritrade now has DBAs trained in Netezza best practices, and installations fully optimized to deliver operational efficiency to various business units.