Download PDF
Actian > Case Studies > Actian Vectorwise
Actian Logo

Actian Vectorwise

Technology Category
  • Analytics & Modeling - Real Time Analytics
Applicable Industries
  • Finance & Insurance
Applicable Functions
  • Business Operation
Use Cases
  • Predictive Maintenance
Services
  • Data Science Services
The Challenge
The Rohatyn Group (TRG), a hedge fund based in New York, needed a solution to manage risk in the highly volatile market of hedge funds. Information about positions, pricing, and risk is critical to investment decision-making. For tactical decision-making, TRG provided analysts immediate access to the information they needed in a format that they could use through a self-service data access environment. However, the combination of market volatility and a desire to do more strategic analysis drove the need to understand how their positions had performed over time. While the existing solution provided the interactive analysis TRG was looking for, it did not have the historical data. They wanted the user tools to remain the same and the query responses to be interactive, but they needed to do the analysis on more than 1000 times the data.
About The Customer
The Rohatyn Group (TRG) is a hedge fund headquartered in New York, focusing on emerging markets. The company provides analysts with immediate access to the information they need in a format that they can use through a self-service data access environment. TRG maintains extensive data about the current state of all their market positions in a multi-dimensional data structure managed by a proprietary in-memory database. This enables analysts to interactively answer their questions about the current state of their investments.
The Solution
TRG deployed Vectorwise to process data from multiple systems so that hedge fund managers could evaluate their positions in near real time. For the Vectorwise POC, TRG decided to flatten all of the data into a single table with almost 300 columns. They loaded millions of rows of historical data into the single table and the results were incredible. Vectorwise provided the in-memory performance and interactivity wanted with the data residing on-disk. Fast performance was delivered out-of-the-box without any indexing, preaggregating results, or extensive database tuning. Vectorwise’s support for standard SQL made the implementation very fast and the simplicity of the data design made the migration very easy.
Operational Impact
  • Access to historical data enables different analyses that enable analysts to better assess the risk of the current market positions.
  • Flexibility and adaptability of the Vectorwise-based solution have improved greatly over the replaced proprietary in-memory database.
  • In-memory query performance against large data sets that cannot possibly fit in-memory is delivering the performance and interactivity users want.

Related Case Studies.

Contact us

Let's talk!

* Required
* Required
* Required
* Invalid email address
By submitting this form, you agree that IoT ONE may contact you with insights and marketing messaging.
No thanks, I don't want to receive any marketing emails from IoT ONE.
Submit

Thank you for your message!
We will contact you soon.