Due to the increase in TAQ data volume and data flow rates, conventional relational database management systems (RDBMS) cannot meet the real-time query requirements for automated securities trading and real-time market analysis. Sybase IQ can meet this challenge.
The core data management component of the Risk Analytics Platform, Sybase IQ, is a SQL database that uses vectorial representation of data (independently indexed columns) as opposed to relational tabular structures. The data stored column-wise is bit wise indexed and compressed. Consequently the query performance is much better than one would expect from relational databases and the data storage capacity is close to petabyte range.
The design is based on requirements of high performance, concurrent retrievals by a large user population as opposed to design needs of high rate of concurrent transactional updates as in the case of RDBMS. The internal data structure and the manner data is served to user applications renders Sybase IQ particularly suitable to store large amounts of time series data. The next generation automated trading infrastructure in institutional trading and prime brokerage firms is characterized by limited number of inbound data streams (that represent market data delivery channels) and high number of concurrent reader processes that access indexed columns to retrieve large data sets for analysis. The architecture of the Risk Analytics Platform meets these requirements.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
