Sybase RAP captures real-time data flow in both the cache database and the repository and maintains a cached-copy and a disk-based copy; the repository stores the union of the historical and intraday data as one complete time series.
The RAPStore database supports multiuser and multiapplication workloads by scaling up and scaling out in multiprocessor, clustered configurations.
Sybase RAP supports different applications, such as pretrade analysis, posttrade analysis, quantitative modeling, and scenario-based backtesting against a shared database, and distributes the query workload across the cache and the repository based on the time-criticality of the data access requirements of each application.
The design requirements are based on high performance and concurrent retrievals by a large user population. The internal data structure and the way data is served to user applications renders the RAPStore particularly suitable for storing large amounts of time-series data. The next-generation automated trading infrastructure in institutional trading and prime brokerage firms is characterized by a limited number of inbound data streams (that represent market data delivery channels) and a high number of concurrent reader processes that access indexed columns to retrieve large data sets for analysis. The architecture of Sybase RAP meets these requirements.