Continuous aggregation and combining of data in real-time is a fundamental requirement for many Financial Services applications. Analytics must be derived from multiple sources of diverse streaming data including trading data, news feeds, credit ratings, transaction data, customer data, market data and fraud patterns.

SQLstream provides both the technology and the application expertise required to deliver real-time solutions for both banking and capital markets. The following describes some of the financial services challenges that SQLstream is helping our customers to address.

Real-time Service Level Monitoring

Financial Services companies, like all service companies, are bound by a combination of expectations and service level agreements. Failing to meet the expected service levels results in measurable consequences. For example, if a company has committed that "all customer trades will be executed within ten seconds of the availability of any buyer at that price and volume", then delays in such trades can lead to a cascade of lost deals, lost money and disgruntled customers. SQLstream delivers real-time service level monitoring and alerting to track critical performance objectives. SQLstream will process and combine massive volumes of dynamic data in real-time. Exceptions and SLA violations are instantly detected and immediately reported.

Real-time fraud detection

Most fraud applications require transactions to be collected in a data warehouse. Although some analysis is performed in real-time, the bulk of the processing is carried out at the end of each day, or at intervals throughout the day. With the focus on improving the speed of detection, existing data warehousing technology struggles to cope with the performance overhead of running large, complex analysis queries in real-time. SQLstream's provides continuous, time-sensitive monitoring and pattern analysis over real-time streaming data, identifying potential fraudulent activity, exceptions and behavioural patterns in real-time.

Continuous, real-time analytics for market feed data

For a large many Financial Services applications, analytics must be derived from multiple sources of diverse streaming data including trading data, news feeds, credit ratings, transaction data, customer data, market data and fraud patterns. Continuous aggregation and combining of data in real-time is a fundamental requirement.

SQLstream's real-time analytics enables real-time alerts, live risk monitoring and real-time fraud detection. While traditional databases are excellent repositories for historical records for the data sources listed above, real-time analysis of incoming data streams is where financial services firms make their reputation as well as their bonuses. SQLstream enhances the datawarehouse, adding real-time capabilities, and scaling with data volume. SQLstream meets the needs of the financial services industry by offloading billions of messages from the data warehouse while avoiding slow and costly database queries and batch processing.